…and several other InnoDB and …execute: ALTER TABLE `test`.`test` DROP INDEX `col2`; # ######################################################################## # … … connected. $ pt-duplicate-key-checker –tables test.test # ########################################################################…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…for 10, 100, 1000 records in the main table. and transactions for this workload are: $ID=monotonically increasing… tps. With TokuDB we also see a drop, and by end of 5 hours the average …_log = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) …Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has been removed because the upstream DROP TABLE…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) …Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has been removed because the upstream DROP TABLE…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops in performance. What can be the reason…_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. The others all have assorted performance drops scattered throughout the graph. We see …configuration C avoids the spikes and produces a very constant and predictable result. vCache vs. FlashCache… = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…4) There are _no_ parallel queries (within a single connection) anywhere in any ‘free’ variant of MySQL. …whole table“: * If the DELETE is a single row based on a UNIQUE/PRIMARY key and it …hence slightly faster. Conclusion: Not much difference. Yes, DROPping an ‘old’ partition is very efficient, much…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…table_namesblogpercona.commanual master_bindblogpercona.commanual master_connect…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table | …all your data in MyISAM table so all you have to do is to drop old table and convert new table back to Innodb …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… with only a single connection. I felt these results warranted deeper investigation, so I did some research and detailed my findings here… by d_year, s_city, p_brand; And the schema: DROP TABLE IF EXISTS customer; CREATE TABLE IF NOT EXISTS customer ( C_CustomerKey int…_LastDayInMonthFl tinyint, D_HolidayFl tinyint, D_WeekDayFl tinyint ); DROP TABLE IF EXISTS lineorder; CREATE TABLE IF NOT EXISTS lineorder ( LO_OrderKey bigint not…
