Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5]

137 questions
1
vote
1 answer

what causing an error about 'lc-messages-dir' how can i fix it

./mysqld --initialize --user=mysql --basedir=/opt/mysql/mysql --datadir=/opt/mysql/mysql/data [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for…
Keven.Lee
  • 11
  • 1
  • 3
1
vote
0 answers

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 point. The only database that uses innodb tables…
user211502
  • 11
  • 2
1
vote
0 answers

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 putting a damper on my development cycle iterations,…
Kenny Wyland
  • 200
  • 1
  • 12
1
vote
2 answers

Installing MySQL 5.1 & PHP 5.2 on RHEL5.3

I would quite like to be running the latest production releases of PHP and MySQL on my production RHEL5.3 server. PHP so that I can use Zend Framework 1.9 which only supports PHP 5.2.4 or later. MySQL because they claim 5.1 is faster. I am a little…
Richard
  • 127
  • 1
  • 6
1
vote
1 answer

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: '5.6.10' socket: '/var/lib/mysql/mysql.sock' …
Max M.
  • 23
  • 2
  • 5
1
vote
0 answers

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 administrative tasks such as backup\restore etc. My MySQL…
Steven Combs
  • 119
  • 1
  • 6
1
vote
3 answers

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 5.0.67-community-log. Could it be so that it's not possible to…
Arlukin
  • 1,203
  • 6
  • 18
  • 27
1
vote
1 answer

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 url: hxxp://hostname/~userN, where N is…
Bonn
  • 43
  • 1
  • 8
1
vote
2 answers

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 clause. As the ORDER BY does not match the index…
Ahn
  • 181
  • 3
  • 5
  • 13
1
vote
1 answer

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 creating few innodb tables. So we have commented…
Ahn
  • 181
  • 3
  • 5
  • 13
1
vote
1 answer

Innodb Queries Slow

I have RedHat 5.3 (Tikanga) with Mysql 5.0.86 configued with RAID 10 HW, I run an application that queries Mysql/InnoDB and MyIsam tables, the queries are super fast,but some queires on Innodb tables sometimes slow down and take more than 1-3…
user105196
  • 69
  • 1
  • 5
1
vote
1 answer

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 any more connections, even though i have set…
Newbie
  • 11
  • 3
1
vote
1 answer

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 But I still not clear about how to use -A?
Roberto Apasajja
  • 77
  • 1
  • 1
  • 4
1
vote
1 answer

What can cause a delay in authentication to mysql5 database?

I have a mysql5.0 server that is very slow authenticating database requests. After a just a few requests there is a backlog of processes, showing waiting for login: | Id | User | Host | db | Command | Time | State |…
dmaestro12
  • 172
  • 1
  • 7
1
vote
3 answers

Screwed libmysqlclient-dev in Ubuntu

I have messed with symlinks and libraries in /usr/lib. I modified libraries like libmysql*. someone suggested to reinstall libmysqlclient-dev package. Is libmysqlclient-dev holding Mysql libraries? How can I force the re-installation of…
rtacconi
  • 745
  • 4
  • 14
  • 28
1 2 3
…
9 10