A few hundred users and MySQL started to complain...
gtani: not a lot to go on, start herehttp://hackmysql.com/documentshttp://dev.mysql.com/doc/refman/5.0/en/optimization.htmlhttp://mysqldba.blogspot.com/2008/04/common-steps-to-scale-l...http://mikaelronstrom.blogspot.com/2008/07/1-making-mysql-cl...