mysql and gdb

Very interesting trick:
(Reference: http://www.mysqlperformanceblog.com/2010/03/23/too-many-connections-no-problem/ )

gdb -p $(pidof mysqld) -ex “set max_connections=5000″ -batch

mk-heartbeat monitor MySQL replication

Master server:

# cat mysql_repl_heartbeat_master.sh
mk-heartbeat --database test --table heartbeat --user heartbeat --interval 15 --update --host localhost &

Slave server:

# cat mysql_repl_heartbeat_slave.sh
mk-heartbeat --database test --table heartbeat --user heartbeat --interval 15 --monitor --host localhost --file /tmp/heartbeat &

mysqlfragfinder.sh

mysqlfragfinder.sh

defrag mysql MyISAM tables:

cat /root/admin/defrag.sh:

/root/admin/mysqltuner/mysqlfragfinder.sh –user root –password “abc”

filefrag

Reference: http://mysqldba.blogspot.com/2008/01/filefrag-dbas-best-friend.html

Use ‘filefrag’ to see file fragmentation for innodb file: TABLE.ibd