MySQL
Open Source Relational Data Base engine. Known for simplicity and speed.
But doesn't support transactions and other "advanced" features. For that you typically use PostgreSQL.
- but few websites really use/need transactions, and Scalability is pushing people away from those features.
Part of the LAMP platform.
Do FederatedTables allow greater scale-out of a schema that uses foreign keys, etc.?
installing on MacOs X
-
building http://hivelogic.com/narrative/articles/installing-mysql-on-mac-os-x
-
see some comments
- MAMP http://www.mamp.info/en/index.php - yes, I did that.
-
"still some issues on Tiger"
-
what are they? just the "shared library" problem?
-
I'm actually still running Panther.
-
-
Mark Pilgrim on the joys of not building yourself.
-
Command Line interface: 'mysql' http://dev.mysql.com/doc/refman/5.1/en/mysql.html
GUI tools http://dev.mysql.com/doc/#guitools
- Security concerns often keep you from using such things (because you make your db as inaccessible as possible, except from other machines behind that firewall)
batch input/output
-
output/export: "mysqldump" from Command Line
-
import: "source" from inside mysql
date queries: MySQL doesn't have as nice date_trunc and date_part functions as PostgreSQL.
-
you can use date(timestamp) to group by whole-date
-
there's a month() function but that gives you just the month-number, so doesn't work for cross-year queries
- though I suppose you could break on year() and month()
monitoring tools (recommended by friend May'2011)
- slow query log http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
- Percona allows you to get below 1 second minimum http://www.percona.com/docs/wiki/percona-server:features:slow_extended_51?redirect=2
- Percona also particularly helpful in MultiCore servers
- Percona allows you to get below 1 second minimum http://www.percona.com/docs/wiki/percona-server:features:slow_extended_51?redirect=2
- Running "mysqladmin processlist > "/tmp/mysqlplog" ; sleep 5" in the background
- Zabbix
- mytop http://jeremy.zawodny.com/mysql/mytop/
- spotlight http://www.quest.com/spotlight-on-mysql/ - run it for an hour to collect data then turn off - adds load to server
- MySQL Tuner - could help diagnose if your mysql instance is configured/tuned correctly for your workload http://www.howtoforge.com/tuning-mysql-performance-with-mysqltuner
- If you're running innodb storage engine, innotop will give you 'top' style real-time view into your databases http://innotop.googlecode.com/svn/html/index.html
- Maatkit would let you look at all aspects of your instance including slow query logs http://www.maatkit.org/
Edited: | Tweet this! | Search Twitter for discussion