… on crontab so that schema changes are automatically picked up. Nice, eh? Usage of this tool is very straightforward and it… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… enabling GTIDs on a production setup. The manual describes very nicely how to switch to GTID-based replication, I won’t… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
Nice to see this writeup on ZFS and MySQL. One question, why with 192GB of memory, did you limit …. Would be interested if someone wanted to contribute on the MySQL side. Interesting that on Wikipedia Data Virtualization is talked about… is not seen for example aggregating Oracle, SQL Server and MySQL into one source that the user or application sees. On…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… nice description of how to setup and run this benchmark, can be found here. We decided to run this benchmark for MySQL…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in this benchmark… the special-case “read-only transactions” optimization in MySQL 5.6 are nice ways to improve scalability in highly concurrent workloads. We…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… code base. However… for those using MySQL, Percona Server, MariaDB or any other of the MySQL branches/forks, you get to have… UI for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file… implemented in MySQL, the defines can still found in the source. Basically, it’s why we can’t have nice things (like…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods… run time data available, but at least you get a nice ranking of queries sorted by the number of times they… issues. If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more work, in…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… vCache with the time-based flushing that we see some nice, predictable, constant performance. So why is it the case that…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
…, Nice article. Recently we shifted on following new dedicated server. From first day onwards, we were facing the performance issue. Still MYSQL… going down. Then we did some R&D on Percona MYSQL server and found that Percona need some configuration setting regarding… again performance degradation started and now it is slow again. MySQL load is not going very high. We have also noticed…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe…), I can write data out to spinning disk at a nice sustainable rate. @Mark- I don’t know, actually. The only…
