'Linux' Tag

  • Trick: recovering from "no space left on device" issues with MySQL

    August 23, 2013

    Just read Ronald Bradford's post on an unnecessary 3am (emergency) call. I sympathize! Running out of disk space makes for some weird MySQL behaviour, and in fact whenever I encounter weird behaviour I verify disk space. But here's a trick I've been using for years to avoid such cases and to be able to recover […]

  • Installing MySQL from source/binary tarball as a Linux service

    May 1, 2012

    I've written before I prefer to do a manual install of MySQL over a repository one. I still do: I typically install from binary tarball or by compiling from source. I'd like to share my setup procedure for Linux installation and service setup. I've done this dozens of times, on different Linux flavors, and it […]

  • Test-driven SQL development

    October 20, 2011

    I'm having a lot of fun writing common_schema, an SQL project which includes views, tables and stored routines. As the project grows (and it's taking some interesting directions, in my opinion) more dependencies are being introduced, and a change to one routine or view may affect many others. This is why I've turned the development […]

  • Where's my cnf file?

    December 7, 2010

    So you have a running MySQL server, it's working well and everyone's happy. You want to make a minor change to the configuration file, so you edit the file, restart MySQL - but the change doesn't catch! Or maybe you want to check that some global variable has not been dynamically changed without an update […]

  • mylvmbackup HOWTO: minimal privileges & filesystem copy

    August 17, 2010

    This HOWTO discusses two (unrelated) issues with mylvmbackup: The minimal privileges required to take MySQL backups with mylvmbackup. Making (non compressed) file system copy of one's data files. Minimal privileges Some just give mylvmbackup the root account, which is far too permissive. We now consider what the minimal requirements of mylvmbackup are. The queries mylvmbackup […]

  • Tips for taking MySQL backups using LVM

    August 3, 2010

    LVM uses copy-on-write to implement snapshots. Whenever you're writing data to some page, LVM copies the original page (the way it looked like when the snapshot was taken) to the snapshot volume. The snapshot volume must be large enough to accommodate all pages written to for the duration of the snapshot's lifetime. In other words, […]

  • mycheckpoint (rev. 170): improved custom queries; local charting; page/swap I/O monitoring; improved HTML reports

    July 16, 2010

    Revision 170 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision: Improved custom queries: lifting of limitations from previous, introductory revision; better HTML presentation Local, inline charting: no rendering of Google Charts, unless explicitly requested. All charts are now rendered locally using JavaScript. No data is now sent over […]

  • To not yum or to not apt-get?

    February 16, 2010

    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 […]

  • mycheckpoint rev. 76: OS monitoring, auto deploy, brief HTML and 24/7 reports

    January 5, 2010

    Revision 76 of mycheckpoint comes with quite a few improvements, including: OS monitoring (CPU, load average, memory) Auto-deploy Improved charting Brief HTML reports 24/7 charts OS Monitoring When monitoring the local machine, mycheckpoint now monitors CPU utilization, load average, memory and swap space. This only applies to the Linux operating system; there is currently no […]

  • Manually installing multiple MySQL instances on Linux: HOWTO

    February 19, 2009

    Installing a single MySQL instance on a linux machine is a very simple operation. It may be as simple as: apt-get install mysql-server But you cannot use this method to install another MySQL instance. Moreover, if you try to manually install another instance, you may find that some collisions occur. For example, when trying to […]

 
Powered by Wordpress and MySQL. Theme by openark.org