… MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld startup params…_KEY_POINT queries. InnoDB is better than MyISAM by 2-26 times and than Falcon by 1.64 – 3.85 times. READ_PK… threads, but MyISAM scales a bit better in this case. InnoDB is better than Falcon by 2-3 times. // //
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… (Laurynas Biveinis). Log tracking was initialized too late during the InnoDB startup. Bug fixed #1076892 (Laurynas Biveinis). Temporary files created by binary… of individual statements in stored procedures correctly, this caused Query_time to increase for every query stored procedure logged to the…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did …e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov). Fixed assertion failure in InnoDB. #…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… startup until LRU dump is loaded Added a new boolean option, –innodb-blocking-buffer-pool-restore (in 5.1 it is –innodb-blocking… (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…. Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables, instead it computes them on first table access after startup. This may take significant time…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…] Set Percona server to startup at boot time [root@alarmpi ~]# systemctl …| Transactions | XA | Savepoints | +——————–+———+—————————————————————————-+————–+——+————+ | InnoDB | DEFAULT | Percona-XtraDB, Supports …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… more if you’re running Innodb chances are you will not buy you more “up time” either as Innodb is very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it… interval: 0 () These corresponds to automatic file system check on startup which is normally done once per so many mounts or…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…. innodb_open_files is now dynamic at startup, based on the table_open_cache setting because we expect most tables to be InnoDB and use innodb_file_per… default in 5.7 – one more release to give people time to get applications upgraded or using connection settings if that…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…. The frequency of checkpoints, as with other engines like InnoDB, determines the recovery time. Does PBXT support clustered indexes? No, currently it… PBXT recovery. When MySQL calls the engine “init” method on startup it is holding the global LOCK_plugin lock. In init… are more in InnoDB/XtraDB now than there were three years ago. This is probably something that emerges over time as we…
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
…:disable, 1:enable * innodb_ibuf_max_size (default [the half of innodb_buffer_pool_size](bytes)) – This parameter is startup parameter. If the lower value is set than the half of innodb_buffer… asynchronous. Second important fix introduces variable use_global_long_query_time, which allows all current threads see change of long_query…
