… InnoDB you need two things: media with records(ibdata1, *.ibd, disk image, etc.) and a table structure. Indeed, there is no information… in CREATE TABLE statement internally they always go first in a record. The second issue we should take into account is internal… dictionary parsers make dict_parsers 2. Split ibdata1 with page_parser ./page_parser -f /var/lib/mysql/ibdata1 3. Recover SYS_TABLES…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…(within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (… pruning. A billion rows in a BTree is only (about) 5 levels deep. If you split that …I have rambled on about things as a preface to rebutting “delete records from this table, those will be…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
… will not be taken into account. I start by splitting our document into a list of words: cat /tmp/constitution.txt | sed… multiple times. mysql> load data infile ‘/tmp/words’ into table words (chars); Query OK, 6033 rows affected (0.01 sec) Records: 6033….41 sec) Records: 3088896 Duplicates: 0 Warnings: 0 Here is the serial version as run by the native database interface (MySQL): mysql> select…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… get a recording once it is over? A: Yes, we will email a link to all webinar attendees with a recording of the webinar and a link…: Hello, was there any good experiences with MySQL Proxy (RW-splitting)? A: Most solutions with MySQL Proxy I see have stern disclaimers against using it in production. Even the official manual page for MySQL…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…A: Sure, see this post or webinar recording. Q: Fault tolerance: Can you recommend a three node cluster for production use? A…mysql replication (asynchronous) for a given node, it’s not possible. However, a node in PXC can be a master or a…case of a network split. If a network split happens and a node…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…helps improve the performance of queries against a MySQL database by distributing the work over …a large amount of data. Shard-Query includes a loader (loader.php) which can be used to either split a… Following is a list of the queries, followed by a response time table recording the actual response…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…from each node correspond logically to a records in a Flexviews materialized view delta … to its logical maximum conclusion, splitting a problem up into many small …MySQL storage nodes are supported. Amdahl’s law applies to the distributed processing. The results from the slowest node will place a…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…a lower buffer pool hit ratio during the MySQL 5.6 runs and MySQL 5.6.10 was doing more IO as a…fix this problem by splitting the LRU into hot and cold sections. When a page is first …, count(*) – sum(is_old=’YES’) hot, sum(number_records) records from information_schema.innodb_buffer_page_lru where…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… can be simplified as “majority vote”) is not honoured. A split-brain is a state in which the nodes lose contact with one… (0.01 sec) and on node2 you can also add records: percona2 mysql> insert into percona values (0,’percona2′,’jay’); Query OK… algorithm fails to select a Primary Component, we have then a split-brain condition. In our 2 nodes setup when a node loses connection…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… ibdata files. A well known innodb_file_per_table option brings the second one. Tables and system areas are split into different… -f /var/lib/mysql/ibdata1 page 8 invalid (fails new style checksum) page 8: new style: calculated = 0x B7C5C82C; recorded = 0x BFE71C21… style: calculated = 0x E4189B9B; recorded = 0x C168689B fixing new checksum of page 11 # # ./innochecksum -f /var/lib/mysql/ibdata1 page 8 invalid…
