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: Call for papers: Percona Live London

…, bars, theaters, festivals and much more. With an easy-to-use interface, search within distance, date, or by type or genre…

Comment: Sphinx search performance optimization: attribute-based filters

… we use sphinx based on attributes, but memory consumption is exaggerated, so we applied the technique described here, but the search results

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

… recommend Xtrabackup SST for its reduced locking period from its use (which means the donor is blocked for a shorter while… like compression, parallel streaming, encryption, compact backups which can be used for SST (Note, the wsrep_sst_xtrabackup in 5.5… optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is to reduce the overhead…

Comment: Sample datasets for benchmarking and testing

the links here are useful and informative…

Post: Call for papers: Percona Live London

… us your war story: What have you experienced while actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank…

Comment: Sphinx search performance optimization: attribute-based filters

… groups per 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for examples…

Comment: Converting Character Sets

… to ensure that the new column is long enough to store as many characters as the original column.” [followed by a…

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… my complete answers: Q: Can you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance…’re talking about using a temporary table to store an interim result set, and then use that to ultimately produce the result you want, that…

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

… the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to hold the log system mutex for the log reads…_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which…