Tag Archives: MySQL

筆記: MySQL replication 問題 Client requested master to start replication from impossible position 解法

Posted on November 28, 2011 by victor

今天遇到MySQL的master伺服器主機當機的情況，當master復原時，slaves都出現了  Slave I/O: Got fatal error 1236 from master when reading data from binary log: ‘Client requested master to start replication from impossible position’, Error_code: 1236 這樣的錯誤，問題起因很簡單，原本的slave正在pulling的master.bin因為當機的原因不正常關閉，當下次master資料庫終於正常重啟時，master會開另一個bin繼續寫，此時slave重練上後不知道有這件事，繼續向master要求當掉的bin的下一筆資料，就會出現上面的錯誤 只要確定是這種情況，解決方法就是看新的bin編號是到多少 mysql> show master statusG *************************** 1. row *************************** File: master-bin.000073 Position: 21959116 … Continue reading →

Posted in 筆記 | Tagged , , , , , | Comments Off on 筆記: MySQL replication 問題 Client requested master to start replication from impossible position 解法

[筆記] 手動編譯MySQL

Posted on June 20, 2011 by victor

Download mysql source tar xvf mysql.tar yum -y install cmake Compile Follow guide here: http://forge.mysql.com/wiki/CMake mkdir bld cd bld cmake .. make sudo make install Set permissions of linux user and group Follow guide here http://dev.mysql.com/doc/refman/5.6/en/binary-installation.html groupadd mysql useradd -r -g mysql … Continue reading →

Posted in 筆記 | Tagged , , , | Comments Off on [筆記] 手動編譯MySQL

為什麼MySQL的InnoDB Select Count(*)這麼慢

Posted on January 31, 2009 by victor

為什麼MySQL的InnoDB Select Count(*)這麼慢 Continue reading →

Posted in 中文文章, 分享 | Tagged , , , , , | Comments Off on 為什麼MySQL的InnoDB Select Count(*)這麼慢