Possible lack of indexes and tables in the Databas

Dear Ladies and Gentlemen,

I have looked at dozens of forums with a problem similar to mine, but none offers a solution to my problem.
I hope it can be fixed.

It is a new installation 7.4.2
Only and exclusively I have installed the Boonex module "Profiles", I have enabled it to be checking from the beginning that modules fail and have a clean installation.
And my surprise is that I have a lot of SQL errors, with a "new" installation.
I have installed the "dolphin.pro-master" version and the same bugs.
And the Dolphin-v.7.4.2 version, I have installed it twice. Now is the version I have installed.

The issue of errors is as if the database lacks indexes and tables. and that also affects the proper functioning of the database and generates too many requests and organization and "JOIN" unions without indexes.

Data of interest:
The server is dedicated Advance1 of Zarconia
All permissions are fine
Other settings also good (see images)
erhfrhfd

fdgg

In this image you can see how the only module I have installed is that of Boonex Profiles and to see the errors:

fghjf

And these are the SQL errors:

----------------------------------------------------------------------------------------------------------------------------------------

sql    time    rows    affected

SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.00045 sec    1    1

SELECT `l`.`Name` FROM `sys_localization_languages` AS `l` INNER JOIN `Profiles` AS `p` ON (`p`.`LangID` = `l`.`ID`) WHERE `p`.`ID` = 1    0.00012 sec    0    0

SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `dependencies`, `date` FROM `sys_modules` WHERE `uri`= ? LIMIT 1    0.00026 sec    0    0

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1    0.00012 sec    1    1

SELECT `id` AS `id`, `unit` AS `unit`, `action` AS `action`, `template` AS `template`, `params` AS `params` FROM `sys_sbs_types` WHERE `unit`= ? AND `action`= ? LIMIT 1    0.00026 sec    0    0
SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`='0'    0.00011 sec    0    0
SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `dependencies`, `date` FROM `sys_modules` WHERE `uri`= ? LIMIT 1    0.00023 sec    1    1
SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Profiler' LIMIT 1    0.00022 sec    1    1
SELECT `Name` AS `name`, `desc` AS `title`, `Type` AS `type`, `AvailableValues` AS `extra`, `check` AS `check`, `err_text` AS `check_error` FROM `sys_options` WHERE `kateg`= ?    0.00029 sec    10    10
UPDATE `sys_options` SET `VALUE`= ? WHERE `Name`= ? LIMIT 1    0.0002 sec    0    0
SELECT `Name`, `VALUE` FROM `sys_options`    0.00031 sec    161    161
SELECT `id` AS `id`, `unit` AS `unit`, `action` AS `action`, `template` AS `template`, `params` AS `params` FROM `sys_sbs_types` WHERE `unit`= ? AND `action`= ? LIMIT 1    0.00015 sec    0    0
SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`='0'    0.00011 sec    0    0
SELECT `caption`, `url`, `target`, `icon` FROM `sys_menu_admin_top` ORDER BY `Order`    0.00021 sec    4    4
SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.0003 sec    1    1
SELECT `id`, `name`, `title`, `url`, `icon` FROM `sys_menu_admin` WHERE `parent_id`='0' ORDER BY `order`    0.0003 sec    6    6
SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.00028 sec    1    1
SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.00028 sec    1    1
SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.00028 sec    1    1
SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.00028 sec    1    1
SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.00028 sec    1    1
SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.00028 sec    1    1
SELECT * FROM `Profiles` WHERE `ID`= ? LIMIT 1    0.0003 sec    1    1
SELECT * FROM `sys_menu_admin` WHERE `parent_id`= ? ORDER BY `order`    0.00033 sec    9    9

Modules:1 modules loaded Modules Queries:1 modules queries (0.15 sec)
+
name    type    class/file    method    time
---------------------------------------------------------------------------------------------------------------------------------

Let's see if we can fix it, for me it's very important.

Best regards

server1.jpg · 164.4K · 561 views
server2.jpg · 62.6K · 488 views
server3.jpg · 206K · 554 views
Quote · 2 Sep 2019

First of all, you don't have the profiles module installed, you have the profiler module installed.

 

https://www.boonex.com/forums/topic/What-does-the-profiler-module-do-.htm

Geeks, making the world a better place
Quote · 3 Sep 2019

