…_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so… MySQL 5.1.69-17.4 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so… MySQL 5.6.11-60.3 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… “hotspots”. Examples of hotspots Example 1: Your application is an online game and you keep track of global achievement statistics in… Instead of updating global counters one at a time (from Example 1, above), how about maintaining the counter in memcache or redis…
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
…now will show per session counter increments and to get global counters SHOW GLOBAL STATUS needs to …=20 order by last_online desc limit 10) ORDER BY last_online desc limit 10; +—-+————–+————–+——+—————+——+———+——-+——-+—————-+ | id | select…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… anything meaningful based on a ratio of counters, because the process of dividing one counter by the other to get the ratio…’s why its counters are so small. The second server has been online practically forever, and that’s why its counters are big… all types of ratio-based and counter-based tuning techniques. Summary Major points in this article: Counter ratios are meaningless as a…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… a different customer’s system. This one is a popular online retail store, running in the Amazon cloud. It’s a… I calculate should cost $100 per month. I grabbed the counters from /proc/diskstats and computed I/O operations done so…. This is over a long period of time, so the counters could have wrapped, but let’s assume not. So this…
Comment: PHP Sessions - Files vs Database Based
March 27, 2009 By 38 Comments
Only consistent way how to count users online, if sessions are stored in memcached is to have your … online and other usefull stats that are problematic to get from MC. You can also create file based backup with simple counter…
Post: Announcing Percona Server for MySQL 5.5.30-30.1
March 7, 2013 By Leave a Comment
…_table variable could share CPU cache lines with InnoDB row counters, which resulted in high false sharing effect in high-concurrent… Server 5.5.30-30.1 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… Biveinis). Fake changes were increasing the changed row and userstat counters. Bug fixed #1064333 (Laurynas Biveinis). Log tracking was initialized too… Server 5.1.66-14.2 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
Post: Announcing Percona Server 5.5.28-29.2
December 7, 2012 By 2 Comments
… Biveinis). Fake changes were increasing the changed row and userstat counters. Bug fixed #1064333 (Laurynas Biveinis). Log tracking was initialized too… Server 5.5.28-29.2 are available in our online documentation. Bugs can be reported on the launchpad bug tracker…
