Percona's MySQL & InnoDB performance and scalability blog
…get a corresponding FTS_*_DOC_ID… 10 rows in set (0.00 sec) mysql> insert…mysql> select * from information_schema.innodb_ft_config; +—————————+———+ | KEY | VALUE | +—————————+———+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 1028261 | | last…
…table doesn’t get dropped. It…row *************************** Log_name: mysql-bin.000007 Pos: 271 Event_type: Query Server_id: 1 End_log_pos: 90 Info: insert…row *************************** Last_Errno: 1146 Last_Error: Error ‘Table ‘test.t’ doesn’t exist’ on query. Default database: ”. Query: ‘insert…
…mysql> insert into percona values (0,’percona2′,’daniel’); Query OK, 1 row affected (0.02 sec) percona2 mysql> select * from percona; +—-+—————+——–+ | id | inserted…id = 6, members = 2/3 (joined/total), act_id = 19, last…
…MySQL. This is very helpful for measurement as otherwise we might not catch some long running connections. Now let’s get…id: 1 Schema: test Last_errno: 0 Killed: 0 # Query_time: 0.117904 Lock_time: 0.002886 Rows_sent: 1 Rows_examined: 655360 Rows…0.0002 1.00 0.00 INSERT poller_output # MISC 0xMISC 0….
…against InnoDB on 5.6.10: mysql: SELECT id, title, MATCH(title, body… OK, now I’m starting to get a little worried. …rows affected (0.00 sec) mysql: INSERT INTO innodb_ft_list2 SELECT * FROM innodb_myisam_stopword; Query OK, 543 rows… may surprise you. That last point bears particular emphasis…
…gets overwritten. mysql> CREATE TABLE actor ( -> actor_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, -> first_name VARCHAR(45) NOT NULL, -> last…id), -> KEY idx_actor_last_name (last_name) -> )ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows… when new record is inserted. But the actual old…
…last. Commit; Now when these statements get run on the slave they will be serialized, thus changing the order of the inserts…
…benchmarked it, but when I get time I will. I am basing…is all a question of how many rows to insert / update at once. Furthermore, …be a VERY good feature in MySQL. InsODKU would be much better implemented… mean that last_insert_id should return an array of inserted ids, instead of only the last one,…
…index before declaring the `FTS_DOC_ID` primary key column properly, MySQL crashed with an out of … you get Sphinx to report which matched? The SHOW META command in Sphinx shows how many rows …data to the MySQL database or else periodically batch-insert data that has changed since last time you …
… special counter table, having say “id” and “counter” columns. Using… have approximately 20 byte rows even for Innodb tables … paramount as if you get it you will be… which processes the views within last hour has to run rather … two tables insert into one and process and truncate another. MySQL offers …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.