June 19, 2013

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars.  If you … no movies, but your random number generator picks values in that… another column, and reinitializing the sequence after making certain insert/update/delete… But the result was that it created a temporary table to count…

Post: MVCC: Transaction IDs, Log Sequence numbers and Snapshots

MySQL Storage Engines implementing Multi …Sequence Number (LSN) Log Sequence Numbers correspond to given position in the log files and typically incremented for each log record. Innodb uses number…: Value 5 created by transaction 100 Value 4 created by transaction 50 Value 3 created by transaction 10…

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

… in the third installment. For now, the important number here is to note that the InnoDB buffer …other mixture of lettercase, you’ll get an error: mysql> CREATE TABLE dir_test_innodb4 (fts_doc_id BIGINT …you also do something to provide some sort of sequence value for that column, whether as an auto_…

Post: Percona XtraDB Cluster reference architecture with HaProxy

…: Primary, number of nodes: 3, my index: 0, protocol version 2 120619 13:20:17 [Warning] WSREP: Gap in state sequence. Need…-rel25.3 started; log sequence number 246661644 120619 13:21:19 [Note] Recovering after a crash using mysql-bin 120619 13:21:19…, let’s create a database and a userfor it. mysql> create database sbtest; Query OK, 1 row affected (0.01 sec) mysql> grant all…

Post: Recovery deleted ibdata1

… will create empty …sequence number and last checkpoint in “SHOW ENGINE INNODB STATUS” output. If checkpoint age is zero, all pages are flushed: — LOG — Log sequence numbermysql# chown -R mysql ib* root@localhost:/var/lib/mysql# And restart MySQL: root@localhost:/var/lib/mysql# /etc/init.d/mysql

Post: SHOW INNODB STATUS walk through

…and all kinds of other things. In MySQL 5 number of Innodb performance counters were exported and …so such log sequences can’t be overwritten in log files. By monitoring log sequence number and value … can also see number of pages being read and written. Created pages is empty pages created in buffer …

Post: Stored Function to generate Sequences

… delimiter ; CREATE TABLE `seq` (…number of servers or to number of individual tables. Finally your own sequences allow you to generate multiple sequence values on demand with single statement for one or more sequences, which also can be helpful: mysql

Post: Copying InnoDB tables between servers

sequence number 3 768598528 (6 %) …. InnoDB: Doing recovery: scanned up to log sequence number 3 …on old servers: CREATE DATABASE “testimport”; USE “testimport” CREATE TABLE `order_line` ( …. When finished quick check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | …

Comment: How to change innodb_log_file_size safely

…) 4) restart mysql I can see the new log file create as 64M now. but i saw some error in mysql_error.log… full: wait… InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130319 0… doublewrite InnoDB: buffer… 130319 0:10:26 InnoDB: Started; log sequence number 0 65548 130319 0:10:27 [Note] Event Scheduler: Loaded…