SMF Support > Server Performance and Configuration
Transferred over to VPS, issues with speed.
Paracelsus:
--- Quote from: Liam_michael on July 02, 2012, 01:20:19 PM ---
--- Quote from: Paracelsus on July 02, 2012, 05:48:50 AM ---Do you have tables in InnoDB? If so, try increasing InnoDB buffers, you seem to have a large pool of unused RAM for it. And maybe increase sort_buffer_size, you seem to have 64k, I have it on 2M.
--- End quote ---
Paracelsus, how do I do these things you recommended?
--- End quote ---
Oh sorry, thought you we're familiar with it... you have to edit my.cnf via root access.
Liam_michael:
--- Quote from: Paracelsus on July 02, 2012, 04:23:21 PM ---
--- Quote from: Liam_michael on July 02, 2012, 01:20:19 PM ---
--- Quote from: Paracelsus on July 02, 2012, 05:48:50 AM ---Do you have tables in InnoDB? If so, try increasing InnoDB buffers, you seem to have a large pool of unused RAM for it. And maybe increase sort_buffer_size, you seem to have 64k, I have it on 2M.
--- End quote ---
Paracelsus, how do I do these things you recommended?
--- End quote ---
Oh sorry, thought you we're familiar with it... you have to edit my.cnf via root access.
--- End quote ---
Thank you, does anyone have any other suggestions before I complain to the main host?
CoreISP:
Did you put the changes through?
Liam_michael:
Okay, I tried it, will let you know what happens.
Liam_michael:
In addition, I've attached my my.cnf if anyone wants to take a look
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version