http://www.mysql.com/ Small, fast database for simple tasks like providing services to web servers. http://dev.mysql.com/doc/ <pre> mysql --host=host --user=user -p database (as root, connected to mysql database) select host, user, password from user; show databases; show tables; describe table; </pre> Debugging "access denied" errors: http://dev.mysql.com/doc/refman/5.1/en/access-denied.html *Replication* troubleshooting: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html <br/> purge binary logs: http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html <pre> show master status; show slave status \G; </pre> *Mac OSX* =/Library/StartupItems/MySQLCOM/MySQLCOM= Installs into =/usr/local/mysql= by default. *Deadlocks* You'll get lots of them: http://dev.mysql.com/doc/refman/5.0/en/innodb-deadlocks.html *Maatkit* http://www.maatkit.org/ - need to look into these tools, they look useful. *OurDelta* An alternative distro with some useful patches applied: http://ourdelta.org/
This topic: Tech
>
DatabaseTips
>
MySqlNotes
Topic revision: r9 - 01 Mar 2013 - TobyCabot
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding The Caboteria?
Send feedback