… CREATE TABLE statement. 0. Download the latest revision …mysql/ibdata1 3. Recover SYS_TABLES, SYS_INDEXES, SYS_COLUMNS and SYS_FIELDS from indexes 0-1, 0-3, 0-2 and 0… NOT NULL, `first_name` VARCHAR(45) CHARACTER SET ‘utf8′ COLLATE ‘utf8…DECIMAL(5,2) type sys_parser will generate DECIMAL(5,0). …
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 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 6.0… time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… GLOBAL. Downloads msl patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL 5.0.54a msl patch for MySQL 5.0.56 msl patch for MySQL 5.0.45 with InnoDB extensions msl patch for MySQL 5.0.51a…
Post: CentOS Comes with free build of MySQL Enterprise ?
January 4, 2008 By 10 Comments
… MySQL version in a hassle free binary form. (On the time of this writing you could only get binaries for MySQL Community 5.0.45 from MySQL Download Pages which was released in July and so about… centosplus mysql-server.x86_64 5.0.54-1.el4.centos centosplus These are not built exactly same as ones you would download on MySQL…
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
… may know MySQL ® announced 5.0.91 and 5.1.47 with serious security fixes, so we provide binary releases of Percona Server 5.0 and… in our download area: http://www.percona.com/downloads/Percona-Server-5.0/Percona-Server-5.0.91-22/ Release Percona Server/XtraDB 5.1.45-rel10.2 is available also ( we backported patches from 5…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… new connections as in MySQL. This is very helpful… you would want to download the “slow query log”…0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0.0987 1.2% 50 0.0020 1.00 0…45.68k 286 345 313.91 329.68 13.06 313.99 # InnoDB: # IO r bytes 0 0 0 0 0 0 0 0 # IO r ops 0 0 0 0 0 0 0 0…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
…| 6 | 0 | 5 | 242 | 0 | 3 | 0 | 8 | 7 | unknown | | | | | 7 | 0 | 6 | 3006 | 0 | 0 | 0 | 9 | 6 | unknown | | | | | 8 | 0 | 45 | 0 | 0 | 0 | 0 | 10 | 2 | undo_log | | | | | 9 | 0 | 50 | 0 | 0 | 0 | 0 …code also available to download P.S. There is Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and …
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…. You can download one here :GRA-header We can verify it easily: file /tmp/GRA-header /tmp/GRA-header: MySQL replication log….log: MySQL replication log [root@node2 mysql]# mysqlbinlog -vvv GRA_3_3-bin.log /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003…_TYPE=0*/; DELIMITER /*!*/; # at 4 #120715 9:45:56 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5…