Hi, thanks for the information.

In any case, something has to be BAD in the database, here I provide screenshots of the errors and the advice it gives for repair.

If there are already these problems in a NEW installation, what will happen when it is fully operational?

So please. Does anyone know how to fix this?. In this case I assume that Boonex can say something, since there are no third-party modules.

Waiting for news

Here I put the images of the errors and tips that occur in the database:

fdgg

fghjf

fghjf

fdgg

fghjf

fdgg

errorsql1.jpg · 159K · 491 views
errorsql2.jpg · 36.2K · 431 views
errorsql3.jpg · 37.5K · 435 views
errorsql4.jpg · 43.6K · 419 views
errorsql5.jpg · 78.4K · 426 views
consejos1.jpg · 511.8K · 501 views
Quote · 3 Sep 2019

Hi,

This is an old Dolphin problem. I understand your frustration. I've gone through the same thing several times while trying to audit/optimize my database. IMHO, the Dolphin database was not developed correctly: not indexing properly, too many unnecessary queries etc. The Dolphin Database architecture/design needs a rework. That will need to redesign the entire Dolphin script. Too much work. I am not a developer, I am just guessing. Boonex developers are professional programers. They have done a nice work and I am thankful but many things still need to be improved.

The only solution I came up with in my case is to optimize the database by increasing some of its variable's values eg: query_cache_size, key_buffer_size, table_open_cache, innodb_buffer_pool_size, tmp_table_size etc. In your case, I also bet that your MySQL server is not optimized well.

If done properly, it will improve your Database performance a bit and get rid of SOME (not all) of the red values (problems) in your Mysql's variable status. Also, If you read the comment next to each red value, it will tell you what needs to be done, which value needs to be increased to fix the problem. They are many tutorials online on How to Optimize the MySQL perfomance. It's just a workaround but not the right fix to this Dolphin Database problem.

Hope this helps. 

Regards!

Quote · 4 Sep 2019

Dolphin uses the MyISAM storage engine.

Geeks, making the world a better place
Quote · 4 Sep 2019

Hi @geek_girl.
What does it mean to use the MyISAM storage engine? Can some of these failures be fixed? how?

Hi @DigitZup.
I understand what you say, since I have seen forums on this subject since 2008 and all without solution. What I do not understand is why Boonex says nothing about these errors, so that time in this matter is not wasted, if it has no arrangement, it is said and that's it.
A manual of how to configure the variables and topic solved is made.

I am going to put here the VARIABLES of my database and on it we can create which are the best options, so surely all the members of the community can benefit, since surely we ALL have the same problems.
Thanks in advance
And best regards

