Re: Monitoring large resultsets
Lets look at memory buffers:
| tmp_table_size | 268435456 | #256M
| max_heap_table_size | 268435456 | #256M
| query_cache_size | 2147483648 | # 2G
Values are too high. 2G size for a query cache is too much. Similarly, tmp table size is high as well.
| Max_used_connections | 151 |
| back_log | 50 |
| Created_tmp_disk_tables | 12342 |
| Created_tmp_files | 60 |
| Created_tmp_tables | 13086 |
lots of disk temporary tables
| Bytes_received | 108989142 | # 103M
| Bytes_sent | 2072944949 | # 1.9G
A lot of data is sent but when I look at total number of questions is high (for 45 minutes uptime) so
>Questions: 774987
>Com_select | 195924 |
10k bytes sent per select and/or 721K bytes sent per second.
Edited 3 time(s). Last edit at 07/12/2012 04:18AM by Aftab Khan.
Subject
Views
Written By
Posted
2199
July 10, 2012 10:26PM
1202
July 11, 2012 02:01AM
1008
July 12, 2012 12:22AM
975
July 12, 2012 02:19AM
1099
July 12, 2012 03:06AM
1025
July 12, 2012 03:37AM
1024
July 12, 2012 03:51AM
Re: Monitoring large resultsets
1017
July 12, 2012 04:13AM
1001
July 12, 2012 05:35AM
1069
July 12, 2012 05:49AM
993
July 12, 2012 06:05AM
1209
July 12, 2012 07:02AM
975
July 12, 2012 04:41PM
1025
July 13, 2012 07:50PM
1016
July 14, 2012 02:43AM
978
July 12, 2012 08:13AM
988
July 12, 2012 08:55AM
1059
July 12, 2012 12: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.