----------------------
"The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay"
---------------------
We enquired about this with the host who basically stated the the SQL is examining more than 5 million rows. I find this hard to swallow considering the fpa text below on show a quarter of a million rows across the entire database.
basically they said we have to "Upgrade" the plan. (Raises alarm bells right there in my book).
I did some research into the comments in the error and could not find much of anything to change, or edit to remove this error, more of my own lack of understanding than anything else.
So my question is multi faceted.
1. How do I fix the Settings mentioned in the error, knowing that I am on a shared hosting service plan;
2. What's the best method to analyze the database to see if there is anything that I can do regarding the database to reduce its size and possibly remove the error?
3. Are there any know extensions or plugins that might bloat the CMS that I may have Installed? (I'll post the second part of this FPA in the first response)
Cheers All
Forum Post Assistant (v1.6.6) : 25-Nov-2023 wrote:Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.4.0-Stable (Pamoja) 17-October-2023
Joomla! Configured :: Yes | Writable (755) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: N/A | Proxy: false | LiveSite: | Session lifetime: 240 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.4.0: Yes | Database Supports J! 4.4.0: Yes | Database Credentials Present: Yes |
Host Configuration :: OS: Linux | OS Version: 3.10.0-962.3.2.lve1.5.81.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 3730.56 GiB |
PHP Configuration :: Version: 8.1.25 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: /dev/null | Last Known Error: 24th October 2023 04:59:55. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 2000M | Max. POST Size: 8000M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 512M
Database Configuration :: Version: 10.6.15-MariaDB-cll-lve (Client:mysqlnd 8.1.25) | Database Size: 92.97 MiB | #of Tables with config prefix: 240 | #of other Tables: 0 | User Privileges : GRANT ALLDetailed Environment :: wrote:PHP Extensions :: Core (8.1.25) | date (8.1.25) | libxml (8.1.25) | openssl (8.1.25) | pcre (8.1.25) | sqlite3 (8.1.25) | zlib (8.1.25) | bz2 (8.1.25) | calendar (8.1.25) | ctype (8.1.25) | curl (8.1.25) | hash (8.1.25) | filter (8.1.25) | ftp (8.1.25) | gettext (8.1.25) | json (8.1.25) | iconv (8.1.25) | SPL (8.1.25) | pcntl (8.1.25) | readline (8.1.25) | Reflection (8.1.25) | session (8.1.25) | standard (8.1.25) | mbstring (8.1.25) | shmop (8.1.25) | SimpleXML (8.1.25) | tokenizer (8.1.25) | xml (8.1.25) | litespeed () | bcmath (8.1.25) | dba (8.1.25) | dom (20031129) | enchant (8.1.25) | fileinfo (8.1.25) | gd (8.1.25) | imagick (3.7.0) | imap (8.1.25) | intl (8.1.25) | ldap (8.1.25) | exif (8.1.25) | mysqlnd (mysqlnd 8.1.25) | mysqli (8.1.25) | PDO (8.1.25) | pdo_mysql (8.1.25) | odbc (8.1.25) | PDO_ODBC (8.1.25) | pdo_pgsql (8.1.25) | Phar (8.1.25) | pspell (8.1.25) | snmp (8.1.25) | sodium (8.1.25) | sysvmsg (8.1.25) | sysvsem (8.1.25) | sysvshm (8.1.25) | xmlreader (8.1.25) | xmlrpc (1.0.0RC2) | xmlwriter (8.1.25) | zip (1.19.5) | ionCube Loader (13.0.2) | Zend OPcache (8.1.25) | SourceGuardian (14.0.2) | Zend Engine (4.1.25) |
Potential Missing Extensions ::
Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: NoFolder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) | api/ (755) |
Elevated Permissions (First 10) ::Database Information :: wrote:Database statistics :: Uptime: 2744477 | Threads: 264 | Questions: 1912445750 | Slow queries: 96357 | Opens: 557327 | Open tables: 20000 | Queries per second avg: 696.834 |Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party:: WF_LISTS_TITLE (2.9.52) ? | WF_LINK_TITLE (2.9.52) ? | WF_TEXTCASE_TITLE (2.9.52) ? | JCE - Noneditable (1.0.0) ? | WF_HELP_TITLE (2.9.52) ? | WF_TABLE_TITLE (2.9.52) ? | WF_CLIPBOARD_TITLE (2.9.52) ? | WF_KITCHENSINK_TITLE (2.9.52) ? | WF_ATTRIBUTES_TITLE (2.9.52) ? | WF_FILEMANAGER_TITLE (2.9.52) ? | WF_MEDIA_TITLE (2.9.52) ? | WF_IMGMANAGER_EXT_TITLE (2.9.52) ? | WF_FORMATSELECT_TITLE (2.9.52) ? | WF_MICRODATA_TITLE (2.9.52) ? | WF_ARTICLE_TITLE (2.9.52) ? | WF_CONTEXTMENU_TITLE (2.9.52) ? | WF_PREVIEW_TITLE (2.9.52) ? | WF_PRINT_TITLE (2.9.52) ? | WF_FONTCOLOR_TITLE (2.9.52) ? | WF_SOURCE_TITLE (2.9.52) ? | WF_IFRAME_TITLE (2.9.52) ? | WF_TEMPLATEMANAGER_TITLE (2.9.52) ? | WF_IMGMANAGER_TITLE (2.9.52) ? | WF_SPELLCHECKER_TITLE (2.9.52) ? | WF_EMOTIONS_TITLE (2.9.52) ? | WF_REFERENCE_TITLE (2.9.52) ? | WF_VISUALCHARS_TITLE (2.9.52) ? | WF_STYLESELECT_TITLE (2.9.52) ? | WF_STYLE_TITLE (2.9.52) ? | WF_FONTSELECT_TITLE (2.9.52) ? | WF_FULLSCREEN_TITLE (2.9.52) ? | WF_CLEANUP_TITLE (2.9.52) ? | WF_MEDIAMANAGER_TITLE (2.9.52) ? | WF_AUTOSAVE_TITLE (2.9.52) ? | WF_CHARMAP_TITLE (2.9.52) ? | WF_SEARCHREPLACE_TITLE (2.9.52) ? | WF_VISUALBLOCKS_TITLE (2.9.52) ? | WF_DIRECTIONALITY_TITLE (2.9.52) ? | WF_LANGCODE_TITLE (2.9.52) ? | WF_WORDCOUNT_TITLE (2.9.52) ? | WF_CAPTION_TITLE (2.9.41) ? | WF_TEXTPATTERN_TITLE (2.9.52) ? | JCE - Columns (1.0.0) ? | WF_ANCHOR_TITLE (2.9.52) ? | WF_HR_TITLE (2.9.52) ? | WF_FONTSIZESELECT_TITLE (2.9.52) ? | WF_BROWSER_TITLE (2.9.52) ? | WF_NONBREAKING_TITLE (2.9.52) ? | WF_LINK_SEARCH_TITLE (2.9.52) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.52) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.52) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.52) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.52) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.52) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.52) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.52) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.52) ? |
Components :: Admin ::
Core :: com_contenthistory (4.0.0) 1 | com_associations (4.0.0) 1 | com_templates (4.0.0) 1 | com_mails (4.0.0) 1 | com_media (3.0.0) 1 | com_cache (4.0.0) 1 | com_tags (4.0.0) 1 | com_categories (4.0.0) 1 | com_languages (4.0.0) 1 | com_users (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_installer (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_config (4.0.0) 1 | com_workflow (4.0.0) 1 | com_actionlogs (3.9.0) 1 | com_content (4.0.0) 1 | com_banners (4.0.0) 1 | com_scheduler (4.1.0) 1 | com_finder (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_redirect (4.0.0) 1 | com_menus (4.0.0) 1 | com_fields (4.0.0) 1 | com_guidedtours (4.3.0) 1 | com_plugins (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_privacy (3.9.0) 1 | com_checkin (4.0.0) 1 | com_admin (4.0.0) 1 | com_messages (4.0.0) 1 | com_login (4.0.0) 1 | com_modules (4.0.0) 1 | com_ajax (4.0.0) 1 | com_newsfeeds (4.0.0) 1 |
3rd Party:: COM_NICEPAGE (5.21.3) 1 | Helpdesk Pro (5.3.1) 1 | com_rsfiles (1.17.2) 1 | HikaShop (5.0.0) 1 | COM_JCE (2.9.52) 1 | COM_JLEXHELPFUL (1.7.3) 1 | com_akeebabackup (9.8.3) 1 | COM_FFEXPLORER (1.0.7) 1 | com_rsfeedback (1.8.8) 1 | com_rsform (3.2.2) 1 | Library - dompdf v2.x (2.0.3) ? | Library - dompdf v1.x (1.2.2) ? | Library - mPDF (8.2.0) ? | com_rsmail (1.22.24) 1 |
Modules :: Site ::
Core :: mod_articles_popular (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_banners (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_login (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_articles_archive (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_users_latest (3.0.0) 1 |
3rd Party:: RSFeedback! Button Module (1.0.3) 1 | mod_phocacart_product (4.0.2) 1 | mod_phocacart_cart (4.0.2) 1 | mod_rsfiles_folder_content_viewer (1.6) 1 | Hikashop Module (5.0.0) ? | mod_phocacart_product_scroller (4.0.2) 1 | mod_phocacart_brands (4.0.2) 1 | Hikashop Currency Switcher Module (5.0.0) ? | mod_phocacart_category (4.0.2) 1 | RSForm! Pro Module List (3.0.5) 1 | RSFeedback! Category Module (1.0.1) 1 | mod_phocacart_currency (4.0.2) 1 | mod_phocacart_search (4.0.2) 1 | RSMail Newsletter (1.6) 1 | mod_phocacart_compare (4.0.2) 1 | mod_phocacart_wishlist (4.0.2) 1 | Hikashop Cart Module (5.0.0) ? | mod_phocacart_filter (4.0.2) 1 |
Modules :: Admin ::
Core :: mod_post_installation_messages (4.0.0) 1 | mod_title (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_messages (4.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_sampledata (3.8.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_loginsupport (4.0.0) 1 | mod_frontend (4.0.0) 1 | mod_feed (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_version (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_privacy_status (4.0.0) 1 | mod_login (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_guidedtours (4.3.0) 1 | mod_user (4.0.0) 1 |
3rd Party:: MOD_NICEPAGEMENU (-) 1 | HikaShop Dashboard (5.0.0) 1 |
Libraries ::
Core ::
3rd Party:: Regular Labs Library (23.10.17780) 1 |
Templates Discovered :: wrote:Templates :: Site :: clearth_9 (1.0) 1 | cassiopeia (1.0) 1 | clearth_9a (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |