Questions tagged [mysql]
MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.
472
questions
5
votes
1
answer
7k
views
Finding out what causes CLOSE_WAIT connections with Apache & PHP & Mysql
First, here is a little bit of context.
We have a custom built PHP application that runs under Apache and that supports our website.
We are currently experiencing a high traffic on our website. ...
- 51
5
votes
2
answers
9k
views
mysql wont stop, mysqld_safe appeared in top
my server (CentOS) contains lots of website, which collect data from lots of sources with cron. the mysql config is the default
recently, PHP failed to communicate with mysql. Firstly I just restart ...
- 51
5
votes
2
answers
6k
views
MySQL: how to enable Slow Query Log?
Can you give me an example on how to enable MySQL's slow query log?
According to the doc:
As of MySQL 5.1.29, use --slow_query_log[={0|1}] to enable or disable the slow query log, and optionally --...
- 3,130
5
votes
2
answers
4k
views
INNODB mysql. Plugin disabled [duplicate]
When I startup mysql on my unbuntu server I will get a message.
121122 17:39:37 [Note] Plugin 'FEDERATED' is disabled.
121122 17:39:37 InnoDB: The InnoDB memory heap is disabled
121122 17:39:37 ...
- 51
5
votes
2
answers
1k
views
Is it possible to install MySQL extensions on Amazon RDS?
We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS.
Unfortunately there is a functionality called Median that MySQL is missing. Our ...
- 1,675
5
votes
3
answers
11k
views
ERROR 2002 (HY000): Can't connect to local MySQL
Ok, I've got a fresh Fedora 12 install, and I have installed mysql via yum. I searched around, including a couple similar posts on this site, but haven't been able to find an answer to my issue ...
- 247
5
votes
4
answers
6k
views
mysql connection is slow (5seconds)
After building my webapp on a first boot i create 2 connections to mysql on debian then 1-2 (r/w) for every page after that. The connection consistently take 5.2 seconds to connect. Debian is in a VM ...
user274
4
votes
1
answer
6k
views
MySQL replication not working - no errors
I set both master and slave up by-the-book. I ran the initial LOAD DATA FROM MASTER; on the slave which worked just fine. But when I insert data into the master it is not being copied to the slave at ...
- 245
4
votes
3
answers
2k
views
Long connection times from PHP to MySQL on EC2
I'm having an intermittent issue connecting to a database slave with InnoDB. Intermittently I get connections taking longer than 2 seconds. These servers are hosted on Amazon's EC2.
The app server is ...
- 255
4
votes
2
answers
4k
views
Fastest way to move multiple databases to a new server
I have several small to medium sized mysql databases, say about 40 and I need to migrate them from one whm server with different cpanel accounts to another one with the accounts set up from the ...
- 630
4
votes
1
answer
638
views
Mysql InnoDB table size performance
I have a table that is closely approaching 2 million records. This table stores a history of transactions. This is on a high traffic website but also the table is not accessed regularly. We ...
- 3,040
4
votes
2
answers
2k
views
Hugepages not utilized by MySQL 5.0, CentOS 5
I've set up Hugepages, but i'm not seeing any of them reserved.
Have I missed a step, or for some particular reason, is MySQL is unable to utilize the Hugepages? I have not created a mount of ...
- 2,471
4
votes
9
answers
1k
views
Looking for server monitoring app... nothing fancy.. for Windows [duplicate]
Possible Duplicate:
What tool do you use to monitor your servers?
We are looking for a tool to keep an eye on our web servers (http, file exists, connects) and our smtp, pop servers. Also we'd ...
- 41
4
votes
1
answer
20k
views
MySQL max_allowed_packet greater than 1024 MB
I have a DB which is greater than 1GB (~1,4GB). The DB upload was stopped at 1GB, because, max_allowed_packet is 1073741824 (1GB). In file /etc/my.conf i set max_allowed_packet=2048M.
How can I ...
- 41
4
votes
3
answers
43k
views
How to reinstall broken mysql package
Trying to fix a broken mysql installation, this happened after upgrading from debian 6.0 to 7.0. I have the dotdeb.org packages in my /etc/apt/sources.list.
root@ginger:/var/log/mysql# apt-get ...
- 226
4
votes
3
answers
2k
views
Replace MyISAM files without stopping Mysql
I've got a bunch of MyISAM files (MYD, MYI, FRM) in the mysql directory and newer versions of them in another directory. How can I replace "old" ones with "newer" without stopping the mysql server?
- 183
4
votes
1
answer
2k
views
innodb memory usage mysql
I have a small vps, with only 256mb of ram, with maximum burst up to 512mb. When I configure my vps without innodb, it only uses 130 mb of ram, so that is no problem for me. But when I turn on innodb, ...
- 1,029
4
votes
4
answers
6k
views
MySQL, disk I/O and SSD drives
We have a LAMP box with 2x mirrored 1 TB WD Black Caviar disks running the whole OS and MySQL. 8 GB / RAM, 2x quad core CPUs.
We're really taxed on disk I/O, and I've been thinking of ...
- 154
4
votes
2
answers
2k
views
How to slave real-time data from two MySQL sources merging in to one MySQL destination?
I have two different MySQL instances that I would like to 'slave' to a third instance.
(so I can do easy joins on the third instance)
eg.
mysql1> show databases
db1
db2
mysql2> show databases
...
- 5,903
4
votes
2
answers
1k
views
How to scale my.cnf settings and variables for move from 16GB server to 128GB
This is a general question about optimal setup for a MySQL environment really, but our current MySQL servers are setup on machines with 16GB RAM, we've recently upgraded to newer servers (more ...
- 463
4
votes
4
answers
8k
views
Who is using the swap memory and why?
My database server is using 191MB of swap space - but also shows 182MB of free RAM
The box is a dedicated MySQL server, running Debian Lenny.
How can I determine who and why is filling the swap ...
- 1,799
4
votes
3
answers
4k
views
mysql master-slave setup with synchronous replication
I have a very trivial mysql master->slave setup going on between two servers. The problem is, replication is asynchronous, and this can cause issues (even on a low latency link), if the master server ...
- 1,981
4
votes
2
answers
8k
views
How to safely backup MySQL using VSS-based backup solutions
One of my clients is running MySQL on a Windows Server 2008 system. Their regular backups are performed using StorageCraft's ShadowCopy, which uses the VSS service to perform backups of open files.
...
- 43
4
votes
5
answers
2k
views
mysqldump for sql server [closed]
I have used mysqldump on a mysql database lots of times and am familiar with how it works. Does anyone know if there is a similar tool that could be used on a sql server database.
I know sql server ...
- 2,672
4
votes
2
answers
34k
views
MySQL Socket configuration issue in my.cnf
I've got an issue that's causing very long "time in database" in my application.
The DB is Percona MySQL 5.5.35.
The application works perfectly, and can read/write from the database just fine. The ...
- 648
4
votes
1
answer
3k
views
Grant access rights to a MySQL instance based on hostname instead of IP address?
I have a MySQL database that I would like to remotely access from Windows Azure which does not provide fixed IP addresses at this point. Instead of white-listing a very large IP range to cover the ...
- 493
4
votes
1
answer
6k
views
Mysql remote connections logging
I need to allow remote connections to my mysql server running on latest stable CentOS.
I don't like this idea at all so I want at least to collect as much relevant information as possible. To be ...
- 143
4
votes
7
answers
6k
views
MySQL database backup over network
Server #1 is a MySQL database server running on Debian which contains numerous tables and one particular table that is over 100GB.
Server #2 is used as a MySQL slave for replication, but now it needs ...
- 204
4
votes
1
answer
8k
views
MySQL is VERY slow on my ext4 file system [closed]
I have a normal hardware, I just installed Ubuntu 11.04 anew. But something's completely wrong. PHPunit tests are REALLY slow.
I have no idea what's wrong. With ext3 all was normal.
Thanks.
- 507
4
votes
4
answers
51k
views
PHP Fatal error: Call to undefined function mysql_pconnect() in
I have updated my php version from php 5.0 to 5.3 and it started showing me this error
PHP Fatal error: Call to undefined function mysql_pconnect() in
I need your help guyz please suggest me what ...
- 143
4
votes
4
answers
33k
views
How do I install the pdo_mysql driver on Red Hat Enterprise Linux 6.1?
I have a RHEL box running PHP 5.3.3, which was installed using the binary packages provided by yum. I have installed the php-pdo package:
# yum info php-pdo
Loaded plugins: product-id, rhnplugin, ...
- 2,513
3
votes
6
answers
40k
views
How to re-create /tmp/mysql.sock?
Have a pretty simple problem, I have accidentally deleted /tmp/mysql.sock file
Now I can not use mysqladmin or anything
How can I recreate this file?
Before I asking this question I have looked at ...
- 181
3
votes
3
answers
2k
views
Access AWS EC2 MySQL instance remotely - Best practice
We have a small business with less than 10 employees. We have a MySQL database with sensitive information that is hosted on an AWS EC2 instance. The employees need to have access to the DB. Currently, ...
- 133
3
votes
1
answer
3k
views
Percona: Got an error writing communication packets
Since a few days, two of our php-applications (symfony2) are reporting the following errors in mysql-logs:
[Warning] Aborted connection 253 to db: '$appname' user: '$appname' host: 'localhost' (Got ...
- 197
3
votes
2
answers
6k
views
tc prio qdisc for priorization of mysql traffic
I am struggling with tc prio qdisc for a few hours now.
I have read the lartc Documentation, Examples and HowTos, but this whole thing is kinda new for me and somewhat confusing :)
So this is my ...
- 1,182
3
votes
4
answers
3k
views
Transferring data between SQL Server and MySQL
We host a couple of SQL Servers where we are planning to upgrade the environment (still classic asp). We are looking whether to move to a LAMP (or WAMP) environment instead of just following the ...
- 783
3
votes
2
answers
4k
views
Weird MySQL Users Been Created (eg. bug115166_10073) and not by me
Have just been looking at my MySQL user permissions during a security audit and have noticed about 20 MySQL users have been created with random names such as 'bug115166_10073'. They don't have any ...
BIOSTALL
3
votes
1
answer
142
views
Safely install mysql on windows server 2008
What are some important points to consider when installing mysql 5.1 on windows webserver 2008?
I never installed mysql on any production windows server, so apart from not using the default user ...
- 481
3
votes
1
answer
1k
views
Is it safe to lock tables on a mysql replica slave?
I have a master mysql database where the application writes and read production data, and then I setup a slave database just in case something goes wrong with the master database server (and I can do ...
- 207
3
votes
2
answers
1k
views
Dual Quad Core Xeon CPU but still high load
I have a dedicated server with following specs:
Two Intel Xeon-Harpertown 5430-Quadcore[2.66 Ghz]
4GB DDRII RAM
500GB SATAII HD
CentOS 5.5 64-bit
Problem is that even with such specs MySQL still ...
- 251
3
votes
1
answer
4k
views
Public Amazon RDS database?
Is there any way to add a wildcard security group to Amazon RDS?
I'm trying to connect from an EC2 under the same account, but had no luck with the security groups. So I'm resorting to just opening ...
- 31
3
votes
2
answers
8k
views
Can't install MySQL
I have a Debian machine that I have previously installed MySQL on. In an attempt to delete it, I stupidly deleted the directories/files /etc/mysql/, /etc/init.d/mysql, /usr/lib/mysql/, /var/lib/mysql/....
3
votes
4
answers
33k
views
Access denied for user 'root@localhost' (using password:NO) [duplicate]
I am attempting to install a network management package called cacti onto Ubuntu running under Windows Virtual PC. I attempted to install MySQL as it is one of cacti's dependencies. I can install and ...
- 157
3
votes
2
answers
5k
views
After adding skip-innodb mysql doesn't start
I am trying to setup these values:
#skip-bdb
#skip-locking
#skip-innodb
When I add them to /etc/mysql/my.cnf and even if I turn ON of of, them after I do the service restart mysql fails to start, ...
- 444
3
votes
2
answers
607
views
Why is MySQL Replication so complicated?
It seems so simple: I have two servers running MySQL, one has a nice big database of important stuff, the other is an empty shell ready to be used as a replication slave. These are the steps I should ...
- 293
3
votes
5
answers
751
views
Alternative to multiple WordPress installs (and not using WordPress-mu)
I run several instances of WordPress on a server for managing blogs across multiple domains (also hosted on the same server). Some domains are even utilizing multiple WordPress instances just as ...
- 18.7k
3
votes
1
answer
7k
views
MySQL InnoDB: how to switch to Barracuda format?
In new MySQL versions Barracuda file format was introduced. So I havew a few questions:
Is it working only with file_per_table option?
How to switch existing system to it (preferably the whole ...
- 2,691
3
votes
3
answers
12k
views
set open_files_limit
When I set open_files_limit = 16k in both:
/etc/security/limits.conf
and
/etc/mysql/my.cnf
ulimit -n
16344
but in mysql:
show variables like 'open_files_limit';
open_files_limit: 4096
So how ...
- 131
3
votes
4
answers
2k
views
EBS+RAID10+XFS slower than EBS+RAID10+EXT3 using MySQL?
We're currently using EC2 with 16 EBS volumes in RAID10 configuration for our MySQL data. I know some people don't recommend to put EBS volumes to RAID but that's not what I'm concerned about at the ...
- 43
3
votes
2
answers
371
views
MySQL over ssh tunnel
I have a very strange problem with SSH Tunnel.
I want to connect to a remote MySQL Server using an SSH Tunnel.
I have created the tunnel with great success in the past, but for a strange reason it's ...
- 842