MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
3 views

MAMP for Mac version 3.4 mysql general query log not working

I am trying to enable the general query log in MAMP 3.4 for mac What I have tried create file /Applications/MAMP/logs/mysql_sql.log chmod 777 /Applications/MAMP/logs/mysql_sql.log add the following ...
0
votes
0answers
9 views

MySQL reading /etc/hosts.allow and /etc/hosts.deny

The error reporting of one of my services reported problems to connect to my MySQL server. This problems were not consistent, it just happened a few times to different servers. I started debugging ...
-1
votes
1answer
19 views

MySQL querries slow down during upload, slow internet connection

I have a bit of an issue with my SQL queries. Basically whenever someone within my network uploads something (to gmail, dropbox anything) my SQL-queries become approximately 20 times slower. Sadly, ...
0
votes
0answers
9 views

Upgraded server, now dealing with MySQL sleeping queries

The Problem MySQL is generating a lot of sleeping queries. At times so many that it was causing denial of service of sorts and really slowing (or shutting) down our site. We created a temporary ...
0
votes
0answers
15 views

Why does XtraBackup tell me my MySQL database is corrupt?

I am trying to backup data on a MySQL Galera node with XtraBackup. Unfortunatelly the tool tells me, that ibdata1 is corrupt. After double checking I indeed found some myisam tables I have importet by ...
0
votes
1answer
26 views

failed to sync slave with master

Hi I have setup a mysql replication Master-slave using mysql utilities, my master have went down as the disk space of log file was full, then I chan ged the log file and started master now slave have ...
1
vote
0answers
25 views

Ubuntu | Mysql Server 300-750% CPU

I have already done a lot of adjustments to the MySQL Configuration, but unfortunately I always get back to time utilization very high CPU. Multiple MySQL processes partially between 200-750% CPU / ...
1
vote
0answers
24 views

Advice on migrating RDS MySQL databases from one AWS account to another

I am currently planning a migration of AWS resources from one account to another. This includes several MySQL RDS instances. After some research it looks like a "dump and load" strategy is needed. My ...
0
votes
0answers
10 views

Why am I getting a different number of results when I change the formatting of the WHERE statement? [migrated]

