… as painless as possible. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we upload mydumper backups to s3…: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…’s going on: /* Synchronize updated contents of a hash database object with the file and the device. */ bool tchdbsync(TCHDB *hdb){ assert…); return rv; } If it first checks if the file descriptor for the database is less then 0, or your not operating as… down as needed to ensure you have the proper recovery -vs- performance setting.
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… 10 with LVM vs. RAID 10 only: Random Write: For small files (<16k) creation, no much difference; For large files creation, LVM causes… 10 without LVM (Dell poweredge, database size 600G). We scaled out the database so the new database is 1/3 of the original. You can argue they are different hardware and in different database…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… vs most of web applications in insane. Not only that but many of these systems were started by beginners so traditional databases were way to complex to use too. All these requirements made traditional databases irrelevant for many web… are inhouse and opensource solutions for tasks for large scale file storage, queuing, data processing etc. But seriously if you look…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… do that, so I generated big SQL file which contained load statements. Load of each …in different queries. First favorite query for any database benchmarker is SELECT count(*) FROM ontime;. Both …Conclusions: This experiment was not really about InfoBright vs MonetDB comparison. My goal was to check …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…accessed, and in an ascending order of the file address, then InnoDB schedules the read of …performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of …easily port your applications to other database brands. Maybe in some denormalized database (for example, if ORDER and…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…because otherwise you can have a really large log file generated. Another thing that we normally do is…, the number of tmp tables created in memory vs on-disk, percentage of queries that needed full … its run. The “Databases” section of the output also shows the name of the databases where this query …
Comment: Air traffic queries in InfiniDB: early alpha
November 3, 2009 By 19 Comments
…€™s a first pass at your observation: LOAD DATA INFILE vs. InfiniDB bulk load (cpimport): We provided support for LOAD DATA… be specified at XML job file creation time (via colxml), not at import time (via cpimport). database size: You actually are correct in determining the size of the database by examining the size of…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… seqwr seqrd rndrd rndwr rndrw; do ./sysbench –test=fileio –file-num=1 –file-total-size=$size prepare for threads in 1 4…=10000000 –num-threads=$threads –init-rng=on \ –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 run \ >> sysbench-size-$size-mode… speaking RAID0 vs RAID10 it’s your call. For sure in regular server I’d never suggest RAID0 for database, but speaking…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…switching to InnoDB. Performance vs. MySQL was horrible, even after tuning. SELECT performance is… hold up. Management of the massive InnoDB binary file was daunting unlike MyISAM which has each table … when you have to quickly restore a single database or table. I would be interested in other …
