…MySQL upgrade – version change but in a lot of cases this will happen when settings are changed at the same time, operating system…system warming up. You need to compare apples to apples such as both systems after restart or even better both systems fully warmed up. To spot what…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… MySQL Upgrade to new version while sticking to very old operating system is important for you ? Finally I’d like to know What is the Oldest Platform/Operating system are you running MySQL on…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… to 10% of theoretical memory consumptions others only to 1%. So what…Operation System cache you would like MySQL to use for your table. Take this number add to it number of memory Operation System…to run MySQL server out of memory MyISAM buffers. MyISAM may allocate buffer which is large enough to…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… in the replication traffic (what updates are being replicated) are frequent cause of concern. Remember replication runs as a single thread and… going through the same operating system you should be able to see it by comparing IO MySQL is doing to IO going to devices from OS standpoint. If this is external and not recorded by operating system you often…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…operation per second which takes 4ms which adds up pretty well. We can also see what…system which can run 1000 IOPs costs $500 to run per month (including leasing, power etc). Such system will be able to…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
…” MySQL the numbers are not that high – many what would be considered medium scale MySQL installations would get there. With MySQL we seems to prefer to run…, yet as MySQL is getting better and better handling large scale systems (both in terms of performance and operationally) and as MySQL is making…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is… you have system completely at your disposal. If you however need system to serve other users too you typically need to reduce concurrency to where it does not overload the system. Unless it…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…to be lost. Not good for system running mySQL Server. As far as I understand this problem is limited to EXT2/3/4 while over systems… what error behavior mode your file system has ? Run …to 2 It is worth to note when error is discovered during the operation EXT3, EXT4 filesystem will force file system…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…what to monitor in MySQL. Those are only suggestions; any given deployment might want to…system administration mistake to delete one of MySQL‘s log or data files from disk. The database server will continue to…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…What I have to found to be useful in the daily work is to have the ability to run a selected MTR testcase under Helgrind. (For the time being, running the whole MySQL… LOCK_global_system_variables and LOCK_system_variables_…and using MySQL 5.5 atomic operation primitives with…
