XAMPP, MySQL and configuration

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP, MySQL and configuration

Postby random1 » 27. January 2009 02:46

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?
random1
 
Posts: 27
Joined: 17. December 2007 07:31

Re: XAMPP, MySQL and configuration

Postby Izzy » 27. January 2009 03:20

random1 wrote: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?
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: XAMPP, MySQL and configuration

Postby random1 » 27. January 2009 03:42

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
random1
 
Posts: 27
Joined: 17. December 2007 07:31

Re: XAMPP, MySQL and configuration

Postby Izzy » 27. January 2009 04:15

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.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: XAMPP, MySQL and configuration

Postby random1 » 27. January 2009 05:08

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 :D

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?
random1
 
Posts: 27
Joined: 17. December 2007 07:31

Re: XAMPP, MySQL and configuration

Postby Izzy » 27. January 2009 05:13

random1 wrote:Many thanks for the help Izzy.
You most welcome.

random1 wrote: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.

random1 wrote: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.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 73 guests