Big Table, myisampack or merge?

long would a process like that take because my members are creating transactions every second, so wouldnt all their queries be locked up while it was creating it? Or would using myisampack be better to just compress all the data. I display about 50 rows of their transaction history based on the User

Re: myisamchk and myisampack

Hello. There're some good descriptions at: http://dev.mysql.com/doc/mysql/en/crash-recovery.html http://dev.mysql.com/doc/mysql/en/myisampack.html [EMAIL PROTECTED] wrote: > Hello everyone, > When running these utilities does the MySQL daemon have to be "down"? > There's no activ

myisamchk and myisampack

Hello everyone, When running these utilities does the MySQL daemon have to be "down"? There's no activity against the database other than an occasional query. George __ Switch to Netscape Internet Service. As low as $9.95 a month

Re: COMPRESS() vs myisampack

myisampack will result in a smaller table. The only downside is that the table becomes read only. On Fri, 03 Dec 2004 09:31:22 +0100, Jacob Friis <[EMAIL PROTECTED]> wrote: > I have a table with lots of text data, and would like to compress this > in order to save space. > &

Re: myisampack

No. Compressed storage format is a read-only format that is generated with the myisampack tool. See: http://dev.mysql.com/doc/mysql/en/Compressed_format.html Jacob Friis <[EMAIL PROTECTED]> wrote: > Is it possible to append rows to a table packed by myisampack? >

COMPRESS() vs myisampack

I have a table with lots of text data, and would like to compress this in order to save space. I would either compress the whole table with myisampack or just the text data with COMPRESS(). When I SELECT from this table, would it be equally fast to use UNCOMPRESS() for text data or use a

Re: myisampack

Jacob Friis wrote: Is it possible to append rows to a table packed by myisampack? No, RTFM, "Compressed storage format is a read-only format that is generated with the myisampack tool." http://dev.mysql.com/doc/mysql/en/Compressed_format.html -- MySQL General Mailing List For list arch

myisampack

Is it possible to append rows to a table packed by myisampack? Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

"myisampack / myisamchk Problem"

Hello * my Problem (resolved for newer mysql Versions): A MyIsam Table is packed with myisampack A subsequent myisamchk -r or -o with index reordering erroneously marks wrong indices in the packed table for 4.0.15 (unpacking reconstructs the original table) This seems to be a known issue

"myisampack, check: already compressed ?"

Hello * Question: Is there a (cheap) way to find out if a MyISAM Table is already compressed, before running a myisampack on it ? Goal: -In a script that regularly compresses Tables i'd like to check before packing. In case the script has previously been started and already don

Re: Myisampack missing from 4.1.1 Win32 binaries

"Rick Robinson" <[EMAIL PROTECTED]> wrote: > Is the myisampack utility supposed to be included in the 4.1.1 binaries for > Windows? It's not there - I couldn't find any explicit reference in the doc > about whether this is deliberate or maybe it was just mi

Myisampack missing from 4.1.1 Win32 binaries

Hello all- Is the myisampack utility supposed to be included in the 4.1.1 binaries for Windows? It's not there - I couldn't find any explicit reference in the doc about whether this is deliberate or maybe it was just missed? Thanks, Rick

RE: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

Re: WG: ABUSE? , myisampack , sql , admin [T2002091901XL] > > At 10:07 +0900 9/20/02, Joel Rees wrote: > >... > >> i received this message , after sending a request to > mysql-mailing-list: > >> > >> >Thank you for bringing this matter to our attention.

RE: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

Cc: [EMAIL PROTECTED] > Subject: Re: WG: ABUSE? , myisampack , sql , admin [T2002091901XL] > > > ... > > i received this message , after sending a request to mysql-mailing-list: > > > > >Thank you for bringing this matter to our attention. We are sorry for > >

Re: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

At 10:07 +0900 9/20/02, Joel Rees wrote: >... >> i received this message , after sending a request to mysql-mailing-list: >> >> >Thank you for bringing this matter to our attention. We are sorry for >> >any inconvenience it has caused you. >... >> It wasn't my intention to abuse , offend or s

Re: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

... > i received this message , after sending a request to mysql-mailing-list: > > >Thank you for bringing this matter to our attention. We are sorry for > >any inconvenience it has caused you. ... > It wasn't my intention to abuse , offend or spam anyone or anything and > i think i didn't do s

Re: ABUSE? , myisampack , sql , admin [T2002091901XL]

Me too received the same but dont know why - Original Message - From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 8:03 PM Subject: WG: ABUSE? , myisampack , sql , admin [T2002091901XL] -U

sql , myisampack

