MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

8
votes
2answers
3k views

Mysql Slave stuck in “System lock”

My MySQL slave is spending a lot of time in Slave_SQL_Running_State: System lock. I can see that the system is currently I/O write bound, and that it is processing the log, although slowly. Show ...
1
vote
1answer
511 views

Too many instances of httpd and mysqld

I have a VPS with 4 GB of ram and 8 cores and about 200K Visits per day. I have DirectAdmin Installed and I always see a huge number of PIDs for httpd and mysqld in DirectAdmin Service Monitor. e.g. ...
1
vote
1answer
30 views

MySQL PID Errors

While attempting to change the MySQL server timezone to CDT to match the Centos sytem time, something has messed up. I edited the my.conf in /etc/ in vim logged in to SSH as root, and saved it. On ...
0
votes
2answers
1k views

MySQL connecting issue with Zend App

I've set up a VirtualHost on my local machine (Windows XP with XAMP installed) and installed Zend there as well, now I'm trying to connect to the MySQL database and I get the following error message: ...
22
votes
4answers
27k views

How do I load a sql.gz file to my database? (importing)

I'm trying to import a gzipped SQL file into mysql directly. Is this the right way? mysql -uroot -ppassword mydb > myfile.sql.gz
1
vote
2answers
982 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 ...
0
votes
2answers
1k views

HAProxy + Percona XtraDB Cluster

I am attempting to setup HAproxy in conjunction with Percona XtraDB Cluster on a series of 3 EC2 instances. I have found a few tutorials online dealing with this specific issue, but I am a bit stuck. ...
1
vote
3answers
2k views

MySQL-5.5.10 - Lost connection to MySQL server during query (Both Web Clients and MySQL Slaves)

We've just upgraded our existing MySQL5.1 DB servers to newer (much better) hardware with MySQL 5.5, and things have been going mostly smoothly for almost 6 weeks. Just the last few days, I've ...
0
votes
0answers
12 views

Can't enable binary logging (“index not found”) [migrated]

I have a MySQL 5.5.41 server running on Ubuntu 14.04 that already contains several databases of data, and I would like to enable binary logging. I want the binary logs to be placed in their own ...
0
votes
0answers
22 views

How to fix hung requests creating dead lock(/root/syn)?

We are running a search service using written in Java using solr We are noticing dead locks on the service. 14:00:30,465 WARN ThreadPoolAsynchronousRunner:416 - Task ...
-1
votes
0answers
14 views

What type of server is right for my requirements? [IOS Application API] [duplicate]

I am preparing for the startup of my iOS application. What type of server would be the best for my requirements. REQUIREMENTS MySQL DB PHP GET/POST Requests Sufficient Storage for Images Good ...
3
votes
2answers
19k views

RSA certificate configured for SERVER does NOT include an ID which matches the server name

I recently started a LAMP server (all the latest versions) w/ WordPress on it, and I'm trying to install a SSL certificate that I recently purchased. When I restart apachectl, error_log gives me this: ...
0
votes
1answer
22 views

cant turn on mysqld. I moved mysql to an XFS directory and pointed it there

hey guys hopefully someone has the answers for this but these are my errors ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) and in my ...
0
votes
3answers
2k views

OpenVZ MySQL InnoDB won't start

I have a OpenVZ Server with 4GB RAM and have tried to install MySQL on several distros (Ubuntu 12.04 64Bit, Ubuntu 12.10 64Bit, Debian 7 64Bit) and I always get the same errors: 130718 6:57:27 ...
0
votes
2answers
40 views

Protecting mysql instance on Linux Azure VM

I have mysql running in a Linux Azure VM. It's currently bound to the "Internal IP Address" of the VM as looked up in ifconfig and the Azure Dashboard. I've turned on logging to see who and what is ...
1
vote
2answers
1k views

When to increase AWS RDS MySQL Server instance to larger CPU/RAM?

