I did restart the MySQL Service after updating the .ini file.
1. Path of my.ini file : C:\Program Files\MySQL\MySQL Server 5.0
2. Contents of my.ini file
Expand|Select|Wrap|Line Numbers
- # CLIENT SECTION
- [client]
- port=3307
- [mysql]
- default-character-set=latin1
- # SERVER SECTION
- [mysqld]
- port=3307
- basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
- datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
- default-character-set=latin1
- default-storage-engine=INNODB
- sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
- max_connections=100
- wait_timeout=7200
- query_cache_size=0
- table_cache=256
- tmp_table_size=9M
- thread_cache_size=8
- myisam_max_sort_file_size=100G
- myisam_max_extra_sort_file_size=100G
- myisam_sort_buffer_size=17M
- key_buffer_size=10M
- read_buffer_size=64K
- read_rnd_buffer_size=256K
- sort_buffer_size=256K
- innodb_additional_mem_pool_size=2M
- innodb_flush_log_at_trx_commit=1
- innodb_log_buffer_size=1M
- innodb_buffer_pool_size=17M
- innodb_log_file_size=10M
- innodb_thread_concurrency=8
Expand|Select|Wrap|Line Numbers
- mysql> select @@wait_timeout;
- +----------------+
- | @@wait_timeout |
- +----------------+
- | 28800 |
- +----------------+
- 1 row in set (0.00 sec)
-Sandhya