All,
InnoDB and MyISAM tables are platform independent, is there a reason
why transferring the actual binary files from one system (or mount
point) is not advised? From like OS to like OS, this seems like it
should be okay and you'll only get into trouble with Float/Double.
MySQL
I have a similar question.
I've run out of disk space on one of my partitions. What would be the best
way to move one table over to another partition? I see you can specify DATA
DIRECTORY and INDEX DIRECTORY, but when I try and ALTER or CREATE LIKE with
these parameters, the table stays where
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 29, 2008 2:02 AM
To: Ivan Levchenko
Cc: mysql@lists.mysql.com
Subject: Re: transfer huge mysql db
Ivan Levchenko wrote:
Hi All,
What would be the best way to transfer a 20 gig db from one host to
Hi,
I'm having trouble wrapping my head around this problem. I have a list
of events for multiple computers. What I want to get is a summary of
the top 3 most common errors for each computer. So I get a result like
this:
Computername event numb_times
Comp1
Hi,
I'm looking an application which let me convert one mysql to another db. I
need this to port my website from one cms (Vivvo) to another (Drupal).
--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
A revolution is about to begin.
A world is about to change.
And you and I are
Hi there,
I have a list of events that occur periodically:
1/1/2008Event
1/1/2008Event
1/1/2008Event
1/2/2008Event
1/2/2008Event
1/4/2008Event
1/4/2008Event
I know how to count events per day, but on
Check out DBConvert variants..
http://www.dbconvert.com/
-Original Message-
From: Sharique uddin Ahmed Farooqui [mailto:[EMAIL PROTECTED]
Sent: 29 January 2008 18:16
To: mysql@lists.mysql.com
Subject: mysql to mysql conversion tool
Hi,
I'm looking an application which let me convert
Hi,
On Jan 28, 2008 3:29 PM, Dean Karres [EMAIL PROTECTED] wrote:
Hi,
I know that someone is going to say, go ask the perl module guys and
I will but they are likely to say, go ask the MySQL guys. I'll be
asking in both groups.
I am installing a script on a brand new RedHat, Fedora Core 7
http://drupal.org/project/convert2drupal
NB:
no pending tasks AND
no developers working on any part of the project
the author claims a release in january (but has'nt published anything yet..)
Looks like you there is some work ahead of you..
Oi Vay!
- Original Message -
From: Sharique
Hi all,
I am attempting to convert a very large table (~23 million rows) from
MyISAM to InnoDB. If I do it in chunks of one million at a time, the
first million are very fast (approx. 3 minutes or so), and then it
gets progressively worse, until by the time I get even to the fourth
Hi,
On Jan 29, 2008 1:10 PM, Ramsey, Robert L [EMAIL PROTECTED] wrote:
Hi,
I'm having trouble wrapping my head around this problem. I have a list
of events for multiple computers. What I want to get is a summary of
the top 3 most common errors for each computer. So I get a result like
Hi,
On Jan 29, 2008 4:08 PM, David Schneider-Joseph [EMAIL PROTECTED] wrote:
Hi all,
I am attempting to convert a very large table (~23 million rows) from
MyISAM to InnoDB. If I do it in chunks of one million at a time, the
first million are very fast (approx. 3 minutes or so), and then it
On Jan 29, 2008, at 4:37 PM, Baron Schwartz wrote:
It's because your index is bigger than your memory (or at least bigger
than your InnoDB buffer pool). InnoDB can't build indexes by sorting
rows, so building the indexes gets slow.
Hmm, this would be an interesting theory for the main table
David Schneider-Joseph schrieb:
Hi all,
I am attempting to convert a very large table (~23 million rows) from
MyISAM to InnoDB. If I do it in chunks of one million at a time, the
first million are very fast (approx. 3 minutes or so), and then it
gets progressively worse, until by the time I
On Jan 29, 2008, at 6:09 PM, Jan Kirchhoff wrote:
what hardware are you running on and you much memory do you have?
what version of mysql?| |
How did you set innodb_buffer_pool_size?
Hardware:
Dual AMD Opteron 246 2.0 GHz
4 GB DDR RAM (no swap being used)
Dual 146 GB SCSI drives with a RAID
David Schneider-Joseph schrieb:
On Jan 29, 2008, at 6:09 PM, Jan Kirchhoff wrote:
what hardware are you running on and you much memory do you have?
what version of mysql?| |
How did you set innodb_buffer_pool_size?
Hardware:
Dual AMD Opteron 246 2.0 GHz
4 GB DDR RAM (no swap being used)
drop the indexes for the conversion then rebuild the indexes after the
tables are converted.
On Jan 29, 2008 4:08 PM, David Schneider-Joseph [EMAIL PROTECTED] wrote:
Hi all,
I am attempting to convert a very large table (~23 million rows) from
MyISAM to InnoDB. If I do it in chunks of one
On Jan 29, 2008, at 7:04 PM, Jan Kirchhoff wrote:
play around with innodb_log_buffer_size, innodb_log_file_size and
try to set innodb_flush_log_at_trx_commit=0.
Do you don't have a BBU on your raid-controller?
let me know if that changes anything.
That did it! I upped the log_buffer_size
On Jan 29, 2008, at 6:21 PM, BJ Swope wrote:
drop the indexes for the conversion then rebuild the indexes after the
tables are converted.
As noted in my original email, I tried that, but Jan's suggestion re:
InnoDB tuning fixed it.
Thanks for the advice, everyone!
David
--
MySQL General
Hey there
Is there any possible way to increase this limit ?
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.4/1146 - Release Date: 22/11/2007
18:55
Is there a reason this wouldn't work with InnoDB? (I understand
there's usually a single ibdata file, but so?)
On Jan 24, 2008, at 8:08 AM, Matthias Witte wrote:
On Thu, Jan 24, 2008 at 01:42:38PM +0200, Ivan Levchenko wrote:
Hi All,
What would be the best way to transfer a 20 gig db from
On Jan 29, 2008, at 10:02 AM, Jerry Schwartz wrote:
mysqldump -A file.dump
tar -jcf file.dump
rsync
[JS] You could also just pipe the output of mysqldump through gzip.
tar buys
you nothing, since it is a single file.
-j is the bzip2 compression option. :)
--
MySQL General Mailing List
22 matches
Mail list logo