Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql-5.1]

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

0
votes
1answer
17 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 ...
-1
votes
0answers
13 views

mysqldump from MySQL5.1 to MariaDB 5.5 breaks Wordpress site

We have an unstable Windows installation of Wordpress that uses MySQL 5.1.73. I am trying to migrate/upgrade this to MariaDB 5.5.62. I am creating a mysqldump of the Wordpress DB, uninstalling MySQL 5....
0
votes
1answer
58 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
134 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
34 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
33 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
464 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
22 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
100 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
81 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
246 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
0answers
22 views

Search in two columns with commas mysql [duplicate]

I have a problem when using comma in a field my query $findd = KL123,OTHER123 $query = "SELECT * FROM test1 WHERE concat_ws(' ', column1, column2) LIKE '%".$findd."%' or concat_ws(' ', column2, ...
0
votes
0answers
46 views

Dumping consistent db on heavy I/O load for migration [duplicate]

On a heavy server (~10db, >100tables, >100M rows, >100GB, MyISAM and InnoDB), what is the best practive to produce a consistent dump despite a heavy writing load ? A lock on the tables, over an half ...
0
votes
1answer
54 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
42 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
534 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
334 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. ...
1
vote
2answers
22k 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
305 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
893 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
520 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 ...
0
votes
0answers
144 views

Missing 'password_expired' column. Need to set password expire policy

My mysql version is 5.1.63-community-log and I need to set password expire policy. describe mysql.user; It shows no password_expired column! Field Type Null Key Default Extra Host char(...
1
vote
1answer
323 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
38 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
65 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
48 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
88 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
153 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
475 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
674 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
616 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 ...
0
votes
2answers
1k 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
82 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
277 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
352 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
621 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
37 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
142 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 ...
2
votes
2answers
424 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 ...
1
vote
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
1k 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
447 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
44 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
680 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 ...
1
vote
2answers
1k views

Should MySQL database be in dedicated server?

The application has about 10 databases. Both application and databases are in the same server since is client does not want any time delay that could possibly occur if the database is in a dedicated ...
1
vote
0answers
120 views

Database has thousands of randomly named tables

Preface: First of all excuse me for bringing forwarding this weird question, as it could be just me. Situation: We have a Centos 6.5 Cloud VPS hosting our website, running MySQL 5.1 and it is also ...
0
votes
2answers
130 views

Importing mysqlnd database to MySQL server

Importing a mysqlnd (5.0.12) database to MySQL server (5.1.66) causes error? Currently we are performing this task and encountering errors (like below): ERROR 1146 (42S02): Table 'xx-xxx-xxx-xxx' ...