Webmaster Forum Rules | Posting Guide | Contact Us | Testimonials | Contributing Geek Program | Advertise on Geek/Talk
Welcome to the GeekTalk Webmaster Discussion Forums from GeekVillage.com

Click Here To Register. It's Free!

Go Back   geek/talk: Signature-free discourse for serious web publishers > YOUR FOUNDATION: Web Hosting & Domains > Web Hosting Discussion
User Name
Password
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 03-31-2005, 07:44 AM   #1
ohcnetwork
Registered User
 
Join Date: Mar 2005
Posts: 19
Default 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:

[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?
ohcnetwork is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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

Please support our advertisers. They ensure our survival.

All times are GMT -5. The time now is 05:13 PM.


GeekVillage.com is copyright © 1998-2014 iOnline Web Design. All rights reserved.
Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.