Re: Total newb at performance tuning mysql

One of our engineers first installed MySQL on one of our Sun boxes which was doing nothing more than MySQL... It seems we also put it on the server and turned it on... it behaved very badly. Essentially when we started to investigate MySQL and find out if we could use it we discovered that

Re: Total newb at performance tuning mysql

Scott Haneda wrote: Unless I am totally off base here, the mysql docs tell very little in regards to how to performance tune mysql. So far I have found this article to help: But it still leaves me with a ton of questio

Re: Total newb at performance tuning mysql

Instead of your cron job, I suggest http://codenode.com/mysqlreport The mysqlreport documentation (http://codenode.com/mysqlreportdoc) is a pretty baseline introduction to comprehending server performance via a mysqlreport report, and a little bit about what you can do for certain issues. -Dani

Re: Total newb at performance tuning mysql

Hello. > I can tell, I have no my.cnf file in place, so there must be some default Create your own and the appropriate value for the table_cache. See: http://dev.mysql.com/doc/mysql/en/option-files.html http://dev.mysql.com/doc/mysql/en/program-variables.html

Total newb at performance tuning mysql

Unless I am totally off base here, the mysql docs tell very little in regards to how to performance tune mysql. So far I have found this article to help: But it still leaves me with a ton of questions. For starters, and d

Performance tuning Mysql

Vien Huynhle writes: > I am getting this error in my log files from mysql > > (Got timeout reading communication packets) > > I'm starting safemysql with the variables > > -O key_buffer=16M -O sort_buffer=1M -O back_log=200 & Hi Vien, Please increase the 'net_write_timeout' and 'ne

Performance tuning Mysql

I am getting this error in my log files from mysql (Got timeout reading communication packets) I'm starting safemysql with the variables -O key_buffer=16M -O sort_buffer=1M -O back_log=200 & mysql> show status -> ; +--+--+ | Variable_name| Va