Questions tagged [mysql5.5]

MySQL RDBMS version 5.5

Filter by
Sorted by
Tagged with
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 ...
1 vote
2 answers
3k views

MySql Server does not start with innodb_force_recovery set to value 1-6

I have an ubuntu 14.04 KVM that was running as server LAMP till today when I have installed a Wordpress Plugin and the MySql Server 5.5 stopped working. I have tried to start the server multiple ...
12 votes
4 answers
48k views

Slave replication stops with Last_SQL_Errno: 1032

I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the ...
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
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

How to remove orphaned foreign key constraint in MySQL?

Using MySQL 5.5. I have a table for which I can't add a foreign key: ALTER TABLE `SOURCE_TABLE` ADD CONSTRAINT `ConstraintFK` FOREIGN KEY (`otherTableID`) REFERENCES `OTHER_TABLE` ...
71 votes
18 answers
130k views

`mysql_upgrade` is failing with no real reason given

I'm upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed ...
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 ...
8 votes
4 answers
20k views

enabling ssl connection from wordpress to mysql

I have been searching on how to configure wordpress to connect to mysql db over ssl, however most of the example are about three to five years old e.g. this wordpress support topic my wordpress ...
15 votes
4 answers
23k views

Variable 'general_log_file' can't be set to the value of '/var/lib/msyql/ubuntu.log'

I changed the value of mysql's general_log_file variable to something else, and now I'm trying to change it back to what it was originally, /var/lib/mysql/ubuntu.log. But when I do: SET GLOBAL ...
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 ...
1 vote
2 answers
639 views

What would cause mysqlcheck to incorrectly report a table as undamaged?

We are administering a MySQL server for one of our customers that has >100 databases with about 50 tables each, many of them InnoDB tables. The server crashed and I'm trying to find the culprit. When ...
7 votes
1 answer
5k views

MySQL Slave stuck on a single bin log + bin log position for 17+ hours

tl;dr: Replication is stalled on a specific binlog and position, and I'm not sure why I have a MySQL Replication setup with MySQL 5.5. This replication setup has no history of ever falling behind ...
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 ...
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
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....
2 votes
3 answers
3k views

MySQL keeps crashing [closed]

So a little background, a few weeks ago I brought a new CentOS dedicated server in Melbourne, however it seems beside the number of attackers I get, there also seem to be an issue with the MySQL ...
0 votes
1 answer
284 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
5k views

MySQL copy temp table filled disk, how do I remove temp files?

What is the safest way to clean up? MySQL server 5.5.62-0 on Debian 8 with no replication. I made a mistake and created a new column on a 26GB table. SHOW PROCESSLIST showed MySQL was copying the ...
0 votes
1 answer
182 views

After Migration from MYSQL to Maria DB, query returns different cases for a result sets column names

Were attempting to migrate mysql servers to MariaDB on a new AWS (amazon-linux-2) instance. After creating a new instance and installing mariadb we've dumped the old database via mysqldump ... --add-...
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
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 ...
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] ...
20 votes
3 answers
51k views

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote MySQL server to use them (and SSL is enabled) I ssh into my remote server, and try connecting to its own mysqld using SSL (...
1 vote
2 answers
4k views

Accidentally delete ibdata1, ib_logfile1 and ib_logfile0

Actually i have problems with the database always down due to log. Usually when I restart it will work just fine. But recently the database cannot start and make me think to simply delete those ...
2 votes
3 answers
5k views

MySQL Service Stop although Restart=Always

I've an Amazon t2.small EC2 - 1 Core and 2GB RAM it's more than the minimum requirements for CentOS and Virtualmin My System: CentOS 7.5.1804 Virtualmin MySQL 5.5.60-MariaDB Apache 2.4.6 The ...
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 ...
1 vote
3 answers
1k views

How to speed up final stage of xtrabackup with lots of tables?

I have a MySQL 5.5 database with thousands of tables and heavy write workload. I need to use xtrabackup to take online backup (create a slave from production server with minimum downtime), but the ...
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 ...
-5 votes
1 answer
9k views

MySQL : How to lock all write in all databases? [closed]

I need to block all writes (insert , update, delete) on all databases. How can I do that ? Put all database in Read Only for a period time.
2 votes
1 answer
136 views

Bugzilla migration from ubuntu 10.04 to 14.04 with Mysql 5.1 to Mysql 5.5

I am running Bugzilla 4.0 on Ubuntu 10.04.4 LTS running on physical server & thought of upgrading it to Ubuntu 14.04 on Hyper-V for testing. After migration of bugzilla webroot 4.0 to Ubuntu 14....
0 votes
1 answer
2k views

mysqldump --single-transaction on slave (without stopping replication)

Is it okay to run mysqldump --single-transaction on Slave DB without stopping replication (stop slave;)? This is for regular daily backup so we can restore Master DB in case of a storage disaster. ...
0 votes
1 answer
335 views

PHP site on new server can't connect after authenticating user

I'm moving an existing PHP/MySQL website application to a new server and for some reason I'm getting a "ERR_CONNECTION_REFUSED" error after I login. I've installed PHP and MySql and copied the ...
0 votes
2 answers
3k views

MySQL Server won't start on non-standard port

I am trying to allow external clients to access my database server through a extremely strict college firewall i.e. only ports 80 & 443 open. To allow clients to communicate with the server, I ...
0 votes
1 answer
88 views

Mysql crashes - plugin library

I would like to ask if from below log we can say that crash of Mysql was because of our custom library for Mysql? Sep 26 15:24:30 mysqld: /usr/lib/mysql/plugin/my_lib_discounts.so(...
6 votes
3 answers
16k views

Maximum execution time of 300 seconds exceeded error while importing large MySQL database

I'm trying to import 641 MB MySQL database with a command: mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql but I got an error: ERROR 1064 (42000) at line 2351406: You have an error ...
-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: ...
0 votes
1 answer
225 views

AWS RDS mysql upgrade 5.5 to 5.6

What is the best/easiest way to upgrade and RDS instance running mysql 5.5 to 5.6. I have seen two potential methods: modifying the instance - this seems the easiest method - have people done it - ...
0 votes
1 answer
5k views

Centos 7 Postfix install using MYSQL 5.7 which replaced mariadb

Sorry to disturb you, but I've a problem I can't seem to get around. I'm trying to install Postfix on a new server which was needed to move to for more space/memory, the old server had 256MB of RAM ...
2 votes
4 answers
5k views

MySQL query cache is enabled but not being used

I've checked the query cache is enabled mysql> SHOW VARIABLES LIKE 'have_query_cache'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | have_query_cache | ...
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 ...
3 votes
1 answer
637 views

CSV engine on MySQL server

I don't think that this is a programming question so I am going to ask it here - Reading the book high performance mysql, I read about the CSV engine. The paragraph says: The CSV engine can treat ...
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 ...
1 vote
1 answer
3k views

Why can't I uninstall mysql-5.5 & install mysql-5.6 on Amazon Linux machine?

I'm on a 64-bit Amazon Linux machine. I had previously installed mysql-server 5.5. (using sudo yum install) However, I soon found out that my application requires MySql-serve 5.6. So I uninstalled ...
0 votes
1 answer
448 views

Why can I not re-create a dropped database?

I'm on a Debian host, and dropped a database from a Django project and then tried to re-create it. I've tried variations on a same basic theme from mysqladmin and mysql to create a database, and (...
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 ...
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 ...
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 ...
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 ...