Re: Utilize maximum system resources for better performance

[Ronald Brown]

Rick James Wrote:
-------------------------------------------------------
QC is still disabled.
set
key_buffer_size = 500M

> > SELECT * FROM content WHERE enabled = 1 ORDER BY
> seeders DESC , upload_date DESC LIMIT 0,25
>
> Needs INDEX(enabled, seeders, upload_date)

added index and now result queries are fast, but count query is slow,

need to implement the new table which will hold the only counts.
is QC that bad ?

> Three things _could_ be happening; which ones
> apply?
> * New rows are being loaded
> * Existing rows are being updated with changed
> values
> * Some existing rows need to be deleted.
>
> Assuming you only need to deal with "new" and
> "changed" rows, see my 'Answer' (just now posted)
> to that stackoverflow thread.

only new rows are inserted and updated existing rows, none rows are getting deleted.

what about

mysqli_autocommit($con,FALSE);
update rows,
mysqli_commit($con);

and it took 19.xx minutes for complete 6.5 mil updates while QC disabled.
and 21.xx minutes when QC enabled.

but is this vaible option ? disabling autocomit and updating on live site ?

Thanks for your time.