MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

2
votes
3answers
976 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, ...
1
vote
2answers
816 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 ...
1
vote
2answers
55 views

Getting no query results in email

This is the powershell script below. I am trying to export the query's results into email body. However, the email contains nothing except the table headers. Could anyone help out what could be wrong ...
-1
votes
0answers
7 views

Application Instantiation Error: Could not connect to MySQL [on hold]

150129 6:33:39 InnoDB: 5.5.39 started; log sequence number 71735211 150129 6:33:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 150129 6:33:39 [Note] - '0.0.0.0' resolves to ...
0
votes
1answer
1k views

Can not restart mysql service after getting Error 2002 Can't connect to local mysql server

Starting yesterday, I'm getting this error when connecting to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I haven't touched my ...
1
vote
0answers
15 views

200 OK blank page setting up Wordpress on restore test VM

I'm testing a partial backup of a frankly rather outdated (legacy, what can you do?) CentOS/Apache/MySQL/PHP/Wordpress server by restoring to a VM with a fresh copy of the relevant packages. After ...
1
vote
1answer
24 views

Timed windows server event to prepare csv file for third party FTP collection

I hope this is posted in the correct forum. I have a Windows 2008R2 web server that runs MySQL. I need to execute a SQL script against the mysql database to create a CSV file, and save to a defined ...
0
votes
1answer
897 views

MySQL Performance Report for Magento [on hold]

We are running Magento 1.7 and created below reports from two different script. Can you please help me if I need to change any values in my.cnf. to get the best out of the server. Magento 1.7.0.2 - ...
0
votes
0answers
15 views

pam_mysql missing in CentOS 7

So it looks like in Centos 7 the pam_mysql package has been removed from EPEL, but I'm still in need of this package do to my reliance on a remote mysql database used for vsftpd. I stumbled on a ...
0
votes
3answers
1k views

ERROR: The partition with /var/lib/mysql is too full!

I am running in a problem here I have a linux instance running on EC2. All was working fine till last night. Today morning it showed me some error stating that there was no disk space to write of ...
0
votes
2answers
1k views

Reinstall MySql AND keep existing database tables and data

Please help! There are server issues and MySql is no longer running on our server (Ubuntu). The service is not recognized and needs to be reinstalled. Unfortunately, the database has not been backed ...
0
votes
1answer
22 views

Can't connect to local MySQL via TCP (Error 1045)

root@127.0.0.1 exists, but still can't connect to local MySQL. It looks like MySQL verifies hostname instead of lo ip(127.0.0.1). root@castle /v/l/mysql# mysql -u root Welcome to the MySQL monitor. ...
-3
votes
1answer
29 views

bash script mysql reset pass

It seems that this code is not working I tried using it on my debian 7 machine and the password it gives me is wrong. # Please confirm that you want to reset the MySQL passwords CONFIRM="n" echo -n ...
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
1answer
81 views

Upgrading mysql release from 5.1.41 to 5.1.5

How do I upgrade the release for mysql server? I want to upgrade from 5.1.41 to 5.1.5 Do I have to do an entire reinstall?
1
vote
1answer
1k views

MySQL on Linux out of memory

OS: Redhat Enterprise Linux Server Release 5.3 (Tikanga) Architecture: Intel Xeon 64Bit MySQL Server 5.5.20 Enterprise Server advanced edition. Application: Liferay. My database size is 200MB. RAM ...
0
votes
0answers
29 views

CentOS MySQL Problems

Im having trouble with MySQL on my centos5 server. When I try to connect to the server I receive the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
21 views

Configure inbound email using postfix

Postfix logs show "unknown user" when I send what I would expect to be a local user. I have the users specified in a mysql database and postfix has been compiled with mysql support. Other variables ...
12
votes
5answers
34k views

How can I show mysql locks?

Is there anyway to show all the locks that are active in a mysql database?
0
votes
0answers
16 views

MySQL suddenly 'crashed' but not stopped, mysqld_safe 100% cpu on CentOS 6

Suddenly, today i see the website down. Checking the cpu with "top" in command, i found the mysqld_Safe at the top using all of the cpu. After some google i found some different solutions, i made a ...
1
vote
1answer
38 views

Low load average, but high %user and %system cpu usage

Summed up question: Why do we see one set of servers perform significantly worse with the same database and workload as others? Symptoms other than longer execution time is low (near zero) load ...
1
vote
0answers
20 views

Performance: Generating up to 2000 rows and email deliveries

I guess this belongs here better than in StackOverflow. I have the following scenario: Small database with users ( around 2000 only ) information, they participated in an event last year. This year ...
0
votes
1answer
946 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
0answers
36 views

How to reduce Tomcat response time (OR increase throughput)?

I have Tomcat 8 and MySQL 5.6 running in 2 Azure virtual machines (8 cores and 28 GB RAM). My web application provides a REST API to insert several data fields into DB. The application uses a common ...
0
votes
0answers
9 views

Install latest mysql 5.6 update (update 19 to update 22) on Ubuntu 14.04

