Big Table, myisampack or merge?

Hi lets say I want to record transactions on my site. This transaction table becomes over 1GB in six months. Which makes it very hard to read. The reading and deleting process becomes very slow. Would it be wise to make a new transaction table every month? Then recreate the merge table? How long

Re: Backup: Copy MYSQL Directory or use MysqlDump

I used mysqlhotcopy and all is fine. Daniel da Veiga wrote: > > On 1/23/07, Alex Arul <[EMAIL PROTECTED]> wrote: >> Hi, >> >> MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM >> tables and copying them or shutting down the server and taring the entire >> MySQL directory

Backup: Copy MYSQL Directory or use MysqlDump

I want to create a backup for my MySQL database every single night. I am currently running on a linux box. I have a backup drive located as /backup Would it be more effecient to use mysqldump tool, or use the unix command "dump or cp" Andrew -- View this message in context: http://www.nabble

Re: Help indexing this query.

ices you need the queried-upon column(s) > listed first(earlier) in the index. > > These might speed things up > > HTH, > Dan > > > On 1/22/07, altendew <[EMAIL PROTECTED]> wrote: >> >> --- EXPLAIN --- >> >> 1 SIMPLE e system cid NULL NU

Re: Help indexing this query.

> Dan > > > > On 1/22/07, altendew <[EMAIL PROTECTED]> wrote: >> >> --- ptsSignups -- >> id int(20) No >> mid int(20) No 0 >> ptsID int(20) No 0 >> pps double No 0 >> points double No 0 >> loginID varchar(255) No >> emai

Help indexing this query.

--- ptsSignups -- id int(20) No mid int(20) No 0 ptsID int(20) No 0 pps double No 0 points double No 0 loginID varchar(255) No emailConfirm longtext No time timestamp Yes CURRENT_TIMESTAMP reasonForDeny longtext No status int(1) No 1 --- index (timeframe) --- timeframe (mid,status,ti

Re: Selecting Different Tables Based on Value. Case seems to fail.

What do you mean assemble the SQL in Code. I am using MYSQL 4.1 and PHP. Daniel Kasak wrote: > > altendew wrote: > >> Im trying to create one query here. I know why its failing because CASE >> can >> not be used like this, but how could I ever do a query like thi

Selecting Different Tables Based on Value. Case seems to fail.

Im trying to create one query here. I know why its failing because CASE can not be used like this, but how could I ever do a query like this. [CODE] SELECT b.* FROM bonus b JOIN CASE b.type WHEN 'custom' THEN 'bonusCustom g' WHEN 'pts' THEN 'bonusPts g'