<br><div class="gmail_quote">On Nov 26, 2007 1:52 PM, Bill Moran <<a href="mailto:wmoran@potentialtech.com">wmoran@potentialtech.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
My point is:<br>a) Let me send you a tweaked postgresql.conf file and well find<br> out whether the performance difference is simply a matter of<br> untuned configuration and ...</blockquote><div><br>I will post them for all to see, maybe someone will point out something else.
<br><br>These are the non comment lines in postgresql.conf<br><br><div style="margin-left: 40px; font-family: courier new,monospace;">hba_file = '/etc/postgresql/8.2/main/pg_hba.conf'<br>ident_file = '/etc/postgresql/8.2/main/pg_ident.conf'
<br>external_pid_file = '/var/run/postgresql/8.2-main.pid'<br>listen_addresses = 'localhost'<br>port = 5432<br>max_connections = 100<br>unix_socket_directory = '/var/run/postgresql'<br>shared_buffers = 24MB
<br>max_fsm_pages = 153600<br>log_line_prefix = '%t '<br>stats_row_level = on<br>autovacuum = on<br>datestyle = 'iso, dmy'<br>lc_messages = 'en_CA.UTF-8'<br>lc_monetary = 'en_CA.UTF-8'<br>lc_numeric = 'en_CA.UTF-8'
<br>lc_time = 'en_CA.UTF-8'<br></div><br>For MySQL, this is the default delivered with Ubuntu (and I imagine Debian would be close).<br><br><div style="margin-left: 40px;"><font face="courier new,monospace">[client]
<br>port = 3306<br>socket = /var/run/mysqld/mysqld.sock<br><br>[mysqld_safe]<br>socket = /var/run/mysqld/mysqld.sock<br>nice = 0<br><br>[mysqld]<br>user = mysql<br>pid-file = /var/run/mysqld/mysqld.pid<br>socket = /var/run/mysqld/mysqld.sock
<br>port = 3306<br>basedir = /usr<br>datadir = /var/lib/mysql<br>tmpdir = /tmp<br>language = /usr/share/mysql/english<br>skip-external-locking<br>bind-address = <a href="http://127.0.0.1">127.0.0.1</a><br>key_buffer = 16M
<br>max_allowed_packet = 16M<br>thread_stack = 128K<br>thread_cache_size = 8<br>query_cache_limit = 1M<br>query_cache_size = 16M<br>log_bin = /var/log/mysql/mysql-bin.log<br>expire_logs_days = 10<br>max_binlog_size = 100M
<br>skip-bdb<br><br>[mysqldump]<br>quick<br>quote-names<br>max_allowed_packet = 16M<br><br>[mysql]<br><br>[isamchk]<br>key_buffer = 16M<br><br>!includedir /etc/mysql/conf.d/</font> <br></div></div><div><br>Note that there are no config files in the includedir.
<br><br>What I normally do (not for this benchmark, but for tuning) is:<br><br><ul><li>Comment out the bin-log lines (log_bin, expire_logs_days, max_bin_log_size). This takes of some load, but more importantly saves disk space on some starved VPSs.
</li><li>Add skip-innodb, which saves some 100MB of RAM for the MySQL.<br></li></ul></div><div>These are irrelevant to the benchmark at hand anyway, but is useful to know.<br><br>For larger web sites, I use a configuration similar to the one listed here:
<br><br><a href="http://2bits.com/articles/mysql-my-cnf-configuration-for-a-large-drupal-site.html">http://2bits.com/articles/mysql-my-cnf-configuration-for-a-large-drupal-site.html</a><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>b) Let me have the query log after the test and I'll see if I<br> can identify any queries that could be improved, then someone<br> else can test to see if the improved queries are acceptable<br> from the MySQL standpoint.
<br><br></blockquote></div><br><br clear="all"><br>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com">2bits.com</a><br><a href="http://2bits.com">http://2bits.com</a><br>Drupal optimization, development, customization and consulting.