…and timing much differently than traditional hardware, and I’ve seen situations where… for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5…. file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… for MySQL is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query-log and MySQL… the overall performance of your MySQL database server. Percona Playback for MySQL can also help evaluate new server versions, patches and hardware against existing setups to…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…plugins are available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions …Karen Padir, the new manager responsible for MySQL business at Sun. A lot of Sun hardware and Solaris focused talks this year. …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to… as the culprit for the results difference. We then compared results across all 3 boxes to see if different hardware has any…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…MySQL 5.6 instance running the memcached plugin. Here are some details about the test: Minimal hardware…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… KEY UPDATE statements for that), so it will produce all good amount of reads. A few words about the hardware: I am…/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD…_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… many process stay in sleeping condition for long time like 200-300 processes. Current Server Details (Dedicated Server): Software: Apache Version – 2.2.15 (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave. I… raid controller with six 300G SAS drives in a raid10 for the database and four 2TB SATA drives in a raid10…=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server-5.5…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
…Server for MySQL A free, open-source solution, Percona Server for MySQL is an enhanced drop-in replacement for MySQL…
Page: Consulting for MySQL
July 31, 2006 By
… you’re looking for. Remote DBA Services for MySQL We act as your remote MySQL DBA – manage users, make sure server runs well… support for MySQL Need choosing Hardware and OS for MySQL ? Performing configuration and troubleshooting platform related issues ? We can help you designing optimal hardware …
