June 18, 2013

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… 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’); …

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

…(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…

Post: Is Synchronous Replication right for your app?

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…

Post: Edge-case behavior of INSERT...ODKU

… 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…

Post: Statement based replication with Stored Functions, Triggers and Events

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

Post: Flexviews - part 3 - improving query performance using materialized views

…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’ …

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

… 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…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

MySQL apparently has no problem with either of the following statements: mysql> insert

Post: Can MySQL temporary tables be made safe for statement-based replication?

… 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-…