some thing wrong when I try to use innodb

2005-06-08 Thread qin lei
050609 16:33:59 mysqld started 050609 16:34:00 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 InnoDB: E

"show innodb status" doesn't work

2005-06-08 Thread qin lei
I use Mysql 4.0.22. When I press "show innodb status",I got the error message: ERROR 1105: Unknow error what's the problem? Is the innodb enable in 4.0.22 by default? How can I check if the innodb enable or not? _ 与联机的朋友进行交流,请使用

how can I close the cache for mysql

2005-06-06 Thread qin lei
I am running a test on mysql. In a specific condition I need avoid using the cache system in mysql how can I do this? If I can't, is there anyway to remove the cached tables from cache manually? _ 与联机的朋友进行交流,请使用 MSN Messenger: ht

how can I close the cache for mysql

2005-06-06 Thread qin lei
I am running a test on mysql. In a specific conditiob I need avoid using the cache system in mysql how can I do this? If I can't, is there anyway to remove the cached tables from cache manually? _ 享用世界上最大的电子邮件系统― MSN Hotmail。 htt

problem when running mysql server

2005-05-26 Thread qin lei
I have instal mysql in /usr/local/mysql. When I run the server. The message showed on the screen is as follows: [EMAIL PROTECTED] bin]# ./safe_mysqld & [1] 5122 [EMAIL PROTECTED] bin]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysql

how can I install mysql without administrator priviledge

2005-05-25 Thread qin lei
I downloaded the binary files and upziped them to /home/myname/mysql.(I use red hat linux) when I use command "mysqld --console" to run the server. The following message are showed on the screen: [EMAIL PROTECTED] bin]$ ./mysqld --console 050525 17:36:11 Warning: Can't create test file /var/li

how can I get performance statistics

2005-05-24 Thread qin lei
I need know the execution time of a query. And how many times the I/O operation are involved for the query. How can I get this kind of infomation? Are there some ways to add these info into the logfile? Thank you. I am a rookie for Mysql and for this mial-list system. If I broke the rule of as