… database server typically will use table structures on top of a filesystem to further abstract the low level operations of storing information in files into something that can be searched, modified and more easily… notion that it’s ‘hack that ignores 50 years of database theory’ probably just indicates the need for better education and…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…’t store everything in the database. Instead, store the source data in some fashion that you can reload later, such as flat files, and… can put these into the database in a little meta-table. Then your script can figure out which files it can ignore…-scale database server for the initial insertion, because you can write CSV files with any programming language. Naturally, CSV files don’t store…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…like this: InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 7…checksum 772331632 InnoDB: stored checksum 2287785129, prior-to-4.0.14-form stored checksum 772331632 InnoDB:…200 Duplicates: 100 Warnings: 0 mysql> insert ignore into test2 select * from test limit 300; ERROR …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… master > show master status; +——————+———-+————–+——————+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB…t exist’ on query. Default database: ”. Query: ‘insert into test.t(a) … > delimiter; Now calling the stored procedure should put a row into the test.ins…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…will perform on each database. To do the size comparison, I used the du utility: InnoDB file size on disk… In general, a column store performs about 8x-10x better than a row store for queries which access … CTRL-C to copy it. Paste this into a text file on shard1 called “/tmp/servers.txt” and …
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… file is taking about 8 bytes per row as I understand so it should be very small and well cached in database… part and dynamic data parts stored in separate files. Dynamic length part is stored in file called “Data Log File” which is quite confusing to… stored in different locations which may require a lot of IO for large data sizes. But you of course should take into…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…appropriate changes. The file is well commented. The example settings file should work …” otherwise. Verify installation The binary log stores it progress in a metadata table: $ mysql …database rows which change into special tables called changelogs. Each changelog is located in the flexviews database…
Post: Living with backups
November 6, 2008 By 28 Comments
…just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data …in the database when mysqldump is used or reading a lot of data when copying physical files, so…MyISAM tables which have dedicated buffers only to store indexes, while the actual data is always read…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… rows from the ibd file and import them into the database. The time between the deletion of rows and the database stop is crucial…:00 hours). Processing speed: 104857600 B/sec All pages are stored in a single directory with some subdirectories inside, one for… import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery’ REPLACE INTO TABLE `salaries` FIELDS TERMINATED…
