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.
This comment has been removed by the author.
ReplyDeleteWould be great if you write something about good select statements and pattern search in big tables. interesting points are:
ReplyDelete- 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:
ReplyDeleteAny 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
ReplyDeleteselects
table layout
optimize tables
scripts for monitoring
DBA toolset
olap, datawarehouse
ReplyDeleteSome topics:
ReplyDelete- 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!
ReplyDelete