June 19, 2013

Post: When is it a time to upgrade memory ?

September 16, 2008 By 11 Comments

… 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…

Filed Under: Insight for DBAs Tagged With:

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 …

Filed Under: Insight for DBAs Tagged With:

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

… replication will work for any application. There is just too many events. In the worse case you might need to do staged upgrades…. Q: What to do if Query Execution Plan changes for the worst during Upgrade? This is one of the big challenges with upgrade which… memory) available. Another thing to mention having multiple instances of different MySQL versions on the same box typically means you will install…

Filed Under: Insight for DBAs, MySQL

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 …

Filed Under: Insight for Developers Tagged With:

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…

Filed Under: Insight for Developers Tagged With:

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…

Filed Under: Insight for DBAs Tagged With: ,

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 …

Filed Under: Hardware and Storage Tagged With:

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…

Filed Under: Benchmarks, MySQL Tagged With: ,

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…

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…will somehow be “better” (as much as it’s actually possible to do this in a single blog post) than what…( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=MEMORY DEFAULT CHARSET=utf8 The docs tell …major MySQL version upgrade before rolling it into production! Percona has tools (pt-upgrade and Percona…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts