# High CPU usage on database with UPDATE \`oc\_authtoken\`

**URL:** <https://help.nextcloud.com/t/high-cpu-usage-on-database-with-update-oc-authtoken/116438>\
**Category:** ℹ️ Support\
**Created:** [May 17, 2021, 2:40pm UTC](https://help.nextcloud.com/t/high-cpu-usage-on-database-with-update-oc-authtoken/116438 "2021-05-17T14:40:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mati24](https://help.nextcloud.com/user_avatar/help.nextcloud.com/mati24/32/38257_2.png) [@Mati24](https://help.nextcloud.com/u/Mati24)\
**Post date:** [May 17, 2021, 2:40pm UTC](https://help.nextcloud.com/t/high-cpu-usage-on-database-with-update-oc-authtoken/116438/1 "2021-05-17T14:40:34Z")

</div>

Hello,  
The MySQL server running my nextcloud db have a high CPU usage, there is constant request like this one:  
`UPDATE `oc_authtoken` SET `password` = 'xxx' WHERE `id` = yyy`  
There is around 10 requests in the same time which commit, updating (max 1sec time running each).  
I don’t have any errors in logs (nextcloud or nginx). Same problem after restart services  
If someone have an idea 🙂  
Thanks

**My config:**

Nextcloud version: 21.0.1.1  
Operating system and version: Debian 10  
nginx version: 1.20.0-1  
PHP version: 7.4.18-2  
mysql version: mysql Ver 15.1 Distrib 10.5.10-MariaDB,

```auto
<?php
$CONFIG = array (
  'updatechecker' => true,
  'instanceid' => 'xxxx',
  'passwordsalt' => 'xxxx',
  'secret' => 'xxxx',
  'trusted_domains' => 
  array (
    0 => 'mydomain',
    1 => '192.168.1.x',
  ),
  'datadirectory' => '/mnt/disk/nextcloud',
  'version' => '21.0.1.1',
  'dbtype' => 'mysql',
  'dbname' => 'nextcloud',
  'dbhost' => '192.168.1.x',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'nextcloud',
  'dbpassword' => 'xxx',
  'logtimezone' => 'Europe/Paris',
  'installed' => true,
  'default_language' => 'fr',
  'enable_previews' => true,
  'preview_max_x' => 1024,
  'preview_max_y' => 1024,
  'preview_max_scale_factor' => 1,
  'mail_smtpmode' => 'smtp',
  'mail_from_address' => 'cloud',
  'mail_domain' => 'xxx',
  'maintenance' => false,
  'overwriteprotocol' => 'https',
  'defaultapp' => 'files',
  'log_type' => 'file',
  'mail_smtpauthtype' => 'PLAIN',
  'filelocking.enabled' => true,
  'theme' => '',
  'mail_smtphost' => 'mail',
  'mail_smtpport' => '25',
  'overwrite.cli.url' => 'xxx',
  'loglevel' => 2,
  'logfile' => '/var/log/nextcloud.log',
  'mysql.utf8mb4' => true,
  'has_rebuilt_cache' => true,
  'trashbin_retention_obligation' => '30,60',
  'updater.release.channel' => 'stable',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => '/var/run/redis/redis.sock',
    'port' => 0,
  ),
  'app_install_overwrite' => 
  array (
    0 => 'files_external_onedrive',
  ),
  'trusted_proxies' => ['192.168.1.1'],
);

```

---

<div class="post-metadata">

**Author:** ![Mati24](https://help.nextcloud.com/user_avatar/help.nextcloud.com/mati24/32/38257_2.png) [@Mati24](https://help.nextcloud.com/u/Mati24)\
**Post date:** [May 20, 2021, 9:02am UTC](https://help.nextcloud.com/t/high-cpu-usage-on-database-with-update-oc-authtoken/116438/2 "2021-05-20T09:02:27Z")

</div>

Hello  
I suppose there was a migration or something like that, there is no more those requests.

---

<div class="post-metadata">

**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\
**Post date:** [December 13, 2024, 9:38am UTC](https://help.nextcloud.com/t/high-cpu-usage-on-database-with-update-oc-authtoken/116438/3 "2024-12-13T09:38:58Z")

</div>



---

<div class="post-metadata">

**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\
**Post date:** [December 13, 2024, 9:38am UTC](https://help.nextcloud.com/t/high-cpu-usage-on-database-with-update-oc-authtoken/116438/4 "2024-12-13T09:38:59Z")

</div>