mysqldump access denied

When I try to backup using mysqldump from ssh, I run the following command on machine 10.64.1.1. It gives the following error. mysqldump --user=test -p=password --host=10.64.1.2 --tab=....

mysql2.so: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory

I am trying to run a Rails two app with Ubuntu 10.04 server, sphinx, myql2 version 0.2.7 and percona server 5.5 (Myslql 5.5). mysql2 in irb works ok, I can connect to the db. this rails 2 app is...

Slow Nginx + PHP-FPM during High Traffic on Magento Enterprise

We are using Nginx with PHP-FPM for Magento Enterprise Edition 1.12 Everything works fine but when we get visitors over 150 the speed drops. During this time we have noticed that CPU utilization...

Can't start mysqld/mysql

first I have to say I'm a mysql newbie. Basically mysql does not start and says: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Now Here...

Improve InnoDB count(*) performance

I got a large table with million of records. I have to do a count(*) for a certain criteria and there is no way I can get rid of it. count() with InnoDB is very expensive. I have been trying to...

Could not open mysql.plugin table. Some plugins may be not loaded

I have an issue with MySQL. When I'm trying to start it, that gives me an error message, which is 2015-12-10 10:52:31 13f4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED....

Mysqldump broken CREATE VIEW export

My database backup through mysqldump get created with wrong source SQL query for all database views. All source columns are always "1". I can export view definition using mysql workbench and the...

mySQL server in XAMP don't start

I read all of articles about my problem but it still not working How can I solve this issue? Here is my log file: 2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is...

Error in starting MYSQL in XAMPP

When I start xampp it gives me an error in mysql. I'm using windows 10. Here is the contents of error log: 2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is...

How can I create Percona XtraDB cluster with Docker?

I need to create Percona XtraDB cluster with "star" topology: with one master node (where I insert data) and two slave nodes (changes in master must be applied to slaves) Also I need to use...

Why does MySQL explicit predicate locking disallow INSERT statements outside of the predicate lock

Assuming we have the following database tables: create table department ( id bigint not null, budget bigint not null, name varchar(255), primary key (id) ) ENGINE=InnoDB create...

Xampp mysql Error: MySQL shutdown unexpectedly

when I starting mysql, giving the following error: 17:43:13 [mysql] Error: MySQL shutdown unexpectedly. 17:43:13 [mysql] This may be due to a blocked port, missing dependencies, 17:43:13 ...

MySQL - Error 1118 Row size too large (> 8126) - No access to sql-config

I know this question is asked a lot and I also found a lot advice, but none that is practicable for me. My website is hostet on siteground.com. Everything works fine so far and suddenly I...

pt-table-checksum not detecting diffs

I have a simple master->slave setup with MariaDB: Master: Ubuntu 16.04 LTS with MariaDB 10.2.8 and percona-toolkit 3.0.4 Slave: Ubuntu 16.04 LTS with MariaDB 10.2.7 Replication is running fine and...

mysql has gone away and tuning mysql database

i have a mysql database that crashes about 1 time a day with error mysql server has gone away. timeout is 28800 sec and I set max_allowed_packet to 1024M but i have still the problem. I read in...

MySQL 5.7 max_connections reset after reboot

We have a set of PXC clusters, each with slaves that we are using for reads. The slaves are running percona server 5.7 with " max_connections" and "max_user_connections" set to 4000 and 4050...

After an XAMPP shutdown, MySQL stopped working too, how do I solve this?

I have errors running mysql with xampp. Here's the log, this error appeared once I started xampp I'm running ips in xampp also the ports of mysql aren't showing in the control panel only if I...

MySQL keeps crashing when using xampp

I have recently started with web-development. I need a good server to run PHP and mySQL applications. The problem I am facing now is that mySQL keeps crashing whenever I open xampp. I have read...

Xampp MySQL not starting - “MYSQL not starting on XAMPP 3.2.1 version…”

i installed xampp version 3.2.1 on my laptop and mysql was working fine on it before but suddenly mysql stopped working while apache and others were working. when i click on start mysql it...

Illegal mix of collation in laravel

I have been trying to implement emoji in table. I have changed the column collation to utf8mb4_unicode_ci and the rest of the columns collation are empty but when I try to query out that. I get an...

InnoDB: The innodb_system data file 'ibdata1' must be writable

I'm trying to run percona xtradb cluster. The output from the percona server is as followings: mysqld: [Warning] World-writable config file '/etc/mysql/my.cnf' is...

Error during docker compose: build path either does not exist, is not accessible, or is not a valid URL

phpstorm swears at parsing the docker-compose.yml file: Error while parsing "/home/victor/PhpstormProjects/cpalife-back/docker-compose.yml" Process `docker-compose config` failed. build path...

Problem with "Transparent Huge Pages" on Windows 10 when using Docker

When running percona/percona-server:5.7 image and enable TokuDB it complained about transparent huge pages (THP) is enabled. However I have turned it off under: "Computer Configuration\Windows...

Percona PMM2 Docker image - how to use it?

How do I run Percona PMM2 with docker-compose? I can run PMM1 just fine. But PMM2 has absolutely zero documentation available and I can't seem to figure it out. Sample docker-compose.yml file db: ...

mySQL using 100% CPU

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...

How to create grafana configmap for datasources?

I am trying to create a configmap for a Grafana datasource, using an instance of Grafana from the Kube-Prometheus-Stack helm chart...

How do I connect a database to mautic using docker compose?

I am trying to deploy mautic in my docker server (using portainer on OMV) and am having issues building the connection to the mysql database. I am trying to follow the instructions from the docker...

Galera cluster not working use wsrep_sst_method=xtrabackup (-v2) until first use rsync

I'm trying to setup a galera cluster, with MariaDB 10.2, and percona-xtrabackup-2.3.10-1.el7.x86_64. If bootstrap the donor by wsrep_sst_method=xtrabackup or xtrabackup-v2, the joiner will be...

Can we can configure grpc_pass and proxy_pass on single nginx conf for the same location(/)?

I am trying to configure Percona PMM along with my proxy servers so that my client servers can securely connect to PMM server. Attaching the current setup here. Also providing the nginx conf I am...

Mac Big Sur MariaDB will not run

MariaDB has worked fine but is now failing to run on boot up. I have uninstalled and it then reinstalled it and this does not fix anything. Here is the output from mysql.server.start mysql.server...