SELECT...ORDER BY (new PK) -- This would make the INSERT part
>> fast, but the SELECT part would be slow. ("You can't win")
>>
>> Your task is all about disk hits. By understanding what MySQL has to do,
>> you can 'predict' whether a plan wil
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'
at are the SELECTs that will benefit from them? (Sometimes discussing this
can lead to fewer/better INDEXes. 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
--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 actually move innodb tables around until 5.6 where you have
trans
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 Li
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 wrote:
>On 2013-06-26 18:31, nixofortune wrote:
>> What would be the best way to convert BIG MyISAM table into I
bably got
'sort' because 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 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 w
7; because 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
>
> O
On 24/06/13 19:57, Reindl Harald wrote:
Am 24.06.2013 18:47, schrieb Johan De Meersman:
- Original Message -
From: "nixofortune"
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 under
Oops, totally missed that, thanks.
Reindl Harald wrote:
>
>
>Am 24.06.2013 18:47, schrieb Johan De Meersman:
>> - Original Message -
>>> From: "nixofortune"
>>>
>>> Hi guys,
>>> any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
>>> command. the space on the hard drive g
Am 24.06.2013 18:47, schrieb Johan De Meersman:
> - Original Message -
>> From: "nixofortune"
>>
>> 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
- Original Message -
> From: "nixofortune"
>
> 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
> remove it after th
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 N
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
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 tha
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 ANALYZE/OPTIMIZE
ebrt.err
-rw-rw1 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 PROTEC
x27;
Cc: [EMAIL PROTECTED]
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
>
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 dr
--- 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
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:
>
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
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 webrt.err
* [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,
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.
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 mysql
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)? O
- Original 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:
>
On 29-Jul-2001 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).
For extremely small values of massive. 'real_data_home' is resolved once at
server startup in my
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 ar
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 Bria
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
shutdow
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]
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: Fri
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 s
36 matches
Mail list logo
