SMF Support > Server Performance and Configuration
Transferred over to VPS, issues with speed.
Paracelsus:
--- Quote from: Liam_michael on July 03, 2012, 10:10:54 PM ---In addition, I've attached my my.cnf if anyone wants to take a look
--- End quote ---
Ok, I see you don't use tables in InnoDB (it's actually turned off ;D)... so everything is MyISAM. I prefer it the way around, but ok.
You put 2M on sort_buffer_size and 64M on key_buffer_size on your my.cnf but probably forgot to restart MySQL as I still see it with just 64k and 4M respectively in status.php. Try something like: /etc/init.d/mysqld restart or /etc/init.d/mysql restart depending on your distro.
After that, if you still have problems (although I doubt it), can try to add:
max_heap_table_size = 32M
tmp_table_size=32M
thread_concurrency=2
thread_cache=64
You can erase one of the skip-innodb instances, you have two of them.
As for the query_cache try these ones instead of those you have there:
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
Liam_michael:
Thank you, Paracelsus.
I restarted the MYSQL like you said, could you check if it updated properly?
Paracelsus:
--- Quote from: Liam_michael on July 04, 2012, 04:18:35 PM ---Thank you, Paracelsus.
I restarted the MYSQL like you said, could you check if it updated properly?
--- End quote ---
No, check your extended status.php, key_buffer_size is still 4M. Maybe you got my.cnf on the wrong location, usually is on /etc/my.cnf. Locate the right one and edit only what's related to what we discussed here, buffers, etc.
Liam_michael:
Thanks again, apparently I was editing the wrong my.cnf. I found the correct path and restarted it. I kept the key_buffer @ 4M, will update you if I notice a change. :)
Paracelsus:
--- Quote from: Liam_michael on July 05, 2012, 04:31:46 PM ---Thanks again, apparently I was editing the wrong my.cnf. I found the correct path and restarted it. I kept the key_buffer @ 4M, will update you if I notice a change. :)
--- End quote ---
I see that you are still having a lot of slow queries.
Although it isn't that low according to your status.php, in my experience you should really tune up key_buffer_size... key buffer and table cache are 2 of the most important parameters when tuning MySQL using MyISAM tables, so I would put key_buffer_size on 64M and table_cache on 512. They are loaded only once (RAM usage) no matter how many threads you are using. Then, besides sort_buffer_size to 2M, read_rnd_buffer_size to 1M (theses parameters will be loaded once per thread, that's why one have to be careful when increasing them) and thread_cache to 32 or 64 (not more, otherwise it's a bit overkill). Finally, thread_concurrency at 2.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version