Optimize MariaDB/TokuDB MySQL table
This project received 4 bids from talented freelancers with an average bid price of $181 USD.Get free quotes for a project like this
Hi, i have the following table,
how can i optimize speed for [url removed, login to view] 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!
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online