From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <mike@fly.osdn.org.ua>
X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on sa.int.altlinux.org
X-Spam-Level: 
X-Spam-Status: No, score=-1.3 required=5.0 tests=AWL,BAYES_00,
	DNS_FROM_OPENWHOIS autolearn=no version=3.2.5
Date: Mon, 17 May 2010 10:40:44 +0300
From: Michael Shigorin <mike@osdn.org.ua>
To: ALT Linux Community general discussions <community@lists.altlinux.org>
Message-ID: <20100517074044.GK21701@osdn.org.ua>
Mail-Followup-To: ALT Linux Community general discussions
	<community@lists.altlinux.org>
References: <201004081818.54957.zerg@altlinux.org>
	<201004221328.23188.a_s_y@sama.ru>
	<201004221600.38786.cas@altlinux.ru>
	<201004221625.51404.zerg@altlinux.org>
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="XF85m9dhOBO43t/C"
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <201004221625.51404.zerg@altlinux.org>
User-Agent: Mutt/1.4.2.1i
Subject: [Comm] =?koi8-r?b?bG93IG1lbW9yeSBteXNxbCBzZXR1cCAod2FzOiBLREUt?=
	=?koi8-r?b?NC40IMTM0SA1LjEp?=
X-BeenThere: community@lists.altlinux.org
X-Mailman-Version: 2.1.12
Precedence: list
Reply-To: shigorin@gmail.com, ALT Linux Community general discussions
	<community@lists.altlinux.org>
List-Id: ALT Linux Community general discussions <community.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/options/community>,
	<mailto:community-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/community>
List-Post: <mailto:community@lists.altlinux.org>
List-Help: <mailto:community-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Mon, 17 May 2010 07:40:48 -0000
Archived-At: <http://lore.altlinux.org/community/20100517074044.GK21701@osdn.org.ua/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>


--XF85m9dhOBO43t/C
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
Content-Transfer-Encoding: 8bit

On Thu, Apr 22, 2010 at 04:25:51PM +0400, Sergey V Turchin wrote:
> Потребление пямяти несколько увеличилось из-за mysql

Кстати, ему аппетит можно и приубавить (attached).
Либо собрать отдельный левый микро-mysql и его заточить.

-- 
 ---- WBR, Michael Shigorin <mike@altlinux.ru>
  ------ Linux.Kiev http://www.linux.kiev.ua/

--XF85m9dhOBO43t/C
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename="my-micro.cnf"

[mysqld]
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# FIXME! bdb maybe work on x86/Linux and amd64/Linux
#skip-bdb
#bind-address = 127.0.0.1 
chroot=/var/lib/mysql
datadir=/db
bdb-logdir=/log
#log=/log/queries
pid-file=/mysqld.pid
skip-locking
skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql

## http://paragasu.wordpress.com/2008/12/02/very-low-memory-mysql-5-mycnf-configuration/
# Set internal buffers, caches and stacks very low
key_buffer = 16K
max_allowed_packet = 800K
table_cache = 1
sort_buffer_size = 16K
read_buffer_size = 16K
read_rnd_buffer_size = 1K
net_buffer_length = 1K
thread_stack = 16K

# Skip Berkley and Inno DB types
skip-bdb
skip-innodb

skip-networking
server-id = 1

# Set the query cache low
query_cache_limit = 1048576
query_cache_size = 1048576
query_cache_type = 1

# Set various memory limits very low, disable memory-hogging extras
[mysqldump]
quick
max_allowed_packet = 16K

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 16K
sort_buffer_size = 16K

[myisamchk]
key_buffer = 16K
sort_buffer_size = 16K

[mysqlhotcopy]
interactive-timeout

--XF85m9dhOBO43t/C--