| Re: What about caching queries? |
| by trabis on 2008/9/23 12:59:42 Hi jdseymour, thanks for your interest! It took me some days to login in ssh. Seems the port has been changed. Then I made what you have told me and applied the changes from the link you gave me. I did not notice any diference using the new values so I tried to change some of them and it got worst. I reverted it back to the values proposed and I let it be. Yesterday, a busy day, the server blocked for 15 minutes, load went above 20 with my 2 CPUS. I believe that was during backup or something. I will check today and tomorrow to see what happens. If it repeats I will have to use the my.cnf backup. I notice that there are some scripts to help tunning but I do not know or don´t want to risk install them. |
| Re: What about caching queries? |
| by jdseymour on 2008/9/23 0:10:49 Hi trabis, Any luck for you with this? |
| Re: What about caching queries? |
| by trabis on 2008/9/16 21:35:42 Ok, I will try that and report back. Thanks again! |
| Re: What about caching queries? |
| by jdseymour on 2008/9/16 21:20:28 I have found this helpful: http://mysqldatabaseadministration.blogspot.com/2005/11/mysql-5-optimization-and-tuning-guide.html It will give you a good start. Remember, optimization is a long process of making small changes and watching the results. Begin by doing a "mv my.cnf my.cnf.old" to back up your current one. then move to /var/lib/mysql and do cp my-medium.cnf /etc/my.cnf . my-medium.cnf will also give you a good basic starting point to build on. 
|
| Re: What about caching queries? |
| by trabis on 2008/9/16 18:46:12 Thank you 
|
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|