Would be great if you write something about good select statements and pattern search in big tables. interesting points are:
- fulltext search - how to sort by relevance - what is better? joins or several statements - how to create select statements by query string in PHP or Java - eg exploding string by whitespace or considering brackets and "..." - techniques to optimize select statements - techniques to optimize tables (splitting, indices, etc)
i think many mysql coders will be interested in this topic.
7 comments:
Would be great if you write something about good select statements and pattern search in big tables. interesting points are:
- fulltext search
- how to sort by relevance
- what is better? joins or several statements
- how to create select statements by query string in PHP or Java - eg exploding string by whitespace or considering brackets and "..."
- techniques to optimize select statements
- techniques to optimize tables (splitting, indices, etc)
i think many mysql coders will be interested in this topic.
yours
Andi
All MySQL given the context I suppose:
Any scripts/configs for monitoring/start-up/recovery? (I seem to remember slaves self-firewalling when they lag significantly mentioned at Flickr...)
Any "gotchas" to avoid with master<->master, federation, sharding?
Any recommended OS settings for standalone DB servers?
What's your recommended DBA toolset? Command line MySQL client? PHPMyAdmin? custom Perl/PHP/python scripts? a GUI?
Thanks for any of the above in advance :)
ok I'll write some stuff on
selects
table layout
optimize tables
scripts for monitoring
DBA toolset
olap, datawarehouse
Some topics:
- optimize searchs
- diference between myisam and innodb
- better table layout
please write about how to achieve automatic failover (+ sync repl?). is cluster the only way? How reliable is it? issues with it, etc. thanks!
Post a Comment