… 32GB of memory and there is very little load. I see that mysqld is using 10g of memory with… If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques…, and a simple mental calculation can then tell me how much total gain I can get from it. Queries are…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…include others as well. Here’s how you can use our new monitoring plugins to check … allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and cause…the problem has grown much more serious. You can use the pmp-check-mysql-status plugin to alert…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… MyISAM uses OS cache to cache the data so you need to leave memory for it as well, and data can be much larger… much, at least on OS with decent memory allocators. Still you might want to have it 20MB (sometimes larger) so you can see how much memory… Note MySQL distribution contains bunch of sample my.cnf files which may be great templates to use. Typically they would already be much…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… other kinds of queries MySQL needs to create temporary tables, which can be created in memory, using MEMORY storage engine or can be created on disk… is to see how much overhead do on disk temporary tables cause compared to MEMORY tables. To have things comparable I used medium size…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… need to answer a question how much load a given system can handle when load is low…Millsap. So how we can use this data to estimate capacity of MySQL system ? We can look at CPU…memory for example is unlikely to help. One helpful way to use this information is to compare systems with different memory…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… that MySQL can‘t tolerate these weaknesses very well in some cases. I’m not trying to say you shouldn’t use the… it to fit in memory. The largest instances currently have a bit less than 70GB of memory, so you can consider something like… greatly how much memory and disk resources are required. The application’s access patterns can be just as powerful a lever. Thus, careful design can…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…how do they manage to keep things up given MySQL gives you so little ways to really restrict how much resources single user can… focused on the load eliminating – using Google UserStats patches (included in Percona…the PROCESS LIST and you can‘t really track how much memory was allocated for given…
Post: 3 ways MySQL uses indexes
September 12, 2009 By 28 Comments
… describes how MySQL uses single index – there are more complex rules of how indexes will be used if you…in memory. If MySQL is only reading index and not accessing rows you will see “using index…use for indexes. You can also see others like using index for group by but I think they can be pretty much…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…how I align IO, now I want to share results of the benchmark that I have been running to see how much benefit can…| 24×12288 KB # Memory ##################################################### Total …MySQL versions or settings. Moreover, I have been running these benchmarks for a customer so I just used…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… a debugging fprintf() to tell me how much was being allocated and whether it …thing unless AWE is used, but it was not used, so I did not …G of the buffer pool. This can become significant in the proper innodb…are set in proportion to physical memory to keep the memory-hungry applications from taking …
