020406 18:02:50 *********************************************** I'm getting this error messge constantly in my error log:
InnoDB: Warning: difficult to find free blocks from InnoDB: the buffer pool (200 search iterations)! Consider InnoDB: increasing the buffer pool size. InnoDB: It is also possible that in your Unix version InnoDB: fsync is very slow, or completely frozen inside InnoDB: the OS kernel. Then upgrading to a newer version InnoDB: of your operating system may help. Look at the InnoDB: number of fsyncs in diagnostic info below. InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0 InnoDB: 5703 OS file reads, 502 OS file writes, 82 OS fsyncs InnoDB: Starting InnoDB Monitor to print further InnoDB: diagnostics to the standard output. Running SuSE Linux 7.3: ccs012:/var/lib/mysql # uname -a ; df -h ; free -m Linux ccs012 2.4.10-64GB-SMP #1 SMP Fri Sep 28 17:26:36 GMT 2001 i686 unknown Filesystem Size Used Avail Use% Mounted on /dev/sda7 67G 59G 8.2G 88% / /dev/sda5 63M 36M 26M 58% /boot shmfs 1007M 0 1006M 0% /dev/shm total used free shared buffers cached Mem: 2013 2008 4 0 10 657 -/+ buffers/cache: 1340 672 Swap: 1035 0 1035 TIA -- ---------------------------------------------------- Jonathan Wilson System Administrator Clickpatrol.com Cedar Creek Software http://www.cedarcreeksoftware.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php