… records), then you don‘t want to use this. Please see “Highly selective columns only” section for examples where it doesn’t work well for…
Comment: Sphinx search performance optimization: attribute-based filters
June 13, 2013 By 11 Comments
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the other servers to s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations… file/binlog position needs to be done with care if you don‘t want to break replication or corrupt your data. Scenario #2: One… the missing events with mysqlbinlog. Let’s say that we want to promote s1 as the new master. We need to…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… is fundamentally broken in the design. You don‘t want to be compatible with it. I don‘t see anyone wanting to try to run a mixed replication cluster of MySQL 5.6 and MariaDB 10 using GTID. You will…
Comment: Sphinx search performance optimization: multi-threaded search
May 24, 2013 By 10 Comments
Hi Robert, – you don‘t actually need to merge sphinx indexes – it does that on the fly. If you are using sphinxql, you can actually just list all the indexes you want to merge on the fly… here for some explanation. And btw, you don‘t want to run indexer for the virtual index, you want to index the local parts instead, hence…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… mirror) and I limited the ARC size to 4GB. I don‘t want to start a war but ZFS performance level was less… on write filesystem, the snapshots are free, no performance penalty. You can easily run a server with hundreds of snapshots. With… fine. Since starting a snapshot take less than a second, you could even be more zealous. Pretty interesting to speed up…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 4 Comments
Hi Moazam, 1) no, you don‘t have to export databases, you can use the existing mysql data dir. But check http://….percona.com/doc/percona-server/5.1/compatibility.html if you‘re planning to switch back from Percona Server 2) here…
Comment: Profiling MySQL Memory Usage With Valgrind Massif
June 5, 2013 By 3 Comments
Aurimas – You-don‘t-run-that-in-production, the slowdown is 10x or more. If you have a server that needs Valgrinding, first you have to reduce the workload to the lightest possible that still exhibits the issue you are investigating.
Comment: Profiling MySQL Memory Usage With Valgrind Massif
June 5, 2013 By 3 Comments
… it’s like barely noticeable or is it more like you-don‘t-run-that-in-production ?
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… 5.6 to MariaDB 10.0 or vice versa. You just won’t be able to use the GTID features to automatically…. That being said, I agree that compatibility is good. If you have any suggestion of how to make MariaDB compatible without…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… for the optimal production deployment you want two identical physical boxes with at least 4 NIC ports. Why 4? Two of those NICs… a two-NIC bonded pair you‘ll get roughly 1.67x the throughput of a single port. [Don‘t try more than 2… reaction was, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine the performance being…
