… solution you choose? Whether it is open source or not? e.g. I choose MySQL, then I go write my app…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… only one specific use case useful with InnoDB compression: i.e. you have a separate table with TEXT column, which stores…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… we used a PowerEdge R720 box with a fast PCI-e flash card as storage. By default linkbench dataset has 10M…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 2, 2013 By 10 Comments
Mrten, Galera/PXC handles the privileges differently even if these tables are MyISAM – simply do not make direct modification to them instead use the usual commands i.e. GRANT, DROP USER, etc
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… if they are blocked by the underlying SST method, i.e., by FLUSH TABLES WITH READ LOCK.
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… are very few reasons to stay with MyISAM nowadays i.e. if you have FULLTEXT you simply cannot replace in short…
Comment: Is your MySQL buffer pool warm? Make it sweat!
April 25, 2013 By 6 Comments
Peter, e are building a dev system that does something similar, and …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… human readable table name in form database_name/table_name e.g. sakila/actor. `ID` is a table identifier. We will…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
Hi,Peter Boros Thanks for your good idea ! I have a security misgivings with use mysql -e,which need user and password because procedure box must be setted.
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select @@global.long_query_time into @lqt_save; set global…
