… one while with MySQL Replication you can use Maatkit to merge the changes after all, also you can review binary logs to… does not touches the same data as read load. Here is simple example – assume you’re inserting the data at the same time… also allows building very nice mixed environments with MySQL – for example you can replicate binary logs using DRBD so if master node…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…data archive storage. On BoardReader for example we’re limited by space and how much data we can comfortably put in MySQL… all search heavy lifting we only need to insert new data and fetch few rows to show search… desired it might be good idea to keep Binary Logs on the separate volume – you may need…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… ascii and hex (16384 bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page checksum 587461377, prior-to… page data. The next comes trial and error approach: mysql> insert into test2 select * from test; ERROR 2013 (HY000): Lost connection to MySQL server… all data it could recover to MyISAM table. Using series of queries with LIMIT can be handly if you recover manually: mysql> insert…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… statements were because of INSERT… SELECT statements that were running against the table, selecting data from it and inserting into another table. Let… MySQL manual actually says this, but not in the clearest way. It just says If you are using the binary log, concurrent inserts…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… innodb_locks_unsafe_for_binlog option with caution. Note disabling binary logs is not enough to trigger relaxed locks. You have… 224576 MySQL thread id 1794751, query id 6994931 localhost root Sending data insert into test select * from sample ——– As you can see INSERT… SELECT…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… logged to the binary log. Let’s create a stored procedure to hold the transaction, which this time will insert data from the… what’s in the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name: mysql-bin.000011 Pos…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery …These stored procedures maintain the Flexviews data dictionary. The data dictionary is used by the …’dashboard_customer_sales’, ‘INCREMENTAL’); SET @mvid := LAST_INSERT_ID(); CALL flexviews.add_expr(@mvid,’…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
… key and insert data in random order you would have the same problems. In fact if you store UUID in binary form you… however completely separate problem which can be fixed in MySQL 5.1 Data Clustering This again applies to Innodb tables aspect of… and assumptions. I promised to publish some insert benchmark for this case with larger data size so here they are: I’ve…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… TEXT, PRIMARY KEY (id) ) Engine=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â Â… depends a lot on the type of data you’re inserting (hint: the more random your data is, the worse compression will work). Something important to note is that the result of the COMPRESS function is always binary…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… specify single page size for Innodb table, while data pages and pages for different indexes may well … and same for all insert cases – in fact if the insert is single value insert or the number of …not we should test them and make binaries with them available. With current MySQL 5.0 I still see …
