Percona's MySQL & InnoDB performance and scalability blog
…start_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table…
…are using MySQL 5.5.30 and MySQL… OK, now I’m starting…mysql: CREATE TABLE innodb_ft_list2 ( value VARCHAR(18) NOT NULL DEFAULT ”) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.02 sec) mysql…
…starting setup completed If the setup detects any problems (such as binary logging not…mysql> create table > test.demo ( > c1 int auto_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql… before the deletion. Though they are none shown here, updates would…
…tables The real problem is that replication may keep on running without error, not… the reasons I mentioned above are not the only ones that …mysql-bin.000001′, master_log_pos=2690; Query OK, 0 rows affected (0,06 sec) slave1 [localhost] {msandbox} ((none)) > start slave; Query OK, 0 rows affected (0…
…MySQL‘s LOAD DATA statement and it’s own colxml / cpimport utilities. As LOAD DATA is more familiar for me, I started… Q6, Q7 from consideration, which are also based on DERIVED TABLES, as not supported by InfiniDB. Other …0.9.4.0-5-alpha (GPL), so I consider it as alpha release, and it is doing OK…
…the node it is started from all …OK, 0 rows affected (0.02 sec) node2 mysql> show create table autoinc\G *************************** 1. row *************************** Table: autoinc Create Table: CREATE TABLE `autoinc` ( `i` int(10) unsigned NOT… nodes with competing locks are automatically rolled …
Are you using InnoDB tables on MySQL…start…0.00 sec) Now check the auto_increment counter: show create table foo\G *************************** 1. row *************************** Table: foo Create Table: CREATE TABLE `foo` ( `id` int(11) NOT…
…start with three empty tables. It is important to note that the tables are empty because the MySQL optimizer treats empty tables (and incidentally, tables…
…mysql> create table t1 (a int not null auto_increment, primary key(a)); Query OK, 0 rows affected (0.11 sec) mysql> insert into t1 values (),(),(),(),(); Query OK…
…mysql> show create table t2\G *************************** 1. row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` int(11) NOT…start by creating a parameter table. This table…table are those which belong to this connection. When the table…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.