… MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5.5.17, Percona Server 5.1.59-13.0 and Percona Server 5.5…. of -1. Bug Fixed#884737 (Alexey Kopytov) The documentation for innobackupex (including –help) erroneously mentioned an –ibbackup-binary command line option when …
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…but we will see the effects anyway. The full command line to run the test is: tpcc_start localhost ….93 NOTPM. This is 1.4x better than we have with the stable line in MySQL 5.5.8. But, finally, … support of big log files (>4GB)Â to help increase throughput. Basically, by lowering innodb_max_dirty_…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… rip through the file and parse it 10k lines at a time, aggregating as it goes. …What about partitioning in MySQL 5.1? I know there are some cases when it can help a lot, and … parts of partitioning, such as maintenance and repair commands, that essentially negate the benefits of partitioning for …
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…command line with –no-defaults –verbose –help options: pz@ubuntu:~$ /usr/sbin/mysqld –no-defaults –verbose –help…MySQL variables in automated way a lot more convenient would be extending INFORMATION_SCHEMA.GLOBAL_VARIABLES Currently as of MySQL 5.5…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…command line…lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql> select sum(total_lines) from complete_example2 ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1…helps you understand how Flexviews can help…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…mysql host would be much larger. Using another type is trivial. I will assume you are using the command line…the help identify them. To create a security simply run this command:…MySQL version in the Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…(5…1 | 1023063 | | 6739359063 | 1 | 1024599 | | 6739305559 | 1 | 2558807 | | 6739336791 | 1 | 2558807 | | 6739300695 | 1 | 208215 | | 6739297111 | 1 | 2736471 | | 6739296855 | 1 | 2736471 | +————+——–+———-+ 10 rows in set (7.92 sec) MySQL mysql…command line language is very helpful…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
…freezing issue as well on FreeBSD 7.1 with MySQL 5.1.32. Its a pretty high traffic …command line mysql client returns error 34, Can’t create a new thread Also issuing a /usr/local/etc/rc.d/mysql-server restart command… FreeBSD 7.0 and MySql 5.0 and never saw this issue. Any help would be GREATLY …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… KB physical id : 1 siblings : 4 core id …vmstat 5 5 iostat -dx 5 5 …MySQL version is, and I check (with the ‘file’ command…go through it line by line, like this: +———————————–+———————-+———————-+ | Variable_name | Value … can frequently help customers …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…MySQL Performance. To start with basics SHOW INNODB STATUS is command… of other things. In MySQL 5 number of Innodb performance …waited at ./../include/buf0buf.ic line 630 for 0.00 …For certain workloads it may help to decrease the time…queries inside InnoDB, 0 queries in queue 1 read views open inside …
