MySQL too slow
#10

Quote:
Originally Posted by Vince
Посмотреть сообщение
Well, it's using the primary key so in theory it should be very fast. Are you running on InnoDB or MyISAM? Because MyISAM is a lot slower writing data than InnoDB and it doesn't support foreign keys.
Its InnoDB, that was actually the first thing I've checked..

The problem of slow MySQL wouldn't be such a big problem if it doesn't block SAMP thread and makes it looks like a lag.
Reply


Messages In This Thread
MySQL too slow - by NikolaSRB - 02.09.2017, 10:37
Re: MySQL too slow - by 10MIN - 02.09.2017, 10:56
Re: MySQL too slow - by NikolaSRB - 02.09.2017, 11:06
Re: MySQL too slow - by Vince - 02.09.2017, 11:46
Re: MySQL too slow - by NikolaSRB - 02.09.2017, 11:54
Re: MySQL too slow - by Vince - 02.09.2017, 12:07
Re: MySQL too slow - by NikolaSRB - 02.09.2017, 12:11
Re: MySQL too slow - by NikolaSRB - 02.09.2017, 12:43
Re: MySQL too slow - by Vince - 02.09.2017, 12:58
Re: MySQL too slow - by NikolaSRB - 02.09.2017, 12:59

Forum Jump:


Users browsing this thread: 2 Guest(s)