The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [mysql-5.1]

MySQL version 5.1 - please also tag with mysql for search purposes.

Filter by
Sorted by
Tagged with
1
vote
2answers
39 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
1answer
14 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
1answer
68 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?
0
votes
0answers
9 views

Table level replication in Mysql [duplicate]

I want to change the config file(my.ini) to replicate particular table. The following statement is working fine for particular database replication "binlog-do-db=databasename" and the same way i need ...
0
votes
1answer
109 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
0answers
27 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
1answer
1k 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....
0
votes
1answer
23 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 ...
0
votes
1answer
71 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 ...
5
votes
2answers
162 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` ...
0
votes
2answers
53 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
1answer
62 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 ...
0
votes
1answer
2k 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
vote
0answers
36 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 ...
0
votes
1answer
171 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 ...
1
vote
0answers
193 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 ...
1
vote
0answers
416 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 (...
0
votes
1answer
68 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.
0
votes
1answer
46 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 "%...
2
votes
2answers
968 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 ...
1
vote
1answer
756 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. ...
9
votes
3answers
41k 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 ?
0
votes
2answers
461 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
1answer
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
2answers
877 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 ...
1
vote
2answers
495 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 ...
0
votes
2answers
39 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
1answer
70 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 ...
0
votes
1answer
68 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
1answer
110 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, ...
0
votes
1answer
261 views

MYSQL Patching -Roll back

MYSQL patching. I took all database backups before starting patching. If we patch mysql 5.6.30 to 5.6.32 and if we want to rollback to 5.6.30 due to some issues. Can we do that? if so should we have ...
0
votes
2answers
775 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
2answers
1k 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 ...
0
votes
1answer
833 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
2answers
2k 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
1answer
100 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 ...
3
votes
2answers
1k 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
2answers
327 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 ...
0
votes
1answer
434 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 ...
1
vote
2answers
887 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 ...
0
votes
1answer
1k views

adding a column with default value to slow in mysq 5.1

I am adding a char(1) column to a table with this: mysql> alter table TransaccionesConvenio add Test2 char(1) default 's'; Query OK, 6711062 rows affected (52 min 27.75 sec) Records: ...
-2
votes
1answer
41 views

How can we migrate Data with MySQL 5.1 - MyISAM to another server with MySQL 5.6 - InnoDB

Currently we have a MySQL 5.1 - MyISAM database on a physical server. We need to move it to another server with MySQL 5.6 - InnoDB at another location. DB size is quite large - 210GB Can someone ...
1
vote
1answer
151 views

Grabbing SQL Dump of Master DB Without Downtime

I'm curious whether downtime will be necessary to grab a SQL dump of my master database. Right now, I'm in the process of rebuilding my one slave. There is actually only one database from master that ...
3
votes
2answers
614 views

Will hacking away ibdata1 destroy databases with only MyISAM tables?

I made a mistake. I have a huge database of MyISAM tables that I was playing with converting [a copy of] to InnoDB. I didn't set innodb_file_per_table=1 before doing so. I know that safely shrinking ...
2
votes
1answer
1k views

Is there any impact to changing IP address of MySQL Server?

We are changing the network and the IP addresses will be changing. Will there be any impact to MySQL running on the server? I don't use the IP address to reference the server. Instead I use the ...
0
votes
1answer
2k views

MySQL Commands out of sync error

I am new to MySQL, normally use SQL Server. I have a MySQL server (version 5.1.73) and I have two databases, syslog and syslog_archive. There are three tables: syslog.logs syslog_archive.logs ...
1
vote
1answer
845 views

Will a mysql db import be interrupted if my ssh session times out?

I have a large-ish (several GB) mysql DB that I'm planning to import via mysql -u root -p mydb < mydb.sql in a SSH session. What would happen if my SSH connection drops? Is it safer to run ...
3
votes
4answers
3k views

MySQL Front - Workbench

We have MySQL Front installed in our server, I can connect to it with no problems, there is a db with tables, everything fine. Now I installed MySQL workbench (client) in the same server, but can't ...
1
vote
0answers
80 views

Unable to get anything other than 'Remote scan' when selecting from linked MySql server

I have a linked server in SQL Server 2012 (SP3) that points to a MySql 5.1.61 server on another machine. Whatever I do, I don't seem to be able to get any where filtering to occur on the remote side. ...
1
vote
0answers
753 views

MySQL 5.1 - Display the error-message returned inside a stored precedure

I'm trying to find an alternative to display the error-message returned from MySQL-5.1/5.5 inside a stored procedure. The example below is what I'm looking for, however it's seems to be only allowed ...