… cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used… to retrieve the Galera replication position on Ubuntu 10.04, because the different shell was … was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… up an Ubuntu 10.04 EC2 instance, installed MySQL and provided the customer the credentials to upload their files. Then, I proceed. Loading the…_TABLENAME.ibd /var/lib/mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -u root -e…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it to load IO… users, load average: 0.00, 0.01, 0.05 System | Supermicro; PDSMi; v0123456789 (Other) Service Tag | 0123456789 Platform | Linux Release | Ubuntu 12…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… fail to install on a vanilla Ubuntu 12.04 server. Bug fixed #1103655 … option innodb_changed_pages_limit. MySQL option handling would then shadow …builds, that were caused by missing files. Bug fixed #1099809 (Alexey Bychko). Fixed… info was used under heavy load. This bug is affecting only -debug …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… an influence, because those idle threads are presents in internal MySQL list objects that need to be scanned and also the…_trx_commit=0 max_connections = 10000 open_files_limit = 32768 The desktop is running Ubuntu 10.04, has 8GB of RAM and… benchmarks, the CPU load on the laptop was never above 10%. I also hacked a bit the “run_mysql.sh” script to…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… some quick and dirty tinkering. I threw up an Ubuntu 9.04 small server on Amazon. (I used this… into MySQL. It’s a complete server with a different optimizer, etc. This point was hammered home during the LOAD…-mapped files to hold the data in-memory. If this is true, it explains why I couldn’t load 4…
