Percona's MySQL & InnoDB performance and scalability blog
…table produced the same error. I submitted a bug report (68450), and as you can …mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT…MyISAM FTS, the results may surprise you. That last point bears particular emphasis, as it also …
…you’re inserting the data at the same time as running reporting queries on last month. All last month … can be caused by software and hardware bugs rather than known limitations. You could argue … automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some…
…Google, Yahoo, MSN) provides real-time reporting last time I was involved with them …-scale database server for the initial insertion, because you can write CSV files …I expect to find a lot more bugs and annoyances. There are already… either using MySQL 5.1′s row-based replication, or in MySQL 5.0 …
… two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql …-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 4000 sec but the result is taken only for last …_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M …
…of mine, Greg Youngblood, who pinged me last week with an interesting MySQL puzzle. He was running Percona Server … so much as a warning. Is this a bug or just documented behavior? I suppose that depends … KEY `i` (`i`,`update_date`) ) ENGINE=InnoDB and then inserted a few bogus rows with the 0024-06-…
…MySQL replication slave the last master binlog file InnoDB: position 0 1604, file name mysql-bin.000001 InnoDB: Last MySQL…mysql-bin.000001 The difference is consistently 27, which corresponds to unimportant binlog events: /*!40019 SET @@session.max_insert…
…) mysql> INSERT INTO t(c) VALUES (RAND()); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO …the last test with innodb_buffer_pool_sizeset to approximately 1/10th of the dataset: mysql>…the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in …
…, Today we are announcing XtraDB release 7. This is the last release based on InnoDB plugin version 1.0.3, as… includes following new features: MySQL 5.1.37 as a base release speed hack for buf_flush_insert_sorted_into_flush_list controlled by the new variable innodb_fast_recovery Fixed bugs: MySQL Bugs: #45357: 5.1…
…id) ) ENGINE=InnoDB; INSERT INTO parent (bogus_column) VALUES (‘aaa’), (‘bbb’), (‘ccc’), (‘ddd’), (‘eee’); INSERT INTO child … on the last statement. We also see the expected output change to: mysql> SELECT * FROM…in all new releases of MySQL and Percona Server. See BUG #53336 for more examples of…
…of 4 on building our training workshop. Last week I talked about why you …over the built-in InnoDB included in MySQL 5.0 and 5.1. …a log file (see docs). Insert Buffer control – The insert buffer is a great feature of… open transactions is limited to 1023 (see bug report).  XtraDB allows this to …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.