…2 (InnoDB dataset size ~5G). I did not use Scale Factor of 40 (InnoDB dataset size ~95G), because the…to MySQL 5.5, and this does not make sense to me. Probably its due to a bug in how counter…to improve the performance of secondary key lookups as well. But this works only with joins and specifically …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…There are internal scaling aspect of the system which include both latching as well as inevitable application…How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql… CPU vs IO utilization as well as as simple as how much does it cost to run a…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
…I wonder how many of MySQL Users are running applications of these scale, for single MySQL Server ?…well over 10K IOPS without going to external storage. 500MB/sec would be exceptional for traditional MySQL as MySQL optimizer with its nested loops joins does not favor …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… because so much more people have followed that road. So how do people approach the upgrade process ? I will describe couple… widely used and well maintained software is the more likely it is to run on wide set of MySQL versions. Safe Approach… ensure both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL history when…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… existing MySQL data sets and queries. Another advantage is that it works with all MySQL storage engines. This set of benchmarks evaluates how well… the scale up configuration it does not perform any better than the baseline, and actually performed just a little worse. Since scale out…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… with what the lead consultant does. We want two sets of …well. The audit itself OK, so here’s a very basic audit, whose scope I’ll keep within just a MySQL… question of where they fall on the scale. Now I analyze these one at… need to really know how to write queries and how EXPLAIN works. At Percona…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… of second to do, but it is not how it happens in practice. mysql> show global status like “key%”; +————————+———+ | Variable_name | Value… | +————————+———+ 7 rows in set (0.00 sec) So how long does it take: mysql> select count(*) cnt,c from gt group by c… rows in set ( 16.41 sec) So MEMORY table scales pretty well with query execution time being close to linear dependence of…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…does MySQL Related work – it is very hard to find people with good enough MySQL knowledge. MySQL…know MySQL well …MySQL and LAMP systems in general, LAMP performance optimization, replication and high availability, scaling, writing whitepapers, helping people with data recoveries, implement MySQL… how …
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
Where does real power of MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this… makes Jim to try harder, if Heikki sees Innodb does not scale as well as PBXT it will be an extra pressure to… any case this is very interesting how it will be evolving and how more parts in MySQL will become pluggable and so hopefully…
Post: MySQL Community Dinner
April 14, 2008 By Leave a Comment
… time – when we were discussing how the bill should be handled for…MySQL and MySQL Community guys, in particular with Mark Callaghan from Google about his experiences of using MySQL and work he does to scale MySQL…queries which MySQL does not optimize well. Also Mark told about failure rate of MySQL/…