Hi, after being mailed from a spam filter (and i still don't know why) , i am sorry , if my question my appear a second time. Myisampack crashes with 'segmentation fault' anytime i try to use it. MySQL-Version is 2.23-41-log. Linux-kernel is 2.4.10-4GB. Everything installe

WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

-Ursprüngliche Nachricht- Von: Franz, Fa. PostDirekt MA Gesendet am: Donnerstag, 19. September 2002 13:00 An: '[EMAIL PROTECTED]' Betreff: AW:ABUSE? , myisampack , sql , admin [T2002091901XL] Hi there, i received this message , after sending a request to mysql-mailing-lis

myisampack , sql , admin

Good Morning Ladies and Gentlemen, there is a real bad problem with myisampack , that never occured before. I wanted to pack some of my Tables via myisampack and at any condition you i can imagin (server up , server down , database directory , different directory , running myisamchk with mostly

myisampack/myisamchk question

I got an error while executing myisamchk -rq on compressed table. Here's the output: [root@db prod_rel5_1_0]# myisampack buyer Compressing buyer.MYD: (3687550 records) - Calculating statistics - Compressing file 62.69% Remember to run myisamchk -rq on compressed tables [root@db prod_rel

Re: Table corrupted after myisampack

Hi. It sounds as if you run myisampack/myisamchk while the server was running. This is not supported and has a high probability to corrupt tables (http://www.mysql.com/doc/R/e/Repair.html) Bye, Benjamin. On Fri, Apr 26, 2002 at 09:50:18PM -0400, [EMAIL PROTECTED] wrote: > Hi, >

Table corrupted after myisampack

Hi, I am running mysql alpha 4.0.2 on solaris 8. I had the following problem: - I have a table called "call_record" and it has 153501 records. The call_record.MYD file is of size 72,605,973 bytes. I performed myisampack on this table, which brings down the table size to 11,411,

myisampack, CHECK TABLE & REPAIR TABLE

Hello all, I would like to compress some tables which have an archive purpose and thus will not suffer from the restriction of using myisampack, which implies that the tables will be read only after packing. However, we also have a database problem detection program, which will check each table

Re: Mandrake and myisampack

sage - From: "Eric" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 3:42 PM Subject: Mandrake and myisampack > I had mandrake 7.2 running on my system. It crashed and I > transfered my back up files to a system running Debian 2.2. >

Mandrake and myisampack

I had mandrake 7.2 running on my system. It crashed and I transfered my back up files to a system running Debian 2.2. The file were db.frm db.myd db.myi. These are packed files and the mysql I am now running does not use these. What can I do?? Need help Eric. -

myisampack cleanups after exit

Hi, I tried to compress some very big table on Linux and it seems to me that myisampack does not properly remove temporary files after abort. After myisampack cannot write to a file (because the filesystem is full), it should at least remove the .TMD file after itself, I hope. :( Since then

Re: myisampack dumps core on some tables

quot;. > mmokrejs> Well, the other rep tables are fine. I'm a bit angry about myself, > mmokrejs> because I dropped the Celegans.rep tables:!!! > > :( Well, intentionally. :( > mmokrejs> I managed successfully to run "myisamchk -rq" on it, myisampack and again

Re: myisampack dumps core on some tables

the other rep tables are fine. I'm a bit angry about myself, mmokrejs> because I dropped the Celegans.rep tables:!!! :( mmokrejs> I managed successfully to run "myisamchk -rq" on it, myisampack and again mmokrejs> "myisamchk -rq". So now I can only tell you that br

Re: myisampack dumps core on some tables

1 mysqlmysql 2411520 Aug 30 21:39 /data/mysql/Celegans/rep.MYI -rw-rw1 mysqlmysql9247 Aug 30 21:38 /data/mysql/Celegans/rep.frm I managed successfully to run "myisamchk -rq" on it, myisampack and again "myisamchk -rq". So now I can only tell you th

Re: myisampack dumps core on some tables

Hi! >>>>> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote: >> >Description: >> I have on Linux running 3.23.41 the following problem: >> >> $ /usr/local/my

Re: myisampack dumps core on some tables

On Wed, 29 Aug 2001, Sasha Pachev wrote: > On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote: > > >Description: > > I have on Linux running 3.23.41 the following problem: > > > > $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp > /data/mysql/

Re: myisampack dumps core on some tables

On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote: > >Description: > I have on Linux running 3.23.41 the following problem: > > $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp /data/mysql/Aactinomycetemcomitans/blimps.MYI > Compressing /data/mysql/Aact

myisampack dumps core on some tables

>Description: I have on Linux running 3.23.41 the following problem: $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp /data/mysql/Aactinomycetemcomitans/blimps.MYI Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records) - Calculating statistics normal: 7 em

RE: myisampack

:54 To: [EMAIL PROTECTED] Subject: myisampack If I have a lot of rows with text that never changes. Only more rows are added. Should/Can I then use myisampack ? Will it make my FULLTEXT search faster ? Will other database SELECTs become faster ? For now I do not care about disk space. Best

myisampack

If I have a lot of rows with text that never changes. Only more rows are added. Should/Can I then use myisampack ? Will it make my FULLTEXT search faster ? Will other database SELECTs become faster ? For now I do not care about disk space. Best regards Jacob

myisampack - segmentation fault

Hy! i have some trouples to compress one table (http://www.notz.ro/table.tar.gz) with myisamcheck. myisampack always terminate with a segementation fault. here an example: istanbul:/var/mysql/sms_plus # /usr/local/mysql/bin/myisampack -vf message_archiv_25 Compressing

RE: myisampack can DELETE data files

[root@switch logging]# ls -lh ll* -rw-r-1 root root 44M Jan 10 17:35 ll.MYD -rw-rw1 root root 126M Jan 10 17:45 ll.MYI -rw-r-1 root root 9.7k Jan 10 17:25 ll.frm [root@switch logging]# myisampack ll Compressing ll.MYD: (0 records

RE: myisampack can DELETE data files

> :( > > copy MYD and frm file to new table name. Copy MYI from wrong > table to the new table name (oops). myisampack new_table. > new_table.MYD is now 64 bytes. I should have made a note: the bad MYI file copied over was for a compressed table, so myisampack said it was already

myisampack can DELETE data files

:( copy MYD and frm file to new table name. Copy MYI from wrong table to the new table name (oops). myisampack new_table. new_table.MYD is now 64 bytes. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e