Closed

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
Employer working
Skills Required
Project Budget
N/A
Total Bids
4
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online