0
votes
1answer
21 views

MySQL on Mac OS is not listening on port 3306 [closed]

I've just installed MySQL 5.6.20 on Mac OS X 10.9.4 (Maverics) It is only accessible via a unix socket however, I would like to be able to connect to it with TCP/IP on port 3306. I have read about the ...
0
votes
1answer
185 views

can't find the private Ip address for my Amazon-RDS instance

i moved my Master/slave database architecture to Amazon RDS and everything works fine. But i have a slave out of the RDS service which should keep sync with the new Master server, to do so i have to ...
0
votes
1answer
51 views

Installing mysql using rpm in linux through commandline

I'm trying to install latest version of mysql server. I tried to uninstall mysql 4.1 using rpm -e . Once uninstallation done I tried to download mysql packages: Command : wget ...
0
votes
1answer
86 views

UTF-8 encoding gone missing after enabling mysqlnd

I've enabled mysqlnd on my PHP 5.4.26 server using MariaDB 10.0.8. My SQL config contained this: [mysqlnd] character-set-server = utf8 collation-server = utf8_general_ci It was all working fine ...
1
vote
1answer
1k 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 ...
1
vote
0answers
226 views

MySQL rebuild after Corrupt ibdata1

I have a MySQL server that serves a couple of databases including a Magento e-commerce store. We have been suffering with corruption in the ibdata1 file for a while, but it has now reached a critical ...
0
votes
0answers
10 views

MySQL Server Not starting on Windows OS with Arabic

I have a MySQL server (The MySQL version is 5.5.25) that I packages with my software that I run on my Windows XP/7/8/Server, the MySQL server is starting up and running as required on the Windows OSes ...
0
votes
1answer
57 views

Where to download MySQL server 5.0.77-log

I have MySQL Server version: 5.0.77-log Source distribution on a RHEL6 server. I need to reinstall it on a second RHEL6 server to set up a testing environment but I cannot find where to download this ...
0
votes
1answer
142 views

MySQL 5.0 not logging aborted connections in general log

