svn commit: r763330 - /incubator/olio/webapp/rails/trunk/etc/my.cnf

[sh...@apache.org]

Author: shanti
Date: Wed Apr  8 17:45:44 2009
New Revision: 763330

URL: http://svn.apache.org/viewvc?rev=763330&view=rev
Log:
Adding sample my.cnf for rails app.

Added:
    incubator/olio/webapp/rails/trunk/etc/my.cnf

Added: incubator/olio/webapp/rails/trunk/etc/my.cnf
URL: http://svn.apache.org/viewvc/incubator/olio/webapp/rails/trunk/etc/my.cnf?rev=763330&view=auto
==============================================================================
--- incubator/olio/webapp/rails/trunk/etc/my.cnf (added)
+++ incubator/olio/webapp/rails/trunk/etc/my.cnf Wed Apr  8 17:45:44 2009
@@ -0,0 +1,52 @@
+#
+#  Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#     http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+# Sample my.cnf. This file is complete and can be used as is after
+# editing the data and log dirs.
+[client]
+port=3306
+socket=/tmp/mysql.sock
+
+[mysqld]
+back_log=1000
+# Tune max_connections based on expected load
+max_connections=10000
+set-variable=tmpdir=/var/tmp
+
+# Other tunables for performance
+#table_open_cache=2048
+thread_cache=40
+join_buffer_size = 8M
+
+default-storage-engine=innodb
+
+# innodb parameters 
+# change innodb_data_home_dir and innodb_log_group_home_dir depending on
+# where you're locating the database
+innodb_buffer_pool_size = 2G
+innodb_data_file_path = ibdata1:2000M;ibdata2:100M:autoextend
+innodb_log_file_size = 100M
+innodb_log_files_in_group = 3
+innodb_autoextend_increment = 100M
+innodb_doublewrite = 0
+innodb_flush_log_at_trx_commit = 2
+
+[isamchk]
+set-variable=key_buffer=12M
+
+[mysqldump]
+quick