things to blog about.

Cardinality.

Also a blog post on “using the sakila sample database”

Speeding-up Queries: New Features of the MySQL 5.0 Query Engine — Katchaounov — blog about it, find the slides, explain well.

new fulltext parser like sergei’s talk. dayum!

Things I learned
Tune server params is last resort AFTER application optimization (from Jay)

http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html

http://lists.mysql.com/mysql/196677 and my response.

nested set/adjacency hybrid code from roland

FOUND_ROWS
ROW_COUNT
SQL_CALC_FOUND_ROWS — calculate how many there are when you’re doing a limit. (or SELECT CALC_FOUND ROWS)

http://firestuff.org/wordpress/2006/07/20/sqlsearch-100/

crosstab: http://rpbouman.blogspot.com/2005/10/creating-crosstabs-in-mysql.html
http://www.futhark.ch/mysql/106.html

(sun has a db tech group — neat, ponder a job?)

What about composite searches — and, or, not? Pivot tables? Crosstabs? SELECTs and defaults, as well as multiple selections? newsome’s “building sane query interfaces” get the code from newsome@acm.org (emailed 8/16)

‘mysqld –verbose –help’
how to find out how it was compiled?

Cardinality.

Also a blog post on “using the sakila sample database”

Speeding-up Queries: New Features of the MySQL 5.0 Query Engine — Katchaounov — blog about it, find the slides, explain well.

new fulltext parser like sergei’s talk. dayum!

Things I learned
Tune server params is last resort AFTER application optimization (from Jay)

http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html

http://lists.mysql.com/mysql/196677 and my response.

nested set/adjacency hybrid code from roland

FOUND_ROWS
ROW_COUNT
SQL_CALC_FOUND_ROWS — calculate how many there are when you’re doing a limit. (or SELECT CALC_FOUND ROWS)

http://firestuff.org/wordpress/2006/07/20/sqlsearch-100/

crosstab: http://rpbouman.blogspot.com/2005/10/creating-crosstabs-in-mysql.html
http://www.futhark.ch/mysql/106.html

(sun has a db tech group — neat, ponder a job?)

What about composite searches — and, or, not? Pivot tables? Crosstabs? SELECTs and defaults, as well as multiple selections? newsome’s “building sane query interfaces” get the code from newsome@acm.org (emailed 8/16)

‘mysqld –verbose –help’
how to find out how it was compiled?