No. i not add host, but maybe add graphs in hosts
after chmod777 all tree is display.
And second problem:
i have 6gb ram and 4 core(vm machine). mysql use 350-390% CPU.
poller run 30-40 seconds every minute. But after 6-12 hours spine works 50-70 seconds and stop by timeout. when i restart mysql all work fine... but 8-10 hours
normal poller run
07/20/2011 03:18:31 PM - SYSTEM STATS: Time:28.8557 Method:spine Processes:6 Threads:8 Hosts:656 HostsPerProcess:110 DataSources:13084 RRDsProcessed:0
i use boost
tech info
Current Boost Status
Boost On Demand Updating: Running
Total Data Sources: 13087
Total Boost Records: 234347
Boost Storage Statistics
Database Engine: MEMORY
Current Boost Table Size: 42 MBytes
Avg Bytes/Record: 132 Bytes
Max Record Length: 100 Bytes
Max Allowed Boost Table Size: 2 GBytes
Estimated Maximum Records: 14005328 Records
Runtime Statistics
Last Start Time: 2011-07-20 15:21:36
Last Run Duration: 4 minutes 58 seconds (17% of update frequency)
RRD Updates: 308777
Peak Poller Memory: 97.5 MBytes
Detailed Runtime Timers: RRDUpdates:308777 TotalTime:298.1069 range_local_data_id:0.81 rcaston_add:5.56 get_records:22.57 results_cycle:253.96 rrd_path:93.74 rrd_template:116.91 rrd_lastupdate:4.6 rrd_field_names:12.13 rrdupdate:13.14 delete:10.65
Max Poller Memory Allowed: 1536 MBytes
Run Time Configuration
Update Frequency: 30 Minutes
Next Start Time: 2011-07-20 15:50:38
Maximum Records: 300000 Records
Maximum Allowed Runtime: 20 Minutes
Boost Server Details
Server Config Status: Disabled
Multiprocess Server: Multiple Process
Update Timeout: 2 Seconds
Server/Port: localhost@9050
Authorized Update Web Servers: 127.0.0.1
RRDtool Binary Used: /usr/bin/rrdtool
Image Caching
Image Caching Status: Disabled
Cache Directory:
Cached Files: WARNING: N/A
Cached Files Size: WARNING: Directory Does NOT Exist!!
mysql config
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
max_heap_table_size = 3G
max_allowed_packet=32MB
key_buffer=1024MB
set-variable = max_connections=500
#set-variable = max_user_connections = 300
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
set-varialbe = max_allowed_packet=16M
[isamchk]
set-varialbe = key_buffer = 512M
set-varialbe = sort_buffer = 512M
set-varialbe = read_buffer = 4M
set-variale - write_buffer = 4M
top info
top - 15:24:14 up 17:14, 2 users, load average: 21.50, 23.91, 23.84
Tasks: 170 total, 1 running, 169 sleeping, 0 stopped, 0 zombie
Cpu0 : 59.4%us, 36.0%sy, 0.0%ni, 4.0%id, 0.0%wa, 0.0%hi, 0.7%si, 0.0%st
Cpu1 : 59.8%us, 36.5%sy, 0.0%ni, 3.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 57.0%us, 38.0%sy, 0.0%ni, 4.6%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Cpu3 : 58.6%us, 36.8%sy, 0.0%ni, 4.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 6126156k total, 3489848k used, 2636308k free, 98344k buffers
Swap: 1023992k total, 2268k used, 1021724k free, 1815260k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14889 mysql 20 0 3345m 361m 6364 S 344.5 6.0 569:56.07 mysqld
31307 apache 20 0 172m 20m 7116 S 7.6 0.4 0:00.23 php
31425 apache 20 0 172m 20m 7092 S 6.6 0.4 0:00.20 php
30647 apache 20 0 183m 31m 7160 S 6.3 0.5 0:00.78 php
29157 apache 20 0 172m 21m 7376 S 0.7 0.4 0:00.34 php
30655 apache 20 0 620m 11m 2664 S 0.7 0.2 0:00.25 spine
30670 apache 20 0 606m 9724 2664 S 0.7 0.2 0:00.18 spine
21807 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.84 php
21812 apache 20 0 173m 21m 7396 S 0.3 0.4 0:00.77 php
23267 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.72 php
23269 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.70 php
24725 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.62 php
24729 apache 20 0 173m 21m 7396 S 0.3 0.4 0:00.63 php
26169 apache 20 0 263m 112m 7284 S 0.3 1.9 0:23.39 php
26177 apache 20 0 56552 1880 1520 S 0.3 0.0 0:03.33 rrdtool
26181 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.54 php
26185 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.55 php
26189 apache 20 0 173m 21m 7396 S 0.3 0.4 0:00.52 php
27651 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.43 php
27656 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.46 php
29163 apache 20 0 172m 21m 7396 S 0.3 0.4 0:00.34 php
30620 root 20 0 14932 1316 944 R 0.3 0.0 0:00.12 top
30627 apache 20 0 172m 21m 7376 S 0.3 0.4 0:00.23 php
30659 apache 20 0 656m 7932 2676 S 0.3 0.1 0:00.16 spine
30676 apache 20 0 616m 10m 2664 S 0.3 0.2 0:00.20 spine
1 root 20 0 19112 596 420 S 0.0 0.0 0:05.65 init
processlist in mysql
mysql> SHOW FULL PROCESSLIST;
+--------+-------+-----------+-------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-------+-----------+-------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 701 | cacti | localhost | cacti | Sleep | 3189 | | NULL |
| 702 | cacti | localhost | cacti | Sleep | 3209 | | NULL |
| 703 | cacti | localhost | cacti | Sleep | 3196 | | NULL |
| 707 | cacti | localhost | cacti | Sleep | 3203 | | NULL |
| 721 | cacti | localhost | cacti | Sleep | 3208 | | NULL |
| 722 | cacti | localhost | cacti | Sleep | 3199 | | NULL |
| 723 | cacti | localhost | cacti | Sleep | 3207 | | NULL |
| 724 | cacti | localhost | cacti | Sleep | 3207 | | NULL |
| 725 | cacti | localhost | cacti | Sleep | 3209 | | NULL |
| 726 | cacti | localhost | cacti | Sleep | 3303 | | NULL |
| 727 | cacti | localhost | cacti | Sleep | 3908 | | NULL |
| 728 | cacti | localhost | cacti | Sleep | 3908 | | NULL |
| 170174 | cacti | localhost | cacti | Sleep | 2 | | NULL |
| 170175 | cacti | localhost | cacti | Query | 0 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='699' |
| 170176 | cacti | localhost | cacti | Query | 3 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='454' |
| 170177 | cacti | localhost | cacti | Query | 0 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='742' |
| 170178 | cacti | localhost | cacti | Query | 2 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='558' |
| 170180 | cacti | localhost | cacti | Sleep | 397 | | NULL |
| 170181 | cacti | localhost | cacti | Sleep | 397 | | NULL |
| 170182 | cacti | localhost | cacti | Sleep | 397 | | NULL |
| 170183 | cacti | localhost | cacti | Sleep | 397 | | NULL |
| 170184 | cacti | localhost | cacti | Sleep | 397 | | NULL |
| 170889 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='423' |
| 170890 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='537' |
| 170891 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='718' |
| 170892 | cacti | localhost | cacti | Query | 0 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='637' |
| 170893 | cacti | localhost | cacti | Query | 2 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='307' |
| 170895 | cacti | localhost | cacti | Sleep | 341 | | NULL |
| 170896 | cacti | localhost | cacti | Sleep | 340 | | NULL |
| 170897 | cacti | localhost | cacti | Sleep | 340 | | NULL |
| 170898 | cacti | localhost | cacti | Sleep | 340 | | NULL |
| 170899 | cacti | localhost | cacti | Sleep | 340 | | NULL |
| 171604 | cacti | localhost | cacti | Query | 0 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='653' |
| 171605 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='401' |
| 171606 | cacti | localhost | cacti | Query | 3 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='288' |
| 171607 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='616' |
| 171608 | cacti | localhost | cacti | Query | 3 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='515' |
| 171610 | cacti | localhost | cacti | Sleep | 282 | | NULL |
| 171611 | cacti | localhost | cacti | Sleep | 282 | | NULL |
| 171612 | cacti | localhost | cacti | Sleep | 282 | | NULL |
| 171613 | cacti | localhost | cacti | Sleep | 282 | | NULL |
| 171614 | cacti | localhost | cacti | Sleep | 282 | | NULL |
| 172319 | cacti | localhost | cacti | Query | 3 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='229' |
| 172320 | cacti | localhost | cacti | Query | 0 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='268' |
| 172321 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='368' |
| 172322 | cacti | localhost | cacti | Query | 3 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='585' |
| 172323 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='495' |
| 172324 | cacti | localhost | cacti | Sleep | 211 | | NULL |
| 172326 | cacti | localhost | cacti | Sleep | 211 | | NULL |
| 172327 | cacti | localhost | cacti | Sleep | 210 | | NULL |
| 172328 | cacti | localhost | cacti | Sleep | 210 | | NULL |
| 172329 | cacti | localhost | cacti | Sleep | 210 | | NULL |
| 173034 | cacti | localhost | cacti | Query | 2 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='208' |
| 173035 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='468' |
| 173036 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='251' |
| 173037 | cacti | localhost | cacti | Query | 2 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='352' |
| 173038 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='566' |
| 173040 | cacti | localhost | cacti | Sleep | 164 | | NULL |
| 173041 | cacti | localhost | cacti | Sleep | 164 | | NULL |
| 173042 | cacti | localhost | cacti | Sleep | 164 | | NULL |
| 173043 | cacti | localhost | cacti | Sleep | 164 | | NULL |
| 173045 | cacti | localhost | cacti | Sleep | 163 | | NULL |
| 173745 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |
| 173750 | cacti | localhost | cacti | Query | 2 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='330' |
| 173751 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='126' |
| 173752 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='152' |
| 173753 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='146' |
| 173755 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='139' |
| 173756 | cacti | localhost | cacti | Sleep | 96 | | NULL |
| 173757 | cacti | localhost | cacti | Sleep | 95 | | NULL |
| 173758 | cacti | localhost | cacti | Sleep | 95 | | NULL |
| 173759 | cacti | localhost | cacti | Sleep | 95 | | NULL |
| 173760 | cacti | localhost | cacti | Sleep | 95 | | NULL |
| 174465 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='93' |
| 174466 | cacti | localhost | cacti | Query | 2 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='108' |
| 174467 | cacti | localhost | cacti | Query | 0 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='83' |
| 174468 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='53' |
| 174469 | cacti | localhost | cacti | Query | 1 | Sending data | SELECT * FROM data_input_data, data_template_data, data_template, data_local WHERE data_template.name like '%Running Process Info%' and data_input_data.data_input_field_id='13' and data_template_data.id=data_input_data.data_template_data_id and data_template.id=data_template_data.data_template_id AND data_local.id=data_template_data.local_data_id and data_local.host_id='73' |
| 174471 | cacti | localhost | cacti | Sleep | 44 | | NULL |
| 174472 | cacti | localhost | cacti | Sleep | 43 | | NULL |
| 174473 | cacti | localhost | cacti | Sleep | 43 | | NULL |
| 174474 | cacti | localhost | cacti | Sleep | 43 | | NULL |
| 174475 | cacti | localhost | cacti | Sleep | 43 | | NULL |
| 174477 | cacti | localhost | cacti | Sleep | 0 | | NULL |
+--------+-------+-----------+-------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
84 rows in set (0.00 sec)
myphpadmin Runtime Information
Query statistics: Since its startup, 243,050 queries have been sent to the server.
Total ø per hour ø per minute ø per second
243 k 1.50 M 25.01 k 416.90
Query type ø per hour %
admin commands 2 12.35 0.00%
assign to keycache 0 0.00 0.00%
alter db 0 0.00 0.00%
alter db upgrade 0 0.00 0.00%
alter event 0 0.00 0.00%
alter function 0 0.00 0.00%
alter procedure 0 0.00 0.00%
alter server 0 0.00 0.00%
alter table 0 0.00 0.00%
alter tablespace 0 0.00 0.00%
analyze 0 0.00 0.00%
backup table 0 0.00 0.00%
begin 0 0.00 0.00%
binlog 0 0.00 0.00%
call procedure 0 0.00 0.00%
change db 240 1,481.99 0.10%
change master 0 0.00 0.00%
check 0 0.00 0.00%
checksum 0 0.00 0.00%
commit 0 0.00 0.00%
create db 0 0.00 0.00%
create event 0 0.00 0.00%
create function 0 0.00 0.00%
create index 0 0.00 0.00%
create procedure 0 0.00 0.00%
create server 0 0.00 0.00%
create table 0 0.00 0.00%
create trigger 0 0.00 0.00%
create udf 0 0.00 0.00%
create user 0 0.00 0.00%
create view 0 0.00 0.00%
delete 134 k 826.30 k 56.56%
delete multi 0 0.00 0.00%
do 0 0.00 0.00%
drop db 0 0.00 0.00%
drop event 0 0.00 0.00%
drop function 0 0.00 0.00%
drop index 0 0.00 0.00%
drop procedure 0 0.00 0.00%
drop server 0 0.00 0.00%
drop table 0 0.00 0.00%
drop trigger 0 0.00 0.00%
drop user 0 0.00 0.00%
drop view 0 0.00 0.00%
empty query 0 0.00 0.00%
flush 0 0.00 0.00%
grant 0 0.00 0.00%
ha close 0 0.00 0.00%
ha open 0 0.00 0.00%
ha read 0 0.00 0.00%
help 0 0.00 0.00%
insert 10 k 63.97 k 4.38%
insert select 63 389.02 0.03%
install plugin 0 0.00 0.00%
kill 0 0.00 0.00%
load 0 0.00 0.00%
load master data 0 0.00 0.00%
load master table 0 0.00 0.00%
lock tables 0 0.00 0.00%
optimize 0 0.00 0.00%
preload keys 0 0.00 0.00%
purge 0 0.00 0.00%
purge before date 0 0.00 0.00%
release savepoint 0 0.00 0.00%
rename table 0 0.00 0.00%
rename user 0 0.00 0.00%
repair 0 0.00 0.00%
replace 136 839.79 0.06%
replace select 0 0.00 0.00%
reset 0 0.00 0.00%
Query type ø per hour %
restore table 0 0.00 0.00%
revoke 0 0.00 0.00%
revoke all 0 0.00 0.00%
rollback 0 0.00 0.00%
rollback to savepoint 0 0.00 0.00%
savepoint 0 0.00 0.00%
select 62 k 383.46 k 26.25%
set option 189 1,167.07 0.08%
show authors 0 0.00 0.00%
show binlog events 0 0.00 0.00%
show binlogs 6 37.05 0.00%
show charsets 7 43.22 0.00%
show collations 7 43.22 0.00%
show column types 0 0.00 0.00%
show contributors 0 0.00 0.00%
show create db 0 0.00 0.00%
show create event 0 0.00 0.00%
show create func 0 0.00 0.00%
show create proc 0 0.00 0.00%
show create table 9 55.57 0.00%
show create trigger 0 0.00 0.00%
show databases 7 43.22 0.00%
show engine logs 0 0.00 0.00%
show engine mutex 0 0.00 0.00%
show engine status 153 944.77 0.06%
show events 0 0.00 0.00%
show errors 0 0.00 0.00%
show fields 132 815.09 0.06%
show function status 0 0.00 0.00%
show grants 3 18.52 0.00%
show keys 0 0.00 0.00%
show master status 0 0.00 0.00%
show new master 0 0.00 0.00%
show open tables 0 0.00 0.00%
show plugins 0 0.00 0.00%
show privileges 0 0.00 0.00%
show procedure status 0 0.00 0.00%
show processlist 257 1,586.96 0.11%
show profile 0 0.00 0.00%
show profiles 0 0.00 0.00%
show slave hosts 0 0.00 0.00%
show slave status 153 944.77 0.06%
show status 258 1,593.14 0.11%
show storage engines 0 0.00 0.00%
show table status 11 67.92 0.00%
show tables 16 98.80 0.01%
show triggers 0 0.00 0.00%
show variables 233 1,438.77 0.10%
show warnings 0 0.00 0.00%
slave start 0 0.00 0.00%
slave stop 0 0.00 0.00%
stmt close 0 0.00 0.00%
stmt execute 0 0.00 0.00%
stmt fetch 0 0.00 0.00%
stmt prepare 0 0.00 0.00%
stmt reprepare 0 0.00 0.00%
stmt reset 0 0.00 0.00%
stmt send long data 0 0.00 0.00%
truncate 18 111.15 0.01%
uninstall plugin 0 0.00 0.00%
unlock tables 0 0.00 0.00%
update 28 k 175.83 k 12.03%
update multi 0 0.00 0.00%
xa commit 0 0.00 0.00%
xa end 0 0.00 0.00%
xa prepare 0 0.00 0.00%
xa recover 0 0.00 0.00%
xa rollback 0 0.00 0.00%
xa start 0 0.00 0.00%
top process:
delete 134 k 826.30 k 56.56%
select 62 k 383.46 k 26.25%
update 28 k 175.83 k 12.03%
insert 10 k 63.97 k 4.38%
What delete mysql?