I am writing a SQL script (in MySQL Workbench, if that's relevant) that involves looking for variations of the same string in my data. This way, I can get an accurate pull even if something is ...
-3
votes
0answers
10 views

Hardware sizing for the Infrastructure [duplicate]

I would like to do the Hardware sizing for below applications on Linux based OS both in Physical and Virtual environment, can someone provide details on how many servers, type of servers, storage, ...
-4
votes
0answers
16 views

LEMP Setup on CentOS at DigitalOcean [on hold]

I'm following this tutorial. I got some issues start from step four: Configure Nginx to Process PHP Pages. After I typed this $ sudo vi /etc/nginx/conf.d/default.conf. I can't find server { listen ...
-1
votes
0answers
13 views

myisamchk results in segmentation fault

My database table is marked as "in use" in phpMyAdmin. I tried to run repair on it. I get this issue and followed the instructions here: ...
0
votes
0answers
10 views

hardware sizing of web and database server [duplicate]

I would like to do the Hardware sizing for below applications on Linux based OS both in Physical and Virtual environment, can someone provide details on how many servers, type of servers, storage, ...
0
votes
0answers
18 views

How to backup MySQL (MariaDB) database on dedicated servers to AWS (S3 Object Storage?)

We have a 180GB dedicated production server, which we currently backup daily using Percona xtrabackup to a backup server in our rack. We're looking at moving our backups (not the database itself) to ...
0
votes
1answer
19 views

How to enable slow query log in MySQL Galera?

I want to enable slow query logging in MySQL Galera. In order to do so, I have enabled it through my.cnf: log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 1 ...
0
votes
2answers
34 views

Trying to access port 3306 (only using it locally)

I am trying to open port 3306 on my archlinux distro. I've tried multiple different iptables settings, but I can't seem to get it to work. (Locally) Here's my current iptables setting: Chain INPUT ...
0
votes
1answer
18 views

Optimizing mysql and apache ovh vps [duplicate]

My website is 100% mysql php so it gets slowdown and sometimes server shutdown. I'm using VPS Classic: The best cheap VPS - $2.99/month - OVH (VPS Classic 4 - 4 vCores and 8GB RAM). I want some ...
2
votes
1answer
60 views

Website sometimes takes long time to load

I am running a LAMP system with Ubuntu 14.04. I have 4 cores and 8GB Ram on my server The problem is that when I connect to my website after idle period( 2-3 hours or more) the it takes lot of time ...
0
votes
1answer
22 views

multi-tenancy saas isolated database configuration [closed]

I'm currently researching the world of Multi-tenancy SaaS environments which run on the isolated database configuration. I'm looking to further understand the provisioning of new accounts (creation ...
0
votes
1answer
40 views

MySQL Optimization for write-heavy DB, single connection [closed]

I have a cloud machine with 1 core CPU, 1GB RAM and 24GB SSD. It is running CentOS 6.5, mysql 5.1.73 with default my.cnf. I have a PHP job that runs and fetches data from some other websites, ...
0
votes
1answer
16 views

How to migrate MySQL Master/Master replication to MySQL Galera Cluster?

Currently our setup consists of two MySQL 5.6 servers on seperate Ubuntu 14.04 bare mettal machines. I am looking into migrating the system to a MySQL Galera Cluster on 3 nodes. Can I "patch" the ...
2
votes
1answer
29 views

MySQL user can't connect from remote host

I have two MySQL users with the exact same permissions, one can connect from a remote host, the other can't. How could this be? Here is my configuration: SELECT * FROM user WHERE user IN ...
0
votes
1answer
22 views

Set up keepalived for MySQL Master-Master replication [closed]

I managed 2 mysqld processes that listen for connections on different ports- 3306 and 3307 on localhost. I set up MySQL Master-Master replication. And now I want to set up keepalived for MySQL ...
1
vote
1answer
29 views

Can one use a MySQL backend for user authentication in a strongswan VPN server?

We have installed and configured a strongswan VPN server with username / password authentication. Is it possible to store the users' credentials in a MySQL backend and configure strongswan to use the ...
0
votes
1answer
24 views

Removing a mySQL database without password? [duplicate]

So about 6 months ago I set up a wheezy server and at the same time I installed MySQL even though I didn't need it. I've now updated to Jessie and need the database but can not remember the password ...
4
votes
3answers
87 views

Hardware RAID1 configuration - Possibly failed sectors on one physical disk. Does the OS automatically read from the other disk?

I'm not a professional sysadmin but since I couldn't find answers to my specific case after researching for a while I was hoping I could get some help here. Our server uses P222 - a HP Smart ...
0
votes
1answer
41 views

Cant read dir of /etc/my.cnf. (Errcode: 2)

I am running MariaDB (libmysql - 5.5.41-MariaDB) and today I noticed that I couldn't go to mysql via command line to create a dump file. It would throw an error: mysql: Can't read dir of ...
1
vote
1answer
52 views

Linux mysql server will not start, or restart

Intro Im running MariaDB and Apache on my linux machine and today I ran into some problems. I connect to the server via SSH and here are some of the issues Im facing. I have absolutely no idea what ...
-2
votes
1answer
45 views

How does one add commands to nrpe.cfg for Percona MySQL plugins on NRPE client? [closed]

How do you add commands to nrpe.cfg for Percona MySQL plugins on NRPE client? To configure percona-nrpe plugins for mysql you will have to do 3 things viz : 1. define commands in command.cfg 2. ...
0
votes
0answers
24 views

RDS connection blocked despite security group “Allow all traffic, all ports, all IPs”

I can only connect by ssh-ing into my ec2, and then using mysql from the cli. I can not connect: ssh-ing into my ec2, and connecting from PHP mysql command line on my local machine. I cannot ...
1
vote
1answer
39 views

SQL Query overloading server

I have one php file which is getting called very often for a session check of an external application. I don't know how many calls there are every second, but I think it may be like 20-100 calls every ...
0
votes
1answer
25 views

Unusually high RDS MySQL memory

could use your help in understanding this. I'm running an RDS MySQL instance (db.m3.large on SSD) with 100GB of storage. I'm a little freaked out that my memory is 50% there: I must be doing ...
0
votes
0answers
16 views

configure apache to use sql server authentication using password and salt

I got a web application which I want to protect using apache authentication. I found out that it uses sha1+salt to store passwords. Since auth_mysql_module is deprecated I try to use authn_dbd_module. ...
0
votes
1answer
26 views

Lost connection to MySQL server at ‘reading initial communication packet’

I am using FreeBSD 9.2 and mysql 5.5 and i am using SOMETIMES this error - * Lost connection to MySQL server at 'reading initial communication packet', system error: 0* when i am executing sql ...
1
vote
2answers
90 views

csv import mysql null

I have to import some csv-formatted data into a mysql (mariadb) database. There is no csv header and the lines look like this: 00323acd-7909-41a4-a849-073ca3391dcf,2014-05,\N ...
-2
votes
0answers
20 views

NDB MySQL Table is full after running billion record

Can anyone tell me what wrong with my mysql cluster? I have a problem while running billion record showing table is full. This is my config.ini on the management node: [ndb_mgmd] ...
0
votes
0answers
13 views

unnecessary MySQL port forwording for WAN connection

I have an application that have MySQL as back-end database server,but while I was scanning open ports using nmap, I recognized that the MySQL port had been forwarded to be accessed over a WAN ...
0
votes
1answer
49 views

how to add kernel command before mysql startup in linux

I want to add these commands to the Linux kernel before mysql startup (at boot time): echo never> /sys/kernel/mm/transparent_hugepage/enabled echo never> ...
1
vote
1answer
44 views

Filtered master-master replication-is it possible?

I got task to configure I think some sort of monster. My boss want to have two mysql servers. Let's say serverA and serverB have databases db1,db2,db3,db4. He wanted that serverA will be master for ...
0
votes
2answers
39 views

Recommended 3x SSD Raid for mysql database [duplicate]

I've been configuring dedicated MySQL server (linux) with 3x 300 GB SSD in SoftRaid. I'm trying to decide which Raid to use to get best performance. I'm expecting this database to be a read-heavy (90% ...
0
votes
0answers
44 views

How do I quickly tell the structural differences between two databases? [migrated]

I am upgrading a web application to a newer version and need to migrate the data manually. The newer version uses slightly different database structure. It has added a few tables, but all of the old ...
0
votes
0answers
22 views

amazon server using RedHat EL 7 on port 3306 so that i can access mysql database remotely

I want to remotely access mysqld on port 3306 but when hen i telnet from public ip address i get a connection time out error. Whats happening here. But within the server telnet is working just fine ...
0
votes
1answer
38 views

MySQL with HAProxy on same server - How to connect from VIP

I am running 2 dedicated servers on which each has HAProxy keepalived running, MySQL in master/master and Apache. Load Balancing for Apache already works, but I can not get MySQL LB running. HAProxy ...
0
votes
1answer
14 views

Mysql Import - You have a error in your Syntax - Workarround

i use a exporter for some mysql data. At first it will create the table and after that insert the data into it. Example Code DROP TABLE IF EXISTS `dbc_Item-data`; CREATE TABLE `dbc_Item-data` ( ...
0
votes
1answer
23 views

built-in php cannot connect to homebrew mysql through localhost on osx mavericks [duplicate]

trying to install wordpress on osx mavericks (with built-in apache+php and homebrew mysql). mysql -u root # connects php -r 'var_dump(mysql_connect("localhost", "root", ""));' # doesn't connect ...
1
vote
0answers
23 views

How to make MySQL Server > 5.5.45 on OS X Yosemite accessible through tcp? [duplicate]

Right now I do a netstat -n | grep 3306 and nothing come. Beside I try to connect using: $ mysql -h127.0.0.1 -u root -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on ...
0
votes
1answer
25 views

Spreading a table's partitions across drives

With nearly a billion rows, we have to split up individual partitions across SSDs with about 4 partitions of them in each SSD. The table's current schema: CREATE TABLE IF NOT EXISTS `a` ( `id` ...
-1
votes
0answers
17 views

Bad chown command crashed mysql [duplicate]

I cd'd to my website subfolder /var/www/example.com and tried to change ownership of it's files by running the following command on my Ubuntu 14.04.2 LTS Server sudo chown -R $USER:$USER /* ...
-1
votes
2answers
20 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

I'm dumb, I did the stupidest thing I could. On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, ...
0
votes
1answer
20 views

apache / mysql unable to connect jails with PF firewall

I have setup two jail environments on FreeBSD11 root@ns312773:/etc # jls JID IP Address Hostname Path 1 10.6.6.6 www ...