Re: Hijackers?

2005-12-13 Thread Jason Martin
believe using bind variables whenever possible also helps prevent this attack. -Jason Martin -- S met ing's hap ening t my k ybo rd . . This message is PGP/MIME signed. pgpBcno4Qf3S7.pgp Description: PGP signature

Re: How to index a table with many fields?

2005-12-01 Thread Jason Martin
woudn't want one index that contains all fields, as there is no efficient way to search it for a field that isn't on the 'leading edge' of the index. You'd be better off with a seperate index for each field. -Jason Martin -- If you don't like the news, go out and make some of your own. This message

Re: using dinamic table name inside stored procedure

2005-11-20 Thread Jason Martin
I'd really suggest looking at the data model that requies you to dynamically select which table to read from, and find another way. If there are several tables that have the same column that differ only by name, why not make the name a column? -Jason Martin On Sat, Nov 19, 2005 at 02:28:41PM

Re: Anyone use Snort and Acid?

2005-11-14 Thread Jason Martin
On Sun, Nov 13, 2005 at 08:56:12PM -0800, Ed Kasky wrote: Snort v2.4.3 ACID v0.9.6b23 I seem to recall hearing that ACID is deprecated; you might want to look around if there is a newer equivalent. SQUIL (http://sguil.sourceforge.net/) is supposed to be really good. -Jason Martin -- I have

Re: Best Fieldtype to store IP address...

2005-11-11 Thread Jason Martin
future. Maybe you'd better choose a field type that can accomodate those as well as the traditional 123.123.123.123 type I believe both 14v6 and ipv4 can be expressed as decimal numbers too. -Jason Martin -- This Charlie Brown must have been a very wise man. This message is PGP/MIME signed

Re: MySQL table growth monitoring via RRDtool and histographs?

2005-11-01 Thread Jason Martin
On Tue, Nov 01, 2005 at 02:38:29PM -0800, Kevin Burton wrote: Gangla and Cacti seem to do similar tasks (if you stretch them) but they really fall down fast. Can you elaborate on 'fall down fast'? It should be a really simple operation to do this in cacti. -Jason Martin -- SYSTEM ERROR

Re: Oracle DMP to mySQL -- Possible???

2005-10-25 Thread Jason Martin
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote: What you need is the table schemas and the data. Oracle doesn't have SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't The oracle-supplied DBMS_METADATA package can do this for you. -Jason Martin -- Silence

Re: Joins Tutorial Anywhere?

2005-10-04 Thread Jason Martin
not have to overlap. -Jason Martin -- Reduce Carbon Dioxide emmissions - STOP Breathing This message is PGP/MIME signed. pgpoEeMSujkX4.pgp Description: PGP signature

Re: Weird delete behavior on mysql 4.0 - rows not disappearing....

2005-08-31 Thread Jason Martin
the transaction in Window B. See the manual for details http://dev.mysql.com/doc/mysql/en/innodb-consistent-read.html Is this a known bug? It's not a bug. Oracle works in a similar fashion. -Jason Martin -- Never eat anything bigger than your head. This message is PGP/MIME signed. pgpnWgmFXjYfU.pgp

Re: What is a schema?

2005-08-03 Thread Jason Martin
multiple schemas. -Jason Martin -- I'd love to, but I have to rotate my crops. This message is PGP/MIME signed. pgpjwHryLEUmW.pgp Description: PGP signature

Re: password is lose

2005-05-20 Thread Jason Martin
On Fri, May 20, 2005 at 09:28:40AM -, [EMAIL PROTECTED] wrote: Hint: Did you specify a password for the login ? I suspect the original poster was saying that he doesn't remember setting a password, so he doesn't know what password to enter. -Jason Martin -- Unrecoverable Application ERROR

Re: How to retain Key order when Deleting a Row

2005-04-11 Thread Jason Martin
. Such a thing isn't possible as it would require MySQL to update every row 'past' the deleted row. Why do you need to do this? -Jason Martin -- Oxymoron: Steel wool. This message is PGP/MIME signed. pgpdul81Q104Q.pgp Description: PGP signature

Re: Non-destructive Expanding Retracting sets

2005-03-31 Thread Jason Martin
with SELECT `id` FROM `thetable` WHERE `type` LIKE '%category3%'; That query will not be able to use indexes and will be too slow to use in any sizable database. -Jason Martin -- Nobody home but the lights, and they're out too. This message is PGP/MIME signed. pgpJnyYA6U07B.pgp Description

Re: Url http://highperformancemysql.com/

2005-02-18 Thread Jason Martin
On Fri, Feb 18, 2005 at 10:06:38AM +0100, Anton Kornexl wrote: There should be tools on this website, but i see only a message from Infektion Group. What happened ? Looks like the website got hacked. -Jason Martin -- Useless Invention: Motorcycle seat-belts. This message is PGP/MIME signed

Re: mysqld process hangs, cannot terminate

2005-02-08 Thread Jason Martin
that is usually the result of a hardware problem. In 'top' is the process stuck on 'D', ie waiting for a disk to respond? -Jason Martin -- If you can't debug it, deplug it. This message is PGP/MIME signed. pgp660FTDZ8an.pgp Description: PGP signature

Re: bash powered MySQL Queries

2005-01-31 Thread Jason Martin
On Mon, Jan 31, 2005 at 06:57:58PM +, Edward Macnaghten wrote: 1 - The output is not cluttered with headers, and a means exist to easily separate fields when there is more than one column or row in the query. The mysql --batch option should take care of that for you. -Jason Martin

Re: disappearing data - please help!

2005-01-30 Thread Jason Martin
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software) wrote: but I'm having the most frustrating problem. Data I've inserted simply VANISHES. What is the setting for AutoCommit? If it is 0, are you sure that commit is being called before the session ends? -Jason Martin

