Questions tagged [mysql5.5]
MySQL RDBMS version 5.5
134
questions
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 ...