I'm wondering at what stage do I need to increase the image for the RDS MySQL server to a larger CPU/RAM instance. The CPU utilization graph is near 0. The Avg Free Memory is around 150MB. The Avg ...
0
votes
2answers
2k 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 ...
0
votes
0answers
2k 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) ...
8
votes
3answers
7k views

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote mysqld to use them (and ssl is enabled) I ssh into my remote server, and try connecting to its own mysqld using ssl (mysql ...
0
votes
2answers
79 views

MySQL: I omitted a space--what did I do?

I'm curious and learning...this is non-urgent On a production server running 19 databases I entered this typo mysql -uroot-p[passwd] ^ omitted space I soon enjoyed a solid 12 seconds ...
-1
votes
0answers
30 views

High memory usage (compared to wamp) and unresponsive site at times

Lately my site (with 260000 posts, 12000 images, 2,360,987 mysql rows and 450.7 MiB size) is running slow and at times not loading for many mins I installed this Debug bar plugin ...
0
votes
1answer
2k views

Run mysqld under a different user (linux)

I've been trying to start mysqld under a different user as well as with a different data path. I've done so by modifing the my.cnf file as follows: [mysqld] datadir=/bob/database ...
0
votes
0answers
24 views

Import outdated MySQL dump using console

I have a mysql dump file created by outdated MySQL version. I have no access to that server (console). If i use this command on my current server: mysql -u user -p dbname < dump.sql I get this ...
0
votes
0answers
34 views

Port 3306 for MySQL closed

It seems that the port 3306 for remote MySQL access is closed on my server. In /etc/mysql/my.cnf I changed the bind-address setting to my remote IP already and restarted the server. A nmap scan of ...
0
votes
1answer
26 views

MySQL Bad Handshake to MySQL Cluster behind Proxy

I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine ...
0
votes
1answer
49 views

Is it better to drop a MySQL database before doing a restore?

I have been doing a ton of database restores lately and have been thinking about better ways to do things. One thing I am not sure of is what is the best order of operations in terms of backup and ...
0
votes
4answers
248 views

telnet cannot connect to port without firewall

If I try to connect to MySQL with telnet myhost.com 3306 I get a network not reachable error, even when I flush all iptables rules. I can reach other ports like ssh (with the same iptables rules ...
0
votes
0answers
224 views

MariaDB crashing with “Assertion failure in thread xxx in file rem0rec.cc line 580”

I have three MariaDB servers set up in a Galera cluster. I use one server at a time as a "primary" master (i.e., Galera is just for failover, the app doesn't actively use multiple masters). About ...
-3
votes
0answers
16 views

Reducing query cache for mostly INSERT-heavy database? [migrated]

What sort of MySQL query cache should I choose considering the following... Large, rapidly growing database (I got 500,000 rows). UPDATEs practically never happen. SELECTs are rare, but when they do ...
0
votes
2answers
48 views

How to install only mysql client on solaris?

I have a mysql server already running on RHEL 5 server. I have other Solaris 10 and Solaris 11 machines (SPARC based T4-4 servers) which need to connect to the server. I downloaded a pkg ...
-1
votes
1answer
20 views

Need help importing data to new SQL server from MySQL folder

My hard drive crashed, and can no longer write, but it can still read. Because of this, I was unable to export my SQL database to an .sql file for later importing. I can still access the drive, and ...
-2
votes
0answers
30 views

MySQL table doesn't exist [migrated]

What I did before the disaster was: vi /etc/my.cfg I added innodb_buffer_pool_size=4G innodb_buffer_pool_instance=2 innodb_read_io_threads=12 innodb_write_io_threads=12 innodb_io_capacity=300 ...
0
votes
3answers
4k views

Cannot find libmysqlclient when compiling php5 on dreamhost [closed]

I'm trying to compile php5 on dreamhost, after doing what http://wiki.dreamhost.com/index.php/Installing_PHP5 said, I had compiled all the components except php5 itself. When running $ ./configure ...
5
votes
4answers
4k views

From a shell script, how can I check whether a table in MySQL database exists or not?

I am trying to write a script which allows a user to select the what manipulation he needs to do on a table. I want to check if the table exists or not. If it exists I will continue the other things ...
-3
votes
1answer
41 views

MySQL backups of information_schema? [closed]

When performing routine MySQL backups (using mysqldump), should I be including information_schema? Isn't it just meta information? I've seen multiple suggestions to ignore the mysql and ...
0
votes
1answer
26 views

mysql command in command line return unknown variable

When I try to use: mysql -u [user] -p command (or any other "mysql") at my Debian server command line I get this error: mysql: unknown variable 'log=/var/log/mysql.log' mysql-client is ...
-1
votes
0answers
21 views

Connect EC2 with RDS

I am trying to move my CMS from 1&1 to AWS. The CMS was built using PHP + MYSQL. I have completed the following steps in AWS - I created an EC2 instace I uploaded a php script to test if ec2 ...
0
votes
3answers
81 views

Offline mysql dump

I'm hosting a 60GB InnoDB file-per-table MySQL database with a VPS provider. I want to generate a dump of the file. Running mysqldump makes the website connected to this database extremely slow, ...
2
votes
2answers
2k views

Unable to connect to any of the specified MySQL hosts. when trying to connect mysql

im using go daddy vps , installed mysql configured /etc/my.cnf to look like this: [mysqld] user=mysql datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock port=3306 # bind-address=1xx.1xx.1xx.148 ...
1
vote
1answer
1k views

InnoDB “log sequence in the future!” crashing, won't start

I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when ...
0
votes
1answer
903 views

Apache not loading: libmysqlclient.so.18: file too short

I have installed MySQL and PHP, and I tried restarting apache and here what happens when I run # service httpd restart: Stopping httpd: [FAILED] ...
1
vote
0answers
38 views

Made changes to my.cnf and mysqld wont restart - no backup [migrated]

I thought I'd be clever and update my.cnf file to add ft_min_word_len=2 and didn't back it up first. I will never make that mistake again. Luckily, our project is still in production and no harm done. ...
0
votes
1answer
41 views

Clustring haproxy + Apache + MySQL

Im new to clustering, So I started my LAB using linux centos, My schema is : 2 Load balancers, 2 Web servers (apache), 2 MySQL DBs (separated). I configured the 2 LBs and 2 Webs, the load balancing ...
4
votes
2answers
3k views

AWS RDS MySQL / Slow Query Log

I'm trying to analyze slow queries on my system and I read that I should enable the "Slow Query Log'. I curious how I can I view this log when I'm using an instance of MySQL hosted on Amazon Web ...
0
votes
1answer
36 views

Current setup maxing CPU. Need help designing AWS architecture and MySQL Clustering via AWS RDS instances

My company runs a mid-sized eCommerce (30,000-50,000 unique views monthly) shopping cart using X-Cart as a back-end. We are in the processing of redesigning and upgrading our back-end software. We are ...
0
votes
1answer
23 views

MySQL Cluster ndb_restore fails without error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
0
votes
2answers
1k views

MySQL Memory Limit Windows Server 2003

I am running MySQL 5.0.51a on Windows Server 2003 Standard Edition on an HP DL580 G4 with 3GB installed. One of my database tables has grown to 5.3 GB with an index file of 2.5 GB, which I believe is ...
0
votes
0answers
15 views

MySQL ODBC DSN ignoring IP address of server - Windows 7

I'm trying to create an ODBC connection to a MySQL server on my network. I can create the DSN but when I click test I get an error (HY000) Access denied for user user@localhost despite the fact that I ...
0
votes
0answers
43 views

Connect to a Server from my AWS EC2 instance

I have a app running on AWS EC2 which connects to a database in another server. The database connection Uri is as following, jdbc:XXX:172.18.2.107:3306/database This is what I got form my ...
2
votes
3answers
1k 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, ...