… all servers to use GTIDs Disable read-only mode This procedure will switch all your servers from regular replication to GTID…_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has been created everywhere. So…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… your stored procedures in your slaves servers. Example: mysql> create procedure this_pyear() BEGIN INSERT INTO t VALUES(YEAR(CURDATE())); END;// mysql> CALL ….1. AUTO INCREMENTAL VALUES In order to have the same auto incremental values on master and slaves the actual used auto incremental value is …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…auto_increment_incrementblogpercona.commanual auto_increment…procedure_codeblogpercona.commanual Com_show_procedure…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… scenario I created a table with just 10000 rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE test_…_free: 0 Auto_increment: NULL Create_time: NULL Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…The incremental refresh method The incremental refresh method uses table changelogs which are created by…incrementally refreshable views are not built directly from SQL. Instead, Flexviews includes a MySQL stored procedure…column `mview$pk` which is an auto_increment BIGINT surrogate key for the table…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… Repositories). Based on MySQL 5.1.66, …1076892 (Laurynas Biveinis). Temporary files created by binary log …AUTO_INCREMENT columns. Bug fixed #1039536 (Alexey Kopytov). In cases where indexes with AUTO_INCREMENT…procedures correctly, this caused Query_time to increase for every query stored procedure…
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
…mysql> desc node; +———-+——————+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +———-+——————+——+—–+———+—————-+ | nid | int(10) unsigned | NO | PRI | NULL | auto_increment…
Post: Stored Function to generate Sequences
April 2, 2008 By 17 Comments
… their sequence generation process to the stored procedure and even though I have already seen…_name; return last_insert_id(); end // delimiter ; CREATE TABLE `seq` ( `name` varchar(20) NOT NULL, `… would like to use sequences instead of MySQL auto_increment columns ? Leaving aside more exotic ways of…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… locks early. It comes at cost of creating temporary table though which can be quite …Another alternative is of course to use MySQL Stored Procedures which can be fit to do this … the temporary table with auto_increment column and fetch data from this table using auto increment column ranges instead. …
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…-based format does offer advantages particularly if triggers or stored procedures are used, or if non deterministic functions like RAND() are… create a test table on a MySQL master database and populate it with some data. CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT…
