…print out queries taking more than 0.5 seconds to execute or having more than 1000 rows…execute combined. There is a tool mysqldumpslow in MySQL distribution which kind of does the thing -…time: 3.348823, Average time: 0.000935686784017883 ### Taking 0.000269 to 0.130820 seconds to complete ### Rows …
Post: Announcing Percona Server 5.5.28-29.3
January 8, 2013 By 2 Comments
…). Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.3 is now the…). Rows_read was calculated in a way which lead to a negative value being printed in the slow query log. Fixed by making Rows_read to be a synonym for Rows_examined in the slow query…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…in a single thread. MySQL never takes advantage of more than a single CPU when aggregating data and fetching rows… is single threaded in MySQL, the new …in a file (or stdin) and a config file. It runs the SQL via ShardQuery and it prints…76904368400570.98018693923950.93061804771423.3 year11.972….
Post: Converting Character Sets
March 17, 2009 By 22 Comments
…row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `c1` mediumtext NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 1 row in…columns to their binary counterparts 3) Convert the table to …Print the ALTER statements that would be executed without executing them. –user|u The MySQL…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… all together we have row which is stored in 3 pieces which are stored in different locations which may require… rather compact foot print in optimal case. On other hand because it leaves old versions in the data files… try out (We’re using PBXT with MySQL 5.1 in one of our projects) and if developed…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…have you ever wondered what servers are in your MySQL replication hierarchy? We have, too… to every server in the replication hierarchy, and prints out a summary…table=foo%.mount% Binary logging ROW Slave status 0 seconds behind, … Auto-increment increment 4, offset 3 InnoDB version 1.0.6-unknown…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…in chunks of a million rows each. (InnoDB internally does operations such as ALTER TABLE in 10k row…fifo. Every million lines, the script prints an EOF character to the fifo…loading the entire 4GB file in one chunk: time mysql -e “set foreign_key…. vmstat showed from 1% to 3% I/O wait during this time….
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… user requests, you are usually interested in queries that are consuming most MySQL time and that’s how mk-query-….00 0 0.06 0 # Rows read 1 2.01M 0 250.47k 3.96k 1.96 27.94k 0….mk-query-digest –filter=’$event->{Thread_id} == 160847′ –no-report –print in > out Pretty cool, isn’t it? Sure, it would …
Comment: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…innobase/dict/dict0dict.cc dict_table_print_low 4944 dict_stats_update(table…(*table, DICT_STATS_FETCH, TRUE); 3 storage/innobase/fts/fts0fts.cc…); 6 storage/innobase/row/row0mysql.cc row_truncate_table_for_mysql 3318 dict_stats_… and dict_stats_update will in turn hold the lock. ========= | /* check…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
….so user=mysql wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave…_read_timeout = PT30S; replicator.commit_order = 3 130221 17:59:06 [Note] … if not, decrease some variables in the equation. Thread pointer: 0×0 …_stack 0×30000 /usr/sbin/mysqld(my_print_stacktrace+0×33)[0x8415893] /usr/sbin…
