MySQL Forums
Forum List  »  Performance

Re: Foreman query optimization
Posted by: Kyle Flavin
Date: November 06, 2015 11:58AM

The server has 64 GB of RAM. The buffer pool is set as follows:

innodb_buffer_pool_size = 45097156608

I tried adding an index on source_id on the logs side, but no luck:

Create Table: CREATE TABLE `logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source_id` int(11) DEFAULT NULL,
  `message_id` int(11) DEFAULT NULL,
  `report_id` int(11) DEFAULT NULL,
  `level_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_logs_on_report_id` (`report_id`),
  KEY `index_logs_on_message_id` (`message_id`),
  KEY `index_logs_on_level_id` (`level_id`),
  KEY `idx_source_id` (`source_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8729466 DEFAULT CHARSET=latin1

Options: ReplyQuote


Subject
Views
Written By
Posted
1750
November 05, 2015 04:15PM
712
November 05, 2015 05:42PM
765
November 05, 2015 06:54PM
687
November 05, 2015 11:19PM
Re: Foreman query optimization
781
November 06, 2015 11:58AM
703
November 06, 2015 12:35PM
677
November 06, 2015 06:44PM
775
November 26, 2015 08:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.