Optimize MariaDB/TokuDB MySQL table

CLOSED
Bids
4
Avg Bid (USD)
$181
Project Budget (USD)
$30 - $250

Project Description:
Hi, i have the following table,

how can i optimize speed for 100.000.000 rows when i do:

"SELECT COUNT(id) from adsDeliveries where _ad>0 and _campaign=1"

CREATE TABLE `adsDeliveries` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`_campaign` bigint(20) NOT NULL DEFAULT '0',
`_ad` bigint(20) NOT NULL,
`session` varchar(44) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
`timeCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`timeUpdated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `active` (`active`),
KEY `session` (`session`),
KEY `_ad` (`_ad`),
KEY `_campaign` (`_campaign`)
) ENGINE=TokuDB AUTO_INCREMENT=91348474 DEFAULT CHARSET=utf8;

This is just a DEMO Task to see your Skills!

Skills required:
MySQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 157
in 3 days
Hire kasune
$ 155
in 3 days
Hire gmuslera
$ 154
in 3 days
$ 257
in 15 days