I know there is a bug in MySQL 5.0 which prevents aborted connections from being logged in the error log (http://bugs.mysql.com/bug.php?id=24761). However, aborted connections should still be logged ...
0
votes
1answer
107 views

Increase the speed of mysqldump

Are there any flags or tricks to speed up mysqldump for backups? Here is what we are currently using: mysqldump --skip-opt --flush-logs --routines --triggers --allow-keywords --create-options ...
0
votes
1answer
37 views

Do global logging settings in MySQL5 stick after service restart?

Want to execute this on MySQL 5.0: set global log_warnings = 2; Will the setting stick after a mysqld service restart?
0
votes
0answers
220 views

MySQL 5.6 Create Table VERY slow

I recently upgraded my MySQL server from 5.1 to 5.6 (running on CentOS 6.x). Ever since the upgrade, when I try to perform certain table tasks the queries take a REALLY long time. This is really ...
-1
votes
1answer
993 views

Installed Windows 8.1, MySQL service disappeared and all MySQL data/settings gone [closed]

This weekend, I updated a Windows 8 workstation to Windows 8.1. This was a development workstation that had a locally hosted MySQL 5.6 instance used for web development work. After the update ...
0
votes
0answers
39 views

Cannot login to mysql through mysql-proxy

Good day, I have a user usera which I grant access. Thus I can do remote$: mysql -h dbhost-u usera -p my_db and dbhost$: mysql -u usera -p my_dba And both works. But after creating a ...
1
vote
0answers
307 views

how to enable remote access to a MySQL server on an AZURE virtual machine

I have an AZURE virtual machine with a MySQL server installed on it running ubuntu 13.04. I am trying to remote connect to the MySQL server however get the simple error "Can't connect to MySQL server ...
0
votes
2answers
152 views

MySQL consuming all system memory on INSERT … SELECT

The mysql daemon is getting killed because Linux is reaching out of memory: Oct 24 07:41:23 <hostname> kernel: [82297.673701] Out of memory: kill process 13816 (mysqld) score 1839626 or a child ...
1
vote
1answer
267 views

MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

Trying to install MySQL (for WordPress) on a CentOS 6.4 /64 bit server. I have installed the mysql-server-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # ...
0
votes
1answer
93 views

Queries going to mysql server even when no one is connected to it

I have a MySql server which has 2 active databases which are used for a web application and 3 inactive ones (left for archival purpose but not currently used). The problem is that the server seems to ...
0
votes
1answer
161 views

PHP connection for Mysql is very slow in another server

Few days ago, we moved our mysql database to another host because of some limitations with our current host. Everything is fine (Seem same performance and speed on our PHP framework based website) ...
2
votes
2answers
249 views

Innodb one file per tablespace

I'm walking into an environment that uses MySQL and Innodb as the storage engine. I'd like to enable innodb_file_per_table to increase performance. Considering all of the databases/tables are ...
0
votes
2answers
543 views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...
0
votes
1answer
837 views

MySQL 5.6 Upgrade - Incorrect definition of table mysql.proc

After upgrading MySQL to version 5.6.10 from version 5.5 I'm getting the following errors when starting MySQL server: 2013-03-19 05:32:38 2666 [Note] /usr/sbin/mysqld: ready for connections. Version: ...
2
votes
2answers
7k views

Error 2013: Lost connection to MySQL server during query when executing CHECK TABLE FOR UPGRADE

I just upgraded Ubuntu from 11.10 to 12.04. My rails app now returns the (passenger) error "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (Mysql2::Error)". I ...
0
votes
2answers
92 views

How to proceed setting up a secondary mysql linux slave?

I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
2
votes
4answers
606 views

MySQL : Separate Log File for Each Database

I have a server with multiple databases on it. Its actually an instance on AmazonRDS so I do not have access to the my.cnf file. What I am trying to do is a create a log for each database separately ...
0
votes
3answers
80 views

MySQL Upgrade RPM

I have a centos5.5 system and have MySQL 5.0.27 install. Now I want to upgrade this to MySQL 5.5.28(Latest). I have two questions, What is the difference between RPM(Redhat) which is recommended and ...
2
votes
3answers
180 views

MySQL specific database replication (Master - Master)

We have a MySQL server at one location, replicating to another in a Master->Slave configuration. There are about 5-7 different databases on this server. We are wanting to do this... We have a second ...
1
vote
0answers
1k 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
3answers
225 views

Replicate between mysql 5.0.xx community and enterprise edition over ssh

I'm trying to setup a mysql replication over an SSH tunnel. The odd thing about this setup is that I have one master with mysql 5.0.60sp1-enterprise-gpl-log and one slave with mysql ...
1
vote
1answer
1k 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 ...
2
votes
2answers
161 views

Rebuild mysql slave from scratch

I'm having a master/slave mysql setup. This night I had some problems with the master. I needed to recreate all databases again because they were corrupt. Now I stopped my mysql slave but want to ...
0
votes
1answer
816 views

why does mysql have so many more open and fragmented tables than tables in the DB?

I've been working making our database run a little smoother and had good results over the past week. But there are still some things I dont understand. For one thing, the database has 25 tables. ...
6
votes
3answers
5k 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
1answer
2k views

What is the use of ibdata1 file in mysql [closed]

I have application which has the backend db as Mysql(InnoDb engine), and currently my client wants to decrease the size of the ibdata file to some fixed size. I found the three below solutions. ...
3
votes
1answer
2k views

Is it safe to modify innodb_data_file_path value for mysql 5?

I recently experienced data corruption after changing the value of this parameter in my.cnf from : innodb_data_file_path = ibdata1:10M:autoextend:max:128M to : innodb_data_file_path = ...
0
votes
3answers
246 views

Pid file for mysql on Oneiric

I cannot locate pid file for mysql server on oneiric. Opened /etc/mysql/my.cnf and /etc/mysql/debian.cnf but see no settings about pid file. I need this pid file to have monit monitor mysql. Any clue? ...
2
votes
2answers
59 views

MySQL server database log

I have a website with MySQL database. Someone deleted 1,000 records from a table. Is there any way to find out who have deleted the records and when from the website? And from where the records were ...
1
vote
1answer
340 views

max_used_connections in mysql keeps on increasing on ubuntu 11.10

We are having mysql 5.1.58 running on ubuntu 11.10 server edition with 48 gb ram and intel e5620 processor together with apache 2.2.20. But we are facing an issue that prevents Mysql from accepting ...
4
votes
2answers
293 views

MySQL 5.5.16 allows anonymous connections

Apparently, I can connect to MySQL (at least from my localhost) without having to provide any username or password. I can even put anything as username, as long as the password is empty. I have access ...
3
votes
2answers
667 views

Insert one data to MySQL table without login

MySQL details: MySQL username: root MySQL password: z To run MySQL query without login, the command is: mysql -u root -pz -e "mysql-query-here" So, if I want to create database with name db1, it ...
0
votes
1answer
39 views

How to use “-A” in “use dbname;”

When running use dbname; in MySQL admin, I will get this message: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A ...
0
votes
1answer
2k views

MySQL ERROR 2026 (HY000): SSL connection error

I have enabled SSL on MySQL 5.1.52 on CentOS 6.0 using the following guide: http://www.madirish.net/node/244 I have followed the instructions correctly but I am running into the following error when ...
0
votes
1answer
240 views

MySql not starting during startup even after adding symlink to rc5.d

I recently added mysql.server to start during the start up by doing this: cd /etc/rc.d/rc5.d/ ln -s /etc/init.d/mysql.server S98mysql I have perhaps not correctly understood the <number> ...
0
votes
1answer
69 views

Aggregating data from multiple MySQL servers

I have 10 MySQL servers and each one holds a database that needs to be replicated to a single, centralised MySQL server. The complexity is that each server must replicate its database to the same ...
0
votes
2answers
588 views

Can I choose which CPUs / Cores to be used by MySQL?

I have a Windows VPS (Windows 2008 R2 x64) that runs a couple WordPress blogs and other few ASP.NET things. The VPS runs 2 CPUs (for example). With ASP.NET, in such situation, I usually set the app ...
1
vote
2answers
674 views

Broken Slave (MySQL replication)

Last night one of the developer ran a wrong mySQL statement (Query inserting a row with duplicate primary key) on master machine. Suddenly the replication to its slave stopped. Slave started writing ...
0
votes
1answer
89 views

mysql performance optimization after enabling replication

Over the weekend I upgrade my Ubuntu server from 9.10 to 10.04 which also updated my MySQL server. I also enabled MySQL replication over to another server as slave. I have not yet moved any ...
1
vote
1answer
646 views

mysql cluster with PHP

I have a very common LAMP stack with about 6-7 machines with PHP and Apache and a few machines with MySQL server (master+slave, sharding) I am exploring options of moving to MySQL Cluster. I couldnt ...
0
votes
1answer
345 views

How to prevent InnoDB log files from getting corrupted?

We run a MySQL server using 600GB of storage over 4 EBS volumes on Amazon EC2. About every 2-3 weeks, the active InnoDB log file gets corrupted, and MySQL won't allow any access on those tables ...
2
votes
1answer
103 views

Mysql performance, understanding top

We have a 64 bit mac os x server running mysql. The machine has 48 GB of ram. Top shows as below. MemRegions: 12053 total, 16G resident, 12M private, 76M shared. PhysMem: 2072M wired, 17G active, ...