June 20, 2013

Post: Concatenating MyISAM files

November 19, 2012 By 5 Comments

… delete-chain – recovering (with sort) MyISAM-table ‘test_concat’ Data records: 3 – Fixing index 1 Data records: 6 And then, back in mysql: mysql…’t fix table with quick recovery: Found wrong number of deleted records myisamchk: error: Run recovery again without -q MyISAM-table ‘test_concat…

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… part (this one) will be a very quick overview of FTS in InnoDB and some…DELETED_CACHE.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_DELETED.ibd -rw-rw—-. 1 mysql mysql…myisam.frm -rw-rw—-. 1 mysql mysql 155011048 Feb 19 17:17 dir_test_myisam.MYD -rw-rw—-. 1 mysql mysql…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL Slow query log in the table

May 31, 2007 By 1 Comment

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…

Filed Under: Insight for DBAs Tagged With:

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

… ‘pc.bootstrap=true’. Q: Can you quickly show the my.cnf settings again? …asynchronous replication, galera and built-in mysql replication are independent from each other…. a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, … SST it’s enough if you delete grastate.dat). So, it is …

Filed Under: MySQL, XtraDB Cluster

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

March 13, 2013 By 8 Comments

… happen? Someone runs UPDATE or DELETE and forgets the where clause… backups between myisam and innodb tables. Global read lock only held until myisam …single tables easy. You can quickly restore a single table, instead…term backups Decompressing Percona XtraBackup for MySQL  in parallel using all your…

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , , , ,

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 …

Filed Under: Insight for Developers, MySQL Tagged With: , , , , ,

Comment: Database problems in MySQL/PHP Applications

November 6, 2006 By 13 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…

Filed Under: Insight for Developers Tagged With: , ,

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 …

Filed Under: Benchmarks, MySQL Tagged With: , , ,