mysql³£ÓÃÃüÁî
mysql³£ÓÃÃüÁî
¹Ø±ÕÊý¾Ý¿â
/data01/mysql/bin/mysqladmin -p shutdown
µ¼³öÊý¾Ý¿â
/usr/local/mysql/bin/mysqldump -opt -uroot -p -h10.15.0.45 bbsdb > 20070918.bbsdb.sql
µ¼ÈëÊý¾Ý¿â
/usr/local/mysql/bin/mysql target_db_name < backup-file.sql
ÏÞÖÆÖ»ÓÐÄÚ²¿ip¿ÉÒÔÁ´½Ó
/usr/local/mysql/bin/mysqld_safe --bind-address=10.15.0.72 &
Êý¾Ý¿â°²×°
./configure --prefix=/usr/local/mysql --with-charset=gbk --with-collation=gbk_chinese_ci
Êý¾Ý¿âÐÞ±í
/usr/local/mysql/bin/myisamchk --safe-recover table_name
¸ü¸ÄmysqlÓû§ÃÜÂ룺
mysql -h 10.15.11.2 -u root -p
Enter password: ********
ERROR 1130 (00000): Host '10.15.11.2' is not allowed to connect to this MySQL server
½â¾ö°ì·¨£¬ÔÚ10.15.11.2»úÆ÷ÉÏÖ´ÐÐ
mysql>grant all on *.* to root@'%' identified by 'yourpassword';
mysql>flush privileges; //Ë¢ÐÂȨÏÞ
##########################################
mysql±¸·Ý½Å±¾
#!/bin/sh
BACK_HOME="/server/back/www.test_db" ####±¸·Ý¿â·Åµ½µÄĿ¼
MYSQLDUMP="/server/mysql/bin/mysqldump" ###ÃüÁî
MYSQLCMD="/server/mysql/bin/mysql"
DB_NAME_LIST_FILE="/server/back/www.test_db/dbnamelist" ###¿âÁбí
##########
TAR="/bin/tar"
MYSQL_SERVER="10.15.0.52" ###Òª±¸·ÝÖ÷»úipµØÖ·
###µ¼Êý¾Ý¿âÁбí
$MYSQLCMD -uzhp -p12345 -h $MYSQL_SERVER </root/showdbcmd.sql>$DB_NAME_LIST_FILE
############
TODAY=`date +%Y%m%d`
MONTH=`date "+%d"`
WEEK=`date "+%w"`
##################
cd $BACK_HOME
for i in `cat $DB_NAME_LIST_FILE`
do
if [ $i != "Database" ]
then
echo "start $i..."
$MYSQLDUMP -Q -uzhp -p12345 -h $MYSQL_SERVER $i >$TODAY.$i.sql && echo "$TODAY.$i.sql good" >>mail.txt ####µ¼¿âÃüÁî
fi
done
echo "start tar...."
$TAR cvzfp $TODAY.db.test.sql.tar.gz *.sql && echo "$TODAY smsdbgood" >> mail.txt
cd $BACK_HOME
rm -rf *.sql
###########################
A.my.cnfÅäÖÃ
±¾ÎÄÖеÄÅäÖö¼ÊÇ´Ó¡¶MySQL5ȨÍþÖ¸ÄÏ(3rd)¡·ÖÐÕª³³öÀ´µÄ£¬¸öÈËÈÏΪ¶ÔÓÚʹÓÃMySQLÊ®·ÖÓÐÓ᣷ÅÔÚ´Ë´¦·½±ã×Ô¼ºËæÊ±²éÔÄ£¬Ò²Ï£Í
Ïà¹ØÎĵµ£º
Galera ÊÇÒ»Ì×ÔÚ MySQL InnoDB ÉÏÃæÊµÏÖ Multi-master ÇÒ synchronous replication µÄϵ統¡£
¸Ã°æ±¾ÐÞ¸´ÁË9¸öbug£¬Ö÷ÒªÊÇ´¦Àí DDL ºÍ DML µÄ²¢·¢ÎÊÌ⣬ÁíÍâ»ù×¼MySQL°æ±¾Éý¼¶µ½ 5.1.41 ¡£
ÏÂÔØµØÖ·£º http://www.codership.com/en/downloads/galera
......
1, MySQL profiling
mysql> set profiling = 1;
mysql> select count(*) from test;
mysql> show profiles;
mysql> show profile for query 1;
2,mysql ¼à¿Ø
http://bbs.linuxtone.org/thread-1854-1-1.html
http://code.google.com/p/mysql-cacti-templates/ -> Hig ......
bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£
smallint ´Ó -2^15 (-32,768) µ½ 2^15 - 1 (32,7 ......
MYSQL³£ÓÃÃüÁîÁбí
1¡¢ÏµÍ³¹ÜÀí
mysql -hÖ÷»úµØÖ· -uÓû§Ãû -p
Á¬½ÓMYSQL£¨ÔÚmysql/bin£©
exit
Í˳öMYSQLÃüÁî
mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë passwordÐÂÃÜÂë
ÐÞ¸ÄÃÜÂ루ÔÚmysql/bin£©
grantselect[insert][,update][,delete]onÊý¾Ý¿â.*toÓû§Ãû@localhost£¨"%"£¬ ±íʾÈκÎÖ÷»ú£©identifiedby " ......