Search
The Caboteria
/
Tech Web
/
DatabaseTips
/
MySqlNotes
(06 May 2014,
TobyCabot
)
(raw view)
Small, fast database for simple tasks like providing services to web servers. People who are concerned about Oracle's actions are moving to <nop>MariaDB: https://mariadb.org/ 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 VARIABLES LIKE 'version'; show databases; show tables; describe table_name; </pre> Debugging "access denied" errors: http://dev.mysql.com/doc/refman/5.1/en/access-denied.html *Character Encoding* http://www.bluebox.net/about/blog/2009/07/mysql_encoding/ Amazon RDS uses latin1 encoding by default, you need to explicitly configure UTF-8: http://matthew.mceachen.us/blog/howto-configure-an-amazon-rds-instance-to-use-utf-8-925.html <pre> mysql> show table status like 'tablename' \G </pre> Note that Ruby's =mysql= gem doesn't respect the table's encoding, but =mysql2= does. *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/
E
dit
|
A
ttach
|
P
rint version
|
H
istory
: r12
<
r11
<
r10
<
r9
<
r8
|
B
acklinks
|
V
iew topic
|
Ra
w
edit
|
M
ore 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