… access may simply allow you to get the data from database directly bypassing the need of complicated cache setup. To check… with high concurrency – besides raw performance not suffering badly from large number of concurrent request is another memcache advantage.
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 5 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 141 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 38 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…
Post: Mail clients and Databases
March 13, 2007 By 14 Comments
… on large data sizes. So what always was interesting to me – why these mainstream solutions do not use some form of databases which both would handle problem of recovery and memory consumptions as databases usually are designed to handle large data sizes… if we look at hosted solutions there are some with database backend such as Zimbra or DBMail.
Comment: MySQL Performance Forums
November 9, 2009 By 18 Comments
… MySQL and have been tasked with coming up with a database that has better performance than our current proof-of-concept… small, have a TINY budget, but will have a faily large database – it will grow to 2-5 TB in the future… opinion, could we get away with just adding a few large SATA disks to the server, logically making them one drive…
Comment: Why MySQL could be slow with large tables ?
January 4, 2013 By 141 Comments
Performance is very important with any application.If your database tables have millions of records then a simple SQL query … the Question comes “How can improve performance with large databases.“ See this article http://techathon.mytechlabs.com/performance-tuning-while-working-with-large-database/
