MySQL is an open-source database owned by Oracle.
3
votes
0answers
121 views
mysql client slow login strace
I am experiencing an issue with slow connections/logins to a loaded mysql server, even when connecting via the unix socket file (CentOS 6.3). Queries are completing very quickly -- (0.00 sec) in this ...
2
votes
0answers
213 views
mysql client can't read query result?
So I have this machine running an XMPP server which connects to its MySQL database. When I start load-testing it, all goes fine up until after about 500s when I notice:
Caused by: ...
2
votes
0answers
40 views
mysqld never gets to “ready for connections”
A fresh install of MySQL on a 1and1 Windows Server 2008 R2 virtual server cannot start. The log gives:
130304 16:09:59 [Note] Plugin 'FEDERATED' is disabled.
130304 16:09:59 InnoDB: Initializing ...
2
votes
0answers
72 views
what can put linux process managing connection pool into bad state, so it restarts them continously?
I have an application with pool of connections to MySQL. At some point, in production, every 1-3 seconds some socket is closed. As a result my app restarts this connection.
This is pretty big pool ...
2
votes
0answers
204 views
MySQL 5.5 (Percona) assertion failure log.. what would cause this? [UPDATED]
256GB RAM, 64 Core , AMD running Ubuntu 12.04 with Percona MySQL 5.5.28.
Below is the assertion failure.
We just had a second assertion failure (different "in file", position, etc) while running a ...
2
votes
0answers
144 views
php-fpm crashing because of to many mysql processes
I have 2 frontend nginx servers going to 4 backend php-fpm servers which all run Wordpress. The php-fpm servers all connect to one MySQL server and I was checking some stats earlier each php-fpm ...
2
votes
0answers
151 views
MySQL: 5000 core users, 2GB Table Heavy Write / Read: How to Prevent Crashing
This is a controversial issue for sure, since many might want to recommend the simple things right away, like: Split up the tables! Split up the read/write into master/slave configurations! Amp up the ...
2
votes
0answers
73 views
Move MySQL database while instance is online
I have a MySQL instance containing a number of databases, one of which is an archive database (although using the INNODB rather than ARCHIVE storage engine) that is not queried or written to in normal ...
2
votes
0answers
143 views
Logging mysql queries under MAMP Pro (MAC)
I am using MAMP Pro 2.0.5 (latest)
and copied the my-medium.cnf file and placed it into /mamp/conf/ and renamed it to my.cnf
under the [mysqld] i placed
log = ...
2
votes
0answers
330 views
MySQL INSERT … SELECT renders server unresponsive
Solution: Although I haven't found a proper solution yet I'm at least sure that this is purely a disk I/O problem and has nothing to do with MySQL...
I have a MySQL server (5.1.54-1ubuntu4-log) ...
2
votes
0answers
163 views
mysqldump trigger crashed tables
We had a database crash this morning starting at 1 minute past midnight (when the database backup runs). The exception emails I was getting said
"Table './core/content' is marked as crashed and ...
2
votes
0answers
580 views
HAProxy + MySQL Slaves, random lost connections
The Setup
Right now I've got set up 3 MySQL Servers (5.1.x, on RHEL5), one Master and two Slaves. Last week I added a load balancer (HAProxy) for some services, and thought I'd experiment with using ...
2
votes
0answers
421 views
MySQL and large pages/hugetlb performance gain in numbers?
MySQL has large page/hugetlb support for InnoDB. And there's plenty of posts (example) on the topic.
But does anyone have examples of what performance changes they saw ?
I have seen other database ...
2
votes
0answers
454 views
macports mysql PID file error
I have macports mysql 5, and I disabled the bin logs by commenting this line out:
log-bin=mysql-bin
Then I manually deleted the bin files. After I tried to restart my server I got:
ERROR! MySQL ...
1
vote
0answers
56 views
InnoDB restore from ibdata: “mysql post-start process terminated with status 1”
I discovered way too late that the backup script for our MySQL databases wasn't working properly. Namely, when the disk on the server had already started to fail, and I logged in via SSH and got a ...
1
vote
0answers
44 views
System.Data.Odbc.OdbcConnection.Open() takes a second for every db call
My experience is with LAMP stacks and not so much with .NET on Windows, but I've been given the task of trying to debug a slow site and I've run into a dead end after Googling everything I can think ...
1
vote
0answers
69 views
Why does a mysql query, that requires copying to tmp table, randomly sometimes consume 100% CPU during several seconds?
I have some crazy SQL queries in my PHP scripts which badly need some optimization. However the question is NOT about how to optimize them.
These queries have a lot of "join"s and some bizarre "order ...
1
vote
0answers
39 views
Upgrading JIRA 5.0.1 to JIRA 6
I am trying to upgrade my jira version from 5.1 to 6 in my test server. with windows(64) platform. So I downloaded jira 6 version with folder name as "atlassian-jira-6.0-m08-standalone". then I ...
1
vote
0answers
86 views
Dovecot Mysql Auth Mechanism
First time poster, long time lurker. I am currently rebuilding my postfix/dovecot mail server for support with MYSQL and am unable to figure out which auth mechanism to use.
dovecot: auth: Fatal: No ...
1
vote
0answers
111 views
MySQL ZRM restore failed with mysql error unknown command \0
I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'.
...
1
vote
0answers
49 views
mysql logging activity from specific user or ip
I have mysql server.
The server is accessed by my application, and by external auditor (person using mysql workbench).
The auditor has specific user and password and dedicated IP and it is granted ...
1
vote
0answers
152 views
postfix won't deliver
I have been setting up an email server based on this tutorial on ubuntu 12.04 with MySQL virtualuser. After having problems with postgray I'm again in that situation that I don't know where should I ...
1
vote
0answers
83 views
pam_mysql / vsftpd error 'AUTHENTICATION FALURE (FIRST_PASS)'
I setup vsftpd and mysql auth via pam on Debian Squeeze.
Config:
auth required pam_mysql.so user=server passwd=x host=localhost db=server table=ftp usercolumn=username passwdcolumn=password ...
1
vote
0answers
56 views
What can lock the only MySQL db process?
A plain old "delete single record" statement froze on me. Suspecting a (dead)lock issue, I checked the process list to see what blocks the delete. The delete statement was the only running db process ...
1
vote
0answers
155 views
Failed MySql install (raspbian)
I finally got a Raspberry Pi for Christmas and decided to set it up as a home web server. I have nginx with php setup and working. I came to install mysql and ran sudo apt-get install mysql-server. ...
1
vote
0answers
47 views
How to create a Capistrano task to import a backup from production into local development db?
I'm trying to do something with a Capistrano task that is similar to the heroku db:pull functionality if you are familiar with it.
I have a remote server. On that server I have a bunch of backups in ...
1
vote
0answers
60 views
MySQL binlog rsync from tmpfs to HDD causes write slowdown on ramdisk
I have a mysql database server and am testing writing my binlogs to ramdisk to speed some things up. A curious thing happens.. fairly often, I get major job slowdown at the same time the rsync is ...
1
vote
0answers
299 views
syslog-ng and nginx logs to mysql
So couple of days ago I asked
how to log php and nginx logs to centralized MySQL database, and m0ntassar gave a perfect answer :) cheer !
The problem I am facing now is that I can not seem to get it ...
1
vote
0answers
47 views
nginx+mysql5 loadtesting configuration strangeness
i am trying to setup a new server running on debian6 and trying to make it work smooth under load. i ve used a wordpress site as a test object, and tried the configurations on http://blitz.io. when i ...
1
vote
0answers
310 views
MySQL crashes when connecting from localhost with tcp (UNIX sockets work)
I have Ubuntu 12.04 running MySQL server 5.5.24.
I can connect with mysql --user root -p. status shows me :
...
Connection: Localhost via UNIX socket
...
When I try to connect with mysql --host ...
1
vote
0answers
189 views
mysqld service crashes on restart, after importing mysqldump #innodb
I have 2 mysql servers. Let's call them server01 & server02. Both have the same configuration: mysqladmin Ver 8.42 Distrib 5.1.61, for redhat-linux-gnu on x86_64
[client]
...
1
vote
0answers
253 views
mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect
When I'm trying to install MySQL 5.5 community edition on my Ubuntu 10.04 by compiling the source code, I met the following problem:
$ fg % 1
sudo ../bin/mysqld_safe ...
1
vote
0answers
25 views
Server error with large posts
On a large drupal site, the database server is on a separate server connected directly to the web server. The web server uses apache and memcached. The problem is that whenever the post is a large, ...
1
vote
0answers
36 views
MySQL not respond when overheaded
I have few Drupal 6 websites on webhosting, which causes this strange problem:
some tables, especially Cache and Watchdog, tend to overhead,
when overhead is bigger than some amount of kB, MySQL ...
1
vote
0answers
264 views
How to connect to Amazon RDS MySQL instance while preventing MITM attack
I have an Amazon
RDS instance running MySQL.
I've created a user account, and I've configured
MySQL to require the use of SSL for all
logins to that account.
I want the MySQL client to be able
to ...
1
vote
0answers
148 views
Extremely slow response when connecting to remote MySQL database (LAMP Server)
I installed a LAMP server and enabled MySQL remote connections but I'm experiencing really bad response times when connecting to the database remotely from a WordPress install.
I've been looking ...
1
vote
0answers
191 views
Linux Nginx + php-fpm + cron + mysqld = always out of memory
I don't get it. I have a VPS with Nginx and php-fpm and MySQL. Should be very lightweight. No Apache, right? When I reboot, it is very lightweight. ~ 50/481 MB MEM usage. Very acceptable IMO.
And ...
1
vote
0answers
236 views
Server quit without updating PID file on multiple mysql installation in linux
Iam trying to install one version of mysql in a LINUX machine. The system contain already another version of mysql installation. I prefer manual installation. Copy the extracted tarball into a ...
1
vote
0answers
695 views
How do I set my root account in mysql to be accessed locally?
I am running into a bit of a problem here. I have a mysql server setup on an Ubuntu 12.04 distro. After the initial install I have been using MySQL Workbench to do all my db creation and ...
1
vote
0answers
116 views
DRBD heartbeat's resource role trouble in centos 5.4 by mysql files owner change?
I am using 2 machines with centos,mysql,drbd,heartbeat,asterisk.
node 1 has
hdc :SAMSUNG HD160JJ/P, ATA DISK drive
kernel version 1 SMP Tue Aug 21 17:50:26 EDT 2012
kernel release ...
1
vote
0answers
97 views
Simple UPDATE query with (sometime) long query times
I run a dedicated MySQL server (2 cores, 16GB RAM) serving 100-200 requests per second. It is getting sluggish during peak traffic and I have a hard time optimizing the server. So I'm looking for some ...
1
vote
0answers
101 views
Considering MySQL on SSD with NTFS and Windows 2008
My company is considering migrating our MySQL data from an HDD array to an SSD, possibly the Intel SSD 520 series. We have a fairly large set of databases, some with upwards of 100 million rows, so we ...
1
vote
0answers
582 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 ...
1
vote
0answers
161 views
Mysql innoDB corruption after server crash
Yesterday my server died because an outage in the data center. Today it's back up, but having some problems with mysql.
First of all my mysql server was not able to start. For this reason I deleted ...
1
vote
0answers
61 views
mysql table version difference
I have a mysql table (MyISAM), called bla. The Version is 9 (mysql4)
Using a mysql5-server I did an alter table (add column, delete the same column). This is a simple trick to upgrade the table ...
1
vote
0answers
36 views
MySQL inserts failing silently / invalid ID's (hardware failure?)
We just ran into a peculiar malfunction with MySQL inserting data successfully, but the rows it was inserting were not actually saved and the inserted ID's were of rows inserted about 20 records ago ...
1
vote
0answers
350 views
MySQL loses connection to local MySQL server
I'm trying to do some analysis on data stored in a largish MySQL database. I have 2 tables with 130mio and 600'000 entries respectively and I want to run the following query:
select
hashes.hash,
...
1
vote
0answers
38 views
error 1045 access denied mysql when I deleted the root user
unfortunately I deleted mysql user and now I can't access mysql
I tried MySQL - ERROR 1045 - Access denied
But it is not proper for me because I don't have any user for mysql even I uninstalled and ...
1
vote
0answers
88 views
apache not releasing connection
i dont know why apache is not releasing connection.Its keeping connection for a long time.
Here is the status from server-status.
Server Version: Apache/2.2.17 (Ubuntu) PHP/5.3.5-1ubuntu7.7 with
...
1
vote
0answers
19 views
Is it possible to secure MySQL admin password with digital certificate on windows
I'd like to know if it is possible: I searched google but couldn't find.
