摘要:
Oriignal article: http://www.symfony-project.com/book/1_0/18-PerformanceClearing Selective Parts of the CacheDuring application development, you have to clear the cache in various situations: When you... 阅读全文
摘要:
1. simple join two tables purpose:generate sql like: select * from photo p left join artist a on p.artist_id = a.artist_id where a.genre = 'something' and p.genre = 'something'code: if(!CriteriaUtil:... 阅读全文
摘要:
Create a file backup_db.sh, and paste the following contents:#get the first parameter as the database nameDATABASE=$1#if no database specified, then you can set the default oneif [ -z $DATABASE ]; the... 阅读全文
摘要:
#server-id = 1log-bin = /var/log/mysql/mysql-bin.log#if you set the expire_logs_days = x var in the [mysqld] section of your my.cnf it will automatically rotate your bin logs after x days.expire_logs_... 阅读全文