Jump to content

My site is "choking"


Recommended Posts

Hello,
Every Saturday night, and sometimes in the middle of the week, my site is "choking" and working very slowly and sometimes crashes. When it happens, my server CPU shows 100 %.
What could be the reason for that? How can i debug it the next time it happens?

Edited by LiveG
Link to comment
Share on other sites

2 minutes ago, LiveG said:

It's possible this was caused by searching for posts by user. But it's hard to say for certain.

Seeing the fact that it happens on a certain time I highly doubt that that could be the case. To echo @teraßyteabove, do you have a backup cronjob/task that runs on those specific days?

If you check the logs in your admin panel or the server error log, is there any message logged in either place about the same time when the issue is happening?

Link to comment
Share on other sites

 don't have the full query, but here's the partial:
/suite::root::IPS\Content\Search\Mysql\_Query::filterForProfile:253/ SELECT COUNT(*) FROM

It was stuck for about 1400 seconds, in State: Repair with keycache

Edited by LiveG
Link to comment
Share on other sites

It happened today as well.

Looking at errors from today, the first error would be
Sat, 17 Dec 2022 15:59:08 +0000
Error: Call to undefined method stdClass::language() (0)
#0 /var/www/html/system/Dispatcher/Front.php(109): IPS\Dispatcher\_Standard->ini
t()
#1 /var/www/html/init.php(927) : eval()'d code(46): IPS\Dispatcher\_Front->init(
)
#2 /var/www/html/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\stickynot
es_hook_Outputs->init()
#3 /var/www/html/index.php(13): IPS\_Dispatcher::i()
#4 {main}
#0 /var/www/html/init.php(1029): IPS\_Log::log()
#1 [internal function]: IPS\IPS::exceptionHandler()
#2 {main}
This error is usually generated as a result of a database failure or query timeout

Edited by LiveG
Link to comment
Share on other sites

You would need to work with your hosting provider to investigate why your MySQL instance is not able to handle the query. A slow query log of what is happening would help determine what query this is related to. If your hosting provider determines that this is a software fault, we will require that slow query log and any other server errors logs associated.

Link to comment
Share on other sites

Do they have instructions on where to find it ( slow query log) ? I'm not sure if one is generated by default

am seeing a mysql errorlog
2022-12-17T15:59:08.347189Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2022-12-17T15:59:08.354720Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-0ubuntu0.20.04.1) starting as process 1071
2022-12-17T15:59:08.384870Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-12-17T15:59:09.506188Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-12-17T15:59:10.044286Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2022-12-17T15:59:10.065552Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2022-12-17T15:59:10.184684Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-12-17T15:59:10.184719Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-12-17T15:59:10.217439Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2022-12-17T15:59:10.217489Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.31-0ubuntu0.20.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2022-12-17T15:59:10.396884Z 8 [ERROR] [MY-013134] [Server] Table './suite/core_sessions' is marked as crashed and should be repaired
2022-12-17T15:59:10.405459Z 8 [Warning] [MY-010756] [Server] Checking table:   './suite/core_sessions'
2022-12-17T15:59:10.405626Z 8 [ERROR] [MY-010239] [Server] Got an error from unknown thread, /build/mysql-8.0-W37JCQ/mysql-8.0-8.0.31/storage/myisam/ha_myisam.cc:893
2022-12-17T15:59:10.405642Z 8 [Warning] [MY-010757] [Server] Recovering table: './suite/core_sessions'
2022-12-17T15:59:19.999341Z 98 [ERROR] [MY-013134] [Server] Table './suite/core_search_index' is marked as crashed and should be repaired
2022-12-17T15:59:20.000110Z 98 [Warning] [MY-010756] [Server] Checking table:   './suite/core_search_index'
2022-12-17T15:59:43.716082Z 98 [ERROR] [MY-010239] [Server] Got an error from unknown thread, /build/mysql-8.0-W37JCQ/mysql-8.0-8.0.31/storage/myisam/ha_myisam.cc:893
2022-12-17T15:59:43.716118Z 98 [Warning] [MY-010757] [Server] Recovering table: './suite/core_search_index'
2022-12-17T16:08:11.802883Z 4515 [ERROR] [MY-013134] [Server] Table './suite/pmviewer_core_message_topics' is marked as crashed and should be repaired
2022-12-17T16:08:11.803277Z 4515 [Warning] [MY-010756] [Server] Checking table:   './suite/pmviewer_core_message_topics'
2022-12-17T16:25:43.214877Z 13191 [ERROR] [MY-013134] [Server] Table './suite/core_tags_perms' is marked as crashed and should be repaired
2022-12-17T16:25:43.215318Z 13191 [Warning] [MY-010756] [Server] Checking table:   './suite/core_tags_perms'
2022-12-17T16:25:43.401098Z 13191 [ERROR] [MY-010239] [Server] Got an error from unknown thread, /build/mysql-8.0-W37JCQ/mysql-8.0-8.0.31/storage/myisam/ha_myisam.cc:893
2022-12-17T16:25:43.401143Z 13191 [Warning] [MY-010757] [Server] Recovering table: './suitel/core_tags_perms'

 

