Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: API node auto restart, mysql-max segfault at ...

From: Stewart Smith <stewart(at)mysql.com>
Date: Sun Sep 23 2007 - 09:52:10 EDT


On Sat, 2007-09-08 at 20:23 +0700, Toan. Dang Anh wrote:
>
> API my.cnf config:
> skip-innodb
> skip-name-resolve
> skip-locking
> #improve performance
> ndb_force_send = 0
> ndb_use_exact_count = 0
>
> key_buffer_size = 512M
> max_allowed_packet=128M
> read_buffer_size=6M
> read_rnd_buffer_size=6M
> connect_timeout=25
> interactive_timeout=30
> wait_timeout=25
> init-connect='SET NAMES utf8'
> max_connections = 1024
> max_user_connections = 256
> max_connect_errors=128
> thread_concurrency=4
> ndbcluster

Some of these memory parameters are per-connection. So check that you're not in a situation where you could run out of memory.

-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@sip.us.mysql.com
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
Received on Sun Sep 23 09:52:35 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:15:14 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library