Re: Slow response in MY SQL 5.5.1.8

[Amila Kumara]

* there are lots of queries running and every things are "slow"

* Your MySQL connection id is 322
Server version: 5.5.18 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW VARIABLES LIKE '%buffer%';
+------------------------------+------------+
| Variable_name | Value |
+------------------------------+------------+
| bulk_insert_buffer_size | 8388608 |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_size | 2147483648 |
| innodb_change_buffering | all |
| innodb_log_buffer_size | 8388608 |
| join_buffer_size | 4194304 |
| key_buffer_size | 3229614080 |
| myisam_sort_buffer_size | 268435456 |
| net_buffer_length | 16384 |
| preload_buffer_size | 32768 |
| read_buffer_size | 4194304 |
| read_rnd_buffer_size | 8388608 |
| sort_buffer_size | 4194304 |
| sql_buffer_result | OFF |
+------------------------------+------------+
14 rows in set (0.00 sec)


* Server RAM - 16GB
* login query is also included in the slow query log

thanks,