… info on “5 Percona Toolkit Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of tools…-world MySQL database administration challenges, such as: Selecting which queries you should try to optimize to get better response times How to efficiently purge data from a huge table without putting too much load on your server How…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
…truth in the article “Dead database walking: MySQL‘s creator on why the future belongs to MariaDB.” To… the MySQL market and your product is under proprietary license (not an Open Source one) you set the bar to success high and you will have a harder time attracting customers,…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…This has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’…UPDATE achievements SET count = count + 1 where achievement = ‘killed_troll’; How many players might accomplish this achievement at the same time? …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical… is a link to the full documentation for setting up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb… Cost of operations time to maintain an additional system Impact of warmup time to application Cost of disk space on database server Now…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these…. Basically, we re-focused it on its primary objective: analyzing MySQL query logs. So the ability… to make their run-related options (–run-time, –interval, –iterations) standard. If you hadn’t noticed…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
…expiration time. If you use the default expiration of 1 year, your cluster will fail on…mysql/cert.pem; socket.ssl_key=/etc/mysql/key.pem” We simply configure the wsrep provider with our certificate and key files on…Will IST be encrypted if I set the above settings? Yes, according to Codership, IST …
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
…of downtime. As usual with these cases, we set up pt-stalk to trigger a capture if…it’s aggregation job on that. Granted, this means there is no run time data available, but at…traffic time without issues. If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…be loaded by the server either automatically on startup or on demand. Time interval between checks done by … can be imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described … on log copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… by Virident. First, some background information. All tests were conducted on Percona’s Cisco UCS C250 test machine, and both the… MySQL configuration for purposes of comparison. Given the apparent differences in time-based flushing in vCache and FlashCache, both cache devices were set…=on –report-interval=1 –rand-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… feature-set comparison between vCache and FlashCache and also to conduct some benchmarks for the use case where the MySQL working set is…, adjusting the dirty page threshold, flushing the cache on demand, or having a time-based cache flushing mechanism, but some of these… backing store, whereas FlashCache has a setting called “fallow_delay”, defined in the documentation as the time period before “idle” dirty blocks…
