- Code: Select all
max_connections = 300
max_user_connections = 300
table_cache = 1200
max_connections = 300
max_user_connections = 300
table_cache = 1200
max_connections = 300
max_user_connections = 300
table_cache = 1200
max_connections = 300
max_user_connections = 300
table_cache = 1200
k0kytak wrote:my.ini file but I myself find it located in C: \ xampp \ mysql \ bin \ my.ini but the problem is that I find the following lines
- Code: Select all
max_connections = 300
max_user_connections = 300
table_cache = 1200
I want to increase these things because mysql is loaded and stops because I have 200 people online site constantly
max_connections =
max_user_connections =
table_cache =
Please be patient as it is hard to understand your broken English.k0kytak wrote:Well why are not these 3 lines to hell
- Code: Select all
max_connections =
max_user_connections =
table_cache =
# The MySQL server
[mysqld]
port= 3306
socket= "C:/xampp3/mysql/mysql.sock"
basedir="C:/xampp3/mysql"
tmpdir="C:/xampp3/tmp"
datadir="C:/xampp3/mysql/data"
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"
max_connections = 200
max_user_connections = 200
table_cache = 1200
...if you cared to read the comments in the my.ini file instead of blowing off steam.# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
Users browsing this forum: No registered users and 210 guests