MySQL Forums
Forum List  »  Newbie

Re: Need Help - Troubleshoot Connection Problems
Posted by: Jay Friedman
Date: August 30, 2015 09:47PM

Thank you for your help! My log file is in /var/log/mysqld.log. (I checked all files the mysql process was using.) To get a "fresh" view, I stopped MySQL, made sure all process were stopped. I then moved the log file so it would create a fresh one. Then I again started mysql. I can't find any error - only warnings.

So I'm totally unsure of what is happening. Here's what the log/error file says from the beginning. (it then keeps generating the warning message.)

150830 20:26:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150830 20:26:46 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288
150830 20:26:46 InnoDB: Initializing buffer pool, size = 2.0M
150830 20:26:46 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 96 598124604
150830 20:26:47 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 96 598188715
InnoDB: 2 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 14179 row operations to undo
InnoDB: Trx id counter is 0 3988958976
150830 20:26:47 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 150830 20:26:57InnoDB: Warning: difficult to find free blocks fro
m
InnoDB: the buffer pool (31 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: 258 OS file reads, 1 OS file writes, 1 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.
150830 20:26:57InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (31 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: 258 OS file reads, 1 OS file writes, 1 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.
150830 20:26:57InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (32 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: 258 OS file reads, 1 OS file writes, 1 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.
150830 20:26:57InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (32 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: 258 OS file reads, 1 OS file writes, 1 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.
150830 20:26:58InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (33 search iterations)! Consider


Any ideas what to do now??

thanks again for your help!!!!

Options: ReplyQuote


Subject
Written By
Posted
Re: Need Help - Troubleshoot Connection Problems
August 30, 2015 09:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.