Dump/Restore

Betöltési hiba külső hivatkozások feloldása miatt

SET FOREIGN_KEY_CHECKS = 0; 
SET FOREIGN_KEY_CHECKS = 1; 

Karakterkódolás beállítása

my.cnf

[client]

default-character-set=utf8

[mysqld]

character-set-server=utf8

collation-server=utf8_hungarian_ci

[mysql]

default-character-set=utf8

Replikáció

itt

Elérés SSL-en

http://dev.mysql.com/doc/mysql-security-excerpt/5.0/en/secure-create-certs.html

http://xn.pinkhamster.net/blog/tech/mysql_with_ssl_on_debian.html

Egyéb

Külső kulcsok használata

A MySQL adatbáziskezelő rendszernél a külső kulcsok használata csak InnoDB típusú táblaszerkezetnél lehetséges, a InnoDB szerkezetű táblák nem támogatják.

Monitorozás

http://alvinalexander.com/blog/post/mysql/how-show-open-database-connections-mysql

https://code.google.com/p/innotop/downloads/detail?name=innotop-1.9.1.tar.gz&can=2&q=

http://innotop.googlecode.com/svn/html/installing.html

The MySQL show status command

You can show MySQL open database connections (and other MySQL database parameters) using the MySQL show status command, like this:mysql> show status like 'Conn%';
------------------+

------------------+

------------------+
1 row in set (0.00 sec)

mysql> show status like '%onn%';
-----------------------------+

-----------------------------+

-----------------------------+
7 rows in set (0.00 sec)
All those rows and values that are printed out correspond to MySQL variables that you can look at. Notice that I use like 'Conn%'in the first example to show variables that look like "Connection", then got a little wiser in my second MySQL show status query.

MySQL show processlist

Here's what my MySQL processlist looks like when I had my Java application actively running under Tomcat:mysql> show processlist;
-----------------------------------------------+

-----------------------------------------------+

-----------------------------------------------+
4 rows in set (0.00 sec)
And here's what it looked like after I shut Tomcat down:mysql> show processlist;
-----------------------------------------+

-----------------------------------------+

-----------------------------------------+
1 row in set (0.00 sec)