| Common Problems |
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Auto-increment
fields |
|||||||||||
| • | User
variables |
|||||||||||
| • | Improper
sync of a new slave |
|||||||||||
| • | Cross
database queries and slave filtering |
|||||||||||
| • | Binary
(or relay) logs use all your disk space! |
|||||||||||
| • | Version
mismatch |
|||||||||||
| • | LOAD
TABLE … FROM MASTER |
|||||||||||
| – | Not
for InnoDB |
|||||||||||
| • | Slave
start/stop commands in 4.0.x |
|||||||||||
| Copyright
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |