The mysql-5.1 tag has no wiki summary.
1
vote
1answer
353 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 ...
1
vote
1answer
149 views
Mysql Forcing close of thread 946 user
My mysql box keeping shutting down and up. Below is snippet of the log file. There is quite a number of places I notice this Forcing close of thread 946 user:
130426 12:36:28 [Note] Event Scheduler: ...
1
vote
1answer
76 views
mysql freeze/crash on JOIN
here is query:
SELECT nw.news_id, nw.title, nw.description, nw.url, nw.date, nw.image,
nw.status, src.title as src_title, src.keyword as src_keyword,
src.url as src_url, src.icon as ...
1
vote
0answers
82 views
Database instance keeps restarting
From the past few days, our MySQL database instance has crashed and had to be restarted a few times. My MySQL version is 5.1.57-log. The CPU and memory usage was way below 50% during the crash time. I ...
1
vote
1answer
187 views
How to run a cold backup with Linux/tar without shutting down MySQL slave?
I run the following before tar-ing up the data directory:
STOP SLAVE;
FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
1
vote
1answer
222 views
MySQL Master-Slave Replication Cross Database
I am setting up Replication for cross Database as i have set 2 variables in Slave' s my.cnf as replicate-do-db=database_name and
Replicate-wild-do-table=database_name.% ,But i am not able to get ...
1
vote
2answers
93 views
Does pt-table-checksum point out rows that are different between Master and Slave?
Trying to verify replication integrity of my replica. And I found that pt-table-checksum is one of the best ways of doing it.
I have a simple Master->Slave set up. Have created a sample table with 10 ...
1
vote
0answers
31 views
How does MySQL 5.1 use indexes?
I've read the docs for MySQL v5.1.x on how about the indexes are used, but I'm not sure I understood it properly.
Suppose having the following MySQL table:
CREATE TABLE IF NOT EXISTS ...
1
vote
0answers
330 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
201 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 ...
0
votes
1answer
630 views
Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down
I always wonder, why does the max_used_connections value not come down, once it reaches the peak value of max_connections?
I always flush the status and bring down this value to avoid DB connection ...
0
votes
1answer
204 views
Adding a user to MySQL with 'name'@'%' fails with ERROR 1396
I just tried to add a new user to MySQL using
CREATE USER 'name'@'%' IDENTIFIED BY '...'
However, it fails with the following error:
ERROR 1396 (HY000): Operation CREATE USER failed for ...
0
votes
3answers
543 views
Automatic MySQL Replication Fail-over Strategy
I want to know that if replication is down due to some reason as if master is down then what strategy should be followed so that the replication is up instantly without manually intervening the ...
0
votes
1answer
49 views
Circular replication with servers in different locations
My service runs on single machine, and database (mysql 5.1.66) is replicated to 2 other identical slaves (with lesser system resources, mysql 5.1.66) via chained replication. Machines are located in ...
0
votes
1answer
266 views
MySQL: Can't find record in tablename
After crash:
mysql> repair table lot_not_sold;
+------------------------+--------+----------+---------------------------------------------------------------+
| Table | Op | ...
0
votes
1answer
259 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 ...
0
votes
0answers
47 views
InnoDB data back in 3 months after OS shutdown
I've got an interesting issue last week that after shutting down an instance of mine, all data were back in 3 months (like a big rollback), even though there is no sign of crashing, recovery crash ...
0
votes
0answers
17 views
strange io in mysql server
one of mysql servers becomes slow recently, and I found that there is a high IO in the server:
$ sudo pt-ioprofile -cell sizes
Mon Apr 29 22:39:32 CDT 2013
Tracing process ID 16934
total ...
0
votes
0answers
50 views
MySQL “hangs” after every restart.. corrupted tables every now and then.. (5.1.68-cll)
I was seeking an advice in forums about a problem that we face last days. We have a vBulletin forum, we never had any problems in general, but the last couple of days MySQL server hangs and when we ...
0
votes
0answers
50 views
Mysql query is very slow
I am developing a website like any other social networking site using mysql.
I wish it give people suggestion to my users, and I have implemented this functionality in my application, but It is ...
0
votes
0answers
28 views
MySQL becomes unresponsive because user reached its OS quota
In CentOS 6.3/MySQL 5.1.67 I had an user that runs wordpress reaching its OS space quota (mostly files, the DB is less than 100Mb). When the user tried to create a post it triggered an [ERROR] ...
0
votes
0answers
48 views
Returning multiple resultset from the same table
i am working with mysql procedure. final result set i have got in to one table.
now i need to return for each set i need to return the value.
example:
like this is contents in my the table.
i need ...
0
votes
0answers
58 views
MySQL flush tables taking too long
I am using MySQL 5.1. I have many databases with a lot of tables.
I used to do a Flush Tables once a day, and it used to take about 5 minutes. Since last Tuesday, it takes about 1.5 hour to be ...
0
votes
0answers
119 views
Which update is faster using join or sequential?
My this question is in sequence of my previous question I asked.
I could write two solutions using Stored Procedure instead of trigger or nested-query .
Both use a helper function ...
0
votes
0answers
382 views
Plesk 11 MySQL connection problem when specifying database
I am having some connection problems with MySQL users when trying to connect directly to a database. This came up when trying to use mysqli_connect in PHP.
$dbc=mysqli_connect('127.0.0.1', ...
-1
votes
2answers
61 views
Infinite Loop While Running Query
When I run this query from the command line, it continuously loops. I'm not sure why this is occurring. Could anyone explain this to me, and please offer a fix.
I will be using a query similar to ...
-4
votes
1answer
65 views
where can I get mysql-5.1.7.tar.gz or mysql-5.1.9.tar.gz? [closed]
I need mysql-5.1.7.tar.gz or mysql-5.1.9.tar.gz, but I can not find them anywhere, who can give me a link to find them, thank you very much!!!
