Notes outils Tuning MySQL
htop iotop iptraf vmstat netstat -ntpl vm.swappiness = 20 mysqlreport innotop http://mysqltuner.com/ https://launchpad.net/mysql-tuning-primer http://www.mysqltutorial.org/mysql-if-function.aspx
Symfony 2 : mise en place d’un projet
Configuration du Virtual Host : <VirtualHost www.xxxx.com:80> ServerName www.xxxx.com ServerAlias www.xxxx.com DocumentRoot /data/webs/www.xxxx.com/web <Directory /data/webs/www.xxxx.com/web> # enable the .htaccess rewrites AllowOverride All Order allow,deny Allow from All </Directory> ErrorLog path CustomLog path combined </VirtualHost> On se place dans le répertoire /data/webs/www.xxxx.com php et on lance l’installation de Composer : curl -s https://getcomposer.org/installer | php Puis(en choisissant la bonne version que l’on souhaite installer !) php composer.phar create-project symfony/framework-standard-edition path/…
Symfony 1.4 : créer et charger une base, regénérer le modèle
symfony doctrine:build –all –and-load
Création de comptes MySQL
CREATE DATABASE bd_test; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON bd_test.* TO user_test@localhost IDENTIFIED BY ‘mypassw0rd’; flush privileges;