Kanboard slowing down. shared hosting

dannyjohan · July 28, 2021, 11:28am

hi,
im using kanboard on shared hosting, on first install when user only 2 and without plugin the response are very fast. now we are in 10 user, 5 project with 5-6 task each project. kanboard are slowing down

its slowing when i move task to other column, editing task, create comment. its like 10-15 second each

this our system

Application version: 1.2.20
PHP version: 7.4.20
PHP SAPI: litespeed
HTTP Client: cURL
OS version: Linux 3.10.0-962.3.2.lve1.5.52.el7.x86_64
Database driver: mysql
Database version: 10.3.29-MariaDB-cll-lve
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36

mail notification i use “mail”, and telegram.

this my plugin list

Name
Bigboard
BigBoard: a Kanboard that displays selected multiple projects
Boardcustomizer
Customize board and card style
SubtaskDueDate
Add a new due date field to subtasks
TaskProgressBar
Show the progress bar of sub-tasks from the bulletin board.
TimeTrackingEditor
Allows Editing of TimeTracking Values
Chat
Minimalist Chat for Kanboard.
Task2pdf
Create a printer friendly PDF of a task.
Signal
Receive notifications on Signal (via signal-cli)
Gantt
Gantt charts for Kanboard
TimeMachine
Plugin to add time machine : Back to the Future (more analytics datas, edit form on subtask time tracking)
CardPushDate
This plugin adds instant due date push actions to tasks in the board view.
KanboardCSS
A polished CSS theme for modern browsers
Bitbucket Webhook
Bind Bitbucket webhook events to Kanboard automatic actions
ExtendedMail
adds functionalit to send comment by mail: custom reply to, templates …
Creecros_Filter_Pack
creecros’s filter pack
Telegram
Receive notifications on Telegram
Milestone
The Milestone Plugin for Kanboard adds a section for milestones to show their related tasks.
TaskPushDate
Push due date out when tasks are moved between columns
TaskAssignCategory
Automatically assign a category when a task is moved to a specific column
DueDate
Force columns to be sorted by due date
Auto Email Extended Actions
Add the automatic actions to Send a task by email to the creator or assignee of the task. Also, included is an action to send a notification via email to user, creator, and assignee when a due date is impending within a duration.
TaskMoveOnDueDate
(Superceded by v1.2.10) Automatically move a task to a specific column on the date
Weekly Recurring Tasks
Automatically clones Tasks with the DAILY/WEEKLY/BIWEEKLY or MONDAY/TUESDAY/WEDNESDAY/THURSDAY/FRIDAY/SATURDAY/SUNDAY tag
Customizer
Completely customize your Kanboard experience with logos, favicons & themes.
Calendar
Calendar view for Kanboard
Task Interval Button
Simple plugins which adds button to incrementally change time spent on task.
Coverimage
Coverimage Function
Group_assign

this my debug.log file link

debug.log download

is there any suggestion how i solve this problem? i cant install background worker since our hosting not provided it. thanks for your help

warmest regards

creecros · July 28, 2021, 5:11pm

I wouldn’t be surprised if Group_Assign is slowing down your interaction on the board, to some degree. I doubt it is your only culprit though. Improvements have been implemented in the past, to help reduce queries, but its a beefy plugin, and kinda is what it is. I have never really noticed a difference on my test machines though, so how much it would affect your speed, I couldn’t tell you.

If you can do without some of your plugins, look towards the ones that are modifying the board or interacting with the database regularly, i.e. Group_assign, Customizer, BigBoard, Boardcustomizer…

You could simply, turn off every plugin, and see if your speed comes back, then start activating them one by one to see which ones are really affecting your speed.

Not sure how much they are affecting you, it could just simply be your machine/server limitations. I’ve seen complaints about speed of Kanboard without plugins before, so, it’s possible the plugins themselves really aren’t the main reason, could be disk i/o.

Your DB version is also behind, there are new releases…something else to consider.

Probably not a major reason, but your linux kernel is quite old as well. I feel like mine is old at 4.14.

Another factor, you say 5 projects, 5-6 tasks each, but how many projects from the past that are closed…those add up. Could maybe try purging those old ones, back them up somewhere else if you need them for records.

dannyjohan · July 30, 2021, 10:52am

hi creecros. thanks for your reply. ill try to find which plugin affect this delay. coz i remember when we first use the kanboard with projects and without plugin its very responsive.

at first its feel slower when we set all user got all notification in email. its resolved when we changed smtp to mail.

in the meantime, would you help determine which plugin producing this query?

[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00014114379882812
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.023876190185547
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00013899803161621
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.024015188217163
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00013613700866699
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.02415132522583
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00015401840209961
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.02430534362793
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM task_has_metadata WHERE task_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00021195411682129
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.024517297744751
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00019502639770508
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.024712324142456
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00016593933105469
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.024878263473511
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00014996528625488
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.025028228759766
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00014591217041016
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.025174140930176
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00015115737915039
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.025325298309326
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00013494491577148
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.025460243225098
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00013303756713867
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.025593280792236
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00013589859008789
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.025729179382324
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00013494491577148
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.025864124298096
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00013017654418945
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.025994300842285
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[2021-07-30 19:48:31] [debug] SQL: query_duration=0.00012803077697754
[2021-07-30 19:48:31] [debug] SQL: total_execution_time=0.026122331619263
[2021-07-30 19:48:31] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1

we check the log. its running all the time event we not doing anything in kanboard

thanks for your assist man

creecros · July 30, 2021, 11:30am

not sure, I’d be guessing Coverimage.

github.com

BlueTeck/kanboard_plugin_coverimage/blob/133a32c7108e82cb7276d9c3dacbf21008448b6b/Model/ProjectCoverimageModel.php#L21

    
      
                  $this->projectMetadataModel->save($project_id, array('prjcoverimage' => $image_id));
              }
          
          
    public function removeCoverimage($project_id) {
          
          
        $this->projectMetadataModel->remove($project_id, 'prjcoverimage');
              }
          
          
    public function getCoverimage($project_id) {
          
          
        $id = $this->projectMetadataModel->get($project_id, 'prjcoverimage');
                  if (!$id)
                    return(null);
                  return $this->getById($id);
              }
          
          
}

lucas · April 19, 2023, 5:24pm

What’s recommended disk I/O speed?

creecros · April 19, 2023, 5:51pm

I dont think there is one, per se. But clearly I/O speed is a factor. If you are using a NAS with 3mb/s, you are going to notice, for sure. Then of course, how many people interact at once, bandwidth, I mean, these are things IT people should problem solve if they are running slow. Im not really an IT person, but its clear a slow ass speed is going to bottleneck.

I mean, if your one guy runnung this, maybe an old ass HDD with 13mb/s is fine, but you start stacking users…maybe not, and then, whats too slow for you, i dont know. My jeep is fast enough for me, not like im going anywhere in a rush, but maybe you wouldnt like it, i dont know.

Topic		Replies	Views
Long Loading Time with 125 Tasks Questions	4	1571	May 25, 2020
Time tracking on Tasks	4	2599	November 19, 2019
Improvement Idea / plugin look up : automatic action for tasks shifting	6	665	July 1, 2019
Task Won't Add. Why? Questions	1	155	October 1, 2023
Feature request: Show subtasks on board	2	897	February 23, 2020

Kanboard slowing down. shared hosting

Related Topics