Update about 1 million rows in MySQL table every 1 hour

Update about 1 million rows in MySQL table every 1 hour

php_rocs
Administrator
Posts: 1,392
Threads: 79
Joined: Jun 2016
Reputation: 72

07-22-2020, 07:09 AM

@olegrain,

As a suggestion, you might want to consider what your database configurations are set to and whether or not you may need more memory/space. Also, you might want to verify that your update query is efficient. You might need to do some database maintenance as well.

Messages In This Thread

Update about 1 million rows in MySQL table every 1 hour - by olegrain - 07-21-2020, 01:20 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by jreklund - 07-21-2020, 06:59 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by olegrain - 07-21-2020, 07:27 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by ChicagoPhil - 07-22-2020, 01:01 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by jreklund - 07-21-2020, 08:35 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by php_rocs - 07-22-2020, 07:09 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by John_Betong - 07-22-2020, 08:39 PM