Following up on Ronald Bradford’s Checked your MySQL recovery process recently? post, I wish to add a prequel.
To see whether you have a clear definition of your backup requirements, ask yourself these questions:
Is there a backup/restore plan?
Is there a written backup/restore plan?
How fast do you need to recover a backup? What’s the longest downtime you [...]
I’ve written shortly on this before. I like yum; I love apt-get; I prefer not to use them for MySQL installations. I consider a binary tarball to be the best MySQL installation format (source installations being a different case altogether).
Why?
I use yum and apt-get whenever I can and for almost all needs (sometimes preferring CPAN [...]
Revision #88 of mycheckpoint is released. In this revision:
Disk space monitoring
Improved charting
Enhanced auto-deploy
And more…
Disk space monitoring
mycheckpoint now monitors (on Linux only) three mount points:
The “/” (root) mount point
The datadir mount point
The tmpdir mount point
It may well be the case that two of the above (or perhaps all three of them) share the same mount point. [...]
In mathematics, a monotonic function (or monotone function) is a function which preserves the given order. [Wikipedia]
To be more precise, a function f is monotonic increasing, if for every x ≤ y it holds that f(x) ≤ f(y). f is said to be strictly monotonic increasing is for every x < y it holds that f(x) [...]
Ever so often a query provides a “bad” execution plan. Adding a missing index can many times solve the problem. However, not everything can be solved with an index. I wish to highlight the point of having an implicit cast, which negates the use of an index on MySQL.
I see this happening a lot on [...]