Search
The Caboteria
/
Tech Web
/
DatabaseTips
/
MySqlNotes
(revision 9) (raw view)
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/
Edit
|
Attach
|
P
rint version
|
H
istory
:
r12
<
r11
<
r10
<
r9
<
r8
|
B
acklinks
|
V
iew topic
|
Raw edit
|
More topic actions...
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