MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-2
votes
0answers
12 views

My website is responding very slow. MySQL eating alot of much CPU

I have hosted only one website on my server and its database is also not much big. The size of database is only 80-90mb and 1 table only. The specification of server is following. Server ...
-1
votes
0answers
13 views

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

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
23 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
14 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
15 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
31 views

SSH from Windows to Jump Server to MySQL [on hold]

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
38 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 [on hold]

I have this problem: With this configuration:
1
vote
1answer
42 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
19 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
63 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
25 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 ...
-2
votes
0answers
21 views

After Max OSX Server App Update SQL ERROR [ mysqli ] No such file or directory [2002] - Webforum is not running [closed]

I have a problem with my Webforum. This is running under Mac OSX Server App, and after a Update of the Server App, my Webforum is now down. There is a error message, when I go to the website SQL ...
0
votes
0answers
20 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
41 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
137 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
53 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
27 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
34 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
108 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
54 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
50 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
46 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
34 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
42 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
63 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
15 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
29 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
24 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
24 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
52 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 ...
-1
votes
0answers
32 views

Horribly slow MySQL (InnoDB) updates, multiple workers [migrated]

I've created a PHP daemon that reads records from a MySQL InnoDB-table, analyses it and then updates the record. This process is spread between multiple workers (and servers) using Redis. However, ...
1
vote
1answer
31 views

MySQL Replication Logs Filling Partition

We have MySQL replication setup from site-to-site. The slave is just a backup used for reporting etc(No write). Everything is going well as far as I can tell. However, the server is quickly running ...
1
vote
0answers
50 views

R1Soft MySQL Failed to perform discovery on database instance

I am using R1Soft (5.8.1) for file backups on a few servers and have tonight been trying to setup a MySQL backup - I installed the driver etc and am setting up the policy but am getting an error. ...
0
votes
2answers
36 views

Tunnel Connection Error with Mysql Workbench (Host key does not match)

I have an issue with Mysql Workbench which is probably a bug. I'm using EC2 with elastic IPs. I changed my server, but kept my keypair and IP the same. So it should connect as usual via SSH tunnel. ...
0
votes
3answers
102 views

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I've developed a website on the Silverstripe framework and deployed this to a digital ocean server using centos (7.0.1406) , mariadb (10.0.14) and apache (2.4.6). I'm somewhat of a novice when it ...
1
vote
0answers
15 views

PhpMyAdmin and auth_ldap plugin

I have a need to authenticate MySQL users from an LDAP source using the community edition of MySQL Server 5.5. The auth_ldap plugin has been compiled from source ...
0
votes
1answer
21 views

mysql grant select to ONE table on ALL database

I have many tables with the same table structure. I want to create a user which can access one table in all of those databases. We are adding new databases frequently, so a wildcard would be ...