The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
44 views

upgrading php 5.3.6 to 5.5 in ubuntu 12.04 LTS requires removing mysql?

I'm trying to upgrade php to latest version (5.5) my current php version is 5.3.6 bundled with ubuntu 12.04 LTS. The problem is I do not want to upgrade anything else just php but although I ...
0
votes
2answers
340 views

MySQL PID file missing [closed]

Some time ago MySQL stopped working on my server and I've only just got round to looking into it. When I try and start it with service mysqld start I get Starting MySQL.The server quit without ...
-1
votes
1answer
504 views

my.cnf configuration in mysql 5.6.X [closed]

Server information 64GB RAM Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz Mysql Server version: 5.6.20-log - MySQL Community Server (GPL) I have 20 websites on this server like share hosting my big ...
0
votes
0answers
35 views

Troubleshooting mySQL load problems

SSD VPS with one Magento site on it. Recently whenever I make a save to a product, the mysql QPS skyrockets and server load goes up tenfold for several minutes (even though the admin page loaded long ...
2
votes
1answer
941 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
66 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
132 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
4k 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
358 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
11 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
98 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
287 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
195 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?
2
votes
2answers
4k views

MySQL 5.6 on CentOS 6 silently fails to start

I'm working on a fresh CentOS 6.5 install and trying to get a MySQL 5.6 server daemon running. The server is a fresh droplet on DigitalOcean's infrastructure. 512 MB size. I used the MySQL version ...
0
votes
0answers
290 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 ...
0
votes
1answer
2k 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 ...
2
votes
1answer
373 views

MySQL Workbench sends computer name with login not IP

I am attempting to connect MySQLWorkbench to a remote MySQL Server. The server has granted access to user@IPAddress However, when I try to connect MySQLWorkbench, it sends user@computername ...
1
vote
0answers
523 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
255 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 ...
0
votes
1answer
156 views

Unable to adjust php.ini max upload size directive on Centos 6.3

Currently i'm setting up Centos 6.3 (64 bit) on vm and installing Wordpress: Already adjust /etc/php.ini but seems like overwritten by other settings. Suspect this is due to selinux feature. My goal ...
1
vote
1answer
315 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
2answers
121 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
212 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
316 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
1answer
138 views

What can I do with corrupted DB in InnoDB format in this case?

guys, I have a big problem. There is one server with CRM database. I corrupted it probably and don't know what to do. ls /var/lib/mysql/sugarcrm/ accounts_audit.frm address_book.ibd ...
0
votes
2answers
672 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
1k 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: ...
0
votes
0answers
236 views

How to set debian with it_IT@EURO without converting the MySQL database?

I have a machine with Debian 6.0.x and MySQL Server version: 5.1.66-0 + squeeze1 (Debian). If I configure my machine with it_IT@EURO instead of en_US.UTF-8 Mysql is not happy, eg a table control / ...
2
votes
2answers
9k 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
103 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 ...
4
votes
2answers
1k views

mysql error 1062 'duplicate entry' when restoring backup

Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this. Requirement: To create an exact replica 'db4' of an existing DB 'db3'. Procedure ...
3
votes
4answers
892 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
81 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
195 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
242 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
212 views

Ubuntu script to add multiple user with apache userdir and mysql username

In Ubuntu 12.04, I'm having difficulties creating a script (since I'm not experienced with it), and is assigned to add multiple users from a list of names in file usernames.txt. The users will have ...
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 ...
2
votes
2answers
179 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
2answers
108 views

MySQL is converting MyISAM tables to INNODB automatically

I recently upgraded MySQL server on CentOS 5 with MySQL 5.0.96 After upgrade when i am trying to import old database dump which has got both MyISAM and INNODB tables in a single database, MySQL is ...
0
votes
1answer
107 views

Mysql - Performance improvement of “ORDER BY” with index

Can I improve the "ORDER BY" by adding an index on fld_date. SELECT * FROM t1 WHERE fld1='XXX' fld2='XXX' ORDER BY fld_date; The query uses the index of (fld1,fld2 - combined index) in the where ...
0
votes
2answers
33 views

Mysql - Find out which Database a particular table is present

How would I find out which Database a particular table is present in MySql ? Mysql version is +----------------------+ | version() | +----------------------+ | 5.1.35-community-log | ...
0
votes
1answer
887 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. ...
0
votes
1answer
90 views

Optimize server for faster processing of requests [duplicate]

Possible Duplicate: LAMP Server Performance Tips I am running a web directory using WordPress which has a lot of categories, and I mean a lot. Around 26,000 to be precise. And it takes ...
0
votes
1answer
370 views

Issue with InnoDB engine while enabling and [ skip-innodb ] - [ERROR] Plugin 'InnoDB' init function returned error

In production server as of now we are running with MyIsam tables only, hence we have disabled the innodb engine with skip-innodb option. But now onwards we need to enable the innodb engine as well for ...
7
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
272 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? ...