Yakın zamanda bayağı bir konu açtım. Eski MySQL, Eski FreeBSD ne güzeldi tık tık kuruyorduk. Nedense bunda hata yapıyorum ya da hata görüyorum. [Yaşlı Kurt]
Şaka bir yana yine hata çıktı. Aslında hata denemez. Konularda belirttiğim hataları teker teker nasıl olduysa atlatmayı başardım. Ancak MySQL sorunsuz sapasağlam çalışıyor olmasına rağmen bilgisayarımdan veya aynı router'a bağlı olan bilgisayardan giremiyorum sunucuma. Log dosyamı göstereyim önce:
Bu arada belirtmek isterim
FreeBSD 9.1 32 Bit Yüklü
130623 10:35:01 mysqld started
130623 10:35:02 InnoDB: Started; log sequence number 0 43655
130623 10:35:02 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
A mysqld process already exists at Sun Jun 23 10:45:11 EEST 2013
130623 10:45:12 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 10:45:12 InnoDB: Starting shutdown...
130623 10:45:13 InnoDB: Shutdown completed; log sequence number 0 43655
130623 10:45:13 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 10:45:13 mysqld ended
130623 10:45:56 mysqld started
130623 10:45:56 InnoDB: Started; log sequence number 0 43655
130623 10:45:56 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
130623 10:48:02 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 10:48:02 InnoDB: Starting shutdown...
130623 10:48:03 InnoDB: Shutdown completed; log sequence number 0 43655
130623 10:48:03 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 10:48:03 mysqld ended
130623 10:56:21 mysqld started
/usr/local/libexec/mysqld: Too many arguments (first extra is '.user=mysql').
Use --help to get a list of available options
130623 10:56:21 mysqld ended
130623 10:57:09 mysqld started
130623 10:57:11 InnoDB: Started; log sequence number 0 43655
130623 10:57:12 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
A mysqld process already exists at Sun Jun 23 10:58:23 EEST 2013
130623 10:58:32 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 10:58:32 InnoDB: Starting shutdown...
130623 10:58:33 InnoDB: Shutdown completed; log sequence number 0 43655
130623 10:58:33 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 10:58:33 mysqld ended
130623 10:58:33 mysqld started
130623 10:58:33 InnoDB: Started; log sequence number 0 43655
130623 10:58:33 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
130623 10:59:14 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 10:59:14 InnoDB: Starting shutdown...
130623 10:59:14 InnoDB: Shutdown completed; log sequence number 0 43655
130623 10:59:14 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 10:59:14 mysqld ended
130623 10:59:58 mysqld started
130623 10:59:58 InnoDB: Started; log sequence number 0 43655
130623 10:59:59 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
130623 11:05:05 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 11:05:05 InnoDB: Starting shutdown...
130623 11:05:06 InnoDB: Shutdown completed; log sequence number 0 43655
130623 11:05:06 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 11:05:07 mysqld ended
130623 11:05:07 mysqld started
130623 11:05:07 InnoDB: Started; log sequence number 0 43655
130623 11:05:07 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
130623 11:14:34 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 11:14:41 InnoDB: Starting shutdown...
130623 11:14:43 InnoDB: Shutdown completed; log sequence number 0 43655
130623 11:14:43 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 11:14:43 mysqld ended
130623 11:15:28 mysqld started
130623 11:15:28 InnoDB: Started; log sequence number 0 43655
130623 11:15:29 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
130623 14:09:57 mysqld ended
130623 14:10:39 mysqld started
130623 14:10:39 InnoDB: Started; log sequence number 0 43655
130623 14:10:39 [Note] Recovering after a crash using mysql-bin
130623 14:10:39 [Note] Starting crash recovery...
130623 14:10:39 [Note] Crash recovery finished.
130623 14:10:39 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
130623 14:38:07 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 14:38:07 InnoDB: Starting shutdown...
130623 14:38:08 InnoDB: Shutdown completed; log sequence number 0 43655
130623 14:38:08 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 14:38:08 mysqld ended
130623 14:38:12 mysqld started
130623 14:38:12 InnoDB: Started; log sequence number 0 43655
130623 14:38:12 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
130623 14:38:31 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 14:38:31 InnoDB: Starting shutdown...
130623 14:38:32 InnoDB: Shutdown completed; log sequence number 0 43655
130623 14:38:32 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 14:38:32 mysqld ended
130623 14:38:32 mysqld started
130623 14:38:32 InnoDB: Started; log sequence number 0 43655
130623 14:38:32 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
A mysqld process already exists at Sun Jun 23 14:54:31 EEST 2013
130623 14:55:02 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 14:55:02 InnoDB: Starting shutdown...
130623 14:55:03 InnoDB: Shutdown completed; log sequence number 0 43655
130623 14:55:03 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 14:55:03 mysqld ended
130623 14:55:45 mysqld started
130623 14:55:45 InnoDB: Started; log sequence number 0 43665
130623 14:55:45 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
A mysqld process already exists at Sun Jun 23 15:02:21 EEST 2013
130623 15:02:37 [Note] /usr/local/libexec/mysqld: Normal shutdown
130623 15:02:37 InnoDB: Starting shutdown...
130623 15:02:38 InnoDB: Shutdown completed; log sequence number 0 43665
130623 15:02:38 [Note] /usr/local/libexec/mysqld: Shutdown complete
130623 15:02:38 mysqld ended
130623 15:02:39 mysqld started
/usr/local/libexec/mysqld: Too many arguments (first extra is '.user=mysql').
Use --help to get a list of available options
130623 15:02:39 mysqld ended
130623 15:02:55 mysqld started
130623 15:02:55 InnoDB: Started; log sequence number 0 43665
130623 15:02:55 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95
A mysqld process already exists at Sun Jun 23 15:02:58 EEST 2013
Loglar bu şekilde.
Bir de mysql serverin durumuna bakacak olursak:
Uptime: 148 Threads: 1 Questions: 1 Slow queries: 1 Opens: 1 Flush tables: 1 Open tables: 1 Queries per second avg: 0.048