My Variables:


      aria block size                                           8,192
      aria checkpoint interval                             30
      aria checkpoint log activity                        1,048,576
      aria force start after recovery failures         0
      aria group commit                                       none
      aria group commit interval                          0
      aria log file size                                          1,073,741,824
      aria log purge type                                     immediate
      aria max sort file size                                 9,223,372,036,853,727,232
      aria page checksum                                  ON
      aria pagecache age threshold                   300
      aria pagecache buffer size                        134,217,728
      aria pagecache division limit                     100
      aria recover                                               NORMAL
      aria repair threads                                     1
      aria sort buffer size                                    134,217,728
      aria stats method                                       nulls_unequal
      aria sync log dir                                         NEWFILE
      aria used for temp tables                          ON
      auto increment increment Documentation             1
      auto increment offset Documentation                    1
      autocommit Documentation                             ON
      automatic sp privileges Documentation           ON
      back log Documentation                           50
      basedir Documentation                            /usr
      big tables Documentation                        OFF
      binlog annotate row events                      OFF
      binlog cache size Documentation            32 KiB
      binlog checksum Documentation             NONE
      binlog direct non transactional updates Documentation     OFF
      binlog format Documentation                                              STATEMENT
      binlog optimize thread scheduling                 ON
      binlog stmt cache size Documentation          32 KiB
      bulk insert buffer size Documentation           8 MiB
      character set client Documentation               latin1
    (Session value)                                                utf8
      character set connection Documentation      latin1
    (Session value)                                                utf8
      character set database Documentation        latin1
      character set filesystem Documentation       binary
      character set results Documentation            latin1
    (Session value)                                               utf8
      character set server Documentation             latin1
      character set system Documentation           utf8
      character sets dir Documentation                /usr/share/mysql/charsets/
      collation connection Documentation            latin1_swedish_ci
    (Session value)                                    utf8_unicode_ci
      collation database Documentation     latin1_swedish_ci
      collation server Documentation         latin1_swedish_ci
      completion type Documentation         NO_CHAIN
      concurrent insert Documentation      AUTO
      connect timeout Documentation                  10
      datadir Documentation                       /var/lib/mysql/
      date format Documentation                %Y-%m-%d
      datetime format Documentation         %Y-%m-%d %H:%i:%s
      deadlock search depth long                      15
      deadlock search depth short                     4
      deadlock timeout long                       50,000,000
      deadlock timeout short                      10,000
      debug no thread alarm                         OFF
      default storage engine Documentation          InnoDB
      default week format Documentation               0
      delay key write Documentation                      ON
      delayed insert limit Documentation              100
      delayed insert timeout Documentation         300
      delayed queue size Documentation             1,000
      div precision increment Documentation           4
      engine condition pushdown Documentation     OFF
      event scheduler Documentation                       OFF
      expensive subquery limit                           100
      expire logs days Documentation                   0
      extra max connections                                  1
      extra port                                                       0
      flush Documentation                                OFF
      flush time Documentation                            0
      foreign key checks Documentation              ON
      ft boolean syntax Documentation               + -><()~*:""&|
      ft max word len Documentation                  84
      ft min word len Documentation                   4
      ft query expansion limit Documentation          20
      ft stopword file Documentation               (built-in)
      general log Documentation                     OFF
      general log file Documentation               server.log
      group concat max len Documentation           1,024
      have compress Documentation                 YES
      have crypt Documentation                      YES
      have csv Documentation                         YES
      have dynamic loading Documentation             YES
      have geometry Documentation                 YES
      have innodb Documentation                     YES
      have ndbcluster Documentation                  NO
      have openssl Documentation                  DISABLED
      have partitioning Documentation             YES
      have profiling Documentation                  YES
      have query cache Documentation                 YES
      have rtree keys Documentation                 YES
      have ssl Documentation                         DISABLED
      have symlink Documentation                  DISABLED
      hostname Documentation                      server.MISERVER.com
      ignore builtin innodb Documentation         OFF
      ignore db dirs Documentation    
      init connect Documentation    
      init file Documentation    
      init slave Documentation    
      innodb adaptive flushing Documentation         ON
      innodb adaptive flushing method                      estimate
      innodb adaptive hash index Documentation     ON
      innodb adaptive hash index partitions               1
      innodb additional mem pool size Documentation     8 MiB
      innodb autoextend increment Documentation          8
      innodb autoinc lock mode Documentation                1
      innodb blocking buffer pool restore                     OFF
      innodb buffer pool instances Documentation           1
      innodb buffer pool populate                       OFF
      innodb buffer pool restore at startup          0
      innodb buffer pool shm checksum             ON
      innodb buffer pool shm key                        0
      innodb buffer pool size Documentation     128 MiB
      innodb change buffering Documentation        all
      innodb checkpoint age target                          0
      innodb checksums Documentation                 ON
      innodb commit concurrency Documentation      0
      innodb concurrency tickets Documentation       500
      innodb corrupt table action                            assert
      innodb data file path Documentation             ibdata1:10M:autoextend
      innodb data home dir Documentation    
      innodb dict size limit                                      0
      innodb doublewrite Documentation            ON
      innodb doublewrite                                      file    
      innodb fake changes                                OFF
      innodb fast checksum                               OFF
      innodb fast shutdown Documentation             1
      innodb file format Documentation                   Antelope
      innodb file format check Documentation        ON
      innodb file format max Documentation          Antelope
      innodb file per table Documentation              OFF
      innodb flush log at trx commit  Documentation     1
      innodb flush method             Documentation    
      innodb flush neighbor pages                             area
      innodb force load corrupted Documentation     OFF
      innodb force recovery Documentation              0
      innodb ibuf accel rate                                       100
      innodb ibuf active contract                 1
      innodb ibuf max size                                  67,092,480
      innodb import table from xtrabackup         0
      innodb io capacity Documentation            200
      innodb kill idle transaction                         0
      innodb large prefix Documentation           OFF
      innodb lazy drop table                               0
      innodb lock wait timeout Documentation        50
      innodb locking fake changes                          ON
      innodb locks unsafe for binlog Documentation     OFF
      innodb log block size                               512
      innodb log buffer size Documentation     8 MiB
      innodb log file size Documentation          5 MiB
      innodb log files in group Documentation             2
      innodb log group home dir Documentation         ./
      innodb max bitmap file size                                 104,857,600
      innodb max changed pages                                 1,000,000
      innodb max dirty pages pct Documentation         75
      innodb max purge lag Documentation                  0
      innodb merge sort block size                                1,048,576
      innodb mirrored log groups Documentation          1
      innodb old blocks pct Documentation           37
      innodb old blocks time Documentation         0
      innodb open files Documentation                 300
      innodb page size Documentation                 16 KiB
      innodb print all deadlocks Documentation    OFF
      innodb purge batch size Documentation            20
      innodb purge threads Documentation                1
      innodb random read ahead Documentation       OFF
      innodb read ahead     linear
      innodb read ahead threshold Documentation    56
      innodb read io threads Documentation              4
      innodb recovery stats                                    OFF
      innodb recovery update relay log                  OFF
      innodb replication delay Documentation            0
      innodb rollback on timeout Documentation   OFF
      innodb rollback segments Documentation         128
      innodb show locks held                                10
      innodb show verbose locks                          0
      innodb simulate comp failures                      0
      innodb spin wait delay Documentation         6
      innodb stats auto update                              1
      innodb stats method Documentation nulls_equal
      innodb stats modified counter                            0
      innodb stats on metadata Documentation         ON
      innodb stats sample pages Documentation       8
      innodb stats traditional                                ON
      innodb stats update need lock                     1
      innodb strict mode Documentation             OFF
      innodb support xa Documentation              ON
      innodb sync spin loops Documentation         30
      innodb table locks Documentation             ON
      innodb thread concurrency Documentation     0
      innodb thread concurrency timer based          OFF
      innodb thread sleep delay Documentation      10,000
      innodb track changed pages                           OFF
      innodb use atomic writes                             OFF
      innodb use fallocate                                     OFF
      innodb use global flush log at trx commit     ON
      innodb use native aio Documentation          ON
      innodb use stacktrace                                  OFF
      innodb use sys malloc Documentation         ON
      innodb use sys stats table                            OFF
      innodb version Documentation                      5.5.59-MariaDB-38.11
      innodb write io threads Documentation         4
      interactive timeout Documentation                28,800
      join buffer size Documentation                      128 KiB
      join buffer space limit                                      2,097,152
      join cache level                                               2
      keep files on create Documentation              OFF
      key buffer size Documentation                      128 MiB
      key cache age threshold Documentation       300
      key cache block size Documentation         1 KiB
      key cache division limit Documentation     100
      key cache segments                                  0
      large files support Documentation             ON
      large page size Documentation                 0 B
      large pages Documentation                      OFF
      lc messages Documentation                     en_US
      lc messages dir Documentation    
      lc time names Documentation                 en_US
      license Documentation                          GPL
      local infile Documentation                     OFF
      lock wait timeout Documentation             31,536,000
      locked in memory Documentation                 OFF
      log Documentation                               OFF
      log bin Documentation                         OFF
      log bin trust function creators Documentation     OFF
      log error Documentation                                       /var/log/mariadb/mariadb.log
      log output Documentation                                     FILE
      log queries not using indexes Documentation OFF
      log slave updates Documentation                    OFF
     

