Percona's MySQL & InnoDB performance and scalability blog
…mysql -A in this case, to prevent it from getting field list from all tables) Reads though would not be blocked, ie there is…a workaround you can consider having scripts which would check for situation like above and either kill FLUSH TABLES…
…MySQL, you won’t have any problems until you try to create or drop a table, or the database itself. Likewise, if a…if you choose), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is…
…VARCHAR support for MEMORY tables for MySQL 5.0. …if you have a performance-critical application depending on MEMORY tables, they are no replacement for application-specific tests. We start by checking if there is…TABLE sbtest (id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, c VARCHAR(4096) NOT NULL…
…table which would look as following in terms of data and index size: mysql> show table…NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL…is the default configuration, second is with expand_fast_index_creation=1 which builds table with primary key only when creating a table…
…if you have hundreds of such columns. Lets see how things look for MyISAM for same tables: mysql> show table…mysql> select count(*) from cbool where c1=NULL; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.20 sec) You can use IS NULL operator which is…
…mysql> create table test_innodb(a int, b int) engine=innodb; Query OK, 0 rows affected (0.30 sec) Check…if small tables are used The information in INFORMATION_SCHEMA can’t be used to judge how much space table is…
…table is referencing and have it of proper type and indexed): mysql> set foreign_key_checks…mysql> show create table child \G *************************** 1. row *************************** Table: child Create Table: CREATE TABLE `child` ( `parent_id` int(11) NOT NULL, `v` varchar(10) DEFAULT NULL…
…MySQL 5.6 the default value of innodb_old_blocks_time is changed to 1000. The location at which a page is…TABLE IF EXISTS lineorder; CREATE TABLE IF NOT EXISTS lineorder ( LO_OrderKey bigint not null, LO_LineNumber tinyint not null, LO_CustKey int not null…
…a table, and configure that table to be our stopword list for InnoDB? This is the table that we’re trying to emulate: mysql: SHOW CREATE TABLE…
… (bind-address): ‘(null)’; port: 3306 120619 13:21:19 [Note] – ‘(null)’ resolves to ‘…are done, you should check if you have a 3 node cluster. mysql> show global …mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp-table-size=10000 –num-threads=8 run This is…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.