Apache Friends Support Forum

I have a problem I can not find my.ini file to edit these lines there

Code: Select all

max_connections = 300
max_user_connections = 300
table_cache = 1200

This is the wrong forum as it is the German language forum - the English XAMPP for Windows forum is here and this topic may get moved there by a mod:
viewforum.php?f=16


In xampp\mysql\bin folder you may find what seems to be a shortcut file named simply my - drag this shortcut into your open text editor (Notepad for example) and you should be able to edit and save the file as a normal text file - in the newer XAMPP 1.7.1 version this shortcut file has been renamed to the my.ini file and will hopefully end the confusion.

Well I installed xampp 1.7.1 my.ini but not inside

Code: Select all

max_connections = 300
max_user_connections = 300
table_cache = 1200

I have just installed XAMPP 1.7.1 and the my.ini file is definitely in the xampp\mysql\bin folder as large as life.

So you must have an issue with your installation and it would be advisable to check and reinstall if you still can't find it or check your Windows configuration so that all system files etc. are visible, for example untick Hide extensions for known file types and Show hidden files and folders etc.

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

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

First you can't find the my.ini file but now you can.

Then you are saying perhaps that the above lines are not in the my.ini file, is that correct?

Well why are not these 3 lines to hell

Code: Select all

max_connections =
max_user_connections =
table_cache =

k0kytak wrote:Well why are not these 3 lines to hell

Code: Select all

max_connections =
max_user_connections =
table_cache =

Please be patient as it is hard to understand your broken English.

You will have to add those line and increase the values as required.

You have this in the my.ini file and so just add those lines at the end like I have done here and save the file and restart the mysql server.

# 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

The my.ini and the implementation of MySQL is for...

# 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.

...if you cared to read the comments in the my.ini file instead of blowing off steam.