Thanks much. and bytheway. can anyone tell me which is better for large database ?
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… of memory for table cache, especially if you’re using large blobs. It is easy to check though. Run “FLUSH TABLES… uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ? In a… Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using…
Comment: Announcing Percona XtraBackup 1.9.1
February 28, 2012 By 9 Comments
… for certain tables / entire databases at some point? I would like to backup a number of critical database / tables, but some other ones are much less critical, VERY large, and can be rebuilt from…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… impact of FLUSH TABLES WITH READ LOCK can be quite large because of the time it may take to complete this… might get a feel you can’t connect to the database at all (use mysql -A in this case, to prevent…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… the customers assuming it will be quick to rearrange their database or even restore from backup. You need Patience simply because… it can still take hours especially if database is already loaded. So operating wit such large databases you need to be patient and… with large set. One thing I often find people miscount is assuming data management operations will be proportional to the database size…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 4 Comments
…-sync. Both of these operations can be very expensive for large databases. MongoDB approach used in Replication Sets is for failed master…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… become upset and become one of thouse bloggers. Note – any database management system is different in some respect and what works… accesses to database. Some people would also remember if indexes are helpful or not depends on index selectivity – how large proportion of… is right way to design your database as textbooks teach you… but when dealing with large data sets it could be recepie…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… undo location. The LVM Snapshots versioning is however different from database Multi Versioning because only one old version per snapshot is…. Of course depending on database or workload this may need to be adjusted. If you have 10GB database size (including logs etc… replication for large database with little no – connect USB hard drive place LVM snapshot on it and you can copy your database without…
Page: Presentations
May 3, 2006 By
… in Russian. Download MySQL/Innodb Architecture and Performance Optimization OpenSource Database Conference 2006, Frankfurt, Germany, November 2006 Very condenced 1h 15min… FullText search techniques for content stored in database focusing on delivering high performance for large databases. We look at performance properties of MySQL…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means… from RedHat and Debian respectively, but their install bases are large enough to mention them separately. Running MySQL won’t be… (startup) script for MySQL. By default it not only starts database, but also updates system tables (if needed), scans all tables…
