The mysql-5.1 tag has no wiki summary.
0
votes
1answer
252 views
Mysql:Need to upload data to database, get duplicate key error - how can dup keys be ignored
I'm uploading data to a db (mysql 5.1.42) from a dump file using mysql command line and get duplicate key error.
This is the format I use:
/mnt/temp# mysql -u username -p -h url_of_db_master -D ...
1
vote
2answers
254 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 ...
2
votes
1answer
3k 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 ...
1
vote
1answer
162 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
0answers
313 views
mysql pre-start process (23901) terminated with status 1
I installed a new Mysql server version 5.1 on machine which was running on 5.0. Now when I try to start the mysql server using command service mysql start it gives me an error start: Job failed to ...
1
vote
0answers
197 views
why is MySQL 5.1 on ubuntu 10.10 not starting? [closed]
I just installed a MySQL 5.1 server on Ubuntu machine. after installation the server should automatically start but it does not start and gives me an error start: Job failed to start
. Even when I ...
6
votes
1answer
204 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 ...
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
3answers
172 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
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
2answers
670 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 ...
5
votes
1answer
99 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 ...
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
...
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 ...
1
vote
2answers
391 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
1answer
629 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 ...
1
vote
2answers
478 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
333 views
Problem with MySQL Master/Slave reboot when in replication
There is a master and number of slaves connected to it.
Due to some patches, we have to Reboot the Master and Slave.
Afterwards, we have to make sure replication is running fine.
While doing this ...
3
votes
1answer
978 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
856 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 ...
2
votes
1answer
347 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 ...
3
votes
1answer
425 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
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 ...
