Announcement

Announcement Module
Collapse
No announcement yet.

Performance check

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Performance check

    Hi friends,
    How can i get a log to check the performance of my application in my sql.
    thanks
    annie

  • #2
    First of all I'd suggest to enable slow queries log:


    long_query_time = 1log_queries_no_using_indexeslog_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.

    Comment

    Working...
    X