… post. Auditing user activity in MySQL has traditionally been challenging. Most … too, and isn’t flexible at all. The specific problem of … is what the McAffee plugin does. Installation and configuration are straightforward following the… which means you can write a script to listen on this socket …
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
…, and are delivered in the form of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added…) * Added 1-second granularity to pmp-check-mysql-deadlocks (bug 1154774) * Added package install/update instructions and other documentation updates (bugs 1139652… installation and setup of these tools are included with our services. You can find links to the documentation, forums and more at…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… the base plugin directory (/usr/lib64/mysql/plugin/libmemcached.so) that can be stopped and started at runtime. In a nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached… Box with http/php, 1 box with memcache or mysql started PHP script Zend framework libmemcached PECL module Zend_Cache_Backend_Libmemcached…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL… install anyway. The larger problem – chances are that fixing this with ‘dpkg –configure -a’ would cause MySQL to shut down. The MySQL package scripts… problems, etc. I mean, that works great for a computer at home or a tiny and unimportant system, but any of…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… version at first. Ie upgrade to recent MySQL 5.0 before upgrading to MySQL 5.1 – this makes sure you will be at somewhat…. mysql user removed I’m not sure if this one is done by RedHat uninstall script or MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after upgrade…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different…an example, take a look at this bug report (not a bug). Looking at MySQL status Now we’re starting…at least one “cycle” of queries in it. Then I run the following: wget http://hackmysql.com/scripts…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
…. Looking at Server-Status I’ve seen scripts executing for hours sometimes which is obviously the problem – they take Apache Slot, MySQL Connection… (and so script abortion) worked only in case script was outputing something. If script is just doing something like scripts or MySQL calls and does… for scripts which spend most of their time waiting. There is also pcntl_signal function which you can use to install your…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… script (such as the one that ships by default with many server installations) or a system administration mistake to delete one of MySQL…. These things tend to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory…. A variety of problems can delete MySQL‘s PID file, such as a buggy init script that attempts to start the server…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…the replication traffic. An interesting thing to note – scripts can hurt replication traffic well after they are… with you in SAN, NAS or Cloud installations. It all can be the cause of the…a bit different workload and when backup taken at the wrong time may be responsible for unexpected MySQL …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster database… thanks! A: Yes, as long as there are at least 3 datacenters, and the total number … since it is backed up by the wrapper script called innobackupex, and not xtrabackup itself while …
