473,326 Members | 2,168 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Configure wait_timeout

I am using MYSQL version 5.0 (5.0.46). I intend to configure wait_timeout variable by updating the my.ini file(WINDOWS XP). But the value updated in this file is not getting reflected when checked in MYSQL command prompt.
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
  1. # CLIENT SECTION
  2. [client]
  3. port=3307
  4.  
  5. [mysql]
  6. default-character-set=latin1
  7. # SERVER SECTION
  8. [mysqld]
  9. port=3307
  10. basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
  11. datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
  12. default-character-set=latin1
  13. default-storage-engine=INNODB
  14. sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  15. max_connections=100
  16. wait_timeout=7200
  17. query_cache_size=0
  18. table_cache=256
  19. tmp_table_size=9M
  20. thread_cache_size=8
  21. myisam_max_sort_file_size=100G
  22. myisam_max_extra_sort_file_size=100G
  23. myisam_sort_buffer_size=17M
  24. key_buffer_size=10M
  25. read_buffer_size=64K
  26. read_rnd_buffer_size=256K
  27. sort_buffer_size=256K
  28. innodb_additional_mem_pool_size=2M
  29. innodb_flush_log_at_trx_commit=1
  30. innodb_log_buffer_size=1M
  31. innodb_buffer_pool_size=17M
  32. innodb_log_file_size=10M
  33. innodb_thread_concurrency=8
  34.  
3. Value at mysql command prompt for wait_timeout
Expand|Select|Wrap|Line Numbers
  1. mysql> select @@wait_timeout;
  2. +----------------+
  3. | @@wait_timeout |
  4. +----------------+
  5. |          28800 |
  6. +----------------+
  7. 1 row in set (0.00 sec)
  8.  
Thanks
-Sandhya
Jul 30 '08 #1
0 6456

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Moritz Steiner | last post by:
I set a lot of variables in the my.cnf file, all variables are set (I checked it with "show variables") except of wait_timeout. If I set the option in MySQL with "option wait_status=3Dxxx" it...
0
by: Moritz Steiner | last post by:
Thanks a lot, that solved my problem! Moritz -----Urspr=FCngliche Nachricht----- Von: Egor Egorov =20 Gesendet: Freitag, 18. Juli 2003 10:16 An: mysql@lists.mysql.com Betreff: Re: WG:...
2
by: Sami | last post by:
I keep getting the famous 'Too Many Connection' Error, and don't know how to change my variables, so they persist even if i have to restart mysql service. Platform: Windows 2003 Server My...
0
by: D. Niemeyer | last post by:
Hello All, Currently we are running MySQL 4.0.17-nt on a Server 2003 machine. I am having a problem with connections hanging around in a sleep state, and building up over time. Eventually...
0
by: Markus Wollny | last post by:
Hello! When I try to run ./configure --with-java, it complains that ant doesn't work. However ant is installed, as is the latest Java SDK 1.4.2 from sun, PATH and JAVA_HOME are set correctly; ...
0
by: Samuel M. Smith | last post by:
I am trying to build python2.4.2 on an arm 9 running Debian 3 Sarge when I run ./configure it fails with ../configure checking MACHDEP... linux2 checking EXTRAPLATDIR... checking for...
1
by: Markus Wollny | last post by:
Hi! I am trying to build PostgreSQL 7.4.3 with Java enabled; I've got Apache Ant version 1.5 and j2sdk1.4.1_05 installed: Verifiying ant: # which javac /usr/java/j2sdk1.4.1_05/bin/javac #...
14
by: david | last post by:
I have developed web forms including login by using ASP.NET via HTTP. Now I want to secure the connection from client to the server via HTTPS. How can I configure the server or something else to...
0
by: Satish S Nandihalli | last post by:
following errors were found on executing configure file: 1) configure: WARNING: thread.h: present but cannot be compiled configure: WARNING: thread.h: check for missing prerequisite headers?...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.