Re: Sending data in processlist
Posted by:
Rick James
Date: December 20, 2014 10:18AM
int(2) is not what you think. It takes 4 bytes and the "(2)" is ignored. Perhaps you want TINYINT UNSIGNED, which takes only 1 byte.
All the fields, except for pk_id, are NULL. Perhaps many should be NOT NULL?
INDEX(a), INDEX(b) is not the same as INDEX(a,b) -- and often not as good. You could try INDEX(observedstate, powercost), but I doubt if it would help much.
Did you try my reformulation?
Subject
Written By
Posted
December 19, 2014 07:55AM
December 19, 2014 03:07PM
December 20, 2014 12:03AM
December 20, 2014 05:33AM
Re: Sending data in processlist
December 20, 2014 10:18AM
December 26, 2014 02:23AM
December 26, 2014 11:56AM
December 29, 2014 02:59AM
December 29, 2014 01:16PM
December 30, 2014 07:02AM
December 30, 2014 02:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.