MySQL Optimization: table_cache & key_buffer

[vaibhavs]

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

[varmadba]

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