… end up scripting mostly Linux-centric things, so a little tweaking to the tools might be needed on other platforms. The… finish these, I’ll post them on Percona.TV, our MySQL video/screencast blog site. Another interesting topic is how to…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
… Fedora 9 and later, you’ll likely find that this tweak no longer works. In Fedora 9 and RHEL 6, a… Heisenbug, wherein the actual nproc limits that apply to your MySQL instance are contingent upon how/when it was launched, and… limit: (root@revolution 23:59:37)# service mysql restart Shutting down MySQL (Percona Server)… SUCCESS! Starting MySQL (Percona Server).. SUCCESS! [~] (root@revolution 23…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might… save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the… fact and dimension tables, and so on. With careful tweaking, many of these things can be overcome, but how much…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…, indexing) in isolation, because they are tightly bound together, and tweaking one will often have effects on the others. Each decision…
Post: What attendees are saying about Percona Live NYC ?
September 19, 2012 By Leave a Comment
…) Percona engineers. Percona Live goes above and beyond simply a MySQL conference. I can always count on enjoying presentations on surrounding… the awesome tweaks they’re running with MySQL there. It’s not everyday that you get to hear from top MySQL engineers how… foyer, I ran into all sorts of luminaries in the MySQL space. Percona folks like Peter Zaitsev & Vadim Tkachenko, plus other…
Post: InnoDB/XtraDB Training in New York City!
September 25, 2009 By 2 Comments
… class size going down, we have a little freedom to tweak our format. One of those changes is that we… continuing our early bird special (a copy of High Performance MySQL 2nd Ed). Interested in signing up? Registration is…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… a human with many years of experience, deep knowledge of MySQL and the full application stack, and familiarity with your application… people. Most my.cnf files I see only need minor tweaks, which give only so-so performance improvements. Tuning my.cnf…
Comment: Why MySQL could be slow with large tables ?
May 23, 2007 By 141 Comments
… tutorial configuring MySql .. My server isn’t the fastest in the world, so I was hoping to enhance performance by tweaking some parameters in the conf file, but as everybody know, tweaking without any clue how different…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
….com/supportingmysql/entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman/5.6/en/server…. More on this at https://blogs.oracle.com/supportingmysql/entry/mysql_server_5_6_default . thread_cache_size is quite low…. This will eventually end up in our documentation and be tweaked based on experience with 5.6 in production. We’re…
Comment: High Rate insertion with MySQL and Innodb
June 2, 2012 By 17 Comments
… testing many config tweaks with: sysbench –test=oltp –oltp-table-size=720000 –max-time=30 –max-requests=0 –mysql-table-engine=innodb –db-ps-mode=auto –mysql-engine-trx=yes –oltp-skip-trx=false… –oltp-range-size=1 –num-threads=16 –mysql-db=test –mysql-user=root –db-driver=mysql run got no more than aprox. 1…
