… referring to the amazing MySQL manual, especially the option and variable reference table. ….commanual Delayed_errorsblogpercona.commanual delayed_insert_limitblogpercona.commanual Delayed_insert_threadsblogpercona.commanual delayed_insert_timeoutblogpercona.commanual delayed_queue_sizeblogpercona…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… database server for the initial insertion, because you can write CSV files with any programming language. Naturally, CSV files don’t store… server. If you do it on the master with INSERT..SELECT queries, it will propagate to the slaves and it… save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as …. As default table format for slow_log is CSV with no indexes typical operations like finding how …similar structure with needed index and populate it with insert… select statement as you need it. One little …
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…to to integers: sql/log.cc, Log_to_csv_event_handler::log_slow(): 610 longlong query_time= (…Statistics,Processlist,Connect,Kill,Debug,Ping,Time,Delayed insert,Change user,Binlog Dump,Table Dump,Connect …: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the …
