June 18, 2013

Post: TPC-H Run on MySQL 5.1 and 6.0

April 10, 2008 By 16 Comments

…. It can be downloaded here So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB… MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL…

Filed Under: Benchmarks

Post: Identifying the load with the help of pt-query-digest and Percona Server

December 29, 2011 By 3 Comments

… just for new connections as in MySQL. This is very helpful for … so ideally you would want to download the “slow query log” to another…hits # 10 0x88BA308B9C0EB583 0.0905 1.1% 4 0.0226 1.00 0.01 SELECT poller_…= 1.00 [1.0], V/M = 0.00 # Query_time sparkline: | .^_ | # Time range: 2011-12-28 18…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… 1.3383517265319824 | | 7112 | Download… And Background Checks | 4.516233444213867 | …mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_myisam_stopword` ( `value` varchar(18…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How to recover deleted rows from an InnoDB Tablespace

February 20, 2012 By 4 Comments

…it clearer: 1- Extract all the InnoDB pages from the tablespace: First we need to download Percona … located (-f) The row format can be -4 (REDUNDANT) or -5 (COMPACT). From 5.0….mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id 18, flags 1…

Filed Under: Insight for DBAs, MySQL

Post: Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By 17 Comments

…=2 -fexceptions -fstack-protector –param=ssp-buffer-size=4 -m64 -mtune=generic’ ‘CXX=gcc’ ‘LDFLAGS=’ This command … 1 macko macko 7453516 2008-04-18 20:38 sql/mysqld You are ready to have the patched MySQL …. Downloads msl patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL 5….

Filed Under: Percona Software Tagged With:

Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1

February 3, 2013 By 8 Comments

…-rw-r–r– 1 root root 20427834 Jan 30 18:44 Percona-XtraDB-Cluster…5.29-23.7.1.387.rhel5.x86_64 3.4 M Transaction Summary …y Downloading Packages: Running rpm_check_debug ERROR with rpm_check_debug vs depsolve: mysql…

Filed Under: Events and Announcements, MySQL, Percona Software, XtraDB Cluster

Post: Improved InnoDB rw_lock patch

October 20, 2008 By 3 Comments

…results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442) ThreadsStandard InnoDBGoogle …on 8cores box, and as you see for 4+ threads we have worse results than for 2…download them there The results for the same benchmark: ThreadsStandard InnoDBYasufumi rw_lock ver 2 19700.289812.18…

Filed Under: Percona Software Tagged With: , ,