…’) DATA, CONCAT(ROUND(data_free / ( 1024 * 1024 ), 2), ‘MB’)FREE from information_schema.TABLES where TABLE_SCHEMA=’xyz’ and table_name….00MB(free space) after this I executed alter table abc engine=innodb and re-executed SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT…’) DATA, CONCAT(ROUND(data_free / ( 1024 * 1024 ), 2), ‘MB’)FREE from information_schema.TABLES where TABLE_SCHEMA=’xyz’ and table_name…
Comment: How much memory Innodb locks really take ?
May 19, 2012 By 11 Comments
I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you …
Comment: ext4 vs xfs on SSD
May 18, 2012 By 23 Comments
Benoit, nice little script you’ve got there; using it!
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
… where did all of the configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built… being a startup company cannot afford to get paid support from percona, but at-least you can answer this one or…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
…difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run…involved? Because providing quality server builds is a substantial engineering effort that requires a lot of expertise to do…a role. Zend DBi is available under GPL license from Zend …
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
…sec) root@localhost:test 14:35:29>select * from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows …:35:54>insert into t values(29); ERROR 1205 (HY000): Lock wait timeout exceeded; try … my insert still be blocked. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION 0 …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 3.25 EC2 Compute Units each) 1690 GB of instance storage 64-bit platform I/O Performance: High API name: m2… LESS THAN (800000000) ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE = InnoDB, PARTITION p10…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… with bug fixes and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM… SST methods, better error handling New SST wsrep_sst_method=skip, useful when you start all nodes from the same sources (i… will connect to the first available Binaries are available from downloads area or from our repositories. For this release we will provides…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… /var/log/mysqld.log file which i believe is the error log you are talking about? 120502 11:50:41 [Note… down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11:51:16 InnoDB: Started; …
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB into my hands. In this post … thread. For 2 or more, the throughput varies a lot from second to second. I draw boxplots, which show 25-50…
