RE: Deletes on big tables

006 00:02 To: Marvin Wright Cc: mysql@lists.mysql.com Subject: Re: Deletes on big tables Marvin Wright wrote: >I have 3 tables where I keep cache records, the structures are >something like > > >TableA is a 1 to many on TableB which is a 1 to many on TableC > >To give you

RE: Deletes on big tables

Thanks Chris for your input. I have no redundant indexes but of course I will double check. I will look into making smaller tables. Marvin -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: 19 October 2006 23:52 To: Marvin Wright Cc: mysql@lists.mysql.com Subject: Re

Deletes on big tables

Hi, This is a bit of a long mail, so apologies in advance, I've tried to five as much information as possible that I think might be useful regarding my problem. I have 3 tables where I keep cache records, the structures are something like TableA TableB TableC Id

Multi Master Replication

idea why this could be a problem ? All mysql versions are 4.1.12 and running on linux. Many Thanks Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] ** This email and any files transmitted with it are con

InnoDB per-table table spaces

, however if there is enough disk space on the system why would it do this if I am on per-table table spaces ? It should grow to what it likes. I don't have any 2 Gig file size limit. Any information on this would be great. Thanks. Marvin Wright Flights Developer Lastminute.com [EMAIL PROT

Slave Problem

Hi, I found this morning that the slave replication thread seem to have hung. Below I have pasted in my show slave status, it seems to be stuck trying to connect to the master. To fix this I issued a stop slave and start slave, my slave is about 3 weeks behind now. I have a script checking for wh

RE: Correct way to use innodb_file_per_table?

t: 26 July 2005 16:24 To: Marvin Wright; mysql@lists.mysql.com Subject: Re: Correct way to use innodb_file_per_table? On Jul 26, 2005, at 3:56 AM, Marvin Wright wrote: > > Regarding the file size issue, we are on a 32-bit system running > redhat AS3, we already have idb files in excess of

RE: Correct way to use innodb_file_per_table?

blog files, would it still work after restoring the original files ? With this I could test Heikki idea without the pssibility of losing data. Cheers, Marvin. -Original Message- From: Bruce Dembecki [mailto:[EMAIL PROTECTED] Sent: 25 July 2005 17:55 To: Marvin Wright; mysql@lists.mysql.com S

RE: Correct way to use innodb_file_per_table?

CTED] Sent: 25 July 2005 12:53 To: Marvin Wright Cc: mysql@lists.mysql.com Subject: Re: Correct way to use innodb_file_per_table? On Jul 25, 2005, at 5:47 AM, Marvin Wright wrote: > You recommend to dump tables before changing then re-import them back. > But if all databases are in t

RE: Correct way to use innodb_file_per_table?

Hi, Can anybody help with this ? Regards, Marvin -Original Message- From: Marvin Wright Sent: 22 July 2005 10:46 To: Heikki Tuuri; mysql@lists.mysql.com Subject: RE: Correct way to use innodb_file_per_table? Hi Heikki, I've followed your instructions here and its all worked

RE: Correct way to use innodb_file_per_table?

Hi Heikki, I've followed your instructions here and its all worked fine. Now I currently have a 200Gb shared innodb table space which is sitting almost empty now all databases have there own table spaces. I want to reduce this amount but ot sure what is the best way to do it. I know I can not ju

innodb_file_per_table table status

Hi, I've just converted my databases so they are using per_table tablespaces. When I do a show table status in that database the Comment line still shows the amount free, but I assume this doesn't mean anything now ?? It doesn't make sense ? *** 1. row ***

Mysqladmin bug

7483647 is the max size of an int. Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to

Slow InnoDB Delete Transaction

r advice. Please let me know if I should provide any more information. Regards, Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] +44 (0) 207 802 4543 ** This email and any files transmitted with it are confident

Replication / Purge Logs

show slave status, I should be looking at the Master_Log_File field ? Thanks. Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] +44 (0) 207 802 4543 ** This email and any files transmitted with it are confidential

InnoDB Deletes / Swap Problem

