I am using MySQL 3.23.58 on FC2

I ran PhpMyAdmin >> Runtime Information and it said that "Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based. "

My existing my.cnf looks like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_allowed_packet=16M
skip-innodb


[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I added some parameters as follows:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_allowed_packet=16M
skip-innodb

key_buffer_size = 33554432
table_cache=512

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

But after this when I restart mysqld, it does not start.
What is going wrong ?

I need to increase table_cache & key_buffer.

Any help or advice is deepl appreciated.

Thank you in anticipation.

best regards,
Vai

Hope my post is not too late...

Best way is to start mysqld in console mode,
console shows why mysql is not able to start

u can start this by scrolling to you mysql installation directory
and type mysqld-nt --console Please me know how it goes