MySQL Forums
Forum List  »  Performance

Re: Mysql seems to be bogged down
Posted by: Mike Martinez
Date: September 20, 2005 09:54AM

Okay Ladies and Gents,
Here's the scoop:
In the configuration file for my.cnf there was a mistake. The previous webmaster was checking the calls to the database by turning on the logging capabililties of mysql. How is this done?

1.) Open my.cnf and place the word log into it and save the file.
2.) Restart mysql.

Since we didn't add any arguments when we put the word log into the my.cnf file, this will create a file in your directory mysql_data (usually found in the mysql folder) named after your machine (i.e. if your machine is webmedia your file will be called webmedia1.log). We get about 10 - 20 thousand visitor a day so our log file was growing at a rate of 2mb per minute. Last weekend we ran out of memory. This log file grew to 55GB!!! After we turned off log by delimiting it (putting a # in front of it in the my.cnf file) we gained a little bit better performance.

I've determined that our slow performance is probable due to the age of the OS (SunOS5), MySql (3.23.49) and apache (1.3.29) not forgetting to mention some questionable coding, who knows. Any further suggestions would be greatly appreciated.

Sincerely
Mike Martinez

Options: ReplyQuote


Subject
Views
Written By
Posted
2348
September 09, 2005 12:40PM
1453
A F
September 09, 2005 01:45PM
1693
September 09, 2005 09:32PM
1498
A F
September 12, 2005 07:50AM
2011
September 12, 2005 11:31AM
1355
September 12, 2005 05:13PM
1340
September 16, 2005 05:28PM
Re: Mysql seems to be bogged down
1513
September 20, 2005 09:54AM
1541
September 22, 2005 04:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.