Sorry about that, There hasn't been a significant change that I have seen. The load sometimes is stuck around 8 and sites start to lag. I looked into the cpu usage, although it showed me nothing unusual.
I do see that mySQL uses up about 15% of the memory during those high loads. So I need to...
Here are the latest reports:
MySQLTuner.PL
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.45-log
[OK] Operating on 64-bit architecture
-------- Storage Engine...
There are heavy websites which need better performance but they aren't taking quite alot of resources. And so, I am trying to optimize the server for better outcome.
It is a dedicated server and it is still quite a bit under the RAM provisions. The CPU usage normally does not go beyond 10%...
Can you list me through all the optimizing techniques please?
I haven't set many things regarding the server limits, can you please guide me through it ?
I have distributed cron quite evenly. I have 2 stats log because one gives overall logs and another is very detailed log which is quite...
- Nice layout
- Good colours.
- You have video tutorials which are quite handy, although text besides it will be helpful as we have to type huge commands at times.
- Adverts mix in quite well.
- The quality of video can be improved I suppose. It is just enough to look into.
- The search area is...
Alright, I'll do that. Although I'll wait for others input for a day and then implement it so everything can be done together and I do not have to wait for 48 hours every time.
I just have a doubt,
I don't suppose the join_buffer_size would be 4.0M, it .0 at the end makes mysql fail to restart...
New results from the tuners:
MySQLtuner.pl
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.44-log
[OK] Operating on 64-bit architecture
-------- Storage Engine...
I just checked, the path /var/log/mysql/mysql-slow.log does not exist on my server.
var/log/ is available while mysql/mysql-slow.log is not..
Shall I create the file up ? or is there some other path it should log to?
Those three lines are already added. Thank you for looking into it :)
EDIT: I'll look into other variables. Just wrote down before you edited the previous post.
Changed, if there are any other suggestions, do let me know.
These three lines are already present within.
Hello,
I have been having some load issues with my server due to the response time in the MySQL server (I suspect that it is due to that). The load hits to 15/20 at peak hours (like just about 2 hours) and is below 1 most of the time.
I have been tracking down the process on what is causing it...
It mention's in my letter that if its used after 28th feb, then it value would drop to £50. So well, I suppose not many of those letters have been out ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.