The mysql-5.1 tag has no wiki summary.
6
votes
1answer
205 views
Why does Oracle keep working on MySQL 5.1
2 years ago the first version of Mysql 5.5 was released. What is the reason to continue working on MySQL 5.1 - the current release is Mysql 5.1.62
It looks like there are should be fundamental ...
5
votes
1answer
226 views
Migrating MySQL to new server
We have a MySQL 5.1 instance running on Windows Server 2008 R2 x64 (Server A) replicated to another MySQL 5.1 instance on Windows Server 2003 R2 (Server B).
We have a new MySQL 5.5 instance on ...
5
votes
1answer
105 views
What is the expected performance impact when dropping a large table
I have a 100G+ innodb table that needs to be dropped in a production environment. I am trying to do this without interruption to service.
The table is no longer being written to, and needs to be ...
4
votes
1answer
161 views
If MAX(id) != COUNT(id), does that mean rows have been deleted?
The question pretty much says it all. We're talking MySQL here, version 5.1.
What I'm wondering is whether this would strictly means rows have been deleted, or if there are other possible scenarios ...
3
votes
1answer
916 views
What memory should be given to the variables of my.cnf ?
Installing a MySQL server is quite easy. However, after installing, configuring the server is an important task for a DBA.
Having 2GB of RAM and 250GB of disk space, how should I tune MySQL server so ...
3
votes
1answer
60 views
How can I get this query to use it's index?
Queries matching this query below shows up in the slow log (with different contentVersionId & modifiedDateTime).
As I don't really know what I'm doing I tried adding indexes to all columns in ...
3
votes
1answer
997 views
Does `Seconds_Behind_Master` show exact Slave Lag from Master?
Does Seconds_Behind_Master show the correct result?
I have also Implemented the mk-heartbeat replication monitoring.
It was showing the other result in comparison with Seconds_Behind_Master.
Which ...
3
votes
1answer
431 views
Is it possible to compare timestamps between rows?
I have a MySQL table reqs with (this is simplified from actual):
| Field | Type | Null | Key | Default | Extra |
...
3
votes
1answer
162 views
Clarification about master slave configuration in mysql
We are planning to migrate an existing MySQL database to a new server using the MySQL replication master slave procedure.
Unfortunately this will take a lot of time so we were thinking of doing a ...
3
votes
1answer
2k views
MySQL : if server_id is not explicitly set, then get error `ERROR 1200 (HY000) at line 1: The server is not configured as slave;`
Our mysql version is "mysql Ver 14.14 Distrib 5.1.35, for portbld-freebsd7.2 (amd64) using 5.2"
We have two database servers with replication, in a simple master/slave relationship. mysql2 is the ...
3
votes
2answers
177 views
Can I do anything about a very long running KILL command?
I've got a table with 103M+ records in it and takes up 70GB on the disk. I decided to DELETE (in one statement) 70% of the records.
As expected, this took an awfully long time to run. I decided to ...
2
votes
2answers
629 views
Can we assign mysql Key_buffer_size value for particular table?
In some documents I found that we can assign key_buffer_size to myisam table. This also includes the following steps:
SET GLOBAL myisam_table.key_buffer_size = 4194304;
CACHE INDEX test.myisam_table ...
2
votes
1answer
145 views
Innodb Slow queries since convert from MyISAM
a few days ago we converted some write intensive tables from MyISAM to InnoDB hoping to have a better performance due the better locking system of InnoDB, but instead of gain performance, we start to ...
2
votes
1answer
79 views
How can I disable utf8mb4 entirely on MySQL 5.5?
I know you're not supposed to do this, but I have a MySQL 5.5 master and a MySQL 5.1 replication slave. That's supposed to be okay, unless I do something stupid like use utf8mb4 that isn't supported ...
2
votes
1answer
1k views
Change existing datadir path in mysql
I want to change the datadir path in the my.ini file.
The existing datadir path is C:/ProgramData/MySQL/MySQL Server 5.1/Data/
The size of my C: drive is 30GB and the MySQL data folder is occupying ...
2
votes
1answer
455 views
log_warnings doesn't seem to work for aborted connections in MySQL 5.1
The docs for 5.1 say that I can set log_warnings = 2 to capture Aborted_connects in the error log. This bug report suggests that this was only merged into 5.5 and 6.0 (and maybe 5.2) but not into ...
2
votes
1answer
647 views
How to optimise read/write performance a MySQL table with many rows?
I am developing a django application where I use a MySQL database. In my application there is one table for domains information which has only 2 coloumns
id
domain_name
but I have a problem when I ...
2
votes
1answer
4k views
MySQL case sensitive table names on Linux
Moving a MySQL database from Windows to Linux I have the problem that on Linux the names of the tables are case sensitive. This is a problem, because the Java application that I am developing can't ...
2
votes
1answer
1k views
Repairing Myisam Table when there was no additional Disk space & Table corrupted
I had a table which MyIsam as storage Engine contains million rows. There is a purging task and need to remove 35 days old data. i measured up the rows in following manner :
mysql> select ...
2
votes
1answer
350 views
MySQL proxy and SHOW PROCESSLIST query time
I have MySQL replication currently occurring between two masters bidirectionally, one in a data center locally, another over at Amazon EC2.
Everything seems to function normally replication wise, no ...
2
votes
1answer
63 views
Problem in Fetching Result set in Desired Format
I have 2 tables having the following columns
Person
------
person_id,
first_name,
middle_name,
last_name
Items
-----
person_item_id,
person_id,
item_type,
status,
ordered_date
The query is
...
2
votes
2answers
3k views
innodb_flush_method=O_DIRECT vs O_DSYNC performance impact on ext3 with LVM disk partition
In one of my production environment, we have two instances running on a RedHat cluster, with one production instance associated with the cluster.
We have 125G main memory with 24G InnoDB buffer pool ...
2
votes
1answer
488 views
Take individual MySQL database offline
MySQL does not have any SQL commands or internal mechanisms for
making an individual database unavailable / offline
moving an individual database
Thtis being the case, how can you take an ...
1
vote
1answer
102 views
Help Optimizing Query
For the following table structure in MySQL 5.1.49:
CREATE TABLE `leads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`institution_id` int(10) unsigned NOT NULL,
`lender_id` int(10) unsigned ...
1
vote
2answers
405 views
Mysql master-master permission replication issue
I came to know it's safe to replicate mysql database to have the users and permissions replicated, from a post in ServerFault is-it-ok-to-replicate-mysql-db. I have setup master-master replication ...
1
vote
3answers
173 views
getting error while starting memecached service with ndb engine
i am installed memcached library by following the steps in the internet.
now there is a binary file created in bin folder of mysql
now i exicuting the command memcached i am getting error like this ...
1
vote
1answer
2k views
Mysql master-master replication auto flush old logs
I have mysql-5.1.41 master-master setup running on ubuntu machines and below is the configuration of a master:
skip-host-cache
skip-name-resolve
event_scheduler = ON
max_connections = 500
...
1
vote
3answers
95 views
Can I make sure two columns dont have the same value
If I have a table that looks like this
CREATE TABLE foo (
id INT NOT NULL AUTO_INCREMENT,
aa INT NOT NULL,
bb INT NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY (aa, bb),
CONSTRAINT aa_ref ...
1
vote
1answer
159 views
My SQL server showing different result with same query execution at different time
When I execute below query from MySQL server, it shows me different output for each time even though database is stable and not used by anyone except me.
SELECT TABLE_NAME , table_rows
FROM ...
1
vote
2answers
2k views
How do you install MySQL 5.1.34 on CentOS 5.5?
I am trying to install Mysql 5.1 on cent OS. I researched a lot but could not find any link which gives step by step procedure. Everywhere, there are vague answers. Can someone please give me steps ...
1
vote
1answer
605 views
Solutions to 4-byte utf-8 characters in mysql 5.1
I'm running into a problem that seems to be an issue w/ mysql 5.1s limitations on UTF8 characters.
From http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-utf8.html
Currently, MySQL support for ...
1
vote
2answers
300 views
Lost connection to MySQL server during query
Here is a part of my query
SELECT * INTO OUTFILE 'Target_File_Name' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '' FROM (SELECT 'Start time','Calling no','Called ...
1
vote
2answers
258 views
why can I only install MySQL 5.1 on cent OS 6.2?
I had Ubuntu 10.10 on my server and MySQL 5.1 version. But since i wanted to update the system, I installed a fresh version of Cent OS 6 only so I could install the latest version of MySQL. But after ...
1
vote
2answers
687 views
Client to use the slave when the master is down in MySQL replication
Is it possible for the client to use the slave when the master is down in mysql replication?
I have already setup a simple mysql replication having a master and a slave.
The client connects to the ...
1
vote
2answers
506 views
How to eradicate Mysql Slave Replication delays when huge updates from master
At my environment we had slave replication with mysql server version 5.1.47
enterprise version.When ever there is huge updates from master, slave is lagging behind
the master. What is the best ...
1
vote
1answer
37 views
Is there any query to fetch the a single row data in chunks?
The data stored in a row is just like "Phone Number:--- xxxxxxxxxxx Call Type:--- MISSED Call Date:--- 2013-06-13 Call duration in sec :--- 0 Phone Number:--- xxxxxxxxxxx Call Type:--- OUTGOING Call ...
1
vote
1answer
84 views
How to solve “The table … is full” with “innodb_file_per_table”?
I have a MySQL database that holds a large amount of data (100-200GB - a bunch of scientific measurements). The vast majority of the data is stored in one table Sample. Now I'm creating a slave ...
1
vote
1answer
70 views
Is there a way to recover this database (MySQL)
I did a "cold" (db offline, all filesystem files) backup of a MySQL db.
I wrote the backup to an ISO image. Unfortunately Joliet filenames are not default.
I didn't realize that until attempting to ...
1
vote
1answer
109 views
What would cause Mysql database entries to be truncated to 253 characters?
Randomly seeing database entries truncated to 253 characters on a php site and can't figure out why or if it could be malicious or a corruption issue. Any thoughts would be appreciated.
1
vote
1answer
327 views
How soon after updating expire_logs_days param and restarting sql will old binlogs get deleted?
MySQL 5.1.x | InnoDB | Windows
My mysql data directory is starting to fill up with bin logs.
I currently have the following settings configured in my windows mysql server:
[mysqld]
log-bin
...
1
vote
1answer
356 views
Is there a progress indicator for OPTIMIZE TABLE progress?
MySQL 5.1.4x (Windows) | Innodb
I recently purged data from a mySQL DB (a few hundred thousand rows) and I'm planning to use
OPTIMIZE TABLE LOGTABLEFOO1,LOGTABLEFOO2,LOGTABLEFOO3;
to reduce the ...
1
vote
1answer
275 views
How to properly secure MySQL database?
We have a web application based on the famous triad apache + php + mysql which we sell to our customers and gets installed on their servers.
Currently, we are using MySQL 5.1.41 which has only a ...
1
vote
1answer
431 views
Retrieve double data type value in non exponential form
Is it possible to retrieve non-exponential value in double data type column? After the width of the column is increased to 15 it shows the values in exponential form.
Now I get the following:
...
1
vote
1answer
97 views
How do I restore 3 tables into a MySQL database from a single Windows dump file?
I want to import 3 specific tables from a dump file that contains 270 tables.
The dump file, naveen_ifs_db.sql, is 20 GB.
How do I restore 3 tables from that dump-file using the command line in ...
1
vote
1answer
171 views
SHOW SLAVE HOSTS shows incorrect output
I had used --report-host option in one of my slaves, so that I could see that under SHOW SLAVE HOSTS. Now that server is no longer in use. I have uninstalled that server as well. Unfortunately I still ...
1
vote
1answer
3k views
Error Code: 1205 Lock wait timeout exceeded in MySQL
I have set InnoDB lock wait time-out to 120 seconds.
When I run the query below for first time, it works fine. However, the second time, the same query with a different value gives me:
Error ...
1
vote
1answer
172 views
MySQL lost records in a master slave scheme
We have developed a web application that uses two MySQL servers set up with replication (master-slave scheme). The application was to be used for a couple of days only, when ~ 50-60 users would enter ...
1
vote
1answer
164 views
time executing inserts + slow SSH
_ Hello,
my setup is a slow SSH to some linux machine. From there I start a mysql terminal client and execute about 200k inserts (in a while loop inside a stored procedure). This takes about 3 hours ...
1
vote
2answers
2k views
How to install MySQL 5.1 on Ubuntu 10.10?
I researched a lot but could not find any link which gives step by step procedure. Everywhere, there are vague answers. Can someone please give me steps to be followed to install Mysql 5.1 ?
It gives ...
1
vote
1answer
660 views
MySQL - MySqlDump uses \n instead of null
Using Windows with MySQL 5.1.
I am running a script that uses mysqldump to backup a database.
The mysqldump syntax used is:
mysqldump --user=root --port=3306 --password=topsecret some_database ...
