… am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers… will take some time to complete. Compression ZFS can compress data on the fly and it is surprisingly cheap. In fact… well. The tpcc database, which contains a lot of random data that doesn’t compress well showed a compression ration of…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… useful if you’re trying to limit the amount of data sent over the wire, but it comes at the cost… on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You can… problem before it occurs. For example, if you see a large number of long-running queries in the output of SHOW…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Hi Hrvoje, Few quick questions: 1. I have a large innodb database, do I have to export databases from mysql … import them in Percona server or can I use mysql data directory? 2. What’s the advantage of using Percona server…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… the benefits and unless you get to the large data sets you will not see large benefits. The Cloud might change a lot…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… ms up to several hundred. This really will open a large window where rows won’t be able to be updated…. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This is fine as long… (100, 1, NOW()); Conclusion Choosing a system to replicate your data to a distributed system requires tradeoffs. Most of us are…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
…-checksum/pt-table-sync, to check if data on replicas is in sync with data on the master pt-stalk, to gather data when performance problems happen randomly or are very short pt-online-schema-change, to run ALTER TABLE statements on large… fix the problem without rebuilding the tables How to gather data for performance problems that happen randomly and last only a…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… of SSDs and RAID them together and store all the data on that, and that will be better than HDD RAID… my data on SSD when some of that data might just be sitting idle? Or what if my database is really large, say… than a regular SSD or HDD RAID), I can write data out to spinning disk at a nice sustainable rate. @Mark…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both… away from this spherical read-only cow and throw some data updates into the mix, limitations of read-only transactions become…: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend innodb_flush_log_at_trx…
