Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Performance check
Performance check [message #2268] Tue, 27 November 2007 04:49 Go to next message
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
Report message to a moderator
Re: Performance check [message #2271 is a reply to message #2268 ] Tue, 27 November 2007 15:52 Go to previous message
scoundrel is currently offline scoundrel
Messages: 58
Registered: August 2006
Location: Toronto, ON, Canada
Member
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
Report message to a moderator
Previous Topic:How to solve this connection error?
Next Topic:Mysql Replication with write forwarding?
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 01:19:45 EDT 2009

Total time taken to generate the page: 0.08071 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.