'scripts' Tag

  • 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 [...]

  • Another Python MySQL template

    August 11, 2010

    Following up on Matt Reid’s simple python, mysql connection and iteration, I would like to share one of my own, which is the base for mycheckpoint & openark kit scripts. It is oriented to provide with clean access to the data: the user is not expected to handle cursors and connections. Result sets are returned [...]

  • 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. 132): custom monitoring, custom charts, process list dump

    June 4, 2010

    Revision 132 of mycheckpoint has been released. New and updated in this revision: Custom monitoring: monitoring & charting for user defined queries HTML reports for custom monitoring Process list dump upon alert notifications Custom monitoring & charts Custom monitoring allows the user to supply with a query, the results of which will be monitored. That [...]

  • EXPLAIN: missing db info

    May 11, 2010

    I’m further developing a general log hook, which can stream queries from the general log. A particular direction I’m taking is to filter queries by their type of actions. For example, the tool (oak-hook-general-log) can be instructed to only stream out those queries which involve creation of a temporary table; or those which cause for [...]

  • oak-hook-general-log: streaming general log

    March 21, 2010

    I’m seeking input on a new openark kit utility I’ve started to implement. The tool, oak-hook-general-log, will hook up to a MySQL (>= 5.1) server, and stream the general log into standard output. It looks like this: bash$ python src/oak/oak-hook-general-log.py –socket=/tmp/mysql.sock –user=root 2010-03-21 10:18:42     root[root] @ localhost []       79      1       Query   SELECT COUNT(*) FROM City [...]

  • mk-schema-change? Check out ideas from oak-online-alter-table

    March 10, 2010

    In response to Mark Callaghan’s post mk-schema-change. I apologize for not commenting on the post itself, I do not hold a Facebook account. Anyway this is a long write, so it may as well deserve a post of its own. Some of the work Mark is describing already exists under openark kit‘s oak-online-alter-table. Allow me [...]

  • 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 [...]

  • On restoring a single table from mysqldump

    December 1, 2009

    Following Restore one table from an ALL database dump and Restore a Single Table From mysqldump, I would like to add my own thoughts and comments on the subject. I also wish to note performance issues with the two suggested solutions, and offer improvements. Problem relevance While the problem is interesting, I just want to [...]

 
Powered by Wordpress and MySQL. Theme by openark.org