SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Thread Tools Display Modes
Old 13/06/2018, 05:34 PM   #1
MBilal's Avatar
Join Date: May 2013
Posts: 823
Reputation: 57
Default mysql slow issue


Some time players mysql data not loading quickly when i got players got more than 50 or 60+
I read a lot of post on the forums about after trying a lot i not able to fix it.
I even calling all mysql callbacks with pquery and UPDATE with tquery. I'm not using any where loop to call the data from the mysql.

Well let me Explain how my system work.
First I check from mysql when some body connect is his ip or name is in banlist or not ,if not in banlist than show login dialogs if he is banned kick him.

Here is where Login dialogs taking alot to time to appear almost try to relog 3 to 4 time to connect then dialogs appear.

As some people mentioned i also increase the pool size to 4 also using latest mysql plugin and include.

Some more points i am saving/UPDATE kills / death / cash when some body die.

Kindly help me out Thanks.
MBilal is offline   Reply With Quote
Old 13/06/2018, 06:04 PM   #2
Huge Clucker
Join Date: May 2018
Posts: 345
Reputation: 52
Default Re: mysql slow issue

If mysql logging is set to ALL, it will be slower. Other than that, post the query about the login dialog that takes too long and maybe even try to run it on phpMyAdmin and compare them.

Using parallel queries might be worse in some cases and changing the pool size will not matter if server cannot support it.
Calisthenics is online now   Reply With Quote

Thread Tools
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql work slow Mister0 Server Support 22 24/09/2017 05:29 PM
MySQL too slow NikolaSRB Scripting Help 9 02/09/2017 12:59 PM
MySQL running slow Luis- Scripting Help 1 12/05/2015 08:53 PM
MySQL slow? PowerPC603 Scripting Help 20 27/01/2014 08:40 PM
Slow MySQL load, or script issue? Devine Help Archive 13 16/11/2009 09:09 PM

All times are GMT. The time now is 07:24 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.