1) edit /etc/fstab and insert none /mnt/ramdisk tmpfs size=1g 0 0 2) Mount drive mount /mnt/ramdisk 3) configure /etc/my.cnf tmpdir = /mnt/ramdisk
Monday, September 24th, 2007 | Posted in SQL | No Comments »
If the performance of an existing MySQL based system is critical and someone aims to avoid the I/O bottleneck: the MySQL-Engine uses on disk temporary tables for some operations. Use the explain-syntax to detect the details of your queries which might be generating temporary tables and look for “Using temporary”. Once you found them, check [...]
Monday, September 24th, 2007 | Posted in SQL | No Comments »
If you are running Symfony on a production system and want to speed it up, you are probably willing to do the following: 1) Enable APC To enable the ByteCache – System called APC just install it using PECL after you intalled apache2-dev and php5-dev pecl install apc. This will cache all your php-files as [...]
Friday, September 14th, 2007 | Posted in Projects, SQL, Symfony | No Comments »
Ich bin gerade über einen sehr spannenden Blogeintrag bzgl. MySQL Views gestossen. Dieser endet mit den schönen Worten: MySQL has long way to go getting queries with VIEWs properly optimized. Witzig ist, dass wir gerade heute eben dieses Problem zu spüren bekommen haben. Hintergrund war der, dass das von uns verwendete Propel eine bestimmte Query, [...]
Thursday, August 30th, 2007 | Posted in PHP, Projects, SQL, Symfony | No Comments »
You are currently browsing the archives for the SQL category.
