…for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for …512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) …slow to run in production. So the best thing to do in this case is…
Comment: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… symptom of innodb_io_capacity set too low for the workload and system. For an SSD setup with high write load, … go there because it’s best not to set it much higher than required. MySQL 5.5 server dirty page … starts at 75% or 85% of the InnoDB log file space used, while Percona server won’t. You’ll …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… cause kernel panic. I believe remount-ro is the best option to use for the database server, though panic might be good… very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it will assert and restart. Now… it has to check file systems. I believe it is much better to disable both these auto check functions for your data partition…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for a customer… table, used proper file system alignment. Benchmark results I had a hard time thinking how it would be best to present results so…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… a file, file system decides how to distribute writes properly so they make the best use of the underlying storage, it also makes sure file… above). So on such a system, when creating file systems with fdisk, don’t use the default value for a start sector, instead use… (double parity). You want to know that when setting parameters for file system but when RAID is configured, there’s nothing more you…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might be very interesting for you, but I digress… to any of the talks at past MySQL conferences from people who have built systems like yours, and there’s a fair… log files out of the database. The database is usually the most expensive and hardest-to-scale component in your system…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… First if you followed MySQL upgrade best practices such as …for deep investigation. You may also wish to create a repeatable test case which does not use any sensitive data and file…MySQL changes between versions on Percona enhancements. Before reporting bug to Percona Server bug tracking system…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… many cases also don’t log the resulting errors. The best place to fix these problems is in the application, but…) instead of gracefully shutting down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
…for MySQL a few years ago (which are now replaced by the new project), making the Cacti templates use caching was important for… a system for failures” became a tacit best practice. …file as of several minutes ago. In conclusion, you should cache for historical metrics monitoring, but not for…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
…files, files left after script crash can prevent it from starting again) or using GET_LOCK function in MySQL…messages (best to stderr) you can catch when problems start to happen – for example if job failed to run because other one is running which is not expected in your system. In large systems…