log slow filter     admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
     

     log slow queries Documentation                 ON
      log slow rate limit                                        1
      log slow verbosity    
      log warnings Documentation                     1
      long query time Documentation                 5
      low priority updates Documentation               OFF
      lower case file system Documentation           OFF
      lower case table names Documentation         0
      master verify checksum Documentation         OFF
      max allowed packet Documentation                1,048,576
      max binlog cache size Documentation            16 EiB
      max binlog size Documentation                       1 GiB
      max binlog stmt cache size Documentation     16 EiB
      max connect errors Documentation                 10
      max connections Documentation                   1,024
      max delayed threads Documentation             20
      max error count Documentation                     64
      max heap table size Documentation              1 GiB
      max insert delayed threads Documentation     20
      max join size Documentation                          18,446,744,073,709,551,616
      max length for sort data Documentation         1,024
      max long data size Documentation                 1,048,576
      max prepared stmt count Documentation         16,382
      max relay log size Documentation             0 B
      max seeks for key Documentation             4,294,967,295
      max sort length Documentation                 1,024
      max sp recursion depth Documentation         0
      max tmp tables Documentation                     32
      max user connections Documentation             0
      max write lock count Documentation              4,294,967,295
      metadata locks cache size Documentation     1,024
      min examined row limit Documentation           0
      mrr buffer size                                                  262,144
      multi range count Documentation                    256
      myisam block size                                            1,024
      myisam data pointer size Documentation         6 B
      myisam max sort file size Documentation        8 EiB
      myisam mmap size Documentation                 16 EiB
      myisam recover options Documentation         DEFAULT
      myisam repair threads Documentation          1
      myisam sort buffer size Documentation         8 MiB
      myisam stats method Documentation             nulls_unequal
      myisam use mmap Documentation                 OFF
      net buffer length Documentation               16,384
      net read timeout Documentation                 30
      net retry count Documentation                 10
      net write timeout Documentation              60
      old Documentation                                  OFF
      old alter table Documentation                 OFF
      old mode    
      old passwords Documentation                 OFF
      open files limit Documentation                 4,096
      optimizer prune level Documentation            1
      optimizer search depth Documentation         62
     

