I am not sure, but if its a MyISAM table, it should be ordered by the
records insertion order, and in case of InnoDB it should be ordered by the
clustered index, not necessarily it should be a defined one.
On Thu, Dec 13, 2012 at 12:58 PM, jiangwen jiang wrote:
> hi, all:
>
> There's a confusion
When I wrote my comment after Larry Martell s problem, I already suspected it
was somewhat out of place because to his problem it did not apply.
2012/12/12 08:25 -0500, Shawn Green
This is a perfectly acceptable naming convention to use. For example if you
have a field on the `art` tab
On Tue, Dec 11, 2012 at 7:22 PM, wrote:
> 2012/12/11 16:19 -0500, Larry Martell
> I have this query:
>
> SELECT data_target.name, ep, wafer_id, lot_id,
>date_time, data_file_id, data_cstimage.name,
>bottom, wf_file_path_id, data_measparams.name,
>vacc, data_catego
On Tue, Dec 11, 2012 at 8:48 PM, Peter Brawley
wrote:
>>ERROR 1054 (42S22): Unknown column 'data_tool.category_id' in 'on clause'
>>But category_id is a column in data_tool.
>
> Then a bit of reordering is required ...
>
> SELECT data_target.name, ep, wafer_id, lot_id,
>date_time, data_fil
On Wed, Dec 12, 2012 at 8:25 AM, Shawn Green wrote:
> On 12/11/2012 7:22 PM, h...@tbbs.net wrote:
>>
>> ... (Are all the distinct "id"s really needed? When one joins on a
>>
>> field with the same name in both tables, one may use 'USING', and
>> only the common field, with neither NULL, shows up i
Hello,
Just for the record, I found the problem and overcome the contention.
The key was: innodb_thread_concurrency
Quoting the documentation:
"innodb_thread_concurrency is the variable that limits the number of
operating system threads that can run concurrently inside the InnoDB
engine. Rest of
On 12/11/2012 7:22 PM, h...@tbbs.net wrote:
... (Are all the distinct "id"s really needed? When one joins on a
field with the same name in both tables, one may use 'USING', and
only the common field, with neither NULL, shows up in the output.)
This is a perfectly acceptable naming convention t
Hey you lot,
I'm currently being brainwashed with Oracle internals, so to keep a semblance
of sanity I'm throwing this out here :-)
I'd just like to thank the nice Percona people for successfully throwing
together the second edition of Percona Live London. It was, if anything, even
more inte
