… / ( 1024 * 1024 ), 2), ‘MB’)FREE from information_schema.TABLES where TABLE_SCHEMA=’xyz’ and table_name=’abc’ and Data_free > 0 limit 10…(free space) after this I executed alter table abc engine=innodb and re-executed SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
May 18, 2012 By 21 Comments
Is there any option to save the result of show slave status in a table like insert into temp show slave status;
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… is lower with only the primary key because the entire table fits in main memory. Each row is on the order of 30 bytes in the primary table, and so a billion rows is about 30GB. Since we…. With a 55GB buffer pool, we would expect the primary table to simply fit. But with all 4 indexes the data…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… every partition would hold 100 million rows. Table Structure The table structure of the table with no secondary indexes is as follows: CREATE… ENGINE = InnoDB) */ While the structure of the table with secondary indexes is as follows: CREATE TABLE `purchases_index` ( `transactionid` int(11) NOT…
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 16, 2012 By 9 Comments
Gilles, you can filter what tables to replicate using regular replication filter i.e. replicate_*, for it does not affect a node propagation. The new node still will copy all databases and instances.
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… on a DDL statement if an XtraDB internal SYS_STATS table was corrupted or overwritten. This is now fixed by detecting the corruption and creating a new SYS_STATS table. Bug fixed #978036 (Laurynas Biveinis). Release notes for Percona Server…
Post: Load management Techniques for MySQL
May 6, 2012 By 2 Comments
… with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is…
Comment: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
It looks like the requirement on both a single column unique key, or indeed any unique key has been lifted … of using at wikipedia but was limited by having many tables with composite primary keys (or no pk / unique key at…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What about manual aborting a run. will…’t yet have a “resume” feature implemented. Q: periodically the ALTER isn’t written to the bin-log and thus isn… relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL bug…
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
Hi Bill, I’m using the closure table hierarchy to store regions in a database using MySQL and …. I know the level of each branch (with the length column) but they are different for each and can be more…
