June 18, 2013

Comment: Product to try: MySQL/MariaDB-Galera 0.8

… of here, I learned this when attending their session at MySQL conference. Galera is not really 100% fully synchronous (like NDB… (depending on application design). However, it is more solid than MySQL semi-sync in that the transaction is guaranteed to apply… commit you could do something like last_transaction_id() (think like last_insert_id()), and you could then pass that id with your next select, telling…

Comment: Sharing an auto_increment value across multiple MySQL tables

Another solution is to issue: UPDATE option1 SET id = LAST_INSERT_ID(id+1); New id is then available with mysql_insert_id API call.

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

…$80? Introducing the Raspberry Pi with Percona Server: [caption id="attachment_13122" align="aligncenter" width="582"] Raspberry Pi … is how to get Percona Server for MySQL up and running: Insert the SD card into a slot on your…0.180 root@192.168.0.180′s password: Last login: Fri Feb 22 23:27:49 2013 …

Comment: Slow Query Log analyzes tools

… of random battles’ BEGIN END; The problem is that the mysql-slow.log file only contains a trace of the call… Rows_examined: 2 SET last_insert_id=27274; CALL foo(); Is there any way to configure mysqld to trace every statement executed by MySQL?

Post: The perils of InnoDB with Debian and startup scripts

… 6318 | user | Sending data | insert into tableB… | 6322 | user | update | insert into | 6327 | user | | NULL…calculated from the last 15 seconds ———- SEMAPHORES …id 1159956816 starting index read, thread declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL thread id 6424, query id

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

ID column, however, MySQL apparently has no problem with either of the following statements: mysql> insert into dir_test_innodb3 (fts_doc_id

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

mysql> insert into percona values (0,’percona2′,’daniel’); Query OK, 1 row affected (0.02 sec) percona2 mysql> select * from percona; +—-+—————+——–+ | id | inserted… = 2, component = PRIMARY, conf_id = 6, members = 2/3 (joined/total), act_id = 19, last_appl. = -1, protocols = 0…

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

… row *************************** Log_name: mysql-bin.000007 Pos: 271 Event_type: Query Server_id: 1 End_log_pos: 90 Info: insert into test…. 1. row *************************** Last_Errno: 1146 Last_Error: Error ‘Table ‘test.t’ doesn’t exist’ on query. Default database: ”. Query: ‘insert into test….

Post: Recovery deleted ibdata1

Last checkpoint at 363096003 Max checkpoint age 7782360 To speed up flushing we can set dirty pages percentage to zero: mysql…never less than 1): ————————————- INSERT BUFFER AND ADAPTIVE HASH INDEX … up to very last ———— TRANSACTIONS ———— Trx id counter 0 …

Post: Identifying the load with the help of pt-query-digest and Percona Server

… atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise …26 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id: 1 Schema: test Last_errno: 0 Killed: 0 # Query_time: 0….0.6% 260 0.0002 1.00 0.00 INSERT poller_output # MISC 0xMISC 0.8137 10.0% …