MySQL slow?
#7

Quote:
Originally Posted by gtaplayer1
Посмотреть сообщение
I agree something must be wrong with your mysql server's configuration or something.

When you tried using threaded queries, did your server freeze execution the whole time it was dumping data?

EDIT:
Is your MySQL server running locally or on a remote server?
The MySQL server is runnong on my own computer (localhost).
Threaded queries didn't freeze OnFilterScriptInit, non-threaded did.

Just ran another test to do the same when the data was already in place.
The ID field is primary key, so the queries will be sent to MySQL, but the data won't be overridden as the data already exists.
This only took 71 milliseconds.

Perhaps MySQL is increasing filesize of the database everytime when a new record is being added, this might be what takes so long.

I'm using BlueG's plugin R34.
For the server, I'm using MySQL Community Server 5.6.15.
Reply


Messages In This Thread
MySQL slow? - by PowerPC603 - 24.01.2014, 17:21
Re: MySQL slow? - by Memoryz - 24.01.2014, 17:33
Re: MySQL slow? - by PowerPC603 - 24.01.2014, 17:35
Re: MySQL slow? - by iZN - 24.01.2014, 17:38
Re: MySQL slow? - by gtaplayer1 - 24.01.2014, 17:41
Re: MySQL slow? - by Michael@Belgium - 24.01.2014, 17:44
Re: MySQL slow? - by PowerPC603 - 24.01.2014, 18:01
Re: MySQL slow? - by InfiniTy. - 24.01.2014, 18:04
Re: MySQL slow? - by PowerPC603 - 24.01.2014, 18:10
Re: MySQL slow? - by InfiniTy. - 24.01.2014, 18:32

Forum Jump:


Users browsing this thread: 6 Guest(s)