… problem and how MongoDB solves it. If you’re using MySQL Replication when your master goes down it is possible for…-sync. Both of these operations can be very expensive for large databases. MongoDB approach used in Replication Sets is for failed master… – it should be possible to apply the same concept to MySQL Replication, possibly with help of some tools like MMM. Row…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… working with large data things in MySQL is patience and careful planning. Both of which relate two single property of large data sets… 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: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…constantly referring to the amazing MySQL manual, especially the option and variable reference table. …Key_writesblogpercona.commanual languageblogpercona.commanual large_files_supportblogpercona.commanual large_page_sizeblogpercona.commanual large_pagesblogpercona.commanual last_insert_idblogpercona…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple threads. Not all databases… combined with a large number of application servers can lead to a situation where the database server has a very large number of… it were, it wouldn’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… Debian respectively, but their install bases are large enough to mention them separately. Running MySQL won’t be much different whether one… database server during its lifetime comes down to this rather boring process – install, configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its performance significantly… that the application uses the database. These changes can give a much greater improvement in your database‘s performance. Conclusion Don’t… sometimes deliver large gains that go far beyond configuration alone. [1] I prefer to avoid the word “tuning,” because database tuning is…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… time or further degraded performance. In the large databases I run in production relaying on MySQL Replication for HA I often have 15… do maintenance on cold standby database.” But you can do anything you want with a database that you run off a DRBD… to learn about MySQL Replication or just looking to keep MySQL infrastructure to be as close to one for other databases in use…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… are cases when MySQL will allocate a lot of memory for table cache, especially if you’re using large blobs. It is… might look at how it uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements… Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… the opportunity to do some testing on a large data set against two MySQL column-store storage engines. I’d like to… 29 queries on the large data set. I compared a number of different factors between the two databases, including: Ease of installation Loading capability and speed of loading Accuracy of results of queries over the large data…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…doesn’t actually work and 2) it has a large performance overhead. It Does Not Work This code … to the ‘ping’ or ‘statistics’ command at the MySQL protocol level, which will increment Com_admin_commands …and the added load on the database server. The added load on the database server can be very high. …
