….log file which i believe is the error log you are talking about? 120502 11:50:41 [Note] /usr/libexec/…’ port: 3306 Source distribution Also, I don’t see how MySQL could be using any other conf file other …]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… did you know there are some cases when you can get table entirely missing from the backup if you … to original name. How does data visibility works in this case ? DDLs are not transactional and … TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…. For prepared statements you might want to look at Prepared_stmt_count to see how many prepared statements are allocated on server and… variables are allocated (and how much memory they use). Memory Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated… pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
… slave with a 24-hour old backup, and apply the binary logs continuously until it catches up, you will be waiting almost…” capacity, 19h48m/4h12m = 4.7 days). So what are the solutions? If you are using all InnoDB tables, an XtraBackup incremental backup should… feature a few months ago. If you are using multiple storage engines, then your options are to either try and time delay slaves…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… GA release date – quite respected. The cases when you see old MySQL versions are used is typically when application is not overly demanding… it. Do you think such policies are reasonable ? Do we need longer support cycle or shorter would make sense ? How long older platforms… very old operating system is important for you ? Finally I’d like to know What is the Oldest Platform/Operating system are you running…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 11 Comments
Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound… query shows information about how many pages are in buffer pool for given table (cnt), how many of them are dirty (dirty), and what…. You can use this feature to tune buffer pool invalidation strategy, for example play with innodb_old_blocks_pct and innodb_old_blocks…
Post: Explaining Indexes with a Library Metaphor
August 30, 2011 By 1 Comment
… is comparing them to index cards in an old library. In an old library, you used to (or still do) have index cards…. You have your result and you have saved yourself from walking over to the shelves. Using a covering index You are interested to know how many pages a certain book by J.R. Hartley has. You go over to the…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… have followed that road. So how do people approach the upgrade process …you‘re using Reckless approach you just hope you‘re lucky – you hope you‘re using simple enough functionality not to be affected or if you are you are… while you still have the slave running the old version in case you …
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…their interactions and different specifics. Think for example how many DBMS need to do Distributed Transactions (XA)…the binary which is over half a year old was often offered. Enterprise customers who got the… Good News in the End The good news are you really do not need general “quality” or “being…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 7 Comments
…also grandparent-grandchild, and every other path, no matter how long. We even store paths of length zero, …-inserting them one by one, which is awful. Are you aware of a more efficient solution for moving … subtree, we need to disconnect it from its old position in the tree. Delete the outdated paths…
