Advertisement
Guest User

bitcoin mining proxy DB additional indexes

a guest
Jun 24th, 2011
569
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.55 KB | None | 0 0
  1. ALTER TABLE  `work_data` ADD INDEX  `importantData` (  `worker_id` ,  `time_requested` ,  `pool_id` );
  2. ALTER TABLE  `work_data` ADD INDEX (  `time_requested` )
  3.  
  4. ALTER TABLE  `work_data` CHANGE  `worker_id`  `worker_id` SMALLINT( 4 ) NOT NULL;
  5. ALTER TABLE  `work_data` CHANGE  `pool_id`  `pool_id` TINYINT NOT NULL;
  6.  
  7.  
  8. ALTER TABLE  `submitted_work` ADD INDEX  `importantData` (  `worker_id` ,  `time` ,  `pool_id` );
  9. ALTER TABLE  `submitted_work` ADD INDEX (  `time` );
  10.  
  11.  
  12. ALTER TABLE  `submitted_work` ADD INDEX  `workerTime` (  `worker_id` ,  `time` );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement