… data if you don’t need to?). I get up to speed a lot faster and can contribute to the Development process… 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: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… second, you could even be more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. If… interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is up front and…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… non-relevant tablespaces when partial backup is being taken which speeds up the backup process. Bug fixed #1130145. Percona XtraBackup didn’t… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… version of Percona XtraBackup has implemented full support for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… backup is being taken which speeds up the backup process. Bug fixed #1130145. Due to different implementation in MySQL 5.6 error messages…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…a cost-effective price point, or I might end up saturating my RAID controller such that now it … not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the…RAM, that’s true, but much closer to memory speed than a regular SSD or HDD RAID), I can…
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
… check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query… by MySQL restart. Even if you restart MySQL server there is significant chance data will still remain in Operation System cache speeding up query… started and is warming up ? Sometimes it makes sense. In this case you would want to clean MySQL and OS caches, most…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as well… is faster local network transfer default GZIP compression will not speed things up on the standard point to point 1Gbit network connection….7 seconds which gives 105MB/sec read speed from archive media and 276MB/sec write speed to the hard drive – this means…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… investigation of the fact read_buffer_size variable affects connection speed. This is not something you would expect right ? me too… use the buffer only once. What can be done to speed things up here ? Of course you can tune you malloc settings… quick. Also MySQL should get smarter in terms of which buffer size should be used, even for sake of speeding up the reads…
Post: 3 ways MySQL uses indexes
September 12, 2009 By 28 Comments
… on the first place. Most popular index type in MySQL – BTREE can speed up equality and prefix range matches. So if you have… of this mistakes come from missing one very important MySQL limitation – once MySQL runs into the interval range it will not use… the reason covering indexes help to speed up queries even if data is in memory. If MySQL is only reading index and not…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… design and understanding inner works of MySQL. If you design your data wisely considering what MySQL can do and what it can… knows about indexes is the fact they are good to speed up accesses to database. Some people would also remember if indexes… large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by…
