… there are too many, you end up with a lot of small files. In MySQL-terms that means at least 1 file per table (.frm), and a lot of pressure on your filesystem to have that many in one directory… in MySQL. See http://www.mysqlperformanceblog.com/2006/11/21/opening-tables-scalability/ and http://www.mysqlperformanceblog.com/2009/06/16…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…1 series. All of Percona’s software is open-source and free, all the details of …2 milestone at Launchpad. New Features: Multiple bitmap file support for XtraDB changed page tracking has been… #908620 (Ignacio Nin). innodb_fake_changes would allocate too many extents on UPDATE. In some cases this …
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… there are a lot of good changes and many defaults are now computed instead of hardcoded. Though… 95%+ of installations innodb_log_file_size = 48M This is still too small for any real load but… is typically protected by Firewall to begin with. open_files_limit = 5000 strangely enough this is where the…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
Interviewing people for our Job Openings I like to ask them a basic question – if you … two Quad Core CPUs scalability issues can be observed on many workloads. Though this depends on the application a lot. The… as when write IO may suffer. innodb_file_per_table – If you do not have too many tables use this option, so you…
Post: Announcing Percona Server 5.5.28-29.2
December 7, 2012 By 2 Comments
…5 series. All of Percona’s software is open-source and free, all the details of …2 milestone at Launchpad. New Features: Multiple bitmap file support for XtraDB changed page tracking has been… #908620 (Ignacio Nin). innodb_fake_changes would allocate too many extents on UPDATE. In some cases this …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… everything people throw at databases Many people assume their application is …ways to get this information, too. The last three commands are…/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/…s like knowing openings in chess — the great chess players study openings exhaustively,…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… also use similar technique with innodb_file_per_table. However you can’…issue by killing transactions which are too old though proper solution would …implemented as temporary tables, so by opening large amount of cursors which …abusers. This is not to mention many Virtual Hosting companies use old …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…one does not really affect performance too much, at least on OS with…allocates for misc needs. innodb_log_file_size Very important for write intensive…with full OS crash. table_cache – Opening tables can be expensive. For …own entry) if you have many connections or many tables increase it larger. I…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…. Look at early MySQL versions – if you insert too long data it would just strip it but … and support. Interesting enough the fact MySQL is Open Source puts it in a worse shape than …S3 service which deals with files, I bet similar service could be designed for many of data store applications, …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…many things that can cause a “server stall” is a long-running transaction. If a transaction remains open…it can be fixed. I see this much too often, and have developed a favorite technique …=tcpdump –no-report –print” on the resulting tcpdump file (after inspecting the captured SHOW INNODB STATUS …
