UVDesk Tuning

wildanm

@vipin

Numbers of ticket

When i'm using 15GB Memory for MySQL, i'm using GCP, with this amount of
tickets the uvdesk is already very slow.

Is there any best practices on how to optimize uvdesk ?

peopleinside

@wildanm what hardware are you using?
How much CPU and RAM your server have?

wildanm

@peopleinside

Here's resources i used on GCP

Compute Engine with 4 vCPUs and 4.5 GB Memory
MySQL 5.7 with 4 CPUs and 15GB Memory.

peopleinside

@wildanm thanks for the information.
Do you know what version of UVdesk are you also using? (latest version is 1.0.18)
Do you run PHP 7.4 or superior? (Lower PHP can be deprecated)

Let's wait a reply from a developer @vipin but in the main time you can add those informations that can be helpful.

I'm happy to see you are strongly using UVdesk for your tickets.
I'm sure the UVdesk team will help you.

wildanm

@peopleinside

Here is my environment :

PHP 7.3.31

I'm using fork version of UVDesk, here is my composer.json files :

{
    "type": "project",
    "license": "proprietary",
    "repositories": [
        {
            "type": "vcs",
            "url": "git@github.com:openthinklabs/core-framework.git"
        },        
        {
            "type": "vcs",
            "url": "git@github.com:openthinklabs/extension-framework.git"
        },    
        {
            "type": "vcs",
            "url": "git@github.com:openthinklabs/mailbox-component.git"
        },    
        {
            "type": "vcs",
            "url": "git@github.com:openthinklabs/automation-bundle.git"
        },                     
        {
            "type": "vcs",
            "url": "git@github.com:openthinklabs/swiftmailer-bundle.git"
        },
        {
            "type": "vcs",
            "url": "git@github.com:openthinklabs/swiftmailer.git"
        },
        {
            "type": "vcs",
            "url": "git@github.com:openthinklabs/swiftmailer-mailgun-bundle.git"
        },
        {
            "type": "vcs",
            "url": "git@github.com:openthinklabs/helpdesk-support-center-bundle.git"
        }
    ],
    "require": {
        "php": "^7.2",
        "ext-ctype": "*",
        "ext-iconv": "*",
        "composer/package-versions-deprecated": "1.11.99.4",
        "doctrine/annotations": "^1.0",
        "doctrine/doctrine-bundle": "^2.4.2",
        "doctrine/doctrine-fixtures-bundle": "^3.4.0",
        "doctrine/doctrine-migrations-bundle": "^2.2.2",
        "doctrine/orm": "^2.7",
        "google/recaptcha": "^1.2.4",
        "guzzlehttp/psr7": "^2.1",
        "knplabs/knp-paginator-bundle": "^5.5.1",
        "ocramius/proxy-manager": "2.2.3",
        "openthinklabs/automation-bundle": "1.0.11.1",
        "openthinklabs/core-framework": "1.0.17.2",
        "openthinklabs/extension-framework": "1.0.6.1",
        "openthinklabs/mailbox-component": "1.0.14.1",
        "openthinklabs/support-center-bundle": "1.0.13",
        "openthinklabs/swiftmailer-bundle": "dev-main#323a6169a254c083a8afb3a6c45a093a15d1dc10@dev",
        "openthinklabs/swiftmailer-mailgun-bundle": "dev-master#d6d03dadec62155ef9e24ab04f6586a82d03cdff",
        "phpdocumentor/reflection-docblock": "^5.3",
        "sensio/framework-extra-bundle": "^5.5.3",
        "symfony/asset": "4.4.*",
        "symfony/console": "4.4.*",
        "symfony/dotenv": "4.4.*",
        "symfony/expression-language": "4.4.*",
        "symfony/flex": "^1.12.2",
        "symfony/form": "4.4.*",
        "symfony/framework-bundle": "4.4.*",
        "symfony/http-client": "4.4.*",
        "symfony/http-kernel": "^4.4|^5.0",
        "symfony/intl": "4.4.*",
        "symfony/mime": "4.4.*",
        "symfony/monolog-bundle": "^3.6.0",
        "symfony/process": "4.4.*",
        "symfony/property-access": "4.4.*",
        "symfony/property-info": "4.4.*",
        "symfony/proxy-manager-bridge": "4.4.*",
        "symfony/security-bundle": "4.4.*",
        "symfony/serializer": "4.4.*",
        "symfony/translation": "4.4.*",
        "symfony/twig-bundle": "4.4.*",
        "symfony/validator": "4.4.*",
        "symfony/var-dumper": "4.4.*",
        "symfony/web-link": "4.4.*",
        "symfony/yaml": "4.4.*",
        "uvdesk/composer-plugin": "^1.0"
    },
    "require-dev": {
        "phpunit/phpunit": "^8.5",
        "symfony/browser-kit": "4.4.*",
        "symfony/css-selector": "4.4.*",
        "symfony/debug-bundle": "4.4.*",
        "symfony/maker-bundle": "^1.0",
        "symfony/phpunit-bridge": "^5.3",
        "symfony/stopwatch": "4.4.*",
        "symfony/web-profiler-bundle": "4.4.*",
        "symfony/web-server-bundle": "4.4.*"
    },
    "config": {
        "preferred-install": {
            "*": "dist"
        },
        "sort-packages": true
    },
    "autoload": {
        "psr-4": {
            "App\\": "src/",
            "UVDesk\\CommunityPackages\\UVDesk\\FormComponent\\": "apps/uvdesk/form-component/src/"
        }
    },
    "autoload-dev": {
        "psr-4": {
            "App\\Tests\\": "tests/"
        }
    },
    "replace": {
        "paragonie/random_compat": "2.*",
        "symfony/polyfill-ctype": "*",
        "symfony/polyfill-iconv": "*",
        "symfony/polyfill-php71": "*",
        "symfony/polyfill-php70": "*",
        "symfony/polyfill-php56": "*"
    },
    "scripts": {
        "post-install-cmd": [
            "@auto-scripts"
        ],
        "post-update-cmd": [
            "@auto-scripts"
        ],
        "auto-scripts": {
            "cache:clear": "symfony-cmd",
            "assets:install %PUBLIC_DIR%": "symfony-cmd"
        }
    },
    "conflict": {
        "symfony/symfony": "*"
    },
    "extra": {
        "symfony": {
            "allow-contrib": false,
            "require": "4.4.*"
        }
    },
    "minimum-stability": "dev",
    "prefer-stable": true
}

peopleinside

@wildanm In the UVdesk Dashboard, if you are running the latest UVdesk version that is 1.0.18 you should see the version.

You are using a deprecated PHP version, this can be a security and performance risk https://www.php.net/supported-versions.php

wildanm

@peopleinside

Oh yes, i see it, it's V -1.0.18.

Ok, i will upgrade to php 7.4. Thanks for your suggestion.

peopleinside

@wildanm I suggest to use PHP 8.0 or PHP 8.1
From your posted file seems you are running UVdesk 1.0.17

wildanm

@peopleinside

Here is my Dashboard :

UVDesk version

peopleinside

@wildanm great, so I suggest to just try to upgrade PHP to 8.0 or 8.1
Personally I'm running PHP 8.1 with the latest Uvdesk version.

Let us know if after upgrading PHP the performance has improvments.

Solved UVDesk Tuning