June 19, 2013

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

I used to be recommended this blog via my cousin. I am not certain whether this put up is written by means of him as no one else know such exact about my trouble. You are incredible! Thank you!

Comment: On Benchmarks on SSD

great write up, heres a video I did on my SSD: http://www.youtube.com/watch?v=gZJ-pPeE5lA

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… environment other nodes are not known until they are brought up, hence bootstrapping with an empty gcomm:// is done for the… in its gcomm:// (since by this time node1, node2 are up). After this, a subsequent run of chef-client is done… node is restarted (and there are others when it comes up) it joins the cluster seamlessly. I would like to note…

Post: Call for papers: Percona Live London

…, the conference would be meaningless without great content. So step up and volunteer to present your unique insights into MySQL and…

Comment: Sphinx search performance optimization: attribute-based filters

…, so we applied the technique described here, but the search results have gone from milliseconds to more than 43 seconds

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… are interested in listening to the presentation, it’s currently up and available for viewing over at percona.com. My apologies… kernel has to do in reordering TCP packets can actually result in performance that’s worse than a single NIC.] The… binary log filters are executed on the intermediate server, thus resulting in less binary log data being sent down to the…

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… temporary table to store an interim result set, and then use that to ultimately produce the result you want, that’s another… to be first, then look up matching rows in `title` by a secondary index.  But the result was that it created a… it pays to test all different solutions, and measure the resulting performance! Q: Bill, back to the query where you were…

Post: ZFS on Linux and MySQL

…, you could even be more zealous.  Pretty interesting to speed up point in time recovery when you dataset is 700GB.  If… and it is surprisingly cheap.  In fact the best tpcc results I got were when using compression.  I still have to… have an impact on performance with ZFS the impact is up front and the backups are almost free.

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

… some caveats). Also, because of asynchronous replication, you can end up having inconsistent data on the nodes and encounter replication errors…

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

…_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which…