| Webmaster Forum Rules | Posting Guide | Contact Us | Testimonials | Contributing Geek Program | Advertise on Geek/Talk |
|
|
|||||||
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Registered User
Join Date: Mar 2005
Posts: 19
|
I have been having some problems with my server, and I'm suspecting that the database, MySQL, is causing these problems. Specifically, MySQL configuration file currently does not set any variable for InnoDB. As I check the information on the web, I find that the following is the standard configuration:
[mysqld] # You can write your other MySQL server options here # ... # Data files must be able to hold your data and indexes. # Make sure that you have enough free disk space. innodb_data_file_path = ibdata1:10M:autoextend # # Set buffer pool size to 50-80% of your computer's memory set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M # # Set the log file size to about 25% of the buffer pool size set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M # innodb_flush_log_at_trx_commit=1 (http://dev.mysql.com/doc/mysql/en/in...iguration.html) How do I know if this is the ideal configuration for my server? |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| www.Googer.net -- PPC Search Engine Website for sale | coosee | Website For Sale - Purchase - Barter - Trade | 4 | 07-11-2008 01:30 AM |
| Tip for heavy MySQL users: CREATE INDEX | demae | Web Hosting Discussion | 4 | 05-15-2001 04:32 PM |
| vBullletin - Corrupted MySQL records! | Steve_S | Web Design and Webmaster Issues | 5 | 02-06-2001 11:44 PM |
| mysql overload? | notibrian | Web Design and Webmaster Issues | 0 | 02-01-2001 08:03 PM |
| Anyone Ever Set Up MySQL on a Win Machine w/ IIS? | jimbo | Web Design and Webmaster Issues | 0 | 07-28-2000 03:44 PM |
![]()