-
Recent Posts
Recent Comments
Archives
- December 2013
- November 2013
- March 2012
- February 2012
- December 2011
- November 2011
- October 2011
- August 2011
- July 2011
- June 2011
- May 2011
- March 2011
- February 2011
- January 2011
- October 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
Categories
Meta
友站連結
Tag Archives: MySQL
筆記: MySQL replication 問題 Client requested master to start replication from impossible position 解法
今天遇到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
[筆記] 手動編譯MySQL
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
為什麼MySQL的InnoDB Select Count(*)這麼慢
為什麼MySQL的InnoDB Select Count(*)這麼慢 Continue reading