… helpful as a scripting language for variety of database administration tasks. It can be more straightforward compared to using shell or Perl when… ? Well just use INTO OUTFILE to create very simple shell script: mysql> select concat(“mysqldump “,table_schema,” “,table_name, ” >> “,table_schema,”.sql”) from tables where…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… were done using this script: The benchmark run with following simple shell script: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql…allocated comparted to internal allocation from single tablespace. Summary: There …
Post: High availability for MySQL on Amazon EC2 – Part 3 – Configuring the HA resources
July 12, 2010 By 4 Comments
… On hamysql Run MySQL Monitor MySQL Get out of way if MySQL is not running From the above … decided to use a resource of type anything which is just a script. Same script name and…mysql 1: monitor crm(live)configure# commit and that’s it. We know have a resource which is just a shell script…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…shell. Next, we need to authorize some communications for the security group. I’ll authorize 3306/tcp (MySQL) from hamysql, 694/udp (Heartbeat) from…mysql-server-5.1 The package install MySQL has an automatic startup script…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…336797133 mysql-bin.000022 | mysql [root@sb logs]# mysqlbinlog –verbose –base64-output=decode-rows –start-position 336797275 mysql-bin.000022 | mysql mysql> select count(*) from …hacked a quick shell script to create snapshots and uploaded it here. By no means it is perfect, you can use `lvmsnap….
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… high-traffic commodity MySQL server running Percona XtraDB for a gaming workload (mostly inserts to the “moves” table), I used strace to… mysql 8uW REG 8,2 268435456 7143989 /var/lib/mysql/ib_logfile0 mysqld 29772 mysql 9uW REG 8,2 268435456 7143993 /var/lib/mysql… could have done it better with a little more shell scripting, but the output from this was enough for me to massage into…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…of query execution, normally hidden from everyone’s eyes. Currently it’s used by many DBAs and developers…in place, we can begin. Open command line (shell) on the server and go to the …mysql-5.0.51a) % patch -p1 < ../patch-mysql-5.0.51a-msl.diff patching file include/my_time.h patching file scripts…
Comment: MySQL Master-Master replication manager released
April 6, 2007 By 27 Comments
… some scripts written in Perl or Python and some cron scripts in shell simply calling mysql to run some queries. Regarding Master promotion from the slave yes you can do that. The problem is however making it 100% clean way if you care. MySQL… it is worth noting. MyISAM checksum can of course be used. The problem is in described scenario with power down on…
Comment: Using LVM for MySQL Backup and Replication Setup
February 21, 2007 By 53 Comments
Well, this just means you should not use shell to write backup script but use something like Perl, so you can hold connection open… can check existing script – mylvmbackup for inspiration. Also password specified in command line is actually wiped from command line by mysql tools, so…
