….7 on June 10, 2013. A drop in replacement for MySQL, downloads are …where an unprivileged MySQL account owner could perform brute-force password guessing attack on other…for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…Fulltext, Memcached integration, a more complete performance schema, online DDL and … this duplicate index, execute: ALTER TABLE `test`.`test` DROP INDEX `col2`; # ######################################################################## # Summary of indexes # …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… after the hot test. All OS caches are dropped at this time as well. These set of… is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not …_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… few slave instances each of production database servers and will perform the backups. The write load is not excessive so a… free, no performance penalty. You can easily run a server with hundreds of snapshots. With LVM, your IO performance drops to 33% after…’ll have to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
…MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates …consistent on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt.blogspot…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… fixed a number of performance bugs. (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
… fixed a number of performance bugs. (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
… 5.5.30 and MySQL 5.6.11 demonstrate notable drops in performance. What can be the reason for that? Below is… MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues… max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona…_node_incoming_address. Bug fixed #1082406 (Alex Yurchenko). Dropping a non-existing temporary table would be replicated when TOI was used in… case when DROP TEMPORARY TABLE statement was used, but it will still replicate in case DROP TABLE statement is used on a temporary table. Bug…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…. We can easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on this size will be…-sec checkpoint interval, as TokuDB does time-based checkpoints. These drops are quite concerning, and it might be a problem for… how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we will need…
