… trouble is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to swap… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL… was, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine the performance…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… is not enterprise and has a lot of different properties – Top web sites like Google, Yahoo, FaceBook have to have to… see as response to these requirements ? From MySQL side we have further development of MySQL Cluster to be more usable for web… scale of Big Table with Map Reduce. Indeed I think MySQL Replication usage will reduce, but I would not expect Memcached to…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
…_DELETE: 62494969560 Or using this data we can TOP 5 accessed tables via mysql> select OBJECT_NAME,COUNT_STAR from table_io… is table with statistic per index: mysql> select * from table_io_waits_summary_by_index_usage where OBJECT_NAME=’sbtest55′G *************************** 1…_OF_BYTES_WRITE: 326303744 or we can get top tables that required read IO mysql> select * from file_summary_by_instance order…
Post: 3 ways MySQL uses indexes
September 12, 2009 By 28 Comments
… of this mistakes come from missing one very important MySQL limitation – once MySQL runs into the interval range it will not use… MySQL uses single index – there are more complex rules of how indexes will be used if you look at multiple indexes usage… across many pages requiring potentially a lot of IOs. On top of that if you just need access to couple of…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… saying about XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise… in MySQL I have created more than hundred of such little projects suggested by MySQL customers and myself based on long MySQL usage for…
Post: Serious build and testing automation
January 2, 2013 By Leave a Comment
… plugin). We currently have: approximately 32 slaves performing builds 151 top level jobs (many of these are matrix jobs) 2,578… done many, many more than this) totalling 109GB of disk usage and a Jenkins master Java process that uses 4GB of…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… are my server ‘TOP‘ status, as you can see cpu4 use 100% usage while others like at idle state. top – 18:27:53… is my.cnf configuration file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for…_concurrency thread_concurrency = 16 set-variable=max_connections=2000 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… much more practical to look from the top of the stack. If you look at MySQL log you may find some queries… among all pages we would see CPU usage as the main factor because sphinx and MySQL respond from cache. We however see… based from top to bottom approach is especially helpful for complex applications using mutliple components (like sphinx and MySQL) or multiple MySQL Servers…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 14 Comments
… be interested in best selling product or top sales people. This information may often need …| | 6950 | 290 | +——+—–+ 10 rows in set (21.12 sec) mysql> select count(*) cnt from dt where slack like “a%”; … desc limit 11; ERROR 1221 (HY000): Incorrect usage of CUBE/ROLLUP and ORDER BY Oops. Bad …
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
… usage. Currently the master db is freezing up. Its replicating to 2 slave servers. When it freezes up it’s top state shows “ucond” and cpu usage is 0% or very low so somehow…-resolve max_connections = 2000 skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id=1 wait…
