MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
2answers
40 views

Unable to restart mariadb after update

I have just updated mariadb to the latest version in arch-linux. I have the database folder in /home/mysql. Out of nowhere, I can't get it restart with systemctl restart mysqld. Here's the error log: ...
4
votes
2answers
3k views

How to move RDS database to different VPC

I didn't select a VPC when creating a MySQL RDS database, so it created it inside an auto-generated "default" VPC. I'm now unable to add it to any of my pre-defined security groups, or access it from ...
1
vote
2answers
2k views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
0
votes
1answer
4k views

installing mysql5.6.12 in ubuntu 12.10 error:/etc/mysql/conf.d is missing

I am trying to install mysql in ubuntu 12.10. Downloaded 'MySQL-5.6.12-1.linux_glibc2.5.i386.rpm-bundle' from http://dev.mysql.com/downloads/mysql/. Extracted it and tried to install using rpm -i ...
-1
votes
0answers
12 views

Why do I use YII2 access to MySQL,but throw an exception [on hold]

I am Yii2 beginner.I use Yii2 built a simple model to link a database table called y_user.But when I want to test fetch the data from y_user it throws an exception,the meaning of this exception code ...
3
votes
1answer
26 views

For MySQL performance, all things being equal, does single threaded processor performance matter more or overall performance?

Say I have two servers, both with the same RAID 10 SSD HDD, 128GB Ram, etc.. I'm trying to figure out which server to get. There is a significant price difference between these two following setups, ...
-2
votes
0answers
19 views

Phpinfo() now showing mysql - Debian wheezy

please, could you provide me your help? I'm using Debian in version Wheezy. I upgraded mysql to version Ver 14.14 Distrib 5.6.29, for debian-linux-gnu (x86_64) using EditLine wrapper and php is ...
-1
votes
0answers
9 views

export table data using mysql command (not mysqldump)

I want to do an export of a table and we do not have mysqldump installed. I thought I can do this: root:~> mysql news media > news.media.7.26.2016.sql where news is the database name and ...
1
vote
1answer
1k views

MySQL allows zero date(0000-00-00 00:00:00) after I enabled strict mode

I want to configure a MySQL db instance not to accept zero dates(0000-00-00 00:00:00) because the software running on top of it fails to run if it encounters such a field. The server is running ...
0
votes
2answers
1k views

'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I'm getting 'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' error when I'm trying to make too much update and ...
-1
votes
0answers
6 views

Advice for Selecting the Right EC2 Instance [duplicate]

