Have you tried MySQLTuner yet? It's free and it makes optimizing your MySQL server easier than ever!

Archive for February, 2007

Need a handy way to list all the email accounts and their passwords?

select CONCAT(mail_name,"@",name) as email_address,accounts.password from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;

Comments No Comments »