Questions tagged [mysql5.5]
MySQL RDBMS version 5.5
42
questions with no upvoted or accepted answers
5
votes
0
answers
3k
views
Invalid key length error when trying to connect phpmyadmin to remote MySql over SSL
I get these error messages when logging in to phpmyadmin instance
Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ...
3
votes
0
answers
96
views
script cannot connect to Mysql server Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Mysql server seems working properly and running also i can connect to the database via ssh command, here's the my.cnf file directives:
[mysqld]
#port=3306
datadir=/home/mysql
socket=/home/mysql/mysql....
3
votes
1
answer
956
views
OpenShift/MySQL error: lower_case_table_names error when migrating from OS X to OpenShift
Ok, so I have dumped a MySQL 5.x database from an OS X instance, and am having problems importing the database into the OpenShift MySQL 5.5 container. My tables are Camel-case (eg "tblAccounts") but ...
3
votes
1
answer
1k
views
High CPU on MySql Fusion-io server
I've just finished reading this old Q&A which had some really good detailed information on a similar setup to ours, though unfortunately our problem (now) is not with replication.
MySQL ...
2
votes
0
answers
6k
views
Child process still did not exit
My LAMP server recently froze and I rebooted it. I ran into some memory issues with MySQL after that that I was able to determine indicated my swapfile got disabled during the reboot. I re-enabled my ...
2
votes
1
answer
894
views
MySQL 5.5 on CentOS 6 -- mysql user 'root@localhost' cannot grant privs
This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and .
I know the password is correct as I can log in with root@localhost to the mysql server and can also create ...
1
vote
2
answers
60
views
Should we upgrade MySQL, move to PostgreSQL, or go cloud?
We use an internal MySQL 5.5 server for our ERP system.
Issue
things are getting slow, and bosses are getting annoyed
our SLA with our infrastructure service provider is ending soon.
our small dev ...
1
vote
0
answers
671
views
Mysql query log is empty after boot
I can't figure out why is general and slow query log empty after computer restart. After restarting the server with systemctl the logs get populated.
After reboot the files are created just empty.
$ ...
1
vote
0
answers
1k
views
Apache is using 100% CPU even with one user
Apache is using 100% CPU even with one user
Apache (or should I say PHP through Apache?) is using 100% CPU for few seconds every time somebody search bugs at our bug tracker or just reload the search ...
1
vote
0
answers
223
views
Possible have 2 php.ini file or 2 extension_dir in php.ini?
i got Fatal error: Class 'mysqli' not found in C:\apache2triad\htdocs\index.php on line 8 error. I checked php.ini file and saw extension=php_mysql.dll is uncommented.Everything is normal. But in php....
1
vote
0
answers
769
views
Mysql table doesnt exist error after trying run from lvm snapshot
I'm trying to set up mysql replication by making lvm snapshot of master datadir and copying it to slave.
The procedure is quite simple, on master server I execute "FLUSH TABLES WITH READ LOCK" and on ...
1
vote
1
answer
294
views
Apache2 / tomcat / MySQL / PageSpeed Server hanging once a day
My server started to hang at least once a day. It remains so until I restart Tomcat. I'm not sure yet which part causes the problem, so I'm trying to work on several hypotheses:
My website is served ...
1
vote
1
answer
236
views
WinServer 2008 R2 MySQL cluster service won't start
So I have a two-node failover cluster in WinServer 2008 R2, I also created a generic service which will manage my MySQL5.5 database (the database root is also in a iSCSI storage).
When the cluster ...
1
vote
1
answer
163
views
Linux iptables DNAT 53306 to 127.0.0.1 3306
mysql real port is 3306。
I want public network using 53306 to visit mysql,and 3306 not allowed access from public network.
How to write the iptables rules DNAT 53306 to 127.0.0.1 3306 ? help me
1
vote
1
answer
834
views
mysql slow queries not writing to log
I have the following slow query information setup in mysql.
SHOW VARIABLES LIKE '%SLOW%';
Variable_name Value
log_slow_queries ON
slow_launch_time 2
slow_query_log ON
slow_query_log_file ...
1
vote
1
answer
1k
views
MySQL is too slow on Windows VPS
I'm running a wordpress blog on my VPS, But MySQL Queries are taking too much time.
For example, it is taking more than 1.5 seconds to load a post from database.
But CPU and RAM usage is low on my ...
1
vote
0
answers
238
views
New Windows Server 2008 R2 WIMP running slower than Windows Server 2003
We recently upgraded a WIMP server from Windows Server 2003 (32 bit) to Windows Server 2008 R2 (64 bit).
The new server has significantly better hardware than the old server, yet many processes take ...
1
vote
1
answer
1k
views
mysql load_file() function always return null for symbolic link
i have installed new database server on ubuntu
mysql version is 5.5.35
im trying to execute select load_file('/usr/home/aaa.com/medya_data/ver.txt')
and im sure ver.txt file is exist but ...
0
votes
0
answers
68
views
Recovery a table in MySQL but it [Err] 1030 - Got error -1 from storage engine
I have a MySQL with InnoDB engine on a legacy Windows, MySQL version is really old is 5.5,I have a table is really big like 90Gigabytes, it disrupted its MySQL database ,when the restful API read ...
0
votes
2
answers
1k
views
Why the length of tinyint seems to make no difference?
I've been searching for what the length in the tinyint declaration means (e.g. tinyint(5)). And the answers seem to be that it should just be a rule for how MySQL displays the data. But in my case ...
0
votes
1
answer
285
views
MySQL 8.0 replica going out of sync with error on executing statements
I have this configuration:
Master running MySQL 5.5 with log file format: STATEMENT
Slave running MySQL 8.0 - connected to (1) master. Log file format: ROW
Another Slave running MySQL 8.0 - connected ...
0
votes
1
answer
1k
views
Master- Master Replication breaks after server Reboot
I have a Master-Master Replication with the following Configuration. Due to some patches, we have to Reboot the both the masters. But when i check the replication i s broken.
MASTER 1:
[mysqld]
...
0
votes
0
answers
292
views
Django cannot find libmysqlclient after upgrade MySQL from 5.1 to 5.5
I have a Server with Debian 6 squeeze.
I've made some upgrade to Debian 7 wheezy.
MySQL is upgraded from 5.1 to 5.5.
Now I have an application developed with Django, and it got me an error, cannot ...
0
votes
2
answers
2k
views
Percona-Server-shared my.cnf file conflicts with file from package mysql-community-server-5.5
I'm trying to install Percona Toolkit on the server where there is already mysql-community-server5.5.52 is running.
I require pt-table-checksum and pt-table-snc utility, so I ran:
yum install ...
0
votes
1
answer
1k
views
Large database table queries return empty set
I'm trying to understand a weird problem with a MySQL database on one of my websites.
When I loaded a big set of data from a CSV file (2,200,000 records with a single column, using LOAD DATA) into a ...
0
votes
0
answers
87
views
pt-pmp fails to run on percona 5.5 ubuntu 12.04
Command:
[mysql] root:/mnt# pt-pmp --pid 16898
Wed Dec 7 18:41:51 UTC 2016
warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fffd4126000
18 libaio::??(libaio....
0
votes
0
answers
110
views
apache php server weird logout issue
we have recently moved PHP application on new server,but we are facing weird session out issue on new server, the session.gc_maxlifetime = 86400 in php.ini but the application goes logout in between ...
0
votes
1
answer
1k
views
Configuring remote access to mysql via puppet
The problem: I want to connect to mysql from another host
I have a mysql instance that I configure with puppet. I want to be able to access the instance from host 1.2.3.4.
Part 1: I start by hand
...
0
votes
1
answer
415
views
MySQL creates huge files every night, bringing down the server
I have an Ubuntu 12.04 LEMP server with shop app ontop, running MySQL 5.5 as DB (currently since this problem started I've already switched to Percona with no success).
So, current facts: every night ...
0
votes
0
answers
34
views
mysql keeps lossing user permisions
We have a mysql database on ubuntu 14.04 server. It was working really fine for months until some weeks ago, when it started with this thing. It suddenly losses all user permisions and we have to set ...
0
votes
1
answer
132
views
Why is the MYSQL variable innodb_file_per_table changed to OFF automatically in a OPENSHIFT online gear?
My application is on openshift online gear with mySQL 5.5. Recently I found that my mySQL database become very big quickly (few days increase 1G) without many operations. This made me try to do ...
0
votes
1
answer
1k
views
different servers different databases replication mysql
I am not sure if this is possible or not but I have 3 servers.
Server A, B and C
Server A has database A_dataBase, B_database
Server B has database A_dataBase, B_database and C_database
Server C has ...
0
votes
1
answer
614
views
Can I do zero downtime MySQL replication if I have archive tables present?
I've read the question and answers at How to setup MySQL replication with minimal downtime. It looks like I can get a slave DB into sync without down time if I am using only Innodb tables.
My ...
0
votes
2
answers
668
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
1
answer
497
views
How to secure mysql server
I have an mysql client with a fixed IP that should be able to access a mysql server.
The mysql client is integrated in a software and only port, ip, username and password are modifiable.
What would ...
0
votes
2
answers
2k
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
1
answer
137
views
How to solve mysql server 5.5 update dependency issue?
since a month or two i cannot update package on my ubuntu server. The problem concern the mysql package which seems newer on the server that the minimum required ?? :
lm@s8:~# sudo apt-get upgrade ...
0
votes
1
answer
284
views
MySQL causes iowait's since 5.5 - optimal my.cnf wanted
I upgraded my MySQL server from 5.1 to 5.5 on CentOS (with 2 cores and 2GB RAM).
With my old my.cnf the mysql service doesn't start anymore (complains about a PID file), so I use an almost empty my....
0
votes
1
answer
141
views
MySQL-server-5.5.18 - Installation issues / doubts
1 ) How to relocate the data dir while installing the MySQL-server-5.5.18-1.linux2.6.i386.rpm.
rpm -ivh MySQL-server-5.5.18-1.linux2.6.i386.rpm
0
votes
1
answer
153
views
Can't run Apache - Would having Ruby on Rails and mysql server installed on the same machine be the reason why?
everyone. I am trying unsuccessfully to run Apache on my machine. I used the command line to find out all the applications that are using port 80 and I ended them, but Apache refuses to run on my ...
-1
votes
1
answer
60
views
Why can root still login remotly?
I have a very strange issue I'm hoping someone may have seen before and might be kind enough to help me resolve.
On MySQL, I took away the ability for the root user to login from any remote host:
...
-2
votes
1
answer
3k
views
High Cpu Usage after MySQL Update (5.1 to 5.5) on CentOS 5.8 (64 Bit)
General Problem: Server load 20.92 (8 CPUs) [it varies from 7 to 40, normally it should be less than 1)
Server Specs:
Dedicated Server
Intel Core i7 (8 Cpus)
RAM: 8GB
We use WHM and we have about ...