Closed

Optimize MariaDB/TokuDB MySQL table

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!

Skills: MySQL

See more: mariadb tokudb, optimize mysql, mysql create table, session task, bigint, create mysql table, create table mysql, session mysql, mysql optimize, count mysql, mysql charset, optimize mysql task, mysql table count, create table, mysql select table, mysql count, mysql speed, optimize mysql count, Optimize speed, parse html table mysql, php drop list values table mysql, loop throu table mysql php, desc table mysql, conver xml sql table mysql, update linked table mysql odbc

About the Employer:
( 20 reviews ) Braunau am Inn, Austria

Project ID: #4495717

3 freelancers are bidding on average $190 for this job

Mohsen6558

I can optimize your db. ready to start.

$157 USD in 3 days
(4 Reviews)
3.6
on2it

Hi, We at on2itonline would love to work with you on this, we do MAD "full service" websites on a clear and fixed budget. We have lots to offer that others don't ,like our lifetime FREE hosting on every website for a More

$257 USD in 15 days
(0 Reviews)
0.0
gmuslera

Have experience optimizing MySQL queries and databases, can help there.

$154 USD in 3 days
(0 Reviews)
0.0
kasune

I have message you.

$155 USD in 3 days
(0 Reviews)
0.0