Lucene/Solr for Searching Memcached for Caching a lot of stuff Varnish for caching too, but that’s a bit different
Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26
June 18, 2013 By Leave a Comment
… since then there has been tremendous interest and adoption. There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such… will include: Backups from the cluster Avoiding SST Flow Control What and How to Monitor Tuning best practices This webinar is…
Post: Call for papers: Percona Live London
June 14, 2013 By Leave a Comment
… keynote, tutorial or breakout session. Tell us your war story: What have you experienced while actively using MySQL, Percona Server, MariaDB… looking for sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs…
Comment: Percona Server 5.6.11-60.3 first Release Candidate now available
June 18, 2013 By 3 Comments
does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: How to calculate a good InnoDB log file size
June 14, 2013 By 38 Comments
According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…part two in what is now a continuing series on the …The SSB The SSB tests a database’s ability to optimize queries for a star… It seems that InnoDB performs better when a larger number of rows must be joined together …innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… of it in a browser-displayable format. It lets you click through the…links and entity-relationship diagrams. It’s also designed to help resolve the…, number of children, parents, count of columns, row counts, and comments — a great way… via crontab once you’re done. What are some ERD tools you use…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… MySQL designers know can be improved. But there’s a finite amount of engineer-years spent developing …a better random choice. Another workaround may be to add a column to the table, and populate the rows … an option there? Yes, I think what you’re referring to is what I covered as the Derived-Table …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… simple query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL HA solution is… I could see network latency wreaking havoc with MySQL’s internal understanding of what‘s happening on the system below. Having never experimented… a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung on me, so that’s where…
