-
From: Brad Barnett [mailto:mysql-general-l...@l8r.net]
Sent: Friday, January 20, 2017 10:45 AM
To: mysql@lists.mysql.com
Subject: Re: io thread very slow copying binlogs
Hey Morgan,
Thanks for the tip. Might come in handy.
But, I'm positive it's not a disconnect / reconnect thing
ve and master.
> >
> > Network tests, such as:
> >
> > - using scp to copy binlogs directly
> > - using different NICs to copy binlogs
> > - using mysqlbinlog to snag logs (the most 'real' way I can think to
> > simulate the replication thread copying
ught up on slaves.
> > > >
> > > > I've done all I can, to validate that this isn't network or disk
> > > > related.
> > > >
> > > > Disk tests (using iostat and other methods) show lots of bandwidth
> > > > left on the slave
gt; the slave and master.
>
> Network tests, such as:
>
> - using scp to copy binlogs directly
> - using different NICs to copy binlogs
> - using mysqlbinlog to snag logs (the most 'real' way I can think to
> simulate the replication thread copying binlogs from the mas
and master.
Network tests, such as:
- using scp to copy binlogs directly
- using different NICs to copy binlogs
- using mysqlbinlog to snag logs (the most 'real' way I can think to
simulate the replication thread copying binlogs from the master)
All seem to show that network speed is blazingly fast
- Original Message -
From: bars0.bars0.bars0 bars0.bars0.ba...@gmail.com
Hi all!
I need to copy data (result set from query) from one server to
another.
This will be done once a month (so cron will be involved:), for data
from previous month.
Any ideas how can I achieve this?
i have a large myisam table (about 3gb) that is updated once a day in the
middle of the night.
when it is not being updated, is there any reason not to copy it out with
rsync without shutting down the server or flush tables with read lock or
whatever?
--
MySQL General Mailing List
For list
Tom,
For MyISAM tables, as long as you aren't overlapping your update
cycles, I can see nothing wrong with this.
We used to rync to prepare slaves under inndb: do a broken rsync from
the live data files on the master to the archives.. when that is
complete, the result file is quite broken but
Hi friends
I have a proble with Copying to tmp table with large tables, table have more
than 3 million rows
EXPLAIN da Query :
Table : log0904
Type : ref
Possible_keys :
data_login_tplig,emp_grp_login_dtlig,grp_tiporeg_tipolig_dtlig,grp_dtlig_tplig,dtlig_num
: Carlos Eduardo Caldi [mailto:ce_ca...@hotmail.com]
Sent: Tuesday, April 28, 2009 8:19 PM
To: mysql@lists.mysql.com
Subject: Copying to tmp table
Hi friends
I have a proble with Copying to tmp table with large tables, table have
more than 3 million rows
EXPLAIN da Query :
Table
I've got two databases Foo and Bar. Both databases have a table called
'zoop_t'. Foo's is the master copy (i.e. the one that gets updated)
and Bar needs to be updated if/when changes are made.
Currently, I'm mysqldump'ing that table from Foo at midnight via cron
and feeding it back into
Assuming that both databases are on the same mysqld instance setting
triggers to keep the table up to date should do what you want...
On Thu, Oct 9, 2008 at 10:34 AM, Eric Anderson [EMAIL PROTECTED] wrote:
I've got two databases Foo and Bar. Both databases have a table called
'zoop_t'. Foo's
Hi Folks
I'm trying to copy a database table form one database to another on a
different server. Is it possible through myphpadmin, or do I need software?
If software, do you know of any good programs to do this?
Bob
--
View this message in context:
http://www.nabble.com/Copying-tables
On Mon, Mar 10, 2008 at 2:58 PM, skills2go
[EMAIL PROTECTED] wrote:
Hi Folks
I'm trying to copy a database table form one database to another on a
different server. Is it possible through myphpadmin, or do I need software?
If software, do you know of any good programs to do this?
On Mon, 10 Mar 2008, Daniel Brown [EMAIL PROTECTED] wrote:
On Mon, Mar 10, 2008 at 2:58 PM, skills2go
[EMAIL PROTECTED] wrote:
I'm trying to copy a database table form one database to another
on a different server. Is it possible through myphpadmin, or do I
need software? If software, do
On Mon, Mar 10, 2008 at 3:26 PM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Mon, 10 Mar 2008, Daniel Brown [EMAIL PROTECTED] wrote:
The same question just received an excellent answer from Rolando
Edwards about ten minutes ago. Check the archive here:
Hi Martin,
On 1/31/08, Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
By default, InnoDB tables aren't stored in the database folder, but rather
in it's own table space files.
In fact when I try to drop the database, the server recognizes
innodb tables. For example, T1 and T2 are INNODB tables
Hi,
I have 2 database folder that being copied directly from a remote
server and sent to me. That databases contains both MYISAM and INNODB
tables.
After I received the data, I try to restored it by copying that
folders to my server. The problem is, only MYISAM tables are being
recognized
Hi all,
I have 2 database folder that being copied directly from a remote
server and sent to me. That databases contains both MYISAM and INNODB
tables.
After I received the data, I try to restored it by copying that
folders to my server. The problem is, only MYISAM tables are being
recognized
Hi,
By default, InnoDB tables aren't stored in the database folder, but
rather
in it's own table space files.
In fact when I try to drop the database, the server recognizes
innodb tables. For example, T1 and T2 are INNODB tables in database
DB1. Then when I try to drop DB1, it issues
09:00:38 PM +0700
From: Feris Thia [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Data folder copying problem
Hi all,
I have 2 database folder that being copied directly from a remote
server and sent to me. That databases contains both MYISAM and
INNODB tables.
After I
Hi Martin,
You are correct. That's the same error that I got.
Looks like this article is the solution =
http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html
Thanks !
Feris
On 1/31/08, Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
By default, InnoDB tables aren't stored in the database
Hi...
I have a situation where I want to periodically copy new rows from a source
database/tables on a remote server. Using a cron process, I'm looking to
periodically copy the new tbl/rows into the dest database on my local
server.
i don't want to get into implementing slave/master replication,
Whil Hentzen wrote:
Baron Schwartz wrote:
Whil Hentzen wrote:
Michael Dykman wrote:
if you see no errors, check your config... are you sure InnoDB is
enabled ?
I can create a new database and add InnoDB tables to it without
problems.
Ack, I lied. No error in the /var/lib/mysql, but
the local box to the remote box and it
is accessible via the remote MySQL server just fine.
Obviously, there is something wrong in the way I'm copying the InnoDB
files.
What am I missing?
Whil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
and neat again.
I can copy a MyISAM database from the local box to the remote box and it
is accessible via the remote MySQL server just fine.
Obviously, there is something wrong in the way I'm copying the InnoDB
files.
What am I missing?
Whil
--
MySQL General Mailing List
For list archives: http
Whil Hentzen wrote:
Michael Dykman wrote:
if you see no errors, check your config... are you sure InnoDB is
enabled ?
I can create a new database and add InnoDB tables to it without problems.
Ack, I lied. No error in the /var/lib/mysql, but there IS an error file
in /var/logs, and it
Baron Schwartz wrote:
Whil Hentzen wrote:
Michael Dykman wrote:
if you see no errors, check your config... are you sure InnoDB is
enabled ?
I can create a new database and add InnoDB tables to it without problems.
Ack, I lied. No error in the /var/lib/mysql, but there IS an error
file in
InnoDB HotBackup but it costs money.
http://www.innodb.com/hot-backup
-Original Message-
From: Ofer Inbar [mailto:[EMAIL PROTECTED]
Sent: 18 July 2007 00:12
To: mysql@lists.mysql.com
Subject: quickly copying a database
I've got a server with a database that's about 10G. I need several
I've got a server with a database that's about 10G. I need several
other copies of this database, with different names, on the same host
and same MySQL instance.
I could mysqldump the db and then restore it into the others...
mysql create database one;
mysql create database two;
...
mysqldump
We have a moderately sized database, more than 5GB in size, several
million rows and 70 tables.
We're running MySQL 5.22 and the database uses innodb throughout with
multiple foreign keys in use.
During development the structure of several tables has been changed many
times, such that we
To: mysql@lists.mysql.com
Subject: Copying DB to new structure
We have a moderately sized database, more than 5GB in size, several
million rows and 70 tables.
We're running MySQL 5.22 and the database uses innodb throughout with
multiple foreign keys in use.
During development the structure of several
How can I copy tables from one database to another on the same host?
Thanks for your help
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Perhaps the easiest way is with CREATE TABLE... SELECT. For example,
if I have a database called NYCNH (by coincidence, I do!) which
contains a table called checks and I want to copy that table to a
database called TEST I could do this:
mysql create table test.checks select * from
. If you are not the intended recipient, an
agent of the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner
Hi to all!
I have to transfer copy of the one table from one to other database.
I was working with phpMyAdmin. I exported table in sql file but, when
tried to Import it to other database I got
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 806882 bytes)
Any idea
[EMAIL PROTECTED] wrote:
Hi to all!
I have to transfer copy of the one table from one to other database.
I was working with phpMyAdmin. I exported table in sql file but, when
tried to Import it to other database I got
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
Hello Friend,
Can you please let me know how to copy data from a column in table A
to a column in table B. e.g. I want to copy value of column age from
table 2 to column age in table 1, provided the entries in column
name, which is there in both the table, should match. In MySQL v 4
it could be
@lists.mysql.com
Subject: copying data!!!
Hello Friend,
Can you please let me know how to copy data from a column in table A to a
column in table B. e.g. I want to copy value of column age from table 2 to
column age in table 1, provided the entries in column name, which is
there in both the table
Tnx for the reply Jimmy. I also sent another question( i know its a
very silly question for you all..but believe me i am tryin this for
past three days and not able to get it)
Pls hlp..(just give me hint in right direction, and i will try to do
the rest)
Tnx
Sachin
--
MySQL General Mailing
Check this out.
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
On 12/9/05, Sachin Bhugra [EMAIL PROTECTED] wrote:
Hello Friend,
Can you please let me know how to copy data from a column in table A
to a column in table B. e.g. I want to copy value of column age from
table 2 to
;
-Original Message-
From: Sachin Bhugra [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:00 PM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Re: copying data!!!
Tnx for the reply Jimmy. I also sent another question( i know its a
very silly question for you all
Sorry the DROP TABLE Should be TEMP not table1
-Original Message-
From: Gordon Bruce [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:51 PM
To: Sachin Bhugra; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: RE: copying data!!!
This is kind of ugly
After reading through the MySQL manuals, as suggested here, I attempted
to construct the following statement to copy data from the table
members to the table forum_members:
INSERT INTO forum_members( MD5(passwd) , dateRegistered, realName,
ID_MEMBER, memberName, emailAddress, active,
Hi Dave,
I think your problem is that you're trying to call one of
your columns MD5(passwd) and my guess would be that you should do:
INSERT INTO forum_members( passwd, dateRegistered, realName,
ID_MEMBER, memberName, emailAddress, active, keitai, number, admin,
cardpic, cardbio, hofpic,
I think your problem is that you're trying to call one of your columns
MD5(passwd)
Thank you for pointing that out. I had the function in the wrong part of
the statement. Actually, I've realized I'm probably best off to leave
the passwords alone for now, and go ahead and copy the rest of
Hello.
After reading through the MySQL manuals, as suggested here, I attempted
to construct the following statement to copy data from the table members
to the table forum_members:
Please, keep your answers on the list. Use INSERT ... SELECT. Don't put
the functions in the column list. See
Dave,
I'm not that good when it comes to collations but latin1_swedish_ci is
normally the default collation for a MySQL installation. Have you
checked via SHOW VARIABLES that you don't have latin1_swedish_ci
lurking somewhere. My hunch here is that your ' ' in the CONCAT_WS
defaults to
My hunch here is that your ' ' in the CONCAT_WS defaults to
latin1_swedish_ci.
It seems you're right. There are a few variables that are still in
default mode which I discovered through the SHOW VARIABLES command. I've
tried to switch them, but I'm obviously using the syntax incorrectly. I
Dave,
I've tried
SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work so
I'm afraid I can't help you anymore there.
/Johan
Dave wrote:
My hunch here is that your ' ' in the CONCAT_WS defaults to
latin1_swedish_ci.
It seems you're right. There are a few
SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work
I made a new Query, copying the text as you wrote it, and it still
didn't work, but in a different way.
I type:
SET collation_connection = utf8_general_ci;
... and I get the following returned to me
While the basic issue of correct syntax is still open, this issue has
boiled down to a specific error message, so I've moved to a new thread
called:
Operand should contain 1 column error
However, for future reference, the issue of variables has been solved. I
discovered that to make the
to merging two fields into one, or copying from one
field to another. All the references I found are for querying the
database, combining data at the point of user input. How do I combine
two fields from one table, and put them into another?
Any assistance is much appreciated. Thank you
, despite the fact that I've looked up combine fields and
concatenate fields on Google, I can't find instructions on how to do
that in reference to merging two fields into one, or copying from one
field to another. All the references I found are for querying the
database, combining data
Hello.
Think about SELECT... INTO OUTFILE and LOAD DATA INFILE (or mysqlimport
utility). If you accept the possibility to run MySQL version 5.0.x beta, you
could use FEDERATED storage engine. See:
http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html
Les Schaffer [EMAIL
I am working on a MySQL application where laptops will be collecting
data into local MySQL tables, and then once a week they will be
network-connected to a central server where they will check in their
new data and check out new assignments for data collection.
given a set of rows in a set of
Les Schaffer [EMAIL PROTECTED] wrote on 07/20/2005 12:06:46 PM:
I am working on a MySQL application where laptops will be collecting
data into local MySQL tables, and then once a week they will be
network-connected to a central server where they will check in their
new data and check out
On Wednesday 20 July 2005 10:06am, Les Schaffer wrote:
I am working on a MySQL application where laptops will be collecting
data into local MySQL tables, and then once a week they will be
network-connected to a central server where they will check in their
new data and check out new
copying.
Is this a valid way to copy a db or only sometimes. Should I really always use
mysqldump. Although I am suspecting given the amount of data this may make for
a v large sql file?
Can some-one advise this newbie, thanks,
Andrew H
] [mailto:[EMAIL PROTECTED]
Sent: samedi 30 avril 2005 00:30
To: mysql@lists.mysql.com
Subject: Newbie Q - Re: Copying databases
I am having to operating MySQL 4.0.18, I had heared that I could copy a
db folder out of the mysql/data folder to the same folder on a different
machine running its own local
Yes I had thought I should use tools to copy, but I have had problems with
mysqldump. I successfully created a dump file, but when I execute this file on
an empty database I got:
C:\xampp\xampp\mysql\bingt;mysql -uroot db2 lt; test1.txtERROR 1064 at line
54: You have an error in your SQL
Hi all,
I need to move a database from a 4.0.20 MySQL server to a 4.0.17
server. I expect it will work fine when simply scp-ing the whole
/var/lib/mysql/MY-DATABASE to the other server's /var/lib/mysql
directory, with only a minor version difference.
Can anyone confirm this is going to work
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Until this version, I used to just copy the data/db directory from the
old database to the new one.
Now, I can't do that, and I think it is because of the data dictionary.
I have a database that only exists on this machine, and I want to get it
into
Hello,
I imported tow tables from an Access database to MySql.
Call them table1 and table2.
Both tables came with unique identifiers (ID1 for table1 and ID2 for
table2)which were generated automatically as a regular integer
index(0,1,2...N-1) for an N set of data. I would like to get rid this
Mahmoud Badreddine [EMAIL PROTECTED] wrote on 03/17/2005 03:16:47
PM:
Hello,
I imported tow tables from an Access database to MySql.
Call them table1 and table2.
Both tables came with unique identifiers (ID1 for table1 and ID2 for
table2)which were generated automatically as a regular
Well if you copy my.cnf settings along with ibdata files and log files
then it is possible to copy innodb exactly on the different machine and
i have done this before worked fine for me.
Love ..
[EMAIL PROTECTED] wrote:
InnoDB files can not be copied from one machine to another like the
MyISAM
Yikes...I've been replying to myself! I forgot that
when I reply to messages from the MySQL newsgroup on
this e-mail account, it doesn't include
mysql@lists.mysql.com, for some odd reason.
At any rate, I wanted to say that I have just ONE file
type left - FRM. My MYD and MYI files have both
InnoDB files can not be copied from one machine to another like the
MyISAM files. If you did not dump the data or you do not have an
archived backup you will more than likely have to recreate the table
structures.
David Blomstrom wrote:
Yikes...I've been replying to myself! I forgot that
when
Ah, I see. So the tables that are represented by all
three files are presumably MyISAM files, right?
--- Victor Pendleton [EMAIL PROTECTED] wrote:
InnoDB files can not be copied from one machine to
another like the
MyISAM files. If you did not dump the data or you do
not have an
I've been using a preconfigured package (Apache, PHP,
MySQL) from Apache Friends/XAMPP for several months.
About a week ago, my computer crashed, and I'm now
getting back on my feet. I downloaded the latest
XAMPP, which features upgrades for PHP, phpMyAdmin and
I think MySQL, too.
Everything
Hello,
I'm having a problem with moving a database from one server to another using
mysqldump. Since the servers are different platforms, some ascii characters
are getting corrupted.
So, my thought was to copy the table from one database to the other via the
mysql interface.
I found this
Message-
From: Andrew Mull [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 11:17 AM
To: mysql@lists.mysql.com
Subject: Copying table to another server.
Hello,
I'm having a problem with moving a database from one server to another using
mysqldump. Since the servers are different
I would like to know if it is possible and how to copy my users
(passwords priviledges etc...) from my Mandrake 10.0 / MySql 4.0
machine to my Win XP Pro/MySql 4.1 machine?
I would like to keep being able to develop the project that I am
working on while I will be away from my main computer?
The rules for copying users or grant tables are the same as any other
MyISAM table and can be found in the manual. Only when the copy is
done you have to restart mysqld or issue a flush privileges; query.
On Wed, 29 Dec 2004 15:01:19 -0500, GH [EMAIL PROTECTED] wrote:
I would like to know
Hello.
Like MyISAM data files, InnoDB data and log files are binary-compatible on
all platforms if the floating-point number format on the machines is the same.
You can move your database by copying all the relevant files. If the
floating-point formats on the machines are different but you
Is it possible to copy the database files (both MyISAM
and InnoDB) that contain tables, indices, and
full-text indices from one MySQL server to another
running/active MySQL server and start using them right
away?
I appreciate your help!
Homam
(r.Section_Value)
AGAINST ('+BAAN' IN BOOLEAN MODE)
AND c.Candidate_ID = r.Candidate_ID
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 1:29 PM
To: [EMAIL PROTECTED]; Mysql
Subject: RE: Copying rows based on query result to another table
I want to copy rows of data from a query result to another table. How do I
accomplish this? Here's my example for further explanation...
I have 2 tables, candidate and resume. I have 2 other (currently empty)
tables, exact duplicates, candidate_erp and resume_erp. In resume_erp will
be
Atley [mailto:[EMAIL PROTECTED]
Sent: 14 September 2004 18:18
To: Mysql
Subject: Copying rows based on query result to another table?
I want to copy rows of data from a query result to another table. How do I
accomplish this? Here's my example for further explanation...
I have 2 tables
, (2,6 Ghz 1GB
internal mem)
The forum runs quick until somebody searches the forum, the process list
shows a item which has the: Copying to tmp table state
This takes ages, at least 200 seconds
I tested with all kinds of config in my.cnf but nothing seems to help at
all..
Now i moved the DB over
Mevershosting.nl [EMAIL PROTECTED] wrote:
Anyone here have any qlue ?
We had a couple of dissatisfactions trying to run MySQL on OpenBSD.
See http://bulk.fefe.de/scalability/
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
Can you run into problems when copying tables with
foreign keys? I want to copy my Nations and States
tables, making versions designed only to hold lengthy
articles. I copied and coverted the States table
successfully, but I'm running into problems with the
Nations table.
I get an error message
PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Can you run into problems when copying tables with
foreign keys? I want to copy my Nations and States
tables, making versions designed only to hold lengthy
articles. I copied and coverted the States table
successfully, but I'm running into problems
:07 PM
Subject: Re: copying longblob value to another table...
Abubakr wrote:
I am trying to copy a file stored in longblob column of a table to a
longblod column of another table, can any one tell me what kind of insert
statement should i use for that purpose.
You should be able to insert
hi,
I am trying to copy a file stored in longblob column of a table to a longblod
column of another table, can any one tell me what kind of insert statement should i
use for that purpose. 2ndly can any one tell me any built in function in mysql to
download a file from longblob column to
Abubakr wrote:
I am trying to copy a file stored in longblob column of a table to a
longblod column of another table, can any one tell me what kind of
insert statement should i use for that purpose.
You should be able to insert into your upload table with a select from
your testing table.
I have a database that stores information in Japanese characters stored in
a blob formatted fields. I am having trouble copying these fields from one
database to another.
I tried doing a mysqldump on the table and then copyng the Insert statement
generated but that failed; the inserted filed
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Ed Curtis [EMAIL PROTECTED] wrote:
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
If you use only ISAM/MyISAM table, rename database directory.
Otherwise create new database, make
Egor Egorov wrote:
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
If you use only ISAM/MyISAM table, rename database directory.
Otherwise create new database, make a dump of tables
Hello,
I am running a DB on a machine in which I am developing on. Then I have been copying
the contents of ~mysql/data/databasename to another box where I am running my code.
All the data I modify copies well, and I can run on my production box with no
problems. Except for binary blob data
Are you just copying the files? I'd suggest using mysqldump if you are
not already..
On Tue, 10 Feb 2004, Scott Purcell wrote:
Hello,
I am running a DB on a machine in which I am developing on. Then I have been copying
the contents of ~mysql/data/databasename to another box where I am
PROTECTED]
Subject: Re: copying blob data to remote box
Are you just copying the files? I'd suggest using mysqldump if you are
not already..
On Tue, 10 Feb 2004, Scott Purcell wrote:
Hello,
I am running a DB on a machine in which I am developing on. Then I have been copying
the contents
To: Scott Purcell
Cc: [EMAIL PROTECTED]
Subject: Re: copying blob data to remote box
Are you just copying the files? I'd suggest using mysqldump if you are
not already..
On Tue, 10 Feb 2004, Scott Purcell wrote:
Hello,
I am running a DB on a machine in which I am developing
of ; at the end of
the EXPLAIN query to make the output more legible.
Matt
- Original Message -
From: Kevin Fries
Sent: Friday, September 05, 2003 11:09 AM
Subject: RE: Query hung up in Copying to tmp table
Matt,
Thanks for your response. It's going to take a bit for me to get the
actual
[mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 1:37 PM
To: [EMAIL PROTECTED]
Subject: Re: Query hung up in Copying to tmp table
Hi Kevin,
I imagine the query is examining/returning so many rows that
it's going to take a long time to create the needed temporary
table
(rows and MB).
Matt
- Original Message -
From: Kevin Fries
Sent: Wednesday, September 03, 2003 6:51 PM
Subject: Query hung up in Copying to tmp table
I'm having a problem where a complex SELECT query begins eating up
lots
of CPU and never returns. In show processlist, it
reports
I'm having a problem where a complex SELECT query begins eating up lots
of CPU and never returns. In show processlist, it
reports Copying to tmp table. Other queries seem to get locked
waiting for this query, as well.
This is on version 3.23.36 of mySQL, and I'm considering upgrading
Hi everyone,
Is there any easy way to duplicate a row in a table with auto increment
column, that shouldn't of course be copied. I tried a query NSERT INTO
table SELECT * FROM table but it caused an error due to the auto
increment column. I succeeded with listing all required fields in the
query,
I'm attempting to normalize a database that was originally created as a
flat file. I want to extract distinct values from a table and insert
them as new entries into a new table. Unless I'm missing something,
INSERT doesn't allow you to SELECT data from another table for
insertion, and UPDATE
1 - 100 of 248 matches
Mail list logo
