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
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 tab
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
- 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 tem
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 the job done. Or removal process executes on the server
The index file will rebuild by using the above command.
On Thu, May 19, 2011 at 11:16 AM, Ramesh wrote:
> Is that index and all will be fine in that table, or have to create again?
>
> On 19 May 2011 11:11, Ramesh wrote:
>
>>
>> Lost all the records once i done the r
Is that index and all will be fine in that table, or have to create again?
On 19 May 2011 11:11, Ramesh wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repair table SystemEvents use_
Can you paste the table files in the datadir and the execution part of the
below query.
On Thu, May 19, 2011 at 11:11 AM, Ramesh wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repa
Lost all the records once i done the repair table with use_frm.
On 19 May 2011 10:30, Suresh Kuna wrote:
> Run this - repair table SystemEvents use_frm ;
>
>
> On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote:
>
>> mysql> repai
Run this - repair table SystemEvents use_frm ;
On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote:
> mysql> repair table SystemEvents.frm;
>
> +--++--++
> | Table| Op | Msg_ty
mysql> repair table SystemEvents.frm;
+--++--++
| Table| Op | Msg_type |
Msg_t
use repair table table_name use_frm ; and try it out.
It needs to be run inside mysql.
On Thu, May 19, 2011 at 9:30 AM, Ramesh wrote:
> Hi,
>
> I am trying to repair the table and i got this error
>
> I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvent
Hi,
I am trying to repair the table and i got this error
I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvents.MYI
[root@uidsyslog001 mysql]# myisamchk --rq --tmpdir=/var/lib/mysql
/var/lib/mysql/tablog/TabEvents.MYI
check record delete-chain
- recovering (with sort) MyISAM-tabl
Sorry...
One small correction to my above post..
'FLUSH TABLES' should be issued between steps 8 and 9.
My 200+ million record table completed in 71 minutes.
-Hank
mysql; query;
I've posted a similar post in the past -- but there I was mucking around
with blank index files and frm files to fool myisamchk into repairing a
table.
But now I think I've come across a much better and more efficient way to do
a REPAIR Table in order to upgrade my database tables from
hi
Hope there is no privilege type of REPAIR [Repair Table] supported by MySQL
Server.
use
>SHOW PRIVILEGES;
SHOW PRIVILEGES shows the list of system privileges that the MySQL server
supports. The exact list of privileges depends on the version of your server.
For the global, datab
Hi Folks,
Does anybody know if it is possible to restrict access to these commands
on an individual basis? I have a need to exclude users, who would
otherwise have most privileges, and was wondering if there was a
particular privilege that I could revoke.
If not, does anybody have a technique t
,
Martijn
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Vleugels
> Sent: dinsdag 12 juli 2005 19:37
> To: mysql@lists.mysql.com
> Subject: repair table (error 27)
>
> Hi,
>
> the DB resided on a network appliance filer (happily for a
Hello.
> | eps4.inmail | repair | warning | Can't change size of indexfile, error: 27
As of MySQL 4.0.2, there is a USE_FRM mode for REPAIR TABLE. Use it if
the .MYI index file's header is corrupted. See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
Hi,
the DB resided on a network appliance filer (happily for a year). A nfs
problem corrupted some tables, all got fixed but this one:
mysql> repair table inmail extended;
+-++--+---+
| Table | Op | Msg_type | Msg_t
link-chain corrupted |
> | mailtest.report_1 | check | error| Corrupt|
> +---+---+--+----+
> 2 rows in set (0.02 sec)
>
> Does repair table report_1 command fix?
> or anyt
ext
|
+---+---+--++
| mailtest.report_1 | check | error| record delete-link-chain corrupted |
| mailtest.report_1 | check | error| Corrupt|
+---+---+--++
2 rows in set (0.02 sec)
Does rep
Hi,
I think you need to have root privileges (ALL) on the
table to run REPAIR TABLE since this is a disaster
recovery sql command. It works only for MyISAM tables
in MySQL. I don't think it is supported for all
tables.
I need it because I got a server with big load that sometimes h
I think you need to have root privileges (ALL) on the
table to run REPAIR TABLE since this is a disaster
recovery sql command. It works only for MyISAM tables
in MySQL. I don't think it is supported for all
tables.
Logically a repair table command would update, insert,
delete and alter the t
up
Bgs wrote:
Does this silence mean that nobody knows?!? :)
I've been trying to find what privilege is needed to 'REPAIR TABLE'. I
couldn't find any usefull hint on the net or in the archives. Could
anyone help me out?
--
MySQL General Mailing List
For list archives: ht
Hello
REPAIR QUICK is a recommended method to rebuild FULLTEXT indexes. See:
http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html
Haitao Jiang <[EMAIL PROTECTED]> wrote:
> Hi,
>
> If I remember correctly, if table is ok, then if one does a table
> repair, the command should ret
Hi,
If I remember correctly, if table is ok, then if one does a table
repair, the command should return immediately. I have a table with 14
million rows, and I repeated table repair (quick) 3 times, it took the
same amount of time (55 min). It is almost the same time as if I built
the index from s
Does this silence mean that nobody knows?!? :)
I've been trying to find what privilege is needed to 'REPAIR TABLE'. I
couldn't find any usefull hint on the net or in the archives. Could
anyone help me out?
--
MySQL General Mailing List
For list archives: http://list
Greetings,
I've been trying to find what privilege is needed to 'REPAIR TABLE'. I
couldn't find any usefull hint on the net or in the archives. Could
anyone help me out?
Thanks
Bgs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi!
On Jun 25, Dan Cumpian wrote:
> Is there any harm in using the USE_FRM directive by default whenever
> repairing a table?
Yes.
See http://bugs.mysql.com/4252
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/
Is there any harm in using the USE_FRM directive by default whenever
repairing a table?
Thanks,
Dan
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.703 / Virus Database: 459 - Release Date: 6/10/2004
php <[EMAIL PROTECTED]> wrote:
>
> @@@ please help me! @@@
>
> mysql> REPAIR TABLE f_ivairus_bodies;
> +++--++
> | Table | O
Hello,
@@@ please help me! @@@
mysql> REPAIR TABLE f_ivairus_bodies;
+++--++
| Table | Op | Msg_type | Msg_t
Gowtham Jayaram <[EMAIL PROTECTED]> wrote:
>
> - Are there any benchmarks that provide information
> on time taken to run 'CHECK TABLE' and/or 'REPAIR
> TABLE' on tables of different sizes ?
You can run your own benchmarks and find out the statistics yo
Hello All:
- Are there any benchmarks that provide information
on time taken to run 'CHECK TABLE' and/or 'REPAIR
TABLE' on tables of different sizes ?
- What are the factors that effect the time taken to
run 'CHECK TABLE' and/or 'REPAIR TABLE' on a
Hi!
On Jan 20, rmck wrote:
> Help.
>
> I have a REPAIR table command that has been running since 1/15... I
> dont know if its hung or what? Should I kill it ? Top shows that it
> seems to be running?
No, it did not hang - "Repair with keycache" is slow, especially
Help.
I have a REPAIR table command that has been running since 1/15... I dont know if its
hung or what? Should I kill it ? Top shows that it seems to be running?
mysql> show processl
Help.
I have a REPAIR table command that has been running since 1/15... I dont know if its
hung or what? Should I kill it ? Top shows that it seems to be running?
mysql> show processl
Hello,
I have a broken table (all the INSERTs cause error 'Duplicate entry for key
1: '). When I run 'REPAIR TABLE tablename' it repairs table fine,
but after the short period of thme since the repair process has been run,
other mysql cliens start receiving the error "
At 11:14 -0400 7/24/03, Jeff McKeon wrote:
Is there a way to issue a "REPAIR TABLE table_name" command to all
tables at once? Something like "REPAIR TABLE *"
If you have access to the mysqlcheck command-line program, you can
accomplish that with this command:
mysqlcheck --re
LIST
Subject: Repair table
Is there a way to issue a "REPAIR TABLE table_name" command to all
tables at once? Something like "REPAIR TABLE *"
Thanks,
Jeff McKeon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.
On Thu, Jul 24, 2003 at 11:14:51AM -0400, Jeff McKeon wrote:
> Is there a way to issue a "REPAIR TABLE table_name" command to all
> tables at once? Something like "REPAIR TABLE *"
No.
However, you could use myisamchk with the server off-line. Then you'd
be abl
Is there a way to issue a "REPAIR TABLE table_name" command to all
tables at once? Something like "REPAIR TABLE *"
Thanks,
Jeff McKeon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In a nutshell, I have a query that runs in 28 seconds until I perform a
REPAIR TABLE against one of the tables in the query then execution time
jumps to 51 seconds. The only way to get the query time back down is to
TRUNCATE and repopulate the table. I've been operating under the assumption
Grettings! I'm new to the list, and I hope this isn't off-topic. I've got
a MyISAM table that is about 3.3 GB in size. The index is around 4.7GB. I
started a REPAIR TABLE nnn QUICK last Sunday in a mysql session, and its
still running. The index keeps getting updated, but I c
perror 28
Error code 28: No space left on device
tl wrote:
>Hello,
>Please help me.
>
>mysql> repair table none;
>+++--+-+
>| Table | Op
tl,
Friday, October 11, 2002, 11:55:41 AM, you wrote:
t> mysql> repair table none;
t> +++--+-+
t> | Table | Op | Msg_type | Msg_text
Hello,
Please help me.
mysql> repair table none;
+++--+-+
| Table | Op | Msg_type | Msg_text|
+++--+-+
| n_toccata.none | repair | er
Hi,
perror 28
Error code 28: No space left on device
Make some space on your hard disk ;)
Regards,
Jocelyn
- Original Message -
From: "tl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 11, 2002 10:55 AM
Subject: Repair TABLE - OPER
Please help me "alter table":
___
| |
CREATE TABLE `f_ivairus_bodies` (
`id` int(11) NOT NULL default '0',
`body` text NOT NULL,
`thread` int(11) NOT NULL default '0',
PRIMARY
d NOT NULL auto_increment,
t> PRIMARY KEY (`id`),
t> KEY `hid` (`hid`)
t> ) TYPE=ISAM PACK_KEYS=1
t> |___|
mysql> repair table zinutes;
t>
+--++-
At 9/20/2002, you wrote:
>Please help me REPAIR TABLE:
>___
>| |
> CREATE TABLE `zinutes` (
> `hid` int(10) unsigned NOT NULL default '0',
> `tipa
tmp_zinutes.
I hope this helps
Simon
On Friday 20 Sep 2002 9:34 am, tl wrote:
> Please help me REPAIR TABLE:
> ___
>
> CREATE TABLE `zinutes` (
> `hid` int(10) unsigned NOT NULL default '0',
> `tipas` int(10)
Please help me REPAIR TABLE:
___
| |
CREATE TABLE `zinutes` (
`hid` int(10) unsigned NOT NULL default '0',
`tipas` int(10) unsigned NOT NULL default '0',
ZE TABLE wich died in batch & caused me to try and run the REPAIR.
>
> rafe> I've also tried complete rebuilds with the same data and I get the same crashi
>but builds with less data (~4GB) have worked.
>
> rafe> The REPAIR TABLE dies repeatedly with:
> mysql>
s been no activity except for the following:
rafe> 1) Record inserts from flat file parsing.
rafe> 2) OPTIMIZE TABLE wich died in batch & caused me to try and run the REPAIR.
rafe> I've also tried complete rebuilds with the same data and I get the same crashi
but builds wi
On Tue, 12 Mar 2002, Sasha Pachev wrote:
> On Tuesday 12 March 2002 10:54 am, [EMAIL PROTECTED] wrote:
> > I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a
> fresh build and there has been no activity except for the following:
> > 1) Record inserts from flat file pars
On Tuesday 12 March 2002 10:54 am, [EMAIL PROTECTED] wrote:
> I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a
fresh build and there has been no activity except for the following:
> 1) Record inserts from flat file parsing.
> 2) OPTIMIZE TABLE wich died in batch & cause
[EMAIL PROTECTED] writes:
> >Description:
> I am not subscribe to this list so please cc me in your reply.
>
> I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh
>build and there has been no activity except for the following:
> 1) Record inserts from flat file pa
ied in batch & caused me to try and run the REPAIR.
I've also tried complete rebuilds with the same data and I get the same crashi but
builds with less data (~4GB) have worked.
The REPAIR TABLE dies repeatedly with:
mysql> repair table dna;
ERROR 2013: Lost connection to MySQL serv
Steve Rapaport wrote:
>
> Arrrggghhh!
>
> This is definitely a problem!
> Can't access table White in mysql 4.0.1: table is "read-only".
> why? because it's corrupt!
> Try to fix: takes a long time (about an hour) and seems to work.
> But it's still corrupt and read-only:
>
[cut]
> [roo
Arrrggghhh!
This is definitely a problem!
Can't access table White in mysql 4.0.1: table is "read-only".
why? because it's corrupt!
Try to fix: takes a long time (about an hour) and seems to work.
But it's still corrupt and read-only:
[root@db1 elenco4_fb02]# myisamchk White;
Checking MyI
in specified intervals with CHECK TABLE and if that
reports a problem with REPAIR TABLE. Is it possible without a problem to
run these two commands on a packed table? I couldn't find anything
specific on this topic in the manual. Or is it a grey area which has not
been tested yet?
The MYSQL s
Hi,
> The manual
>
> http://www.mysql.com/doc/R/E/REPAIR_TABLE.html
>
> mentions the QUICK and EXTENDED options for REPAIR TABLE. But it does
> not say which is the default. Anyone know?
I think the default might actually be neither.
I think the two options corresp
The manual
http://www.mysql.com/doc/R/E/REPAIR_TABLE.html
mentions the QUICK and EXTENDED options for REPAIR TABLE. But it does
not say which is the default. Anyone know?
Thanks,
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878
I received several of these messages when I repaired a table. Can anyone
give me any insight about this message.
Should I export all data to a new table or can this message be ignored?
Found block with too small length at 3532; Skipped
--Bill
Hi!
>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello bugs,
Peter> Linux. Mysql 3.23.30 (also checked with 3.23.25). Problem appears with
Peter> repear table as well as myisamchk.
Peter> The problem is quite strange. Then r
Hi!
>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello bugs,
Peter> Linux. Mysql 3.23.30 (also checked with 3.23.25). Problem appears with
Peter> repear table as well as myisamchk.
Peter> The problem is quite strange. Then r
Hello bugs,
Linux. Mysql 3.23.30 (also checked with 3.23.25). Problem appears with
repear table as well as myisamchk.
The problem is quite strange. Then repair table or myisamchk repears
the table, which is empty it grows a index file until it reaches
it's limit 2GB. And then it
78 matches
Mail list logo
