I have a large Wordpress site with 170.000 users and a lot of daily page views. I just tuned all MySQL indexes based on several comments but actually in my slow logs the SELECT distinct wp_usermeta.meta_key FROM wp_usermeta; takes around…
When I launch XAMPP, apache works fine but mysql doesn't start, it always say: 'Failed to start "mysql": cannot start service: /opt/lampp/bin/mysql.server: 263: kill: No such process' It is weird because before, everything was working great, and one time, while…
I made middle ware for setting customize tag of login user, I want to customize tag in event Id for performance monitering.But this is not working I'm I missing something?? Need Help... <?php namespace AppHttpMiddleware; use Auth; use Closure; use…
I want to export some data from the DB. Basically what I want to say is this: 1- Select mbr_name from the members table 2- Choose the ones that exist at the course_registration table (based on mbr_id) 3- Join the…
Recently I have have received under my responsibility the company's wordpress site, suffers from extreme performance issues... I have started investigating, installed Query Monitor and discovered several problemas: Get_terms(). The site's theme use heavily this method in many shortcodes. All…
I'm developing an API with Flask and I cannot retrieve queries from a MySQL database I've connected with flask-sqlalchemy (not sqlalchemy alone). This is a pre-existing database downloaded from my client's PHPMyAdmin, so I haven't ran db.create_all(): I simply created…
I cannot connect to my database which is hosted on OVH remotely from Flutter's package mysql1 and get the following error: flutter: SocketException: Failed host lookup: 'saintlouqpweb.mysql.db' (OS Error: nodename nor servname provided, or not known, errno = 8) I…
Hello I have a telegram bot connected to a MySQL db. I'm using a free account of PythonAnywhere which allows me to have max 3 connections to db per user. But I've been getting a max_user_connections error, so I've configured…
my website recently crashed and is no longer available. I browsed through my Cpanel dashboard and I found error logs file in which I noticed my website is crashing due to call to undefined function mysqli_connect. Website is using PHP…
I am trying to make a CRUD in PHP. Apache and MySQL is still running. class DB { static private $connection; const DB_TYPE = "mysql"; const DB_HOST = "localhost"; const DB_NAME = "crud"; const USER_NAME = "root"; const USER_PASSWORD =…