MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-1
votes
0answers
20 views

Unable to connect to MySQL with Iptables

I have a web server, lets say its IP is 10.0.0.2 and a separate MySQL server on 10.0.0.3. On the MySQL server I have the following firewall rules: # enable all traffic and delete existing rules ...
0
votes
1answer
915 views

MySQL port 3306 became filtered when configured with Keepalived on Ubuntu server 12.04 lts

I'm configuring two load balancer (lb01 & lb02) with keepalived for my two mysql server (db01 & db02) with standard port 3306. There is virtual ip address (192.168.205.10) to access it also ...
0
votes
1answer
1k views

/usr/lib/libmysqlclient.so.18: no version information available (required by /usr/bin/searchd)

Recently I have a problem with sphinxsearch and mysql: Restarting sphinxsearch: /usr/bin/searchd: /usr/lib/libmysqlclient.so.18: no version information available (required by /usr/bin/searchd) ...
0
votes
3answers
418 views

Mysql killing the CPU with gettimeofday

I have a problem with mysql killing the CPU on a Debian Squeeze 64. This is a development machine on a VPS so I stopped all the other services, including apache2. The mysql version is 5.1.49. This is ...
1
vote
1answer
1k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have MySQL installed on Ubuntu 11.10. I has been working fine for months but yesterday I started getting the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
2k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
0
votes
2answers
2k views

How to install MariaDB rpms in CentOS 6.4 using rpm (not yum cmd) + handling mysql-libs conflicts

I need to script the install of MariaDB using the rpm command in CentOS 6.4. I can't use yum since it's going to be an offline install so there's no access to the repository. The only MySQL package ...
2
votes
3answers
953 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, ...
-2
votes
0answers
30 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
vote
0answers
45 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 ...
1
vote
2answers
49 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 ...
0
votes
0answers
19 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. ...
3
votes
1answer
1k views

Why does “commit” appear in the mysql slow query log?

In our MySQL slow query logs I often see lines that just say "COMMIT". What causes a commit to take time? Another way to ask this question is: "How can I reproduce getting a slow commit; statement ...
0
votes
1answer
29 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 ...
-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 ...
0
votes
1answer
1k views

Can't allocate nodeid for API

I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the ...
1
vote
1answer
37 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. ...
0
votes
1answer
1k views

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
1
vote
2answers
313 views

MySQL Migration Toolkit syntax error when creating Sql Server diagram object

I have another syntax error when migrating a diagram. I'm not certain this diagram is necessary, but it would be nice to have a smooth migration, and this is all that's standing in the way. The error ...
3
votes
6answers
9k views

IO Wait causing so much slowdown (EXT4 JDB2 at 99% IO ) During Mysql Commit

I am writing an indexer, using python, which indexes documents and insert them into Database, Before it was single process but now i made it to multiprocessing with 4 parallel processes running.After ...
-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, ...
-2
votes
1answer
1k views

phpMyAdmin displays blank page

I have gone through all links related to a blank page displayed by phpMyAdmin but none of them helped my solve my issue. I have installed phpMyAdmin and deployed it on the Apache server. I have also ...
0
votes
2answers
841 views

mysql multi threading for a single query

I have big db of size 8GB and having 9 million contacts in this db. When we try to retrieve all contacts, it takes nearly 1 or 2 hour (in some cases result in timeout) to retreive all contacts for the ...
1
vote
1answer
867 views

MySQL Database synchronizing with local and remote with c#

I've posted this here as its more of a mysql questions than c#, I have written some software that runs a local instance of mysql when it first starts, now once mysql is up I would like to synchronize ...
0
votes
3answers
2k views

MySQL my.cnf file not being read, Ubuntu 10.04 64bit

I've been researching this for a few hours with no luck. Basically it looks like my server's my.cnf file isn't being read at all. I've searched my server, and there's only one my.cnf file on it, ...
0
votes
1answer
29 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 ...
1
vote
1answer
56 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
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
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 ...
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 ...
1
vote
1answer
2k views

Mysql - innoDb - is in the future! Current system log sequence number

I have this error in my syslog. I restored an older dump to solve this problem, after some reading. Now The errors in syslog are far less than before. But still a few times an hour I get Sep 1 ...
0
votes
0answers
36 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
votes
2answers
43 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 ...
3
votes
1answer
985 views

vsftpd - PAM - MySQL and pam_mkhomedir to create directories

I've been successfully using vsftpd with virtual users connecting with PAM to my mysql DB. Now I'd like to automate creation of user directories with successful vsftpd connection. Here is ...
2
votes
3answers
6k views

too many 408 error codes in access log

Apache access log is showing too many 408 error codes,nearly 400 per day. x-x-x-x - - [25/Apr/2012:22:43:06 -0600] "-" 408 0 "-" "-" there are around 400 of these kind of request from different ip ...
1
vote
2answers
987 views

Horrible PHP/MySQL Query Performance On Ubuntu Server 10.04

I just did a clear install of Ubuntu Server 10.04 with the standard LAMP config.. Then I made a small script to test insert speeds into a table with 3 columns. When I run the script on any of my ...
0
votes
1answer
898 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 ...
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
vote
2answers
4k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
3
votes
1answer
872 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 ...
-1
votes
1answer
73 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
2answers
1k views

Getting shared library error with php and mysql module on centos

I first installed php5.5 and mysql5.6 then due to some pacakge problem i had to remove them and install php5.3 and mysql 5.1 from yum. I php is not detecting any extensions and giving me this error ...
4
votes
3answers
7k views

MySQL simple replication problem: 'show master status' produces 'Empty set'?

I've been setting up MySQL master replication (on Debian 6.0.1) following these instructions faithfully: http://www.neocodesoftware.com/replication/ I've got as far as: mysql > show master ...
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
1answer
1k views

How Do I Restore a MySQL Database from Time Machine Backup?

I develop locally on a Mac, and my computer completely died yesterday. The hard drive is gone, apparently not recoverable. I have a current backup on Time Machine. So my question is: How exactly do ...
1
vote
1answer
4k views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
0
votes
1answer
28 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 ...