Re: How to match a binary null in a varchar column???

Hi Keith, Thanks, it did work. I was trying to use a regular expression but this is just fine for my needs. On Mon, 2005-10-03 at 13:18 -0400, Keith Ivey wrote: > Richard F. Rebel wrote: > > > do I say REGEXP BINARY "" > > > > I have tried \000 \0 as t

RE: How to match a binary null in a varchar column???

the binary operator: > > http://dev.mysql.com/doc/mysql/en/charset-binary-op.html > > Cheers, > > Andrew > > -----Original Message- > From: Richard F. Rebel [mailto:[EMAIL PROTECTED] > Sent: Mon, 03 Oct 2005 17:48 > To: Untitled > Subject: How to match a bin

How to match a binary null in a varchar column???

Hello, How do you match all rows with a binary null (octal 000) in a given column. I have tried all sorts of strange combinations of REGEXP and LIKE with no results. I have dug in the manual, but can't seem to find anything. Any help would be appreciated. -- Richard F. Rebel cat /dev

Number of InnoDB files vs performance?

Hello, I was wondering if anyone had any knowledge to share regarding creating many 2GB innodb table space files, vs creating a few 100GB ones. It has been my habit to create many smaller for several reasons, including nfs clients/servers or utlities which don't reliably copy/ back the

InnoDB files corrupt after copy to another disk???

ving the innodb spaces to another partition/disk could possibly cause this type of problem? I double checked my innodb table space directives, the paths are all correct. Thanks! -- Richard F. Rebel cat /dev/null > `tty` signature.asc Description: This is a digitally signed message part

InnoDB Log and binlog files and Solid State Disk?

Hello, I happen to be in a position to utilize a 6GB FC solid state disk (RAM based with battery and disk backup) on our new storage area network. I haven't ever used an SSD for MySQL before, but I am aware of the potential performance benefits. My question is, does anyone have any suggestions

Re: R: R: connectorJ & huge table problem

e: > > int table = ((m / 200) + 1); > String query = "SELECT * FROM PARTITIONED_B_" + table + " WHERE ID=?"; > ) > > > Thank you anyway -- Richard F. Rebel [EMAIL PROTECTED] t. 212.239. signature.asc Description: This is a digitally signed message part

Re: InnoDB file data size against MyISAM files data sizes

e data files > sizes? convertion to InnoDB will need more or less disk space than MyISAM? > > -thanks, Eli -- Richard F. Rebel [EMAIL PROTECTED] t. 212.239. signature.asc Description: This is a digitally signed message part

Replication and LOAD DATA INFILE MySQL Max 3.23.56-1

into a table using AUTO_INCREMENT as well and this may be compounding the problem. I have read the docs, but it's sort of unclear, does LOAD DATA INFILE work in a replicated 3.23.56-1 setup, only under certain circumstances, or not at all? Your help is greatly appreciated. Thanks. --

Many InnoDB files and performance.

many (30 to 50) 2gb InnoDB files adversely effect performance or the size of the indexes/tables? Thanks! -- Richard F. Rebel [EMAIL PROTECTED] t. 212.239. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477

That changes the query plan and might > mask the bug whatever it is. I have done this, and will report if it diminishes or masks the problem. We cannot upgrade to 4.0 right now as we have several large deployments and it's a large undertaking to recompile everything with the right clien

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477

ode we have that updates and interacts with this table in order to try and cause the server to crash to no avail. What's next? Best, -- Richard F. Rebel [EMAIL PROTECTED] t. 212.239. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477

t, we see little change from that 374 megs figure. I can try and install something that will monitor more than once per minute (our current granularity). I will change the buffer sizes as you mention and test. But, after all of this, where does it lead us? The thing is still crashing. :( Best,

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477

se Oy > http://www.innodb.com > Transactions, foreign keys, and a hot backup tool for MySQL > Order MySQL technical support from https://order.mysql.com/ > > > .. > > Subject: RH 8.0 InnoDB: Assertion failure in thread 122911 in file > mem0pool.c line 477 &g

RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477

followed the advice to use the most recent MySQL and to alter a few variables which did seem to help for a couple of weeks atleast. Our db traffic really hasn't changed much since then so I am flummoxed as to why now this would resurface. Thanks, Richard F. Rebel. /usr/sbin/mysqld-max: ready

Memory usage of MySQL-Max on Rh 8.0 with InnnoDB

Hello, I am running MySQL-Max on RH8.0 on a Dell 1650, 2 proc with 512MB ram. I am only using InnoDB for databases (40gb) other than the mysql.*. I have the following relevant memory settings: set-variable= sort_buffer=2M set-variable= record_buffer=2M ## For redhat 8.0 set-variable

After MyISAM -> InnoDB data is >2x larger?

expected on some increase, just based on the premise of how things are different between the two formats, but I didn't expect this much. All of my databases take like 200gb instead of the 100gb used b4. Is this normal? Is there anything I can do to mitigate this? Thanks! Richard F.

Re: Why does MAX(this_col) when this_col has index?

ng the wrong thing. Any further thoughts? Thanks! On Saturday, April 27, 2002, at 01:31 PM, Jeremy Zawodny wrote: > On Sat, Apr 27, 2002 at 08:25:26AM -0400, Richard F. Rebel wrote: >> >> Hello, >> >> Perhaps I don't understand indexes but I was wondering h

Why does MAX(this_col) when this_col has index?

Hello, Perhaps I don't understand indexes but I was wondering how to improve teh performance of a query on an indexed column that uses MAX(). mysql> explain select max(master_mtime) from redirects where uri_scheme = 'http'; +---+--+-++---