I have a PHP application that is executed up to one hundred times simultaneously, and very often. (its a telegram anti-spam bot with 250k+ users) The script itself makes various DB calls (tickers update, counters etc.) but it also load…
I am working on cPanel Database. Recently I edited some tables and deleted one table using PHPMyAdmin of cPanel. For sometime I saw Loading notification on the screen. But After 2 hours When I refreshed the cPanel and reopon phpMyAdmin…
I have a woocommerce DB Products are stored in rows where each row has: post_id (int not unique) meta_key (varchar) meta_value (double) I am trying to find all post_id where the value of meta_key which equals to "_price" is different…
How can I remove or replace a string from a column? eg: I want from my articles to remove the string: <p>John say's "Hello Mary"</p> I try with the REPLACE() function in phpmyadmin but I get an error. The query…
I have about 30 websites running Magento/Wordpress. Every 1-2 days I would need to reset mysql and then the CPU usage would be around 27% but then it'll slowly climbing up slowly over 1-2 days until it can't process any…
I am running a MySQL update query, but it always fails. I am using WordPress, I also tried to run the same query from phpMyAdmin which also fails. This is my table: id period x y 1 Sep 2021 -…
I've this query but it works only for DATE type. But my column type is DATETIME. How can I change this query to works on DATETIME type? I need to get output for todays report cases. SELECT COUNT(report_id) ASs total_today_case…
I am running a couple of crawlers that produce millions of datasets per day. The bottleneck is the latency between the spiders and the remote database. In case the location of the spider server is too large, the latency will…
Scenario I wish to SELECT from a table with simple varchar and integer columns and return a JSON representation of the whole table. This is so that later I can use PhP's curl() to send the 'table' to another server…
I am creating a dashboard where a user can see their form submissions and no one else's submissions. The database looks like this: db_frm_item_metas | meta_value | field_id | item_id | ----------------------------------- | 90 | 57 | 33 | |…