Details
-
Improvement
-
Resolution: Fixed
-
Minor
-
None
-
None
Description
SQL Indexes
ALTER TABLE `vlans_fdb` ADD INDEX ( `port_id` ) ;
|
ALTER TABLE `device_graphs` ADD INDEX ( `graph` ) ;
|
ALTER TABLE `wifi_sessions` ADD INDEX ( `device_id` ) ;
|
ALTER TABLE `eigrp_ports` ADD INDEX ( `device_id` ) ;
|
ALTER TABLE `devices` ADD INDEX `disabled_lastpolled` (`disabled`,`last_polled_timetaken`);
|
Collation changes;
from latin1_general_ci;
alter table `processors-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `sensors-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `ucd_diskio-state` convert to character set utf8 collate utf8_unicode_ci;
|
from latin_swedish_ci;
alter table `accesspoints-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `bgpPeers-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `bgpPeers_cbgp-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `mac_accounting-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `ports-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `wifi_accesspoints-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `wifi_radios-state` convert to character set utf8 collate utf8_unicode_ci;
|
alter table `wifi_sessions-state` convert to character set utf8 collate utf8_unicode_ci;
|
Also attached is a patch for cache-data page. We have to force index on this query because of the order by.
Attachments
Activity
| Workflow | Original: classic default workflow [ 12067 ] | New: Observium workflow [ 14416 ] |
| Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
| Assignee | Original: Adam Armstrong [ adama ] | New: Mike Stupalov [ landy ] |
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Open [ 1 ] | New: Resolved [ 5 ] |
Fixed in r6255.
Note, all *-state (MEMORY) not required any collations, because use only numeric data.
Also in other tables if not really used non-latin data, general_ci prefered.