Percona's MySQL & InnoDB performance and scalability blog
… on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you …matching rows that you’ll get skewed results. For instance, if… the sequence after making certain insert/update/delete operations. If you…in the index. Example: WHERE (last_name, first_name) = (‘Karwin’, ‘Bill’); …
…(PXC) for MySQL is a hot thing right now and… if you can leave them behind. Lastly, once that bug above is fixed, …, this is to avoid collisions when INSERTs are happening on not only a single …are consistently running overnight reporting jobs and getting them through the replication stream expect some…
… get to disk. This has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) VALUES (100, 1); UPDATE groups SET last_joined=NOW(), last_user_id=100…
… of events. (root@localhost) [test]> INSERT INTO update_test (username, host_id, last_modified) VALUES (‘foo’,3,NOW()); …to be considered as being defined first. So, MySQL checks our INSERT, sees that the next auto-inc value … number of seconds in a day, and we get 33.1 days, or a little over 4 weeks…
…mysql> create trigger Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql> insert… the previous event after it gets replicated on the slave: CREATE …INSERT INTO y (value) VALUES(LAST_INSERT_ID()) That was for a insert with only one value. What is the behavior if we insert…
…CALL flexviews.create(‘demo’, ‘dashboard_customer_sales’, ‘INCREMENTAL’); SET @mvid := LAST_INSERT_ID(); CALL flexviews.add_expr(@mvid,’GROUP’,'customer_id’,'… to determine the contents of the view. mysql> select flexviews.get_sql( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)) -> as ‘SQL’ …
… here that the ALTER waits only at the last stages when its making changes to the table …get piled up waiting for table metadata lock bringing down the MySQL server or causing all the connections to get…Query OK, 0 rows affected (0.09 sec) session1 > insert into t1 values(null); Query OK, 1 row …
… have your hardware, here is how to get Percona Server for MySQL up and running: Insert the SD card into a slot on… system (to prevent partial writes), take out the card and insert into your Pi. Carefull, the card goes upside down 
Plug….168.0.180 root@192.168.0.180′s password: Last login: Fri Feb 22 23:27:49 2013 from percona…
…MySQL apparently has no problem with either of the following statements: mysql> insert…
… ROLLBACK the temporary table doesn’t get dropped. It’s not really …Last_Errno: 1146 Last_Error: Error ‘Table ‘test.t’ doesn’t exist’ on query. Default database: ”. Query: ‘insert…`test`; insert into test.t(a) values(1) *************************** 5. row *************************** Log_name: mysql-…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.