-
Type:
Incident report
-
Resolution: Won't fix
-
Priority:
Trivial
-
None
-
Affects Version/s: None
-
Component/s: Installation (I)
-
None
Hello.
I run update script for mysql from Zabbix 1.8.5 to 2.0.0.
Now i have this:
| 11524 | root | localhost | zabbix | Query | 104780 | Sending data | INSERT INTO tmp_events_eventid (eventid,prev_value) |
Table have ~1,895,409 rows and 250 MB of data ind indexes. I think its too long more than 29 hours for updating so small table. I have history table with ~40,392,033 rows and i can't imagine how much time it will update... Now MySQL use 2G of innodb pool and 1 core of AMD Athlon(tm) II X2 250 Processor.