MySQL
From Null-pointer
Contents |
run external sql file
[root@localhost ~]# mysql -uusername -p myDatabase < mySql.sql
log all queries
[root@localhost ~]# "D:\Devapps\MySQL\MySQL Server 5.1\bin\mysqld.exe" --console --log=general.log
data
[root@localhost ~]# cd /var/lib/mysql
conf
[root@localhost ~]# vi /etc/my.cnf
dump/restore
query cache
MySQL [1]
RESET QUERY CACHE
show status
mysql> SHOW STATUS LIKE 'Qcache%'; +-------------------------+--------+ | Variable_name | Value | +-------------------------+--------+ | Qcache_free_blocks | 36 | | Qcache_free_memory | 138488 | | Qcache_hits | 79570 | | Qcache_inserts | 27087 | | Qcache_lowmem_prunes | 3114 | | Qcache_not_cached | 22989 | | Qcache_queries_in_cache | 415 | | Qcache_total_blocks | 912 | +-------------------------+--------+
