But those are not memory tables...
On 12/16/2014 02:36 PM, Eduardo Schoedler wrote:
All these? ;)
mysql> SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM columns WHERE DATA_TYPE IN ('text', 'blob') AND TABLE_SCHEMA = 'observium'; +--------------+------------------+-----------------------+-----------+ | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | DATA_TYPE | +--------------+------------------+-----------------------+-----------+ | observium | alert_assoc | device_attribs | text | | observium | alert_assoc | entity_attribs | text | | observium | alert_log | message | text | | observium | alert_tests | alert_message | text | | observium | alert_tests | conditions | text | | observium | alerts | message | text | | observium | authlog | user | text | | observium | authlog | address | text | | observium | authlog | result | text | | observium | bgpPeers | bgpPeerState | text | | observium | bgpPeers | bgpPeerAdminStatus | text | | observium | bill_history | bill_type | text | | observium | bills | bill_name | text | | observium | bills | bill_type | text | | observium | config | config_value | text | | observium | devices | sysDescr | text | | observium | devices | sysContact | text | | observium | devices | version | text | | observium | devices | hardware | text | | observium | devices | features | text | | observium | devices | location | text | | observium | devices | device_state | text | | observium | devices_attribs | attrib_value | text | | observium | eigrp_ports | eigrp_authmode | text | | observium | entPhysical | entPhysicalDescr | text | | observium | entPhysical | entPhysicalClass | text | | observium | entPhysical | entPhysicalName | text | | observium | entPhysical | entPhysicalModelName | text | | observium | entPhysical | entPhysicalVendorType | text | | observium | entPhysical | entPhysicalSerialNum | text | | observium | entPhysical | entPhysicalMfgName | text | | observium | eventlog | message | text | | observium | groups_assoc | device_attribs | text | | observium | groups_assoc | entity_attribs | text | | observium | hrDevice | hrDeviceDescr | text | | observium | hrDevice | hrDeviceType | text | | observium | hrDevice | hrDeviceStatus | text | | observium | munin_plugins | mplug_info | text | | observium | munin_plugins_ds | ds_extinfo | text | | observium | munin_plugins_ds | ds_sum | text | | observium | munin_plugins_ds | ds_stack | text | | observium | services | service_ip | text | | observium | services | service_desc | text | | observium | services | service_param | text | | observium | services | service_message | text | | observium | storage | storage_descr | text | | observium | syslog | msg | text | | observium | users | user_options | text | | observium | vrfs | mplsVpnVrfDescription | text | +--------------+------------------+-----------------------+-----------+ 49 rows in set (0.04 sec)
Regards!
2014-12-16 4:00 GMT-02:00 Adam Armstrong <adama@memetic.org mailto:adama@memetic.org>:
Which fields are those? :) ------ Original Message ------ From: "Eduardo Schoedler" <listas@esds.com.br <mailto:listas@esds.com.br>> To: "Observium Network Observation System" <observium@observium.org <mailto:observium@observium.org>> Sent: 12/12/2014 2:17:14 PM Subject: [Observium] TEXT/BLOB fields in MySQLHi, Any chance to change text/blob fields to another type in MySQL? # ./tuning-primer.sh TEMP TABLES Current max_heap_table_size = 512 M Current tmp_table_size = 512 M Of 17956 temp tables, 29% were created on disk Perhaps you should increase your tmp_table_size and/or max_heap_table_size to reduce the number of disk-based temporary tables *Note! BLOB and TEXT columns are not allow in memory tables. If you are using these columns raising these values might not impact your ratio of on disk temp tables. * Thanks. -- Eduardo Schoedler_______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium-- Eduardo Schoedler
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium