… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places, so… SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through speedier…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… similar to using mysql binary logs for … time. Refresh method performance comparison For demonstration …mysql> select sum(total_lines) from complete_example2; +——————+ | sum(total_lines) | +——————+ | 155187034 | <-- too high +——————+ 1 row in set (0.68 sec) mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… in a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… month projects. Why is that ? Performing MySQL upgrade two things should normally worry…MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL… bugs in MySQL history when issues would only happen at high load. …
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… some of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA… expected. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file name ./galax…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… was testing high volume replication today using Sysbench: sysbench –test=oltp –oltp-table-size=10000000 –db-driver=mysql –mysql-user=root –mysql-db=sbsmall… time and let few GB of binary logs to accumulate the performance on Master will be high even with replication running, but it…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems: A Real High…than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I … testing MySQL/Galera 0.8, binaries are available from Launchpad. The downside of MySQL/Galera …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… always analyze the local system performance independently from anything else. Performance This is perhaps the most … are) you better have binary log flushed on commit too. MySQL also has broken group commit (…. If you want SAN like high availability I would highly consider DRBD which can do storage…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… passive to disable any automatic failover during the process because high availability tools like mmm can cause failover if you stop…. Step 3: the binary event with the wrong server-id are performed on the two slaves (mysql 3 and mysql 4) and the new…-id 2 on mysql 4 (the passive master) is written in the binary log and the new events are also performed on the…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… – MySQL binary logs are not preallocated as Innodb logs are which means both Data AND metadata have critical changes on each binary log… access pattern which is often going to define your MySQL on DRBD Performance. Lets now see how DRBD works so we can…. My typical advice – if you want to have things highly durable and performing well at the same time you must have BBU…
