… workload (which actually is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT NULL DEFAULT…-sec checkpoint interval, as TokuDB does time-based checkpoints. These drops are quite concerning, and it might be a problem for… –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still…_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8…_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… the most consistent performance. The others all have assorted performance drops scattered throughout the graph. We see the exact same pattern… –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size=10000000 –rand-init=on –report-interval=1…=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… Tables guide. Bugs Fixed: Percona XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped… backups has been merged. Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug fixed…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup and an… backups has been merged. Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug fixed…_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… single-row writes are likely to be slower in PARTITIONed tables unless you include something to facilitate pruning. A billion rows… levels. A “point query” in a billion-row (non-partitioned) table will, at worst, hit the disk only 5 times. (Usually… when partitioned, hence slightly faster. Conclusion: Not much difference. Yes, DROPping an ‘old’ partition is very efficient, much more efficient than…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… –apply-log –rebuild-indexes. This allows parallel processing of individual tables when rebuilding the index. Percona XtraBackup has implemented Encrypted Backups… typo. Bug fixed #1172016. Percona XtraBackup would assume the table has been dropped if the tablespace was renamed after it was scanned…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… some tests with concurrent load but did not see performance drops. It is reasonable that N threads doing concurrent load will…. Eventually you change from having all index blocks for all tables in memory to not and then disk read stalls occur…
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: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… how Lazy Drop Table and the new DROP Table in MySQL >= 5.5.23 work, I would like to mention quickly, that how drop table in… old implementation of drop table, but the “Lazy Drop Table” implementation wins here. The dips are there in the case of “Lazy Drop Table” but the… DROP TABLE, and I think this is something that could be implemented in “Lazy Drop Table” to further improve the overall performance during background DROP TABLE…
