…’t measuring the cost of index maintenance. Transaction-id is auto-incremented, and so partitioning on transaction-id makes the insertions easy… in the primary table, and so a billion rows is about 30GB. Since we are inserting on an auto-increment key, I would…. 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
…. Table Structure The table structure of the table with no secondary indexes is as follows: CREATE TABLE `purchases_noindex` ( `transactionid` int(11) NOT NULL AUTO_INCREMENT… structure of the table with secondary indexes is as follows: CREATE TABLE `purchases_index` ( `transactionid` int(11) NOT NULL AUTO_INCREMENT, `dateandtime` datetime DEFAULT…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… / ( 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: 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: 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: Why MySQL could be slow with large tables ?
May 15, 2012 By 139 Comments
i have 90GB db, my selects are pretty slow with tables over 500,000 rows. guess i will have to partition as i used up the maximum 40 indexes and its not speeding things up. i think max rows per table should be 50-100k rows
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 15, 2012 By 9 Comments
Panagiotis, it is supported on level as MyISAM supports Dave, it works like global table lock for MyISAM table. As MyISAM is not transactional there is not much we can do it.
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 15, 2012 By 9 Comments
Glad to see support for MyISAM tables! Just curious – how is this done without transactions?
