On 2013-06-26 18:31, nixofortune wrote:
What would be the best way to convert BIG MyISAM table into InnoDB? We do not
have SLAVE.
I would do it on another computer. Then copy the table to the server and then
add the data that has been added from the original table.
And/or i would experiment
of this being big enough: myisam_sort_buffer_size = 526M
-Original Message-
From: nixofortune [mailto:nixofort...@gmail.com]
Sent: Monday, June 24, 2013 12:35 PM
To: mysql@lists.mysql.com
Subject: Re: space gone after MyISAM REPAIR TABLE
On 24/06/13 19:57, Reindl Harald wrote:
Am 24.06.2013
You can't actually move innodb tables around until 5.6 where you have
transpotable tablespaces.
I suggest having a good hard look at pt-online-schema-change or whatsitcalled.
Jay Ess li...@netrogenic.com wrote:
On 2013-06-26 18:31, nixofortune wrote:
What would be the best way to convert BIG
2013/06/26 17:31 +0100, nixofortune
ALTER TABLE `new_innodb`
ADD KEY `idx1` (`col1`,`col2`),
ADD KEY `idx2` (`col1`,`col2`,`col3`);
Is it really seemly for one index to be a leading part of another?
(or maybe I am really thinking of something else)
--
MySQL General Mailing List
For list
AM
To: li...@netrogenic.com; Jay Ess; mysql@lists.mysql.com
Subject: Re: space gone after MyISAM REPAIR TABLE
You can't actually move innodb tables around until 5.6 where you have
transpotable tablespaces.
I suggest having a good hard look at pt-online-schema-change or
whatsitcalled.
Jay Ess li
. Often it leads to suggesting Summary
Table(s).)
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Wednesday, June 26, 2013 11:46 AM
To: li...@netrogenic.com; Jay Ess; mysql@lists.mysql.com
Subject: Re: space gone after MyISAM REPAIR TABLE
You can't
On 2013-06-27 01:27, nixofortune wrote:
Now importing with Keys in place. It takes longer, much longer but at
least the server is working and customers do not complaint.
Schema design is awful, agree. I try to understand the process so will
redesign it soon, but any suggestions are welcome.
I'
To: li...@netrogenic.com; Jay Ess; mysql@lists.mysql.com
Subject: Re: space gone after MyISAM REPAIR TABLE
You can't actually move innodb tables around until 5.6 where you have
transpotable tablespaces.
I suggest having a good hard look at pt-online-schema-change or
whatsitcalled.
Jay
: myisam_sort_buffer_size
= 526M
-Original Message-
From: nixofortune [mailto:nixofort...@gmail.com]
Sent: Monday, June 24, 2013 12:35 PM
To: mysql@lists.mysql.com
Subject: Re: space gone after MyISAM REPAIR TABLE
On 24/06/13 19:57, Reindl Harald wrote:
Am 24.06.2013 18:47, schrieb Johan De
- Original Message -
From: nixofortune nixofort...@gmail.com
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the space on the hard drive gone down from 165 Gig to 70
Gig. I understand that during repair process MySQL creates temp file and
Am 24.06.2013 18:47, schrieb Johan De Meersman:
- Original Message -
From: nixofortune nixofort...@gmail.com
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the space on the hard drive gone down from 165 Gig to 70
Gig. I understand that during
Oops, totally missed that, thanks.
Reindl Harald h.rei...@thelounge.net wrote:
Am 24.06.2013 18:47, schrieb Johan De Meersman:
- Original Message -
From: nixofortune nixofort...@gmail.com
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the
On 24/06/13 19:57, Reindl Harald wrote:
Am 24.06.2013 18:47, schrieb Johan De Meersman:
- Original Message -
From: nixofortune nixofort...@gmail.com
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the space on the hard drive gone down from 165
Martin Jespersen schrieb:
Does anyone havea clue of how mysql optimizes empty fields and how
query speed is affected?
Why don't you read the part in the mysql documentation about the
opimization?
what will be better for queryspeed/size: adding them with NULL using
NULL as default or with
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
gerald_clark [EMAIL PROTECTED] writes:
Asif Iqbal wrote:
Jack Coxen wrote:
If you database contains time-based data you could age out old records. I
only need to keep data for 6 months so I run a nightly script to delete any
Asif Iqbal wrote:
Jack Coxen wrote:
If you database contains time-based data you could age out old records. I
only need to keep data for 6 months so I run a nightly script to delete any
records more than 6 months old. And before anyone asks...yes, I also run
another script to
In article [EMAIL PROTECTED],
gerald_clark [EMAIL PROTECTED] writes:
Asif Iqbal wrote:
Jack Coxen wrote:
If you database contains time-based data you could age out old records. I
only need to keep data for 6 months so I run a nightly script to delete any
records more than 6 months old.
]
Subject: Re: Space is filling up
Jack Coxen wrote:
If you database contains time-based data you could age out old
records. I only need to keep data for 6 months so I run a nightly
script to delete any records more than 6 months old. And before
anyone asks...yes, I also run another script
1 mysqlmysql 3 Nov 21 2003 webrt.pid
Thanks for all the help
Jack
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 2:07 PM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: Space is filling up
gerald_clark wrote
What about getting a bigger drive?
Asif Iqbal wrote:
Hi All
My mysql data dir is filled up to 95% and only 345M left.
Here is the dir looks like
1.9Gibdata1
3.1Gibdata2
3.0Kib_arch_log_02
3.0Kib_arch_log_04
25K ib_arch_log_00
65M rt3
67K
gerald_clark wrote:
What about getting a bigger drive?
I guess that would be my only option eh?
Asif Iqbal wrote:
Hi All
My mysql data dir is filled up to 95% and only 345M left.
Here is the dir looks like
1.9Gibdata1
3.1Gibdata2
3.0Kib_arch_log_02
3.0K
Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 2:07 PM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: Space is filling up
gerald_clark wrote:
What about getting a bigger drive?
I guess that would be my only option eh?
Asif Iqbal wrote:
Hi All
My
--- Asif Iqbal [EMAIL PROTECTED] wrote:
gerald_clark wrote:
What about getting a bigger drive?
I guess that would be my only option eh?
If any of your data can be considered history data
that is never modified, you could create compressed
myISAM tables for that data, removing it from the
.
But does he even have enough disk space to optimize tables?
Jack
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 2:07 PM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: Space is filling up
gerald_clark wrote:
What about getting a bigger drive?
I
Just enclose the column name in backticks (upper left key on your keyboard just below
ESC). Be warned that if you do this you will ALWAYS have to refer to this column using
the backticks. It would be MUCH better to remove the space from the name. You might
consider using an underscore instead.
* [EMAIL PROTECTED]
I am beginning in mysql, and I do not obtain to create a table
with a space column.
some friend could help me?
mysql CREATE TABLE g1 (p1 GEOMETRY);
Error 1064 :
The error message got lost in the mail. Beware that spatial support is
introduced in mysql version 4.1, what
ln -s /home/dbname /var/lib/mysql/dbname
chown mysql:mysql /home/dbname
-Original Message-
From: Brian Thompson [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 29, 2001 4:55 PM
To: [EMAIL PROTECTED]
Subject: space
I have my /var/ partition set to 400mb, but I need about 4 gigs for a
On 29-Jul-2001 Brian Thompson wrote:
I have my /var/ partition set to 400mb, but I need about 4 gigs for a mysql
database im setting up
how can I relocate the data files in the users /home directory, or how can I
fix this?
Assume the datadir is /var/db/mysql
make a backup
shutdown
these into my.cnf and
avoid the symlink overhead.
- Original Message -
From: Don Read [EMAIL PROTECTED]
To: Brian Thompson [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, July 29, 2001 2:08 PM
Subject: RE: space
On 29-Jul-2001 Brian Thompson wrote:
I have my /var/ partition set to 400mb, but I
On Sun, Jul 29, 2001 at 02:21:43PM -0700, Vincent Janelle wrote:
Uh, don't symlink. That'll just cause massive amounts of issues
later on if you have to deal with performance (added syscalls to
check to valid symlinks).
Doesn't that apply to the time that a table is opened? If tables are
Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Vincent Janelle [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, July 29, 2001 2:47 PM
Subject: Re: space
On Sun, Jul 29, 2001 at 02:21:43PM -0700, Vincent Janelle wrote:
Uh, don't symlink. That'll just cause massive amounts
On Sun, Jul 29, 2001 at 03:10:14PM -0700, Vincent Janelle wrote:
But configuring mysql to point to a diff directory is just better
administration.
Unfortunately, it only gets you so far. What if you want to spread
your data across several physical disks (without hardware/software
RAID)? Or
While you can use space in column names, it is not a very good idea as some
systems can't handle spaces. Your just begging for trouble if you do use
space. Better to use underscores instead.
- Original Message -
From: Mohamad Ilhami [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
Rolf Hopkins wrote:
While you can use space in column names, it is not a very good idea as some
systems can't handle spaces. Your just begging for trouble if you do use
space. Better to use underscores instead.
- Original Message -
From: Mohamad Ilhami [EMAIL PROTECTED]
To:
Wyatt James wrote:
I am getting a misleading error message saying "duplicate key 127 at key 1" when
trying to add an item to a table. There is no duplicate (I downloaded then uploaded
to a new table and get the same error). The unique key is a smallint(4) with
auto-increment. Is there some
35 matches
Mail list logo