macabre_sunsets Δημοσ. 11 Ιουνίου 2011 Δημοσ. 11 Ιουνίου 2011 Μια βάση MySQL που έχω αναλάβει, έσκασε τα ξημερώματα. Μπορεί κάποιος να καταλάβει τον λόγο κοιτάζοντας το παρακάτω log; >Number of processes running now: 0 110611 01:58:21 mysqld restarted 110611 1:58:23 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288 InnoDB: Log scan progressed past the checkpoint lsn 1 1276374882 110611 1:58:23 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 1 1276375632 110611 1:58:31 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 110611 1:58:32 InnoDB: Started; log sequence number 1 1276375632 110611 1:58:32 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.90' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution Number of processes running now: 0 110611 04:56:06 mysqld restarted 110611 4:56:07 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288 InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 110611 4:56:10 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... 110611 4:56:18 InnoDB: Started; log sequence number 1 1276663755 110611 4:56:19 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.90' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution Number of processes running now: 0 110611 05:00:17 mysqld restarted 110611 5:00:18 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288 InnoDB: Log scan progressed past the checkpoint lsn 1 1282927565 110611 5:00:19 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... 110611 5:00:32InnoDB: 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: 129 OS file reads, 0 OS file writes, 0 OS fsyncs InnoDB: Starting InnoDB Monitor to print further InnoDB: diagnostics to the standard output. Το τμήμα από το τελευταίο "InnoDB: buffer..." μέχρι το τέλος επαναλαμβανόταν ένα 4ωρο περίπου. Δοκίμασα "kill -9 (MySQL PID)" ώστε να τερματίσω τυχόν εναπομείναντες διεργασίες της MySQL, αλλά όταν έδινα "/etc/init.d/mysqld (re)start" τότε μου επέστρεφε timeout και δεν εκκινούσε ο δαίμονας. Δοκίμασα και κάποιες άλλες λύσεις που βρήκα στο internet, αλλά με καμία δεν κατάφερα να σηκώσω τον δαίμονα, οπότε έκανα αναγκαστικά επανεκκίνηση του υπολογιστή. Μετά την επανεκκίνηση, δεν έχει γραφτεί κάτι στο log. Το "my.cnf" είναι το ακόλουθο, σε περίπτωση που χρειάζεται: >[mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 query_cache_size = 128M skip-bdb local-infile=1 set-variable = innodb_buffer_pool_size=2M set-variable = innodb_additional_mem_pool_size=500K set-variable = innodb_log_buffer_size=500K set-variable = innodb_thread_concurrency=2 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid skip-bdb set-variable = innodb_buffer_pool_size=2M set-variable = innodb_additional_mem_pool_size=500K set-variable = innodb_log_buffer_size=500K set-variable = innodb_thread_concurrency=2
Προτεινόμενες αναρτήσεις
Αρχειοθετημένο
Αυτό το θέμα έχει αρχειοθετηθεί και είναι κλειστό για περαιτέρω απαντήσεις.