optimizer switch Documentation     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off
     

performance schema Documentation             OFF
      performance schema events waits history long size Documentation     10,000
      performance schema events waits history size Documentation             10
      performance schema max cond classes Documentation                     80
      performance schema max cond instances Documentation                 1,000
      performance schema max file classes Documentation                     50
      performance schema max file handles Documentation                     32,768
      performance schema max file instances Documentation                  10,000
      performance schema max mutex classes Documentation                     200
      performance schema max mutex instances Documentation                 1,000,000
      performance schema max rwlock classes Documentation                    30
      performance schema max rwlock instances Documentation                 1,000,000
      performance schema max table handles Documentation                      100,000
      performance schema max table instances Documentation                   50,000
      performance schema max thread classes Documentation                    50
      performance schema max thread instances Documentation                 1,000
      pid file Documentation                      /var/run/mariadb/mariadb.pid
      plugin dir Documentation                      /usr/lib64/mysql/plugin/
      plugin maturity                                               unknown
      port Documentation                                                        3,306
      preload buffer size Documentation                                 32 KiB
      profiling Documentation                                                   OFF
      profiling history size Documentation                                 15
      progress report time                                                           5
      protocol version Documentation                                         10
      query alloc block size Documentation                             8 KiB
      query cache limit Documentation                                 20 MiB
      query cache min res unit Documentation                             4,096
      query cache size Documentation                                     128 MiB
      query cache strip comments                                            OFF
      query cache type Documentation                                     ON
      query cache wlock invalidate Documentation                         OFF
      query prealloc size Documentation                                 8 KiB
      range alloc block size Documentation                             4 KiB
      read buffer size Documentation                                     128 KiB
      read only Documentation                                               OFF
      read rnd buffer size Documentation                                 1 MiB
      relay log Documentation    
      relay log index Documentation    
      relay log info file Documentation                                   relay-log.info
      relay log purge Documentation                                     ON
      relay log recovery Documentation                                 OFF
      relay log space limit Documentation                                 0
      replicate annotate row events                                        OFF
      replicate do db    
      replicate do table    
      replicate events marked for skip                         replicate
      replicate ignore db    
      replicate ignore table    
      replicate wild do table    
      replicate wild ignore table    
      report host Documentation    
      report password Documentation    
      report port Documentation                                     3,306
      report user Documentation    
      rowid merge buff size                                     8,388,608
      rpl recovery rank Documentation                                 0
      secure auth Documentation                                         OFF
      secure file priv Documentation    
      server id Documentation                                               0
      skip external locking Documentation                             ON
      skip name resolve Documentation                                 OFF
      skip networking Documentation                                     OFF
      skip show database Documentation                              OFF
      slave compressed protocol Documentation                   OFF
      slave exec mode Documentation                                   STRICT
      slave load tmpdir Documentation                                   /var/tmp
      slave max allowed packet Documentation                     1,073,741,824
      slave net timeout Documentation                                 3,600
      slave skip errors Documentation                                  OFF
      slave sql verify checksum Documentation                   ON
      slave transaction retries Documentation                       10
      slave type conversions Documentation    
      slow launch time Documentation                                     2
      slow query log Documentation                                     ON
      slow query log file Documentation                     server-slow.log
      socket Documentation                         /var/lib/mysql/mysql.sock
      sort buffer size Documentation                                     8 MiB
      sql auto is null Documentation                                     OFF
      sql big selects Documentation                                      ON
      sql big tables Documentation                                        OFF
      sql buffer result Documentation                                    OFF
      sql log bin Documentation                                             ON
      sql log off Documentation                                             OFF
      sql low priority updates Documentation                             OFF
      sql max join size Documentation          18,446,744,073,709,551,616
      sql mode Documentation    
      sql notes Documentation                                                 ON
      sql quote show create Documentation                             ON
      sql safe updates Documentation                                     OFF
      sql select limit Documentation             18,446,744,073,709,551,616
      sql slave skip counter Documentation                             0
      sql warnings Documentation                                         OFF
      ssl ca Documentation    
      ssl capath Documentation    
      ssl cert Documentation    
      ssl cipher Documentation    
      ssl key Documentation    
      storage engine Documentation                                     InnoDB
      stored program cache Documentation                                 256
      sync binlog Documentation                                         0
      sync frm Documentation                                             ON
      sync master info Documentation                                 0
      sync relay log Documentation                                     0
      sync relay log info Documentation                               0
      system time zone Documentation                                    BST
      table definition cache Documentation                             1,024
      table open cache Documentation                                    1,600
      thread cache size Documentation                                   128
      thread concurrency Documentation                                 10
      thread handling Documentation                                     one-thread-per-connection
      thread pool idle timeout                                          60
      thread pool max threads                                         500
      thread pool oversubscribe                                         3
      thread pool size                                                 8
      thread pool stall limit                                         500
      thread stack Documentation                                         294,912
      time format Documentation                                         %H:%i:%s
      time zone Documentation                                         SYSTEM
      timed mutexes Documentation                                     OFF
      tmp table size Documentation                                 1 GiB
      tmpdir Documentation                                             /var/tmp
      transaction alloc block size Documentation                 8 KiB
      transaction prealloc size Documentation                     4 KiB
      tx isolation Documentation                                     REPEATABLE-READ
      unique checks Documentation                                      ON
      updatable views with limit Documentation                     YES
      userstat                                                                          OFF
      version Documentation                                         5.5.60-MariaDB
      version comment Documentation                                 MariaDB Server
      version compile machine Documentation                         x86_64
      version compile os Documentation                             Linux
      wait timeout Documentation                                       28,800