I am new to this particular flavor of StackExchange and apologize in advance if this is a poor question or the wrong area for it. I wanted to ask for some help in choosing the right EC2 instance (...
16
votes
2answers
19k views

Is MySQL port 3306 encrypted, and if no, how can I encrypt it?

I am working through a security audit for a system at my work and one of the requirements is to encrypt all traffic through public/unprotected networks. Since we are accessing the MySQL database (over ...
0
votes
2answers
12k views

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 with windows

I found similar questions but none of them helped me with a windows machine. I originally posted this on stack overflow but it was suggested that I ask here. I was able to connect to mySQL through my ...
0
votes
0answers
10 views

Force a connection from PHP to MySQL version 4

I am trying to connect a PHP application to a version 4 MySQL database. Both are running on an internal network on different servers. There is no outside exposure. I've tried using three MySQL ...
0
votes
0answers
16 views

Ubuntu 16.04 Server MySql open_file_limit won't go higher than 65536

I'm running Ubuntu 16.04 Server on XenServer and I'm running into an issue with MySql's open file limit. Here's what I've done so far: sudo nano /etc/security/limits.conf (reference) * soft nofile ...
-2
votes
0answers
23 views

Forcing close Mysql [on hold]

Hi I have the following problem is that the Mysql service falls all the time . I share the log. I could help please and how could solucioanarlo. - root@server:# cat /var/log/mysql/error.log 160723 ...
0
votes
2answers
1k views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum -...
3
votes
1answer
1k views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
0
votes
4answers
1k views

Check if remote mysql is running

I want a bash shell script that i can run using a cron job to check if mysql on a remote server is running. If it is, then do nothing, other start the server. The cronjob will be checking the remote ...
0
votes
1answer
23 views

MySQL replication: any risks to master if replica is locked down?

Any danger to a MySQL master if the slave replica is locked down for an extended period of time? I am using 5.6.xx. This question states that it's "safe", but does not speak to degradation in ...
0
votes
2answers
145 views

MySQL - high RAM usage

I have VPS with 2GB of RAM running Ubuntu. There are three sites using database on this server - two on WordPress and one on custom script. All of them get max few hits per day. MySQL always had ...
-2
votes
0answers
11 views

How much max mysql queries per second a Mysql server can handle with 4GB RAM AND 1 core Dedicated CPU [duplicate]

I created A very Simple Php web page website which load data from mysql database from a separate mysql server which has 4GB RAM and 2 core dedicated cpu Intel(R) Xeon(R) CPU E5-2650 2.30GHz It has ...
0
votes
1answer
30 views

MySQL 5.5 and MariaDB5.5 return different number of columns for the same data and same select query?

I have been searching through the net for some time and can not seem to find answer for this case. It would be much appreciated if I can get some advise. Here is the problem in short. We do have 2 ...
0
votes
0answers
10 views

ERROR 2002 (HY000) … mysql.sock

Mysql Version :: 5.0.51b OS Version :: CentOS 6.4 Error : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (2) I got this error in live ...
0
votes
2answers
1k views

Error while installing mysql on centos 6.7

Error: Package: 2:postfix-2.6.6-6.el6_7.1.x86_64 (@updates) Requires: libmysqlclient.so.16()(64bit) Removing: mysql-libs-5.1.73-5.el6_6.x86_64 (@base) libmysqlclient.so.16()(...
0
votes
1answer
69 views

Can't start any service after installing iRedMail on CentOS

I have attempted to install iRedMail on one of my servers. After reboot, I can't start any service anymore. [root@mx ~]# systemctl start httpd ** (pkttyagent:16323): WARNING **: Unable to register ...
0
votes
0answers
4 views

sql - Select boolean strictly true [migrated]

I want to select a row Ad as boolean which is strictly true. I am using the following SQL statement. SELECT 'user' AS username, 'pass' AS password, true AS Ad FROM users LIMIT 1; However the above ...
0
votes
0answers
14 views

AWS MySql RDS migrate to AWS Aurora without taking downtime in diffrent region [closed]

I've AWS MySQL RDS instance located at Singapore, and I'm planning to migrate it to AWS Aurora (Mumbai). This process roughly takes about 30-40 minutes. I don't want to take any downtime while ...
0
votes
1answer
22 views

How to integrate the php’s error codes to submit to a database

I'm trying to writes PHP error to a mysql database. If there’s a way we can change it so that instead of writing directly to an error_log file, it sends the error to a script, which records it in the ...
-5
votes
0answers
31 views

How to a database chat works? [closed]

I want create a chat with PHP and SQL. How the database chat (with messages, nick etc.) works? I've tried to create this idea: User -> Write something on the input and send it. DB: Save this ...
2
votes
2answers
3k views

Installing Percona Server error: keyserver

I am having an error trying to install Percona Server via APT. First they say you have to add their key, and this is where I get stuck. I am issuing this command and get errors, anyone can help? ...
0
votes
0answers
20 views

MySQL server connection error [closed]

Hi i am running a VM with Centos7. I am running a mysql server on it. It works fine for weeks. But now when i trying to connect it shows the error ERROR 2002 (HY000): Can't connect to local MySQL ...
0
votes
1answer
31 views

mysql php ssl connect certificate verify failed

I have followed this steps to add mysql ssl support on Server A: # Generate a CA key and certificate with SHA1 digest openssl genrsa 2048 > ca-key.pem openssl req -sha1 -new -x509 -nodes -days ...
0
votes
0answers
30 views

Diagnosing slow server networking

So, I have 3 servers all networking together to run a single high traffic website all of which use Cloudflare for reverse proxy purposes. Two are webservers (which are identical) and one is a ...
0
votes
1answer
3k views

Lost connection to MySQL server during query

I am trying to import our old database into a new databsae on our test server however I keep coming accross this error: "Lost connection to MySQL server during query". As you can see below I have ...
2
votes
3answers
1k views

How to speed up Drupal 7 with remote DB (not DNS resolving)

we have Drupal 7 on Ubuntu LTS virtual machine (VMWare) with MySQL 5.1 server on the same physical server, but on a different virtual machine. The Drupal website is currently under development, ...
0
votes
1answer
2k views

Compiling PHP on CentOS Needs MySQL PDO Configured

I am trying to compile PHP with mysql_pdo on CentOS 6 and I am having just one heck of a time trying to make it happen. Currently I am trying to compile PHP 5.2, but I am going to have to do this for ...
-1
votes
0answers
7 views

How can I use logman (on Windows) with a MySQL backend?

I created a logman counter that doesn't start with the following command: logman create counter stats -f SQL -si 2 -c "\PhysicalDisk(*)\Current Disk Queue Length" -o "stats!walk006_log" --v logman ...
0
votes
1answer
1k views

Installing mysql-devel to match MySQL version

I'm running MySQL 5.1.52 on CentOS 4.6 and I'm trying to install mysql-devel to match my MySQL version. If I do yum install mysql-devel it wants to upgrade MySQL to 5.1.58, yet if I do yum search ...
1
vote
3answers
1k views

Zabbix_server.log says [2006] MySQL server has gone away

Environment CentOS 6.6, Zabbix 2.4 DB MySQL Galera cluster with 3 nodes mysql-wsrep-server-5.6-5.6.23-25.10.el6.x86_64 galera-3-25.3.10-2.el6.x86_64 Errors [Z3005] query failed: [2006] MySQL ...
0
votes
2answers
31 views

InnoDB (Not Really) Out Of Memory?

MySQL keeps on crashing on my server. I'm running several dozen sites using VestaCP and haven't had issues with MySQL for months. I'm running on a Linode VPS with 12GB of Ram, normally 9GB of it ...
8
votes
1answer
1k views

Speed up MySQL inserts with partitions on MyISAM with unique key

I have a large MyISAM table (~30M rows). At some point I've switched it to fixed row format, so now table takes ~40Gb on disk and 2Gb for indexes. Table has a unique index and there are 100 'insert on ...
0
votes
2answers
2k views

Syntax error when setting up master-master replication in MySQL

So I've set up my initial master-slave replication pair on two different MySQL servers. That part is working great. So all I have to do is set up the first master as a slave and set up the first slave ...
9
votes
4answers
20k views

Simpler way to convert all tables from InnoDB to MyISAM

Previously, I use this: USE dbname; ALTER TABLE tablename ENGINE=MYISAM; I'm looking for simpler way to convert all tables in a database, rather than writing every table name one by one
1
vote
2answers
1k views

ERROR Fatal error: Illegal or unknown default time zone 'UTC'

I am running MySQL 5.1 from package on Mac OSX 10.6. I am trying running: sudo /usr/local/mysql/bin/mysqld --skip-grant --user root --datadir=/usr/local/mysql/data This error is preventing me from ...
0
votes
0answers
4 views

Fastcgi cache for ajax/restful based application?

Actually, we are using AngularJS with alot of cacheable REST http call. Also, there are dynamic pages that are not ajax based. Since mysql caching is quite good. I wonder if applying Fastcgi cache ...
0
votes
0answers
7 views

Attempting to purge mysql* with apt-get, unable to do so without interaction

I'm attempting to purge MySQL completely from Ubuntu 14.04 non-interactively but can't get past a dialog that requires me to say Yes/No. I'm running this command: sudo apt-get purge -y mysql* ...
0
votes
1answer
16 views

Using external variables inside of an Ansible template

Background I am writing a playbook that installs two of the same web application on different machines. Both applications require their own MySQL/MariaDB database. I plan to pass the MySQL ...
0
votes
1answer
22 views

Upgrading MySQL with YUM

I am trying to upgrade from MySQL 5.5 to MySQL 5.7 with yum (using Amazon linux AMI) When I do : sudo yum upgrade mysql No packages marked for update When I do : sudo yum install mysql ...
0
votes
1answer
1k views

directory not owned by the 'mysql' or '_mysql' user

I have recently installed MSQL for a Rails App. After some tinkering, I have an error starting mysql now that reads as follows: Warning: The /usr/local/mysql/data directory is not owned by the '...