XAMPP, MySQL and configuration

[random1]

I have tried adding:

Code: Select all

# Custom
character_set_server = utf8
secure_auth = 1
local-infile = 0
skip-symbolic-links
delay_key_write = OFF
key_buffer_size = 32M
innodb_log_file_size = 10MB
thread_cache_size = 25
query_cache_type = 1
query_cache_size = 500M
query_cache_limit = 1048576


to the 'my' config file in: C:\xampp\mysql\bin

But this configuration takes no affect to server variables of mysql.

Does XAMPP have another file that overrides this?

[Izzy]

I have tried adding:

Code: Select all

# Custom
character_set_server = utf8
secure_auth = 1
local-infile = 0
skip-symbolic-links
delay_key_write = OFF
key_buffer_size = 32M
innodb_log_file_size = 10MB
thread_cache_size = 25
query_cache_type = 1
query_cache_size = 500M
query_cache_limit = 1048576


to the 'my' config file in: C:\xampp\mysql\bin

Did you edit the existing lines to reflect your changes or did you simply add all those lines?

If you added just the new lines in which [sections] did you add them?

Did you restart MySQL just to be on the safe side after editing the my.cnf file?

There are some MySQL configs in the apache\bin\php.ini file in the [MYSQL] section.

They should be recognised if the edits are done correctly.

You used a text editor not an RTF or a word processor?

Are you using mysql or mysqli?

Which version of XAMPP - from your previous posts I am assuming still 1.7.0?

[random1]

I added those lines to the end of the file. I restarted MySQL.

I used notepad to edit.

I'm using mysqli.

I'm using XAMPP 1.7.0.

I have uploaded the whole file to:

http://codeviewer.org/view/code:5fe

[Izzy]

They have all been added under the [mysqlhotcopy] section which they obviously have nothing to do with hot copy.

Try adding them under the [mysqld] section below the list and after myisam_sort_buffer_size = 8M

Edit the existing line
innodb_log_file_size
rather than create a duplicate entry.

Try that and let us know if it helps.

[random1]

Many thanks for the help Izzy.

After making those changes it errored, I had to delete the 'ib_logfile...' files and start mysql service again.

It's now working

I ended up with:

http://codeviewer.org/view/code:600

I notice at the top of the file in comments:

"Example MySQL config file for small systems"

Is there an example mySQL config file for XAMPP for large production systems?

[Izzy]

Many thanks for the help Izzy.

You most welcome.

After making those changes it errored, I had to delete the 'ib_logfile...'

I did say to edit the existing line rather than add the line into your list as I suspected a duplicate line may give errors.

The same line is down in amongst the other innodb lines and the value can be edited there.

I notice at the top of the file in comments:
"Example MySQL config file for small systems"
Is there an example mySQL config file for XAMPP for large production systems?

I think the inference to small systems is related to the settings values included in the default my.cnf file which on larger systems could be considerably higher values relative to your available system resources - hard to define what is a large system, but a small system would be easier to define.

Imaging how large those values would be on a Google search engine server in the Equinix DC.

Anyhow I am pleased it is now working for you.

Good luck.