A while ago I installed Mysql 5.6.19 via "apt-get install mysql-server-5.6" on a Ubuntu 14.04 amd64 server, now I want to upgrade this Mysql 5.6.19 to the latest stable update (5.6.22). I can't do it ...
0
votes
1answer
23 views

'> instead of -> in mysql command line client?

Im using mac os terminal to insert data into the table of mysql database. I accidentally pressed something and instead of -> now i see '>. I have no idea what it means, what is it and how can i get ...
0
votes
1answer
30 views

MySQL replication or MySQL cluster?

Currently i'm running Rails 3 web application with MySQL on one first server and Rails API application on second server that connects to the MySQL database from first server. I'm not happy that API ...
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 ...
0
votes
1answer
26 views

How to overwrite the database name set in the .sql file when importing

Well I have .sql files which create their own new database when importing because they CREATE DATABASE /*!32312 IF NOT EXISTS*/ `something` /*!40100 DEFAULT CHARACTER SET$ USE `something`; i'm ...
0
votes
2answers
41 views

Yum: No package mysql-server available in Cent OS 7

I just installed Apache on my new Digital Ocean Cent OS 7 x64 server. When following Digital Ocean's tutorial, yum cannot install mysql-server. # yum install mysql mysql-server mysql-libs ...
0
votes
0answers
16 views

Can I get a running list of executed queries from mysql to trace problems?

This question was formerly: "Mysql replication logs are filling disk and halting server". However, I'm asking the community if there is a command line trace or live log that I could tail -f and see ...
-4
votes
0answers
28 views

Need assistance on MySQL configuration [on hold]

We are currently using the latest version of MySQL, with recent traffic increase to our website its now taking down/lagging the server due to too many MySQL requests. We run a website on Wordpress. ...
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 ...
2
votes
1answer
14 views

Splitting MySQL General Query Log by Clients

I would like to know a solution to splitting very large MySQL general query logs by specific clients that have accessed the server. Ideally a separate log will be created for each client. Thanks
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 ...
-1
votes
2answers
57 views

Data lost in MySQL DB when roll back happened after system restart [closed]

Few days back due to electricity outage, client's system got restarted, resulted in DB rollback. But due to this roll back, we lost around 2k existing records from various tables.( which were already ...
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
2answers
743 views

MySQL Fixed-Length and Variable-Length Columns?

I'm trying to generate a little more performance from a particular table full of hundreds of thousands of rows. There are a few VARCHAR fields that I'm converting to CHAR. I'm aware that I won't get ...
-2
votes
0answers
17 views

INNODB failure in MYSQL

I had faced an issue in INNODB Engine, but it get solved, when added buffer memory in /etc/my.cnf file, but there happened an unusual thing that the .HTACCESS file of some domains get modified as the ...
4
votes
4answers
2k views

How to backup big MySQL database on Linux

I want to backup MySQL database which is around 200GB. How should I do it? Using mysqldump - I feel backing up 200GB database on which there are continuous writes are going on. Is it a good idea? I ...
2
votes
2answers
254 views

Centos/MySQL server high load

I currently run a website we get about 15,000-20,000 hits a day. We currently run a very active forum, that is hosted using Vbulletin software. We have 4.5 Million Posts, 80,000 Threads, with about ...
0
votes
1answer
32 views

CRUD with MySQL Master-Slave Architecture

I have setup mysql master-slave replication with 1 master and 3 slaves. Now that I have finished setting up the architecture I am curious as to the best way to make my reads. I realize all writes, ...
0
votes
0answers
15 views

Linked Server Mysql to SQL Server 2008 32-Bit

I have an SQL Server 2008 64 Bit and a Mysql-Server, and would like to use a Linked Server. However I need the 32-BIT Mysql ODBC Connector for an extern Application. When I would like to connect to ...
0
votes
1answer
909 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
1answer
15 views

Size of MYI index smaller on slave server

I've recently altered a huge MyISAM table (80 million entries) by adding a new value in an enum field. After I did this I've checked the health of the table on 2 slave servers which are used to ...
-3
votes
0answers
38 views

mysqli phpmyadmin Seems to be something going on here [closed]

Oddly I can find no help with this issue. I have a developer here who wants to use phpmyadmin. So I set it up on our server and get some errrors. I updated everything I get some errors. I swear some, ...
0
votes
0answers
16 views

How to recover MySQL database on xampp/windows using ib/frm files? [migrated]

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
0
votes
1answer
2k views

can't start mysql due to: Manager of pid-file quit without updating file

I can't start mysql due to this error: ERROR! MySQL manager or server PID file could not be found! Starting MySQL.. ERROR! Manager of pid-file quit without updating file. how can I fix this ...
0
votes
1answer
93 views

Incrementing values, alternate way of doing this that won't use MySQL

I need to count impressions of a .php script that is accessed via web. Right now I do this in a 1 line MySQL table and just increment the value. This works fine usually but when the server has traffic ...
0
votes
1answer
2k 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 ...