MySQL Forums
Forum List  »  General

Re: mysql max_connections
Posted by: Irfan Ali
Date: December 20, 2009 11:39PM

Hi,

i tried to increase key_buffer_size from 4GB to 6GB and i done it without any problem.

Server version: 5.0.85-community MySQL Community Edition (GPL)
mysql> show variables like '%key_buffer%';
+-----------------+------------+
| Variable_name | Value |
+-----------------+------------+
| key_buffer_size | 4294967296 |
+-----------------+------------+
1 row in set (0.00 sec)

mysql> SET GLOBAL key_buffer_size=6442450944;
Query OK, 0 rows affected (0.54 sec)

mysql> show variables like '%max_conn%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_connect_errors | 10 |
| max_connections | 200 |
+--------------------+-------+
2 rows in set (0.00 sec)


But when i tried to increase key_buffer_size on mysql 5.1.32 it fails and truncates value to 4GB. Can you please help me out that why this happening on mysql 5.1.

Server version: 5.1.32-community MySQL Community Server (GPL)

mysql> show variables like '%key_buffer%';
+-----------------+------------+
| Variable_name | Value |
+-----------------+------------+
| key_buffer_size | 4294967296 |
+-----------------+------------+
1 row in set (0.00 sec)

mysql> show variables like '%max_conn%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_connect_errors | 10 |
| max_connections | 200 |
+--------------------+-------+
2 rows in set (0.00 sec)

mysql> SET GLOBAL key_buffer_size=6442450944;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+---------------------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------------------+
| Warning | 1292 | Truncated incorrect key_buffer_size value: '6442450944' |
+---------+------+---------------------------------------------------------+
1 row in set (0.00 sec)


Furthermore, can someone please answer to following thread as well.

http://forums.mysql.com/read.php?24,281390,281390#msg-281390

Thanks,

Options: ReplyQuote


Subject
Written By
Posted
December 11, 2009 01:26AM
December 12, 2009 03:56PM
December 16, 2009 11:59PM
December 17, 2009 12:39AM
Re: mysql max_connections
December 20, 2009 11:39PM
December 22, 2009 12:37AM
December 24, 2009 02:01PM
December 25, 2009 12:49AM
December 25, 2009 03:30AM
December 25, 2009 03:49AM
December 25, 2009 11:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.