Questions tagged [mysql5.5]

MySQL RDBMS version 5.5

42 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
Anadi Misra's user avatar
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....
GUI9876's user avatar
  • 31
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 ...
user1399233's user avatar
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 ...
Jordan's user avatar
  • 31
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 ...
thunderblaster's user avatar
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 ...
m4rty's user avatar
  • 78
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 ...
Dave's user avatar
  • 111
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. $ ...
michalzuber's user avatar
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 ...
Hamma's user avatar
  • 21
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....
Joe People's user avatar
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 ...
B14D3's user avatar
  • 5,258
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 ...
mossaab's user avatar
  • 175
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 ...
SlenderFenderBender's user avatar
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
ikool's user avatar
  • 11
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 ...
rahrahruby's user avatar
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 ...
Mahdi Ghiasi's user avatar
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 ...
starshine531's user avatar
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 ...
Mustafa's user avatar
  • 11
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 ...
sfsaf jaskfjsakf's user avatar
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 ...
Digital Ninja's user avatar
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 ...
aviv's user avatar
  • 167
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] ...
mohan reddy's user avatar
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 ...
Klode's user avatar
  • 101
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 ...
user3637899's user avatar
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 ...
Zorgatone's user avatar
  • 101
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....
brenguy's user avatar
  • 11
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 ...
Girish's user avatar
  • 101
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 ...
jma's user avatar
  • 445
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 ...
TiGR's user avatar
  • 121
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 ...
Adrián Castiglione's user avatar
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 ...
hosais's user avatar
  • 1
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 ...
user50946's user avatar
  • 483
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 ...
mc0e's user avatar
  • 5,931
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 ...
coderkane's user avatar
  • 101
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 ...
pauel's user avatar
  • 115
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 -...
Bathakarai's user avatar
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 ...
Loïc MICHEL's user avatar
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....
Dylan's user avatar
  • 181
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
Aha's user avatar
  • 419
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 ...
Engprof's user avatar
  • 17
-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: ...
L.Ray's user avatar
  • 113
-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 ...
Byivan's user avatar
  • 11