…TABLE, OPTIMIZE TABLE, REPAIR TABLE commands. For OLTP applications with simple queries memory consumption is often less than 1MB per thread with default…storage engines being released for MySQL…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
…still handled on storage engine level making them not working for partitioned tables as …type and indexed): mysql> set foreign_key_checks=0; Query OK, 0 rows affected (0.00 sec) mysql> alter table… ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> create table parentx(i int) engine…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…speed possible at all. Furthermore this type of caching is rather helpful for …use file cache (ie on shared storage). Query Cache is good when there…MySQL Cache to work CREATE TABLE `test` ( `k` varchar(60) NOT NULL default ”, `val` varchar(255) default NULL, PRIMARY KEY (`k`) ) ENGINE=MyISAM DEFAULT…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines…. There are two types of snapshots – some …MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES…in your kernel by default and you need to…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table… using LIKE statement. As default table format for slow_log …table which should be fast. Interesting enough however what would happen if one would use storage engine for log table… most frequent slow query types or queries which load …
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL…ENGINE=MyISAM DEFAULT CHARSET=utf8 This table…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…mysql configuration (We are having only 1 mysql server, no replication setup) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql…_size = 8M table_cache = 3600 table_definition_cache …type = 1 query_prealloc_size = 65536 query_alloc_block_size = 131072 default-storage-engine…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… lookup, same access types for primary key and full table scans. To highlight different properties of storage engines we tested ranges with …/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld startup params: Falcon: libexec/mysqld –no-defaults –…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… set of storage engines or default paths): (garfield:~/work…storage-engine‘ ‘–with-example-storage-engine‘ ‘–with-federated-storage-engine‘ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with-big-tables‘ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql…All filter-type options …
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… wsrep_22.3.r3683 Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. mysql> create table t1 (a int…: (Source distribution wsrep_22.3.r3683) 20120113-132229 INFO Using default-storage-engine: innodb 20120113-132229 INFO Using testing mode: cleanup 20120113-132229…
