[Level 1] Testing notes for MySQL. (mysql commands) 

#!/usr/bin/bash
#ln -s /dev/null .mysql_history ## in my.cnf MYSQL_HISTFILE=/dev/null
#export MYSQL_PS1="(\u@\h) [\d]> " ## mysql --prompt="(\u@\h) [\d]> "
#mysql -u mysql mysql < ./test_mysql.sql
#mysql -u root mysql < ./test_mysql.sql
#mysql -u root --defaults-file=/etc/my.ini


## mysqlslap, benchmark test
# mysqlslap -auto-generate-sql # use default script
mysqlslap -a -c100 i10 -u root -p --engine=InnoDB,MyISAM,MEMORY,ARCHIVE

## mysqlcheck, for MyISAM, InnoDB, CSV and Archive.
#mysqlcheck world;
#mysqlcheck world City Country;
#mysqlcheck --databases world test;
#mysqlcheck --all-databases;

## bin-log
#mysqlbinlog bin.000001 bin.000002 | more
#mysqlbinlog bin.000001 bin.000002 | mysql
#mysqlbinlog --start-datetime="2009-01-01 00:00:00" --stop-datetime="2009-01-01 23:59:59" bin.000001 bin.000002 | mysql
#mysqlbinlog --start-position=1001 --stop-position=1999 bin.000001 bin.000002 | mysql
## purge binary logs
#mysql> purge binary logs to 'mysql-bin.010'; # mysql-bin.010 will not be deleted.
#mysql> purge binary logs before '2009-05-31 23:59:59';


## mysqlhotcopy, for MyISAM not for Innodb
## perl script, need to install DBI module first
#mysqlhotcopy world /var/archive
#mysqlhotcoyp world./Country/ /var/archive

mysql_multi
mysql_multi --example # list example configuration

## replication
mysqldump --master-data=2 
## option write to the dump file a comment
## line containing the replication coordinates, 
## which can be used when setting up replication slaves.
## That line has this format:
## CHANGE MASTER TO MASTER_LOG_FILE='file_name', MASTER_LOG_POS=file_position;
Wish this helps.
regards,
Stanley Huang

Comments

Post a Comment

Popular posts from this blog

[Level 1] Rar tool for Solaris.

Sometimes we will got a rar compressed file from our friends, but there is no default tool in OpenSolaris to decompress the rar filess. We can got a Solaris Intel version from rarlab . The steps as the following: 1. down load the rar tools from rarlab. http://www.rarlab.com/rar_add.htm 2. uncompressed the source. # gunzip ./unrar-sol-intel.gz 3. move it to the location you used to. # mv /unrar-sol-intel.gz /usr/bin/unrar 4. try to decomprss # unrar x ./test.rar Wish this helps. regards, Stanley Huang
Read more

[Level 2] iif in Python

If you want to implement iif in Python, please refer to the following sample code: #!/bin/env python def iif(b): return 'It\'s True' if b else 'It\'s False' print iif(True) print iif(False) And the following sample, guess what will you get! #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % 'Ture' if b else 'False' Result: $ ./iif.py b: Ture False The second result is "False", not "b: False". Why??? Because the prededence of string concatenation is higher than if. Therefore you need to use () to make it correct. #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % ('Ture' if b else 'False') Wish this helps. regards, Stanley Huang
Read more