Quote · 4 Sep 2019

One thing you should do is to uninstall MariaDB 5.5.60; that sounds like the default version that CentOS installs.  To do that you need to go to MariaDB website and they will have the repo you can add to the yum repos.  That will get you version 10.  You can also install php 7.3 and add in php-fpm for the fast cgi processor.  If you are still running Apache I recommend switching to Nginx and not as a proxy for Apache but as the main webserver.  You can then uninstall your current Dolphin since you don't have any content to lose and reinstall.

Then, install a few modules that you will need for whatever type of website you are building and just leave the proflier module uninstalled. 

You can also rent a dedicated or vps server from me and I will do the above for you.

Geeks, making the world a better place
Quote · 4 Sep 2019

Decano01it looks like there is some misunderstanding, you're saying about error, but there is no any errors on your screens.

Dolphin DB is already optimized, if you see some not optimized queries please privide the details of these queries we'll try find out the problem.

Also regarding recommendations in phpMyAdmin - many recommendations are related to InnoDB storage engine, while Dolphin uses MyISAM storage engine, so I suspect that there are other sites on your server which are using InnoDB and these recommendations aren't related to Dolphin only.

Rules → http://www.boonex.com/terms
Quote · 8 Sep 2019

Thank you @AlexT and @geek_girl for your time and information

I will make the indicated changes and will do the tests again. With the result I get, I comment again here

Best regards

Quote · 9 Sep 2019
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.