I tried to find the solution to this on Stackoverflow, maybe my wording is wrong. I have a query which takes to long to execute. I am sure there are simple ways to improve it. For example, I use the…
Having trouble with particular query performance after migrating large database from MySQL 8.0.13 data to MariaDB 10.5.11. I install MariaDB via repo: [mariadb] name = MariaDB 10.5 para CentOS 7 baseurl = http://yum.mariadb.org/10.5/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 To export database I use:…
I'm trying to analyze why the following query is slower with LIMIT 0,1 than LIMIT 0,100 I've added SQL_NO_CACHE for testing purposes. Query: SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS wp_posts.*, low_stock_amount_meta.meta_value AS low_stock_amount FROM wp_posts LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_id…
Hey guys i have 3 tables. First table called parceles(fid, REFCAT) Second table called informacio(fid, Ref_cadastral, fid_parceles) Third table called cedules(fid, Ref_cadastral, fid_parceles) fid_parceles is the foreing key from parceles in the two tables. I use this select for show…
I built a website with laravel 8. The server is a 6 cores CPU / 6 GB Ram VPS. Server is Linux CentOS with nginx and mysql 8. At peak period, there is about 500 visits online simultaneously. The CPU…
I have a concern about my MariaDB 10.4.12 database query execution time, which is getting much faster without any update to my database schema or data. While a speed-up is always welcome, I am concerned about the root cause of…
Found Problem: I was able to significantly reduce the response time to less than 0.01 seconds from 1.1 seconds simply by removing the ORDER BY clause. I was doing a USORT in PHP on dates anyway since the post-processing would…
I'm trying to figure out why a simple select with a LIMIT 1 clause (admittedly, on a really bloated table with a lot of rows and indices) is sometimes taking 30+ seconds (even 2 minutes, sometimes) to execute on an…
I have a query that takes 0.0002s in PHPMyAdmin and takes hundreds of seconds if I do it from PHP. Here it is: SELECT id, id_pages, link, childlink, url, hiddencontent, cansearch, ( SELECT p.id FROM pages as p WHERE pages.hiddencontent=1…
I have a PHP application that is running on a LAMP stack. This application makes an API call back to the server via javascript to get more data to display on the screen every second. When there are a number…