Edited by LiveG
Link to comment
Share on other sites

I have a warning on my ACP, could it be related?

InnoDB database tables typically perform more efficiently and reliably than other database engines such as MyISAM on most modern hosts when configured correctly. It is strongly encouraged to ensure all of your database tables are using the InnoDB storage engine, and that your hosting provider has configured MySQL for InnoDB use.

Could contain: Text

Edited by LiveG
Link to comment
Share on other sites

You should indeed have all tables running INNODB, and its likely why you have queries with "Repair with keycache" showing there. While this may well solve the specific issue you are experiencing though, you need to contact your hosting company about the fact you have tables crashing repeatedly, as that is an issue on the mysql instance itself.

Link to comment
Share on other sites

  • 7 months later...
On 12/19/2022 at 12:13 PM, Marc Stridgen said:

You should indeed have all tables running INNODB, and its likely why you have queries with "Repair with keycache" showing there. While this may well solve the specific issue you are experiencing though, you need to contact your hosting company about the fact you have tables crashing repeatedly, as that is an issue on the mysql instance itself.

Upgraded all the tables to INNODB, the last software version, server PHP version 8.

Entering posts is still slow. entering the post takes 6 seconds in average. It's a lot.

Basis actions take a long time.

https://pasteboard.co/AgnOfjofxfvB.png

 

Edited by LiveG
Link to comment
Share on other sites

1 hour ago, DawPi said:

My suggestion is contact @ASTRAPI, he's good and know server specialist. I'm pretty sure that he would help you with these issues.

Doing something like this and getting someone who can optimise your server would certainly be your best approach

Link to comment
Share on other sites

  • 4 weeks later...

I am still suffering from this periodic chockness of my forum.
I am considering moving to the IPB cloud to solve it, but it is not the best thing to do since IPB suggests an EU server while my region is in the Middle East.
I don't know how server optimization will help, have much CPU and memory, and since all the ACP support panels have no alert.

Relly doesn't know how to move on.

Link to comment
Share on other sites

If you are unsure on how server optimisation will help on the basis you have a lot of CPU and memory, that would most certainly emphasise why would need someone running your server. As while you can make a server perform better by increasing those if configuration is done correctly, you can actually make no difference at all by increasing these in any way if configuration is incorrect.

Just as a very very basic example. If your mysql is set to utilise 8gb of memory, you can add 500gb to your server, and it will make no difference unless you change the way mysql is configured accordingly.

In terms of cloud, we have US and EU based servers. We also have many customers using cloud in the middle east

Link to comment
Share on other sites

9 minutes ago, Marc Stridgen said:

If you are unsure on how server optimisation will help on the basis you have a lot of CPU and memory, that would most certainly emphasise why would need someone running your server. As while you can make a server perform better by increasing those if configuration is done correctly, you can actually make no difference at all by increasing these in any way if configuration is incorrect.

Just as a very very basic example. If your mysql is set to utilise 8gb of memory, you can add 500gb to your server, and it will make no difference unless you change the way mysql is configured accordingly.

In terms of cloud, we have US and EU based servers. We also have many customers using cloud in the middle east

IPB gives this kind of service of server optimization?

Link to comment
Share on other sites

23 minutes ago, LiveG said:

IPB gives this kind of service of server optimization?

We would not offer optimisation of your own server. Thats something you would need to contact your hosting company on. If you are referring to cloud, we take care of all that so you dont need to

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...