//登陆
mysql -uroot
mysql -uroot -p 进入mysql
//导入
mysql>source /home/abc/abc.sql;
//启动&停止
cd /var/lib/mysql
rm -f /var/lib/mysql/mysql.sock; //先删除再重新启动
1.启动:/etc/init.d/mysql start
2.停止:/etc/init.d/mysql stop
3.重启:/etc/init.d/mysql restart
2.停止:/etc/init.d/mysql stop
3.重启:/etc/init.d/mysql restart
reboot 这个非正常的时候用这个
一般建议用init 6
一般建议用init 6
show processlist;
//查看线程状态
show status like '%Threads_connected%';
show variables like ‘thread_cache_size‘;
show variables like '%thread_cache_size%';
show status like '%
Threads%';
show status like '%
Threads_running%';
show variables like ‘thread_cache_size‘;
show global variables like '%timeout%'; 超时时间
set global
thread_cache_size
= 20;
//全局修改
set globa XXXX=???
show variables like '%log%';
set global general_log = "on"; set global general_log = "off";
set global
slow_query_log
= "on"; set global slow_query_log= "off";
tail -f
/var/lib/mysql/localhost.log
//快查询
http://blog.csdn.net/fdipzone/article/details/16995303 把快查询txt变为数据库表
tail -f /var/lib/mysql/mysql-slow.log //慢查询
tail -f /usr/local/bin/apache-tomcat-6.0.45/logs/localhost_access_log.2016-05-26.txt
mysql> show global variables like 'wait_timeout';
//端口
mysql> set global wait_timeout=28800;
8.Could not retrieve transation read-only status server
① SHOW VARIABLES LIKE '%iso%'; //查看mysql事务隔离级别
②若返回结果为:REPEATABLE-READ,修改事务级别SET GLOBAL tx_isolation='READ-COMMITTED' 并重启java;
③修改my.cnf文件transaction_isolation = READ-COMMITTED
补充: transaction_isolation事务级别
READ-UNCOMMITTED:读取未提交内容
READ-COMMITTED:读取提交内容(oracle默认)
REPEATABLE-READ:可重读(myql默认)
SERIRLIZED:可串行化
① SHOW VARIABLES LIKE '%iso%'; //查看mysql事务隔离级别
②若返回结果为:REPEATABLE-READ,修改事务级别SET GLOBAL tx_isolation='READ-COMMITTED' 并重启java;
③修改my.cnf文件transaction_isolation = READ-COMMITTED
补充: transaction_isolation事务级别
READ-UNCOMMITTED:读取未提交内容
READ-COMMITTED:读取提交内容(oracle默认)
REPEATABLE-READ:可重读(myql默认)
SERIRLIZED:可串行化