|Webmaster Forum Rules | Posting Guide | Contact Us | Testimonials | Contributing Geek Program | Advertise on Geek/Talk|
||Thread Tools||Display Modes|
|03-31-2005, 07:44 AM||#1|
Join Date: Mar 2005
MySQL InnoDB set up
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:
# 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
How do I know if this is the ideal configuration for my server?
|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 02:30 AM|
|Tip for heavy MySQL users: CREATE INDEX||demae||Web Hosting Discussion||4||05-15-2001 05:32 PM|
|vBullletin - Corrupted MySQL records!||Steve_S||Web Design and Webmaster Issues||5||02-07-2001 12:44 AM|
|mysql overload?||notibrian||Web Design and Webmaster Issues||0||02-01-2001 09:03 PM|
|Anyone Ever Set Up MySQL on a Win Machine w/ IIS?||jimbo||Web Design and Webmaster Issues||0||07-28-2000 04:44 PM|