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.