MySQL Forums
Forum List  »  Performance

Re: Utilize maximum system resources for better performance
Posted by: Ronald Brown
Date: August 09, 2015 08:04PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Utilize maximum system resources for better performance
1130
August 09, 2015 08:04PM


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.