… tables each with hundreds of thousands of records, for we use sphinx based on attributes, but memory consumption is exaggerated, so…
Comment: Sphinx search performance optimization: attribute-based filters
June 12, 2013 By 11 Comments
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… are referenced the most, and which are candidates for dropping (why keep old data if you don’t need to?). I… for your database — I’m using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required… properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… can use the second index not only for filtering on both columns, but also for filtering by just the first one. Why can’t MySQL enforce this kind of constraints? For many reasons: the… it would break 99% of all applications out there that use MySQL, for which we at Percona tend to find redundant indexes…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… well-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at some other layer of the system stack) and then conclude with some typical use…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
…. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys can…
Comment: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
The ERD tools I use are MySQL Workbench and SchemaSpy. The anomalies tab of SchemaSpy has been quite helpful. However both tools can’t really cope with really large schemas.
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
… Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… was using for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL…-fu was not enough to understand why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here… an important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to name just two…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … needs. With simple services or development systems, many people are using a single server with some backups configured, and then simply… asynchronous or single-threaded replication is not enough, people can use Percona XtraDB Cluster, which has some of its own caveats…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… to missing libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to hold…
