Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Slow query log on V3.23.x
Slow query log on V3.23.x [message #199] Wed, 27 September 2006 08:09 Go to next message
geelwortel is currently offline geelwortel
Messages: 25
Registered: September 2006
Junior Member
Hi All

What is the command to add to the my.cnf file to start the slow query log for version 3.23.x?
Report message to a moderator
Re: Slow query log on V3.23.x [message #200 is a reply to message #199 ] Wed, 27 September 2006 08:15 Go to previous message
Peter is currently offline Peter
Messages: 405
Registered: August 2006
Senior Member
Super Guru
It should be same log_slow_queries=1

You however need to use set-variable to set long_query_time.

I have not been using 3.23 for a while so I might mistake names a bit. Use mysqld --help to verify it.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
Report message to a moderator
Previous Topic:One query on a big table vs multiple queries on multiple smalle ones
Next Topic:MySQL instalation - OS, Version
Goto Forum:
  

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

Current Time: Sat Jul 4 18:21:18 EDT 2009

Total time taken to generate the page: 0.01033 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.