0

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

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by varmadba
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.