mysql ÈÕÖ¾ÎļþµÄʹÓÃ
MYSQLÓв»Í¬ÀàÐ͵ÄÈÕÖ¾Îļþ(¸÷×Ô´æ´¢Á˲»Í¬ÀàÐ͵ÄÈÕÖ¾)£¬´ÓËüÃǵ±ÖпÉÒÔ²éѯµ½MYSQLÀï¶¼×öÁËЩʲô£¬¶ÔÓÚMYSQLµÄ¹ÜÀí¹¤×÷£¬ÕâЩÈÕÖ¾ÎļþÊDz»¿ÉȱÉٵġ£
1.´íÎóÈÕÖ¾(The error log)£º¼Ç¼ÁËÊý¾Ý¿âÆô¶¯¡¢ÔËÐÐÒÔ¼°Í£Ö¹¹ý³ÌÖдíÎóÐÅÏ¢£»
2.ISAM²Ù×÷ÈÕÖ¾(The isam log)£º¼Ç¼ÁËËùÓжÔISAM±íµÄÐ޸쬏ÃÈÕÖ¾½ö½öÓÃÓÚµ÷ÊÔISAMģʽ£»
3.SQLÖ´ÐÐÈÕÖ¾(The query log)£º¼Ç¼Á˿ͻ§¶ËµÄÁ¬½ÓÒÔ¼°ËùÖ´ÐеÄSQLÓï¾ä£»
4.¸üÐÂÈÕÖ¾(The update log)£º¼Ç¼Á˸ıäÊý¾ÝµÄÓï¾ä£¬ÒѾ²»½¨ÒéʹÓã¬Óɶþ½øÖÆÈÕÖ¾Ìæ´ú£»
5.¶þ½øÖÆÈÕÖ¾(The binary log)£º¼Ç¼ÁËËùÓжÔÊý¾Ý¿âÊý¾ÝµÄÐÞ¸ÄÓï¾ä£»
6.³¬Ê±ÈÕÖ¾(The slow log)£º¼Ç¼ËùÓÐÖ´ÐÐʱ¼ä³¬¹ý×î´óSQLÖ´ÐÐʱ¼ä(long_query_time)»òδʹÓÃË÷ÒýµÄÓï¾ä£»
Èç¹ûÄãÊÇÔÚÓÃmysqlµÄ¸´ÖÆ¡¢±¸·Ý¹¦ÄÜ£¬ÄÇô´Ó·þÎñÆ÷»¹ÌṩÁËÒ»ÖÖ½Ð×örelay logµÄÈÕÖ¾Îļþ¡£
ĬÈÏÇé¿öÏÂËùÓÐÈÕÖ¾Îļþ»á¼Ç¼ÔÚMYSQLµÄÊý¾ÝĿ¼Ï£¬Äã¿ÉÒÔͨ¹ýÇ¿ÖÆmysqlÈ¥¹Ø±Õ²¢ÖØÐ´ò¿ªÒ»¸öÎļþ½øÐÐÈÕÖ¾¼Ç¼£¬µ±È»ÏµÍ³»á×Ô¶¯¼Óºó׺
(Èç.00001, .00002)£¬·½Ê½ÓÐÔÚmysql»·¾³ÏÂÖ´ÐÐÓï¾ä mysql>flush logs;
»òÕßͨ¹ýmysqladmin¹ÜÀí³ÌÐòÖ´ÐÐ #mysqladmin flush-logs »ò #mysqladmin refresh
ÕâЩÈÕÖ¾µÄÆô¶¯·½Ê½¿ÉÒÔÔÚmysqld_safe·½Ê½Æô¶¯Êý¾Ý¿âµÄʱºò£¬ºóÃæ¸úÑ¡Ïî²ÎÊý£¬Ò²¿ÉÒÔÔÚÅäÖÃÎļþÀïÅäÖã¬ÍƼö²ÉÓõڶþÖÖ·½Ê½£¬ÅäÖ÷½·¨ºÜ¼òµ¥£¬ÎÒÖ»ÅäÖÃÁËÈýÖÖÈÕÖ¾£º
[mysqld]
log=/var/log/mysqld_common.log
log-error=/var/log/mysqld_err.log
log-bin=/var/log/mysqld_bin.bin
ÈÕÖ¾µÄ²é¿´ºÜ¼òµ¥£¬´ó²¿·Ö¶¼ÊÇÎı¾£¬Ö±½ÓÓÃvim¡¢less¡¢moreÖ®ÀàµÄ¹¤¾ß¿´¾Í¿ÉÒÔÁË£¬ÖµµÃ˵Ã÷µÄÊǶþ½øÖÆÎļþµÄ²é¿´£º
1). Ê×ÏÈÈ·¶¨ÊÇ·ñ¿ªÆôÁ˶þ½øÖÆÎļþ¼Ç¼¹¦ÄÜ
mysql>show variables like 'log_bin';
2). Èç¹ûÄãÏëÖªµÀÏÖÔڼǼ¶þ½øÖÆÊý¾ÝµÄÎļþ¾ßÌåÐÅÏ¢£¬Äã¿ÉÒÔͨ¹ýÏÂÁÐÓï¾ä¿´µ½ÏÖÔÚÕýÔڼǼÄĸöÎļþ£¬ÒÔ¼°¼Ç¼µÄµ±Ç°Î»Öãº
mysql>show master status;
3). ²é¿´¶þ½øÖÆÊý¾ÝÐèÒª½èÖú³ÌÐòmysqlbinlog£¬¿´¿´ËüÖ§³ÖÄÄЩѡÏ¸ù¾Ý×Ô¼ºÐèÒªÀ´Ê¹Óá£
mysql>mysqlbinlog /var/log/mysql/mysql-bin.000040;
²éѯij¸öʱ¼ä·¶Î§µÄ¿ÉÒÔÖ´ÐÐÏÂÁÐÓï¾ä£¬Èç¹û¼Ç¼ºÜ¶à¿ÉÒÔ½«½á¹û¶¨Ïòµ½Ò»¸öÎļþÀï×Ô¼ºÂýÂý¿´:-) £º
mysql>mysqlbinlog
--start-datetime='2008-01-01 00:00:00' --stop-datetime='2008-08-08
00:00:00' /var/log/mysql/mysql-bin.000040 > ./tmp.log
Ïà¹ØÎĵµ£º
http://blog.163.com/mysqldba@126/blog/static/1315356342009931103834396/
×î½ü¿´ÁË¿´mysqlµÄ״̬±äÁ¿£¬¸Ð¾õºÃ¶à¸úÒÔǰ×Ô¼ºÏëÏóµÄ²»Ò»Ñù¡£ÎªÁËÒÔºóÄܼ°Ê±·¢ÏÖ×Ô¼ºµÄ´íÎó,¾ÍÏȼÇÏÂÀ´;
http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html
mysql> show status;
Com_xxx
Óï¾ä¼ÆÊý±äÁ¿±íʾÿ¸öxxx ......
ÓÃÔÚSELECTºÍWHERE×Ó¾äµÄº¯Êý
--------------------------------------------------------------
1 ·Ö×麯Êý
( ... ) À¨ºÅ¡£Ê¹ÓÃËüÃÇÀ´Ç¿ÖÆÔÚÒ»¸ö±í´ïʽµÄ¼ÆËã˳Ðò¡£
--------------------------------------------------------------
2 ³£ÓõÄËãÊõÔËËã
£¨+ - * /£©
Ò»°ãµÄË ......
°²×°mysql
gem install mysql
ʹÓÃmysql£¬È磬rake db:migrate
»á±¨´í£º
E:\study\ruby\rails_space>rake db:migrate
(in E:/study/ruby/rails_space)
!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.
rake aborted!
193: ......
package com.qll.operate;
import java.sql.*;
public class OperateUser {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
String name = "root";
String password = "123456";
static Connection conn = null;
Statement st = ......
À´×Ô£ºhttp://it.china-b.com/zx/linuxsjk/20090525/24129_1.html
ÕªÒª£ºMySQLÊÇÒ»¸ö¸ßËÙ¶È¡¢¸ßÐÔÄÜ¡¢¶àÏ̵߳ĹØÏµÐÍÊý¾Ý¿â
ÖÎÀíϵͳ£¬ÊÊÓÃÆ½Ì¨¶à£¬¿ÉÀ©Õ¹ÐÔÇ¿¡£ÔÚʵ¼ÊÉú²ú»·¾³ÖУ¬²¿ÊðºÍʵÏÖ¾ßÓÐÒ»¶¨¸ºÔؾùºâ¹¦ÄܵÄMySQL·þÎñÆ÷¼¯Èº£¬¶ÔÓÚÌá¸ßÓû§Êý¾Ý¿â
Ó¦ÓÃϵͳµÄÐÔÄÜ¡¢ËٶȺÍÎȶ¨ÐÔ¾ßÓÐÃ÷ÏÔµÄ×÷Óᣱ¾ÎļòÒª½éÉÜÁËÔÚ ......