| Performance check [message #2268] |
Tue, 27 November 2007 04:49  |
annpeter
Messages: 1
Registered: November 2007 |
Junior Member |
|
|
Hi friends,
How can i get a log to check the performance of my application in my sql.
thanks
annie
|
|
|
| Re: Performance check [message #2271 is a reply to message #2268 ] |
Tue, 27 November 2007 15:52  |
|
First of all I'd suggest to enable slow queries log:
long_query_time = 1
log_queries_no_using_indexes
log_slow_queries = /var/log/mysql/mysql-slow.log
And then put your application under some load (I mean jut work with it). When you'll get some noticeable amount of queries in the mysql-slow.log, just use mysqlsla on it and you'll see where you need to look to optimize your aplication.
Alexey Kovyrin, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
|
|
|
Members
Search
Help
Register
Login
Home
