The mysql-5.1 tag has no wiki summary.
1
vote
1answer
46 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 ...
3
votes
1answer
58 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 ...
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
...
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 ...
1
vote
1answer
111 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
65 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 ...
0
votes
0answers
48 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 ...
1
vote
3answers
89 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 ...
0
votes
0answers
47 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
1answer
46 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 ...
2
votes
1answer
130 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 ...
0
votes
0answers
24 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] ...
-4
votes
1answer
62 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!!!
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
55 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
1answer
149 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 ...
2
votes
1answer
76 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 ...
1
vote
1answer
107 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.
0
votes
1answer
241 views
MySQL: Can't find record in tablename
After crash:
mysql> repair table lot_not_sold;
+------------------------+--------+----------+---------------------------------------------------------------+
| Table | Op | ...
0
votes
3answers
480 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 ...
1
vote
1answer
290 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
316 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
228 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
73 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 ...
2
votes
1answer
459 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
173 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 ...
0
votes
0answers
112 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 ...
1
vote
1answer
144 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 ...
0
votes
1answer
575 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 ...
3
votes
2answers
157 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 ...
1
vote
1answer
400 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:
...
5
votes
1answer
220 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 ...
4
votes
1answer
158 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 ...
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
215 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 ...
0
votes
0answers
372 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', ...
2
votes
1answer
930 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
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 ...
1
vote
2answers
90 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
1answer
167 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 ...
3
votes
1answer
159 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 ...
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
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
566 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 ...
2
votes
1answer
410 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
2answers
594 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 ...
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
299 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 ...
2
votes
1answer
624 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 ...
