Use an etl tool like Talend to load the slow query log into a table. We do something similar with the general query log very successfully with mysql 5
Even with 5.1 i would use this approach over the built in log tables as the built in log tables impact performance quite significantly. Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer ----------------------- Sent from HP IPAQ mobile device. -----Original Message----- From: Brown, Charles <cbr...@bmi.com> Sent: Thursday, October 08, 2009 4:37 PM To: Jaime Crespo Rincón <jcre...@warp.es>; mysql@lists.mysql.com <mysql@lists.mysql.com> Subject: RE: MYSQL slow query log in table. Hello. Thanks for quick response. I'm running Mysql 5.0. We have no plans to upgrade to 5.1 that supports slow-log table. Do you know of any work around to get my slow query into a table -- just wondering. Desperate for a resolution or circumvention. -----Original Message----- From: Jaime Crespo Rincón [mailto:jcre...@warp.es] Sent: Thursday, October 08, 2009 10:17 AM To: Brown, Charles Cc: Daevid Vincent; mysql@lists.mysql.com Subject: Re: MYSQL slow query log in table. 2009/10/7 Brown, Charles <cbr...@bmi.com>: > Hello All. I would like to implement MYSQL slow query log in table. Can > someone kindly assist me with the table definition and implementation. SHOW CREATE TABLE mysql.slow_log; <http://dev.mysql.com/doc/refman/5.1/en/log-tables.html> -- Jaime Crespo MySQL & Java Instructor Warp Networks <http://warp.es> ******************************************** This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. ******************************************** [The entire original message is not included] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
