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,