… full, should I be thinking about upgrading memory already?” This is a wrong … Look at Iowait iostat -dx 10 will show disk utilization. Low (less than…be because queries changed their plans. Do the sizing This especially works …size so you get and understanding what Memory-To-Disk ratio is optimal for…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…upgrading memory to 32GB. Interesting enough similar can happen for very large working set – for example if your main queries do…. If your CPU is 25% busy you will unlikely get more than 4x even if … because your application logical serialization problems. So what if we have very IO bound application …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…what the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot? Sometimes there are rigid constraints on what…do this (I will run mysqlreport to get friendly numbers I can read easily). But what I will do… determine when an in-memory temporary table will be converted to an …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…30 seconds you unlikely will be able to solve the problem by CPU upgrade. For single thread … server which would usually have 1-2GB of memory may be couple of SATA hard drives – …what you’re doing to make sure you actually picked up all these low hanging fruits you could and what you’re not doing…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… so most of them instead of “upgrading” to Oracle or other systems which… if it solves their pains. So what do we see as response to these requirements… is appliances – you can see Violin Memory appliance which can be used with… Indeed I think MySQL Replication usage will reduce, but I would not expect…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…memory or so on the server too which will make read caching more efficient in its memory… too) is to really understand what you’re trying to scale and… highly consider DRBD which can do storage level replication between directly … of semi-online MySQL/OS upgrades and Schema changes. Backups SAN …
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… innodb_max_dirty_pages_pct, or for flushing to do checkpoint activity. What is important about this? If your workload is mostly… MySQL settings (mentioned above) do not matter a lot, and performance is mostly defined by available memory and the I/O subsystem… LRU list bound, the strategy which will give the biggest benefit is: Install more memory or upgrade the I/O subsystem. If you…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main…assigned Inaam as the InnoDB scalability engineer. We do not have much resources for scalability research. Peter… figure our what the problem is. We can OPTIMIZE the table, but how long will this take…
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
The question “what problems will I have when migrating to the cloud” gets asked often … store, it costs $2094 to upgrade an R900 from 4G memory to 64G (or $4378 to upgrade to 128G) which justifies that some problems are best solved by just throwing memory at them. With EC2, you can’t do…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…changes into a log, it will be faster to do on the fly as transactions come…numbers are relevant from the BUFFER POOL AND MEMORY section of SHOW ENGINE INNODB STATUS: Database … are not flushed. This, in essence, is what fuzzy checkpointing is. The checkpoint process … reasons to consider an upgrade…
