MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
0answers
15 views

How to run mysql prompt in windows powershell ISE?

I want to use PowerShell ISE tab to be able to connect mysql client and tun sql statements, however as soon as I connect to client using following command - >mysql.exe ...
0
votes
0answers
11 views

Only Innodb databases locking up [migrated]

I'm trying to troubleshoot my MYSQL in a LAMP and have an interesting situation. At first I thought MYSQL itself was locking up, but it turns out to be ONLY innodb databases that are locking up. ...
0
votes
1answer
27 views

Using lvm2 snapshot of MySQL InnoDB file-per-table, do I need to stop the server for backup?

I've read a bunch of articles on taking consistent backups of mySQL, including What's the meaning of consistent dataset? (MySQL), but I still don't think I know enough to answer this question with ...
1
vote
0answers
15 views

MySQL open_files_limit - cannot change this variable [migrated]

I'm running into issues because my open_files_limit for mysql is only 1024. Centos 7, MySQL Community Server 5.6.22-log It's actually a vps dedicated to mysql for a WHM server (remote mysql), but ...
1
vote
2answers
47 views

How to interpret iostat for a crumbling MySQL server

We have a combined application/MySQL-server which has started to crumble. Right now, it gets stuck on copying a 125 million row MySQL MyISAM table (INSERT INTO a_copy SELECT * FROM a with KEYS ...
1
vote
0answers
43 views

2006: MySQL server has gone away

I am getting 'Lost connection to MySQL server' and '2006: MySQL server has gone away' errors so frequently that the server is unusable. There are questions related to this issue, but none that apply ...
-5
votes
0answers
41 views

Mysql dump failed? [on hold]

My sysadmin made a backup of the DB from another server and imported it into a new one. If I login to phpmyadmin in the new server I see a table in the left column, but if I click into it, it says ...
1
vote
1answer
33 views

Cause of error: Invalid (old?) table or database name 'lost+found'

My MySQL log shows duplicated errors: 141223 5:47:21 [ERROR] Invalid (old?) table or database name 'lost+found' I have a database named #mysql50#lost+found but I cannot seem to delete it. ...
-2
votes
0answers
29 views

Lost connection to database [closed]

I end up with a connection lost to my MySQL database a couple off times a day and the only thing for me to fix this is to reboot the server. Wounder way some part off the server goes down. I even ...
-1
votes
0answers
16 views

sum of multiple products with show rows concerned using array [closed]

I have a table that has 3 products description (Product_1, Product_2, Product_3) and Each product of some reference AND quantity with location of every row Iwant show all rows for product_1, ...
0
votes
1answer
28 views

Moving MySQL files from Mac to Linux

I had a mysql server running on a Mac. Unfortunately, the Mac died. However, I got a backup. I am now trying to restore the server on a Linux machine. I have moved the mysql files located in ...
0
votes
1answer
16 views

File Location of mysql startup script on Ubuntu

When we run a command as "service mysql start" [OR] "/etc/init.d/mysql start", The mysql daemon it starts. Who is providing the job mysql to start to those commands? What is the startup script file ...
0
votes
0answers
35 views

MySQL unable to repair, dump, upgrade table (simply crashes)

I need to backup one of my databases from MySQL (Running MariaDB). The issue is that aside from all of my other databases that backup perfectly fine, this database has issues backing up and crashes ...
1
vote
1answer
32 views

SSH from Windows to Jump Server to MySQL [closed]

We have a MySQL instance running on a Linux machine and had to open a tunnel to access the server. This worked fine until admin decided to add a steppingstone / jump server. Now i can't seem to ...
0
votes
2answers
42 views

“Cannot open SSH Tunnel” on MySQL (corrected)

(help, patience and mercy... begginer lost haha) -Ok heres the deal, im trying to connect a EC2 Instance to MySQL throught SSH in MySQL Worckbrench -I set up the configurations this way SSH ...
0
votes
0answers
23 views

“Cannot open SSH Tunnel” on MySQL [closed]

I have this problem: With this configuration:
1
vote
1answer
55 views

FreeRadius Accounting not working, bad passwords not cheked

I'm trying to configure a captive portal using a router with OpenWRT+ChilliSpot and an external server with Freeradius and a Web Server. ChilliSpot 1.3.0 My issue right now is that the freeradius ...
0
votes
0answers
22 views

Backup MySQL with LVM, questions about the MySQL Session

I want backup my mysql database with lvm. I will do the backup with cronjob. Here the pseudocode Open mysql session Run SQL FLUSH TABLES WITH READ LOCK Do backup lvcreate -l100%FREE -s -n ...
-1
votes
1answer
71 views

Why the time taken to fetch results of a query for 10,000 times from a RDS is so uneven? (experiment)

tl;dr : Why the time taken to fetch results of a SELECT statement for 10,000 times from a RDS when requested from an EC2 is so uneven? Updated the question with results of small and medium RDS ...
0
votes
1answer
27 views

How to generate unique Auto increament id field across multiple data centers?

I have multiple mysql servers deployed in three different data centers. Now my database has few tables with Auto increment id column. I want these columns in all three data center must have unique id ...
-1
votes
0answers
7 views

How to configure database loadbalacer and fail over with master slave configuration

I have a web application written in java with Mysql database. I want to ensure high availability of my database server, hence i have configured master-slave replication mode. All my reads goes to ...
0
votes
0answers
21 views

Forward traffic to MySQL over two+ SSH hops

I am trying to get from my computer through a gateway VPS to the database VPS and leave a forward port open back to my computer so I can access MySQL. For example, using port 9999 on my machine I was ...
-1
votes
1answer
26 views

MySQL - data inside vm on shared storage? [closed]

I'm planning on moving all my VMs to shared storage, and I have a question about how to deal with a MySQL VM: Currently the size of the VM image is 100GB, where most of the space is taken up by the ...
1
vote
2answers
44 views

Can't connect to MySQL from another server

I have two servers on the same subnet. 192.168.100.1 (mysql) 192.168.100.2 (php) MySQL seems to be running fine on it's box but I can't seem to connect to it. These are both ubuntu boxes and ...
0
votes
0answers
14 views

25.000+ rows - MySQL SELECT consecutive numbers performance issue [migrated]

I have tried to be as explicit as I could. Below you have the query explained in details What I want to obtain? - I want to SELECT start_number and end_number from a set of consecutive numbers ...
2
votes
2answers
141 views

No changes made but MySQL InnoDB overloading CPU

I haven't changed any scripts or settings what so ever. Now I have CPU load at least 4 times higher. Mysqld is taking around 360 %CPU according to TOP. It's Debian, I'm running some MyISAM tables but ...
0
votes
0answers
7 views

Installing MySQL with Macports on Yosemite [migrated]

I am following this tutorial Step 3 (Install MySQL) but it's failing. I am running Mac OS X Yosemite and have freshly installed Macports 2.3.3-10.10. sudo port install mysql51-server failed with "All ...
0
votes
1answer
64 views

ERROR 1130 (HY000): Host 'host' is not allowed to connect to this MySQL server, only on slave

So I have a master and a slave in a mysql cluster, the syntonization works as it should however I am not able to connect to the slave from any host except from the server it self. I have no problems ...
0
votes
2answers
29 views

Running 'show process list' simultaneously

I have two scripts put into a cron that runs every single minute. Both the scripts connect to the same database and runs a show full processlist. Is it okay if two show full processlist commands are ...
-1
votes
0answers
21 views

MySQL cluster replication merge [migrated]

We'd like to have two MySQL cluster groups, and at the same time have replication set up between them. Is that possible?
-1
votes
0answers
35 views

Best practice to provide MySQL access to my users

My application collects data and stores it in a MySQL database. I want to provide read access to my users. I previously had a VPS with cPanel. I set up a read-only mysql user and distributed the ...
-2
votes
3answers
114 views

I can not do anything with mysql [closed]

Debian woke up in a bad mood. I worked on it until 9pm yesterday using LAMP. The process that I made yesterday to today was off and on the machine. When I called today mysql just does not work. Follow ...
-1
votes
0answers
17 views

Ubuntu 12.04 cant start mysql server after changing permissions

I've changed /var/lib/mysql/* ownership to my user in order to sftp files to other machine. After that I've change it back to mysql:mysql (I think that this is what it was before), but I can't start ...
-1
votes
0answers
16 views

How to slow down MySQL service autostart on boot (dependency on another service) [migrated]

I'm running a MySQL database on Debian on RaspberryPi (Raspbian). I would like to use the RaspberryPi as a local MySQL server, but to have the MySQL database datadir outside RaspberryPi's SD card - ...
-1
votes
1answer
70 views

Mysql crashing/restarting, InnoDB: Unable to lock ./ibdata1. Can't kill via 'stop';

My server seems to crash/restart under a load that would not have previously made it crash. How can I troubleshoot this? VPS is running Centos 6.x, 8GB ram Mysql is crashing/restarting itself ...
0
votes
1answer
64 views

Postfix MySQL Dovecot Roundcube configuration

I am in the process of setting up a mail server and I was hoping to get some help. It starts with Roundcube webmail, when I tried to login with an existing correct user name and password it gives me ...
0
votes
1answer
49 views

Mysql crashed, dumped DB's in recovery mode. What now?

I ran into an InnoDB issue that only seemed to get worse as I tried to fix it. Started with InnoDB: Unable to lock ./ibdata1, error: 11, I moved and then copied it back. I soon had an ib_logfile issue ...
-2
votes
0answers
25 views

All files wiped, Cannot access phpMyAdmin [duplicate]

I have had a lampp server running fine for months until the other day when i went to check on my website and when typing in the web address (samvella.co.uk) I can just see some directorys. All of the ...
0
votes
0answers
37 views

How to change the execution time of the my.ini file using Chef

I'm attempting to get an existing Drupal site set up using Vagrant Drupal Development but have come across a few problems. My first is that I cannot seem to connect to the database to import my SQL ...
0
votes
0answers
50 views

MySQL Error 1114 the table is full

I've got a MySQL cluster where I build a new database for each customer. The databases are relatively small in size and I currently only have 4 databases on this cluster. I just tried to run my ...
0
votes
1answer
64 views

mysqldump running extremly slow

I posted this in stackoverflow but it rightly got moved (apologies about duplication!) I'm testing a new set of db servers on dell m820s running esx5.5 with debian wheezy using ext4 as a VM on each ...
0
votes
0answers
18 views

mysql: relocation error after installing in centOs?

I remove any mysql package and now after installing mysql after type this command mysql -u root -p this error occured: # mysql -u root -p mysql: relocation error: mysql: symbol strmov, version ...
-1
votes
1answer
44 views

Can't install mysql in centos6.4

When i try to install mysql 5.6 and i remove mysql 5.1 from centos now not installing any mysql in my VPS. yum install mysql-server Loaded plugins: fastestmirror, refresh-packagekit Setting up ...
0
votes
1answer
23 views

It is possible having MySQL server and MariaDB server together in the same Ubuntu 14.04 using official packages?

It is possible having MySQL server and MariaDB server together in the same Ubuntu 14.04 using official packages? I want to have both servers running in the same machine, using different listening ...
-1
votes
0answers
32 views

dropping tables with bigger size [migrated]

We have a mysql database with a size of 2 TB, in which we have for to five big tables ranging from 110GB to 350GB. When we try to drop these tables the mysql goes to the defunct mode and hangs in that ...
-1
votes
1answer
28 views

Unable to import dump.sql via a .sql file which will be run through mysql command line

I have a MySQL database that contains almost 100 tables. I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to ...
-1
votes
0answers
19 views

What specs does apache need to handle 1000 active users [duplicate]

My VPS is hosted through digital ocean. I know there can be many factors to this, but would like a ball park as to what i need to do. I am prepping for a busy season next April and my web server ...
0
votes
0answers
12 views

Web Based Server Monitoring and Alerts For In-house server [duplicate]

I'm currently working on a project that has an in-house set of CentOS 6.5 servers for both Apache and MySQL. What happens is that it doesn't have a monitoring system so, if it happens for the server ...
-1
votes
1answer
27 views

Error when setting up mysql cluster

I am trying to set up the mysql cluster. But when I try to start the mysqld(API) node, I get this error: 2014-12-02 17:02:37 0 [Warning] Using unique option prefix key_buffer instead of ...
0
votes
1answer
59 views

MySQL/MariaDB stops running. How do I find out why?

Today I've seen MySQL/MariaDB stop running on a CentOS VPS. When I check the status I get: # service mysql status ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists So I ...