Announcement

Collapse
No announcement yet.

Missing mysql index

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Missing mysql index

    1097657 xxx xxx xxx 603 Query DELETE FROM searchlog WHERE `dateline` < 1442020702 /**searchlog**/

    Ridiculously long query time. Is there a reason there is no index on the dateline column in the searchlog table? The query currently does not use an index at all.

  • #2
    On top of that is there any reason why searchlog.ibd is 11G and cache.ibg is 8.9G ? They are huge files.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X