… versions streaming backups were performed by the innobackupex script but incremental backups were done by the …backups. As part of the backup, the LRU dump is now included as well. Support for …of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there …
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… why number of people established slow by safe upgrade procedures – dump your data and reload. Little tip to mention – upgrading to… problems Upgrade Script fails to shut down MySQL Server. Obviously nothing can work without this one. Upgrade Script Removes /var/lib/mysql symlink I… 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: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… did this preprocessing with the MyISAM storage engine, then I dumped the data to tab delimited flat files using mysqldump. I…: The MySQL command line client was used to execute the a script file containing the 11 queries. This same SQL script was used… run_query.php script and the output was captured with the ‘tee’ command. $ cat one.ini [default] user=mysql db=ontime_one…
Post: Using INFORMATION_SCHEMA instead of shell scripting
November 24, 2008 By 7 Comments
… have also found it to be very helpful as a scripting language for variety of database administration tasks. It can be… shell script: mysql> select concat(“mysqldump “,table_schema,” “,table_name, ” >> “,table_schema,”.sql”) from tables where engine=’innodb’ into outfile ‘/tmp/dump.sh… -f /var/lib/mysql/art73/article73.frm | | rm -f /var/lib/mysql/art73/author73.frm | | rm -f /var/lib/mysql/art73/forum73.frm…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… of developments in the market such as MySQL 5.5, MariaDB, Drizzle, etc. The short … with “fast index creation” when restoring a dump, which can potentially speed up restores greatly. … merged new documentation into innobackupex, the Perl wrapper script around xtrabackup. We cleaned this up, moved …
Post: Percona-XtraDB version 9.1
March 14, 2010 By 16 Comments
… Percona-XtraDB Enabled support of SSL Enabled profiling Added script to sort LRU dump New supported platforts are added. The full list… #506894: buf_flush_LRU_recommendation() is too optimistic Fixed mysql-tests: mysql mysql_upgrade ssl tests enabled rpl_killed_ddl and innodb-autoinc… Percona-XtraDB should be installed. It will replace currently installed mysql-server, mysql-client, etc. Centos platform. 1. If you didn’t…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, at the tail it has information on core dumps and so on. It’s possible that …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… I run the following: wget http://hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them on different… trash/dump data. It is easier to analyze – Troubleshooting bottlenecks on shared boxes is more complicated compared to systems running only MySQL… only use it in last resort – placing some data crunching scripts on database server is often better use of their free…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
…. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6… a foundation of our live binary log backups. The wrapper script below will connect to the remote server specified in the…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
… filesystem layout. Recompile the same version of mysql, with this patch applied (we compile mysql from source ourselves anyway, so this is… pump your query log acquired earlier through the below perl script. It’s very quick, very dirty, and probably very buggy…. That means if you have 60 hours worth of dump data, the script will run for 60 hours replaying it. This was…
