Thanks for the help guys.
I have turned off persistent connections in php.ini (though in threads they where off already) but I don't want to change the my.ini just yet.
Could you please mail me your my.ini (without your password off-course:-)) so I can just test it with yours?
the e-mail address is: []
[email protected][/]
Thanks,
Ron
Here is my ini as it is at the moment. I have tried default ini settings as well. Makes no difference.
<br /># This will be passed to all mysql clients <br />[client] <br />port=3306 <br />#socket=MySQL <br /> <br /># Here is entries for some specific programs <br /># The following values assume you have at least 32M ram <br /> <br /># The MySQL server <br />[mysqld] <br />port=3306 <br />user=root <br />password=***************** <br />#socket=MySQL <br />skip-locking <br />set-variable = key_buffer=256M <br />set-variable = max_allowed_packet=1M <br />set-variable = table_cache=256 <br />set-variable = sort_buffer=1M <br />set-variable = record_buffer=1M <br />set-variable = myisam_sort_buffer_size=64M <br />set-variable = thread_cache=8 <br /># Try number of CPU's*2 for thread_concurrency <br />set-variable = thread_concurrency=8 <br />log-bin <br />server-id = 1 <br /> <br /># Uncomment the following rows if you move the MySQL distribution to another <br /># location <br />#basedir = d:/mysql/ <br />#datadir = d:/mysql/data/ <br />tmpdir = c:/tmp/ <br /> <br /># Uncomment the following if you are using BDB tables <br />#set-variable = bdb_cache_size=64M <br />#set-variable = bdb_max_lock=100000 <br /> <br /># Uncomment the following if you are using Innobase tables <br />#innodb_data_file_path = ibdata1:1000M <br />#innodb_data_home_dir = c:\ibdata <br />#innodb_log_group_home_dir = c:\iblogs <br />#innodb_log_arch_dir = c:\iblogs <br />#set-variable = innodb_mirrored_log_groups=1 <br />#set-variable = innodb_log_files_in_group=3 <br />#set-variable = innodb_log_file_size=5M <br />#set-variable = innodb_log_buffer_size=8M <br />#innodb_flush_log_at_trx_commit=1 <br />#innodb_log_archive=0 <br />#set-variable = innodb_buffer_pool_size=16M <br />#set-variable = innodb_additional_mem_pool_size=2M <br />#set-variable = innodb_file_io_threads=4 <br />#set-variable = innodb_lock_wait_timeout=50 <br /> <br /> <br />[mysqldump] <br />quick <br />set-variable = max_allowed_packet=16M <br /> <br />[mysql] <br />no-auto-rehash <br /># Remove the next comment character if you are not familiar with SQL <br />#safe-updates <br /> <br />[isamchk] <br />set-variable = key_buffer=128M <br />set-variable = sort_buffer=128M <br />set-variable = read_buffer=2M <br />set-variable = write_buffer=2M <br /> <br />[myisamchk] <br />set-variable = key_buffer=128M <br />set-variable = sort_buffer=128M <br />set-variable = read_buffer=2M <br />set-variable = write_buffer=2M <br /> <br />[mysqlhotcopy] <br />interactive-timeout <br /> <br />[WinMySQLadmin] <br />Server=C:/mysql/bin/mysqld-nt.exe <br />QueryInterval=10 <br />