(correct me if I'm wrong), Linux should free memory from these buffers when needed by something else. Why should the machine be using swap at all if there is plently of memory elsewhere that can be used ?? Any help on this would be great. Marvin Wright Flights Developer Lastminute.com [

RE: deleting millions of records did not change the file size

Run optimize table position_log Marvin. -Original Message- From: Gil Vidals [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 17:04 To: [EMAIL PROTECTED] Cc: robert gavina Subject: deleting millions of records did not change the file size My question in brief is why wouldn't the physical mys

RE: Linux 2GB Memory Limit

b buffer pool of > 2GB ?? Regards, Marvin. -Original Message- From: Marc Slemko [mailto:[EMAIL PROTECTED] Sent: 09 July 2004 20:15 To: Marvin Wright Cc: [EMAIL PROTECTED] Subject: Re: Linux 2GB Memory Limit On Fri, 9 Jul 2004 15:46:37 +0100 , Marvin Wright <[EMAIL PROTECTED]>

RE: Concurrency Question

Hi, It suggests below to bundle transactions into one commit, at what point does this become unecessary ? For example I have 2 threads each doing 12,000 inserts in 1 commit each. Would I really gain any performance if I did these 24,000 inserts in 1 commit only ? Additionally, what performance

RE: Linux 2GB Memory Limit

rebuild equivalents like TAO Linux and White box Linux). Kev -Original Message- From: Marvin Wright [mailto:[EMAIL PROTECTED] Sent: 09 July 2004 14:07 To: [EMAIL PROTECTED] Subject: Linux 2GB Memory Limit Hi, Is there any work around for this yet where a process can not allocate

Linux 2GB Memory Limit

Hi, Is there any work around for this yet where a process can not allocate more than 2GB. Can I upgrade my Redhat OS to any particular version ? Many Thanks. Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] +44 (0) 207 802 4543

Server Configuration

Hi, We are about to build some new database servers and I have some questions which I'd like some advice on. The machines we are building have 4 Xeon 2GHz CPU's, 4 x 32GB SCSI disk using RAID 1+0 (so thats 64GB of storage) and 4 Gig of RAM. The OS will be Redhat 7.3. Other than the mysql database

RE: InnoDB - Foreign Key - Error 150.

am using mysqldump? [see commands below] Or, is this a problem with how I am restoring the database? [Which, I create a "default" mysql database on its own port and then run from the prompt "mysql --port= --socket= -p < archive_file.sql" Thanks again Gabe -----Original M

RE: InnoDB - Foreign Key - Error 150.

Hi, Are you creating them in the correct order ? object_type must exist before you can create cur_reject_tk_sum otherwise the foreign key will give errors. Marvin -Original Message- From: Tucker, Gabriel [mailto:[EMAIL PROTECTED] Sent: 04 May 2004 14:46 To: Mysql General (E-mail) Subje

RE: InnoDB Load Problem

0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 Have switched innodb_flush_log_at_trx_commit to 0 but still do not see any difference in performance. Marvin. -Original Message- From: Mechain Marc [mailto:[EMAIL PROTECTED] Sent: 20 April 2004 13:02 To: Marvin Wrigh

RE: InnoDB Load Problem

T -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: 19 April 2004 23:35 To: 'Marvin Wright'; [EMAIL PROTECTED] Subject: RE: InnoDB Load Problem > -Original Message- > From: Marvin Wright [mailto

InnoDB Load Problem

transaction. * Should I increase the innodb_buffer_pool_size ??, ( bare in mind there is a 2GB limit on linux/GLIBC ) * Change the innodb_flush_method to O_DSYNC Any advice on the steps I should take would be greatly appreciated. Please let me know if you require any additional in

RE: InnoDB Questions

Hi, >From my experience, once you have created a datafile it doesn't work when you try to make it larger. If you dont care about the data thats already in it then delete the current ibdata files and restart mysql. If you do then put the size back to how it was, dump the data, shutdown the server,

RE: Key_buffer_size

Hi, I'm in the same boat here, I only have InnodDB tables except for the mysql MyISAM tables. So in theory would a value of something like 8mb be sufficient for those ? Cheers. Marvin. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: 30 September 2003 22:13 To: [E

RE: InnoDB / Linux

00:07 To: [EMAIL PROTECTED] Subject: Re: InnoDB / Linux Marvin Wright said: > Hi, > > I'm in the process of setting up a new database server that will run on > redhat linux. > The machine will be dual processor with 4GB ram and about 16GB disk. > > The machine is goin

InnoDB / Linux

Any input would be greatly appreciated. Best Regards, Marvin Wright This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus servic

Error Log Entries

w done this and it still appears in the log, the last thing it suggested was to check the patch level of Solaris. I am running on a Sun Solaris 2.7 machine, does anybody know what the recommended patch level is to stop this problem happening ? Thanks. Regards, Marvin Wright Senior

Communication Errors

one this and it still appears in the log, the last thing it suggested was to check the patch level of Solaris. I am running on a Sun Solaris 2.7 machine, does anybody know what the recommended patch level is to stop this problem happening ? Thanks. Regards, Marvin Wright. ÝÝ