Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Dec 2008

    Default MySQL Tuning and Performance

    I've found these scripts helpful in MySQL Tuning and Performance

    And this one is based off of it

    I tried a program called monolith but couldn't get it working right

  2. #2
    Junior Member
    Join Date
    Dec 2008

    Default slow query analyzers

    for running these, 48+ hours uptime is recommended

    this one may be useful, though I didn't try it

    westhost has recommended this one but I couldn't get it to do anything

    this one also looks useful. I ran it once and it worked, though it took a while to run
    I ran it from /var/log as
    ./mysqlsla-2.03 -lt slow slow_queries.log > slaoutput.log
    to save the output. (it had set in /etc/my.cnf log-slow-queries = /var/log/slow_queries.log for a while) Now I just need to figure out what to do with it...

    I didn't try this

    This seems to be the same at the day32 script

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts