Questions tagged [mysql-5.1]
MySQL version 5.1 - please also tag with mysql for search purposes.
301
questions
0
votes
1
answer
140
views
MySQL update with inner join taking too long
I have the following two tables
CREATE TABLE `tbl_products_temp` (
`cd_id` INT(6) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
`cd_structure` MEDIUMBLOB NOT NULL,
`cd_smiles` TEXT NULL ...
- 155
0
votes
1
answer
171
views
Remote connecting to Asterisk mysql database from internet issue
I can connect to Asterisk MySQL database (asteriskcdrdb) and everything is okay. Asterisk server located in my LAN network. I can to connect to this database from my computer with Mysql client ...
- 101
0
votes
1
answer
2k
views
'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,EXPLICIT) for operation '='' on query
I have migrated the mysql 5.1 to 5.7 by using the mysqldump file. But i am facing the issue during master slave replication as below.
Error 'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (...
- 101
0
votes
1
answer
467
views
How to set up mysql docker container with existing ib* files?
Related to a previous issue, I'm trying to recover some data from existing ib* files from a crashed server. The database version is 5.1.69, so quite old. One of the responses was to install MySQL 5.5, ...
- 115
1
vote
1
answer
48
views
Latest version to support MySQL 5.1.69 ib* files
Would like to recover InnoDB data from a crashed server. The last backup indicated it was running MySQL server 5.1.69. When doing a recovery, the log files show that the current MySQL won't support ib*...
- 115
1
vote
2
answers
147
views
Problem with complex queries after migrating from MySQL 5.1 to MariaDB 10.4
I completed a migration from MySQL 5.1 master-slave system to a MariaDB 10.4 Galera Cluster. All the databases where copied over since they were on InnoDB per-file and they are working fine. However ...
1
vote
1
answer
4k
views
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error
I created a linked server to MySQL database server on my SQL Server database server. I tested the connection. It succeeded successfully for MySQL connection. I can see the databases on MySQL instance ...
- 69
1
vote
1
answer
305
views
MySQL still using one CPU even though extra CPU added
I m SQL server DBA. My company just handover one MySQL server to manage which i m still learning. Recently extra CPU has been added to the server due to CPU is 100% but when checked on the server , ...
- 13
1
vote
3
answers
5k
views
Mysql Daemon cannot start after upgrade from 5.1 to Mysql 8
I preinstalled Oracle Enteprise Linux and it automatically installed Mysql Community 5.1. But I wanna update it to 8.
After update the daemon won't start and the /var/log/mysqld.log shows that
[...
0
votes
1
answer
112
views
Update query over nested select query
Want to update status of only those record whose a_msisdn count > 100 on specific date:
mysql> select * from cc_info limit 1;
+----------------------+--------------+--------+------------+----------...
1
vote
1
answer
4k
views
Insert into table with column same values as auto increment column ( computed column )
Say I have a table with "column1" (Primary Key, Auto Increment) and "column2".
How can insert into the table with column2 will have the same values as column1 which is auto increment column?
- 13
2
votes
1
answer
19k
views
MySQL "bad handshake" after entering password
I'm having problem to connect to the remote DB from the terminal as follow
mysql -u db_user -p -h 10.100.1.100
Enter password:
afer entering password I'm getting that error:
ERROR 1043 (08S01): Bad ...
- 127
0
votes
2
answers
2k
views
How to replicate particular table in MySQL master-slave configuration?
How do I replicate a particular table in a MySQL master-slave configuration?
I have tried replicate-do-table and replicate-wild-do-table.
I tried in my.ini file; is there any alternative to replicate ...
0
votes
0
answers
197
views
Restoring backup with a MySQL Database downgrade
I want to migrate a MySQL 5.7 database to a MySQL 5.1 version because the MySQL version of the server I’m migrating my WordPress webpage is 5.1. I tried to do it in the usual way but it was not ...
2
votes
1
answer
5k
views
Host 'host_name' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
I'm getting following message:
Host 'host_name' is blocked because of many connection errors. Unblock
with 'mysqladmin flush-hosts'
I've tried to follow MySQL :: MySQL 8.0 Reference Manual :: B....
- 605
0
votes
1
answer
47
views
How to transfer data from mysql 5.5.24 to 5.1.36
I've had a server that is not booting up, it had mysql 5.5.24. I was able to copy the whole /data directory.
I will be temporarily using an older backup server that has mysql 5.1.36 and cannot be ...
- 105
1
vote
1
answer
246
views
MySQL server 5.1 trigger problem
I have implemented a trigger. But once I try to update the table it is giving me the error:
can't update table 'booking' in stored function/trigger because it is already used by the statement which ...
- 11
5
votes
2
answers
193
views
Is there a "soft" ORDER BY / GROUP BY?
SQL-Fiddle
http://sqlfiddle.com/#!9/c82c87b/1
Table Definition
First of all, this is my table:
CREATE TABLE `stackoverflow` (
`id` VARBINARY( 36 ) NOT NULL COMMENT 'GUID generated by PHP',
`time` ...
- 53
0
votes
2
answers
1k
views
display numbers with zero pad
I have some data stored as an unsigned tinyint. When displaying it I want it to be zero padded only if it is 1 digit in length. I have issues with LPAD(CAST(NUMBER AS CHAR CHARSET UTF8),2,'0') when ...
0
votes
1
answer
828
views
Changes between Mysql version 5.1 TO 5.7
I have recently migrated Mysql 5.1 to Mysql 5.7. DB Migration was successful but when the application started firing few selected queries, Mysql started taking hours to execute them for which ...
- 1
1
vote
1
answer
4k
views
Where should I store a custom ".my.cnf" file?
I am working in a Vagrant box (for development) and I have a provisioner script written in Bash. The script does install MySQL and setup a few things: basically it does what mysql_secure_installation ...
- 1,710
1
vote
0
answers
62
views
Optimization Technique For Update Query in MySQL 5.1.73-log
I am trying to optimize an update query on InnoDB table in MySQL 5.1.73-log.
As per my understanding we can not use EXPLAIN on update query for 5.1 version.
So what will be the alternate course of ...
- 371
0
votes
1
answer
1k
views
SELECT multiple columns when using GROUP_CONCAT with UNION
I have a frustrating situation caused by poor database design - unfortunately that part is out of my control.
This is the table definition:
CREATE TABLE `account` (
`account_no` int(10) unsigned ...
2
votes
1
answer
392
views
Chain replication M1 (5.1) -> S1 (5.5) -> S2 (5.6) to limit downtime for an upgrade 5.1 to 5.6
I have to upgrade a production server from 5.1 to 5.6 version. The favourite option would be to dump the database from 5.1 and import on 5.6 but this operation has been estimated to 2 hours on my ...
- 21
2
votes
1
answer
1k
views
MySQL innodb_row_lock_time is more than wall clock time
We recently started graphing the innodb_row_lock_time status variable in our monitoring system.
I noticed something I can't understand on a graph for a busy server:
Between 04:55PM and 04:57PM, the ...
- 121
1
vote
0
answers
1k
views
Unable to delete a MySQL InnoDB table
I am using MySQL 5.1.56
I have a DB with about 70 tables and I have an issue with a particular corrupted table e.g. Table_X
When I try to access the table mysql> select * from Table_x; ERROR 1105 (...
- 11
7
votes
2
answers
5k
views
MySQL and AUTO_INCREMENT columns in multiple-column index for InnoDB tables: support status?
Missing support for AUTO_INCREMENT columns in multiple-column index for InnoDB tables is a widely known limitation, as is the trigger workaround for when it is needed (see e.g this post). Yesterday, ...
- 145
0
votes
1
answer
88
views
How to roll back mysql 5.6 to sql 5.1
I recently updated mysql from 5.1 to 5.6 however it's causing too many issues with the websites hosted on my machine. Does anyone know how to remove mysql 5.6 and reinstall version 5.1.
- 101
0
votes
1
answer
87
views
MySQL in RHEL shows different versions
I was given a RHEL 6.9 server with MySQL installed and I just wanted to check the MySQL version running on it.
When I tried the rpm -qa | grep mysql or mysql --version or SHOW VARIABLES LIKE "%...
- 147
2
votes
2
answers
2k
views
Importing a large mysql dump while replication is running
So we have a simple master/slave mysql replication running between two CentOS Servers.
The master has multiple databases. eg..
Database1
Database2
Database3
The issue is we have a mysql dumpfile ...
- 21
1
vote
1
answer
2k
views
Removing InnoDB indexes causes database table almost not accessible and slow [closed]
I have a server with 32GB RAM. I have given almost 70% InnoDB buffer pool to it. I have table with almost 40 million rows. Recently, I tried to remove one of the indexes and replace it with another. ...
- 135
36
votes
5
answers
188k
views
MySQL: How to create Column if not exists?
I am trying to create a Column for my table only if it does not exist.
I have researched a lot but I could not find any solution yet.
Is this really possible to conditionally create Column ?
- 463
0
votes
2
answers
806
views
Simple, small table (5000 rows) with around 2% slow queries, with high table lock time - context_voluntary and block_ops_out
I am running MySQL version 5.1.69 and the tables in question are MyISAM.
I have a very simple table:
CREATE TABLE `tbl` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`otherID` int(11) NOT NULL,
`...
0
votes
1
answer
1k
views
Credentials for mysql fail for mysqldump in bash script [closed]
I am having a very strange problem in a script to back up MySQL schemas. The script creates a list of schemas and then runs the mysqldump command for each of them. The credentials are stored in a ...
0
votes
2
answers
2k
views
MySQL Server Overloaded
I have a MySQL 5.1 server that is struggling. We have too many rows in some of the tables and we do not have enough RAM - currently only 32 GB RAM.
I have RAM begin delivered tomorrow, but I ...
- 133
4
votes
2
answers
2k
views
Repeatable Read: Which one is correct?
Which one is correct?
With transaction 1 as Repeatable Read, other transactions can not update a row after it has been selected by transaction 1.
With transaction 1 as Repeatable Read, other ...
- 127
0
votes
2
answers
53
views
Need MySQL configuration options like 'first time'
When I installed MySQL-5.1.49-win32 for the first time I got a window asking 'root password' and 'confirm' in 'mysql server instance configuration wizard'.
Now I uninstall the software and install ...
1
vote
1
answer
92
views
mysql upgrade 5.0.45 to 5.1.7 and problem query
Have been working on a migration the past few weeks, and we have run into a mysql specific problem.
After creating a new VM, faster server than the old, we have a query that takes approx 2 seconds on ...
- 19
0
votes
1
answer
152
views
Importing a mysql database after drop filling up limited / in /tmp deleted file - A problem?
I'm importing a fairly large set of databases into a system which has a / partition only 10GB large. After a previous failed import, I dropped the database, but noticed /var/lib/mysql didn't exactly ...
0
votes
1
answer
152
views
MYSQL Password Settings
Is there a command that I could use to check the password settings for MySQL without looking into each account? I'm trying to get password max length, min length, lockout threshold, password history, ...
- 1
0
votes
1
answer
782
views
Can I roll back only MySQL?
I took all database backups before starting patching.
We want to update MySQL 5.6.30 to 5.6.32. If we want to roll back to 5.6.30 due to some issues, can we do that?
Would we have to roll back the ...
- 1
0
votes
2
answers
2k
views
MySQL query using alias to count certain years from DATETIME
I have a table which consists of an ID count, a DATETIME field named orderDate showing when a customer bought an item. I am trying to create a query which takes ID and orderDate, to find all dates ...
0
votes
2
answers
4k
views
Why is a 'Select distinct limit 100' using tmp tables? [closed]
I hope someone can teach me why MySQL is using temporary tables on a super simple select with a limit of 100 and how to get it do query more efficiently. I'm running MySQL 5.1.53-community.
The ...
- 133
0
votes
1
answer
2k
views
Not Able to Increase InnoDB Buffer Pool Size in Mysql
I am facing a very rare problem with my DB. I have Windows Server with 64 GB RAM but I am not able to increase innodb buffer pool size in mysql.
Current InnoDb buffer pool Size : 1.6G
When I ...
1
vote
3
answers
3k
views
MYSQL parallel query performance issue
Im working on a project for my company which sells huge amounts of weather data to customers through a Web API. As part of that API, there is a backend service which needs to fetch data from MYSQL ...
1
vote
1
answer
281
views
Increasing column from VARCHAR(255) in master/slave setup
We have replication set up on some MyISAM servers, in a master/save scenario, MySQL v5.1.
One of the columns is currently declared as VARCHAR(255). We want to increase this to VARCHAR(512).
We have ...
- 135
3
votes
2
answers
3k
views
count null values of table from information_schema tables
Is there any way to count null values in a column by using information_Schema tables? EG:
SELECT table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA ='myschema'
and ...
3
votes
2
answers
623
views
Skipping chunk X of Y.Z because MySQL chose no index instead of the word_sid_typeindex
My environment:
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.8 (Santiago)
# uname -a
Linux A.B.C 2.6.32-642.4.2.el6.x86_64 #1 SMP Mon Aug 15 02:06:41 EDT 2016 x86_64 x86_64 ...
- 605
0
votes
1
answer
1k
views
Mysql slave skipping some updates
I have an existing Mysql 5.1.73 Master/Slave/Slave configuration, which is working correctly and all changes are being replicated.
I have now set up a PerconaDB (mysql+galera+XtraDB) 5.6.30 3-node ...
- 111
1
vote
2
answers
2k
views
Mysql Refuses to Start
On HOST OS RHEL 6.5, I upgraded mysql server from 5.1 to 5.7.9. And when i try to start it refuses and give me these messages in Logs
2016-08-01T07:29:42.939712Z mysqld_safe Starting mysqld daemon ...
- 123