Re: disappearing data - please help!

2005-01-30 Thread Jason Martin
inserting the data: mysql_query(COMMIT, $this-dbh); and see if that changes anything. -Jason Martin -- My karma ran over my dogma This message is PGP/MIME signed. pgpplCPHXl079.pgp Description: PGP signature

Re: A problem of structure

2005-01-26 Thread Jason Martin
On Wed, Jan 26, 2005 at 01:56:05PM +, Pupeno wrote: Takes more room because of the extra field ? Can you tell me more about 'the normalized approach' ? http://en.wikipedia.org/wiki/Database_normalization -Jason Martin -- If you cannot convince them, confuse them. This message is PGP/MIME

Re: load balacing in a replicated environment

2005-01-21 Thread Jason Martin
On Fri, Jan 21, 2005 at 09:21:18AM -0500, Eben Goodman wrote: connection layer, and based on time of day or something passes a You could use a TCP load balancer such as Balance or PEN, or you could modify the code to randomly select a server name from a list at connection time. -Jason Martin

Re: calculated field

2005-01-21 Thread Jason Martin
a table that way. However when selecting the data you can do select (field2+field3) FIELD1, field2, field3 from table such that you'll get the calculated field. -Jason Martin -- When I tried to take an ego trip I got stopped at the border This message is PGP/MIME signed. pgpwOoiS87sEx.pgp

Re: Generic graphing tool?

2005-01-11 Thread Jason Martin
On Tue, Jan 11, 2005 at 11:44:34AM +1100, Daniel Kasak wrote: Jason Martin wrote: Does anyone know of a web-based tool that will let you graph arbitrary data out of of MySQL? I'm thinking of something that lets you define a select statement, some graph options and produce a graph. JPGraph

Re: Generic graphing tool?

2005-01-11 Thread Jason Martin
On Tue, Jan 11, 2005 at 05:55:31PM +0100, Olivier Kaloudoff wrote: Cacti, based on mysql stored rrd database is probably the kind of tool you are looking for; Ahh, so is there a cacti-like tool that understands MySQL? Thanks, -Jason Martin -- This message is PGP/MIME signed

Generic graphing tool?

2005-01-10 Thread Jason Martin
Does anyone know of a web-based tool that will let you graph arbitrary data out of of MySQL? I'm thinking of something that lets you define a select statement, some graph options and produce a graph. Thanks, -Jason Martin -- You can't go home again, unless you set $HOME. This message is PGP/MIME

Re: how to connect to MySQL with an ecripted password.

2005-01-10 Thread Jason Martin
once known it can be used in another script. You should concentrate on protecting that file. -Jason Martin -- Any philosophy that can be put in a nutshell belongs there This message is PGP/MIME signed. pgpvmpfpEhT4g.pgp Description: PGP signature