… on the nodes and encounter replication errors, which you have to deal with. Even later, when asynchronous or single-threaded replication… the application gets really popular, sooner or later you have to think about write scalability, and implement sharding ultimately. I will… some possible deployment and scaling scenarios, when it makes sense to use one or an other, and common pitfalls we typically…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
Hi, I was looking for your forum to ask this but it seems to be down. Basically I have a problem regarding… on disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…Percona is glad to announce the release of Percona XtraBackup 2.1.3 for … a high priority bug. It’s advised to upgrade your latest 2.1 version to 2.1.3 if you’re using… processing during backups Savings on disk space and network bandwidth Automatic backup verification Higher uptime due to faster restore time XtraBackup makes…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
… XtraDB changed page tracking was enabled and variable innodb_flush_method was set to ALL_O_DIRECT. Bug fixed #1131949. Fixed the… not found in 32-bit builds due to a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause…_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so that…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… to illumos ZFS by giving up 10% total ram for metadata caching, but it is just the price you should be willing to… of L2ARC and ZIL. All I am dreaming now is to have LZ4 compressed persistent L2ARC, which is coming soon. 2… Pacemaker. Maybe you guys can get Galera working on OmniOS to solve our lack of clustering problem on illumos?
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… my tpcc test with primarycache=metadata, if giving more arc to metadata make sense, I should already see a difference right… move for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took a look at OmniOS but frankly it was the first time I read something about it. How…
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
Daniël, thank you for your feedback. * How do you define large schemas, and what do you mean …,000 tables per mysqld instance. SchemaSpy does take some time to execute but this is generally no more than a couple… this schema into Workbench so I can’t comment as to how well it scales at this volume of tables.
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… ARC size to 4GB” ZFS needs a significant portion of ram to work with. I agree that limiting ARC to small amount of ram prevents…) You need to sacrifice a little ram for ZFS metadata caching to make ZFS fast. NexentaStor recommends minimum 1-2GB ram for every 1TB… 20GB for ZFS is worthwhile. (All ZFS systems should max ram slots with 16gb dual rank dimms, which are relatively cheap…
Comment: MySQL 5.6.7-RC in tpcc-mysql benchmark
June 3, 2013 By 22 Comments
Hy, I’m new to TPC-C benchmarking and i would like to know how and what are the steps for testing MySQL with TPC-C benchmark. My goal is to compare VoltDB and MySQL under TPC-C benchmark. Thanks
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
Stephane, how are you coping with bug#69095 (replication fails with GTID enabled and master changes from SBR to RBR) and bug#69135 (mysql.slave_master_info is not updated) ?
