As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had… physical position quickly without need to have indexes would be quite handy I also should tell log table implementation in MySQL is… blocked as normal DELETE statements are blocked. More than that. I found even if I convert table to MyISAM, disable concurrent inserts…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show …) supports the MySQL Backup API which was originally implemented in MySQL 6.0. … are no longer needed and deletes them from the database. The …is that the init function returns quickly, but the first queries that …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for…file, unless you shutdown # the slave server, delete master.info and restart the slaver server. #… #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And … field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/… note that MonetDB supports all INSERT / UPDATE / DELETE statements (and space is price for that …
