…single MySQL server with improved performance and high availability. Of course there is MySQL … MySQL does not handle complex queries well, being able to use only one CPU…MySQL I have created more than hundred of such little projects suggested by MySQL customers and myself based on long MySQL usage…
Post: Percona Server with XtraDB Case Study, Behind the Scenes
October 21, 2010 By 13 Comments
… cache was causing both mutex contention and excessive CPU usage, for different reasons, and I found different problems… could be done without fixing these problems inside MySQL and InnoDB at the source code level, or… the database server’s performance is not as high as many I’ve worked on, so the…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… happening in parallel, improving buffer pool usage (currently you may need to both …. If you choose this number too high the compression ratio will not be … becomes increasingly important as their number per CPU just keeps doubling. It is also … which may come in MySQL 5.2 or even MySQL 5.1. I surely …
Comment: Choosing innodb_buffer_pool_size
November 16, 2012 By 39 Comments
… right mysql configuration for me? This dedicated mysql server is for my otrs application the problem is my database is always having high load average and cpu usage. I…
Post: Cache Miss Storm
September 10, 2010 By 30 Comments
… the problem recently which showed itself as rather low MySQL load (probably 5% CPU usage and close to zero IO) would spike to… in this case ? This is the query which has too high ratio of requests to be served with 100% misses for… have instrumentation in your applications or take a look at MySQL Slow queries – which is good enough if you populate each…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY … require too much IO capacity or high in memory fit. For large number … can make. One application can become CPU bound even with 5% of total … runaway logs or extreme temporary space usage to stop the database, but they …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… than just prefix compression. The downside in gzip is increased usage of CPU time. PZ: We will see how it plays when… high load situations where INNODB is using most of the system’s memory the kernel can decide (incorrectly) to swap out MySQL… your load is CPU bound and you’re scaling out you can get better performance by using couple of MySQL Servers on…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… used to ballance between wasting CPU time running spin locks and doing… inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079… fsync() for modified files. Constant high values for any of these …section shows Buffer pool activity and memory usage. You can see total memory allocated…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
…000 user accounts. You can see the CPU,IO and Network usage is below 10% of capacity – …MySQL (and systems in general) do not scale perfectly with numbers of CPUs and number of concurrent requests. Reduced efficiency of CPU… hold many copies of data to support high load but this is a scaling through …
Post: Living with backups
November 6, 2008 By 28 Comments
…so the price may actually be rather high. And the more effectively the server resources…tar … Please cosult ionice man page for usage details, it’s really very simple …MySQL instance, these are just examples. The cheks can also be more sphisticated or include things like processlist information, CPU…
