Raised This Month: $51 Target: $400
 12% 

MySQL connection freezes via SQL_FastQuery


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
ZASTRELIS
Veteran Member
Join Date: Nov 2010
Location: Siberia, Irkutsk
Old 09-01-2017 , 05:44   MySQL connection freezes via SQL_FastQuery
Reply With Quote #1

Have a one of problem. MySQL server located not in same location where srcds server located. Difference in 60-80ms between them. And client occurs a lag when I used SQL_FastQuery stock by chat trigger. For example u write something in chat and it's saved in db. I don't understand why it happens, why sourcemod not used multithreading with mysql ext net_graph reports that sv and var ups to 10ms when SQL_FastQuery used. Last time I thought that mysql server not enought optimized but after configuration updates I understood that problem happens due to sourcemod.. because last experience tell me same when I used MySQL on same machine with SRCDS, lags happens, but not as when distance amount between servers is 60-80ms I thing that sm team must rewrite old part of mysql ext and fix problem with threading

Last edited by ZASTRELIS; 09-01-2017 at 05:59.
ZASTRELIS is offline
DJ Tsunami
DJ Post Spammer
Join Date: Feb 2008
Location: The Netherlands
Old 09-01-2017 , 06:10   Re: MySQL connection freezes via SQL_FastQuery
Reply With Quote #2

The MySQL extension does support threading, you just have to use SQL_TQuery.
__________________
Advertisements | REST in Pawn - HTTP client for JSON REST APIs
Please do not PM me with questions. Post in the plugin thread.

Last edited by DJ Tsunami; 09-01-2017 at 06:11.
DJ Tsunami is offline
Bacardi
Veteran Member
Join Date: Jan 2010
Location: mom's basement
Old 09-01-2017 , 07:58   Re: MySQL connection freezes via SQL_FastQuery
Reply With Quote #3

...what the? OP lazy to read SM wiki and old topics?
__________________
Do not Private Message @me
Bacardi is offline
ZASTRELIS
Veteran Member
Join Date: Nov 2010
Location: Siberia, Irkutsk
Old 09-01-2017 , 08:55   Re: MySQL connection freezes via SQL_FastQuery
Reply With Quote #4

Quote:
Originally Posted by Bacardi View Post
...what the? OP lazy to read SM wiki and old topics?
Yes. It's. Not enought time for this. bro.. I ask and subscribe to the my treads only, for future if problem happens again.

Last edited by ZASTRELIS; 09-01-2017 at 08:59.
ZASTRELIS is offline
ZASTRELIS
Veteran Member
Join Date: Nov 2010
Location: Siberia, Irkutsk
Old 09-01-2017 , 08:56   Re: MySQL connection freezes via SQL_FastQuery
Reply With Quote #5

Quote:
Originally Posted by DJ Tsunami View Post
The MySQL extension does support threading, you just have to use SQL_TQuery.
Thanks. Very shortly and helpfully. +rep

Last edited by ZASTRELIS; 09-01-2017 at 09:00.
ZASTRELIS is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:04.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode