Re: How to avoid deadlocks.. advice needed also insight, illumination and a bit of hallucination...

riginal Message - > From: "Andrés Tello" > To: "Mailing-List mysql" > Sent: Wednesday, 20 April, 2011 9:15:09 PM > Subject: How to avoid deadlocks.. advice needed also insight, illumination > and a bit of hallucination... > > I'm running into some de

How to avoid deadlocks.. advice needed also insight, illumination and a bit of hallucination...

I'm running into some deadlocks issues. I have this structure accounting |---movements To know the balance of the account, I usualy do a sum(movements.amount) where accounting.id=someid The issue is that the sum is starting to run very slow due hardware constraints, and I can't trow more hardw

RE: Guru's advice needed ........[Security: SQL injection]

ience has already tried this... Thanks, Matt -Original Message- From: Tariq Murtaza [mailto:[EMAIL PROTECTED] Sent: 19 March 2004 18:41 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Guru's advice needed [Security: SQL injection] *Dear Friends!* Can someone shed some lig

Re: Guru's advice needed ........[Security: SQL injection]

Hi Jigal, others, > > Can someone shed some light on how "SQL injection" attack occurs when > > *magic_quotes_gpc *is"ON" and how it prevents when its "OFF". To my > > understanding apostrophise are escaped automatically in POST/GET/COOKIE > > when its ON, so how it tends towards SQL Injection.

Re: Guru's advice needed ........[Security: SQL injection]

From: "Tariq Murtaza" <[EMAIL PROTECTED]> > Can someone shed some light on how "SQL injection" attack occurs when > *magic_quotes_gpc *is"ON" and how it prevents when its "OFF". To my > understanding apostrophise are escaped automatically in POST/GET/COOKIE > when its ON, so how it tends towards

Guru's advice needed ........[Security: SQL injection]

*Dear Friends!* Can someone shed some light on how "SQL injection" attack occurs when *magic_quotes_gpc *is"ON" and how it prevents when its "OFF". To my understanding apostrophise are escaped automatically in POST/GET/COOKIE when its ON, so how it tends towards SQL Injection. Someone sugges

Re: Advice needed for high volume of inserts

e: - To: "Peter J Milanese" <[EMAIL PROTECTED]> From: "STE-MARIE, ERIC" <[EMAIL PROTECTED]> Date: 01/20/2004 02:41PM cc: [EMAIL PROTECTED] Subject: Re: Advice needed for high volume of inserts -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On January 20, 2004 02:31

Re: Advice needed for high volume of inserts

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On January 20, 2004 02:31 pm, Peter J Milanese wrote: > It'll work. >   > I do slight less on the way of inserts. What I do is dynamically generate > the tables within my entry code, and merge tables based on the query. Good > for large log parsers. Be

Re: Advice needed for high volume of inserts

-Forwarded by Peter J Milanese/MHT/Nypl on 01/20/2004 02:36PM - To: "STE-MARIE, ERIC" <[EMAIL PROTECTED]> From: Peter J Milanese/MHT/Nypl Date: 01/20/2004 02:31PM cc: [EMAIL PROTECTED] Subject: Re: Advice needed for high volume of inserts It'll work. I do slig

Advice needed for high volume of inserts

Hello, This is my first message on this list. So I take the occasion to salute every one of you. I'm looking to implement a database server wich will mostly insert data. The data structure is not complexe. The data will be insterted in 1 table at burst rates of 13000 insert/seconds and sust

Help and advice needed with mysqldump

Hi I need to get some data out of a table hosted for me on a webserver. I'm thinking of using the command mysqldump to grab the data, though I'm confused as to how to structure the statement. Also I'd like to automate the process on a Windows PC, how would I do that? (My perfect solution would

date calculation, design advice needed (continued)

arrgg, sorry i made a mistake and my precedent mail was sent before i finished wrting it :-{, the query is: INSERT INTO `TBL_COUNT_EXCLUDE` SELECT MAIN.id, SUM(IF(EX.excl_date BETWEEN MAIN.start_date AND MAIN.end_date, 1, 0)) AS excl_count FROM TBL_MAIN_DATE AS MAIN, TBL_EXCLUDE_DATE AS EX GROUP

date calculation, design advice needed

hi all, i've a question concerning the calculation of the number of days between 2 dates, and after searching the mailing list i'm still stuck, any help will be appreceiated :} actually i've a table with a lot of rows (varying between 5 to 15 millions), each row has a unique id and 2 date: start_

Advice needed on starting out with MySql...

Greetings all, I have formerly installed mysql 4.0.12 on my machine running win2k Advanced Sever, with Apache 2.0.46 and PHP 4.3.2. Somehow I messed up my configuration file and decided to start the whole thing from scratch. Now I hear that version 4.0.14 release date is only days away. My quest

Re: Normalization advice needed

On Thu, Dec 27, 2001 at 04:01:57PM -0600, Gawain wrote: > I've got a 3500 record database cataloging an art collection. The > data was originally assembled (by others) in Access. I've imported it > into MySQL to make it available on the artist's web site: > . > >

Normalization advice needed

I've got a 3500 record database cataloging an art collection. The data was originally assembled (by others) in Access. I've imported it into MySQL to make it available on the artist's web site: . The data was formatted in Access as one big table. About 800 of the

Re: Replication advice needed...

On Sun, Aug 26, 2001 at 11:29:31AM +, Greg Cope wrote: > Jeremy Zawodny wrote:> > > On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote: > > > > > > The other solution is rsync. I dont know much about this guy > > > yet, but I have some concerns with using it to copy over large > > >

Re: Replication advice needed...

Jeremy Zawodny wrote:> > On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote: > > > > The other solution is rsync. I dont know much about this guy yet, > > but I have some concerns with using it to copy over large remote > > files. For example, if I have a 1.2 gig table that has been hea

Re: Replication advice needed...

On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote: > > The other solution is rsync. I dont know much about this guy yet, > but I have some concerns with using it to copy over large remote > files. For example, if I have a 1.2 gig table that has been heavily > modified over a weeks work

Re: Replication advice needed...

> The other solution is rsync.  I dont know much about this guy yet, but I > have some concerns with using it to copy over large remote files.  For > example, if I have a 1.2 gig table that has been heavily modified over a > weeks work, how reliable is the remote file after rsync?  I guess Im jus

Re: Replication advice needed...

On Thu, Aug 23, 2001 at 03:19:17PM -0700, Bryan Coon wrote: > Hi, > > We have a somewhat tricky problem that I need some help with. What > we have is one machine (the master) that we use for database > development, and two dedicated nodes (slaves) on a beowulf cluster > that house the non-dev da

Replication advice needed...

Hi, We have a somewhat tricky problem that I need some help with. What we have is one machine (the master) that we use for database development, and two dedicated nodes (slaves) on a beowulf cluster that house the non-dev databases. What we need is to mirror the master to the slaves, but not ne

RE: Advice needed....

Message- From: clay bond [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 19, 2001 6:51 PM To: [EMAIL PROTECTED] Subject: Re: Advice needed On Sat, 19 May 2001, Dave Carter wrote: > I'm converting an Access db to mySQL, and Access allows users to Insert > Records into a table AN

RE: Advice needed....

On 19-May-01 Dave Carter wrote: > I'm converting an Access db to mySQL, and Access allows users to Insert > Records into a table AND call them as well in the FROM clause. This is > illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't > know really how to get around it. How ca

Re: Advice needed....

On Sat, 19 May 2001, Dave Carter wrote: > I'm converting an Access db to mySQL, and Access allows users to Insert > Records into a table AND call them as well in the FROM clause. This is > illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't > know really how to get around

Re: Advice needed....

u might want to have a table holding UNIQUE ids so every inserted record is unique. Mayways, depends on what EXACTLY you want. Describe your case better. Regards, Artem - Original Message - From: "Dave Carter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday,

Advice needed....

I'm converting an Access db to mySQL, and Access allows users to Insert Records into a table AND call them as well in the FROM clause. This is illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't know really how to get around it. How can I insert only new records that aren't a

building advice needed on database structure

I have a database project, historic building materials... I've designed 4 Tables like this (there are more fields which I didn't listed here): table products - primary key(productid) - product description ... table category - primary key(categoryid) - category description table subcategory - prima

configuration advice needed

Hello All. I have some questions / requests for advice that I hope some of you could help me with. I have alot of virtual domains that I want to provide MySQL access to. These virtual domains are spread out across several servers right now and continue to grow. On each of these servers I curr