RE: Collation problems or messed joins?

Have you check that the collation for the text columns match the collation for the table and that you've set UTF8 for the query (set char set utf8). Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct

RE: Mysql 4.1.1 on Linux table size limit of 4GB and grant priv for Load

As it looks like no one else has replied. The default table size is 4GB - effectively if you do not modify the table create statement this is the size you get. To alter the table size you need to change the value of the MAX_ROWS parameter. The table size is governed by MAX_ROWS multiplied by aver

RE: any performance increase from using prepared statements

Unless something has radically changed since 4.1.2 then prepared statements (at least from c) are 50% slower than executing statements as required. Search for posts by me on the subject from last year. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000

RE: Mysql installation information

If the Redhat Enterprise edition is anything like the SuSE Enterprise then you have Mysql installed already. It won't be 4.1.10a most likely 4.0.x. Just down load the 4.1.10a rpm and install it over the top of the existing version. Kevin Cowley Product Development Alchemetrics Ltd SMARTER

RE: table join question

- provided you're prepared to wait whilst it works out the result. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] > -Original Message- > Fro

RE: MySql error...

-test /var/mysql /test Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] > -Original Message- > From: jschmidt [ma

RE: MySql error...

ld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] > -Original Message- > From: jschmidt [mailto:[EMAIL PROTECTED] > S

RE: Join Limits

d of a job to rewrite the relevant parts of MySql though. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] > -Original Message- > From: Eric Berge

Join Limits

Does anyone know if there is a method of circumventing or changing the default join limits of 64 tables or 1024 columns? We're running Mysql 4.1.4 using MyISAM tables Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902

RE: Two versions of MySQL on same machine

d 3.n.x installed on the same machine and the 3.n.x are in the default path for system users. You then have to remember to explicitly reset the path every time you want to use any of the 4.n.x utilities as they'll try and use the 3.n.x libraries and fail. Kevin Cowley R&D Tel: 0118

RE: Two versions of MySQL on same machine

mysqld_safe version that corresponds to the version you want. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- > From: Dean, Michael L USAATC [mailto:[EMAIL PROTECTED] > Sent: 11 February 2005 15:07

RE: Two versions of MySQL on same machine

hich finds and starts/stops/shutsdown each installed version. Then you'll need to work out migrations strategies, user admin between versions, etc. Welcome to the world of system/database admin. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www

RE: Error 1271 (HY000) - Illegal mix of collations

har set at database level and the default on the table is different you'll need to wrap your query with a set character set pair - the first to set it to what you need and the second to set it back to the default. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL P

RE: Upgrading from 3.23.57 to 4.1.9 using mysqldump

Modify the insert statement so that you name the column you're inserting to. INSERT INTO `db` (put the column names in here) VALUES('localhost','dbxxx','','Y','Y','Y','Y','Y','Y','N',

RE: Character Sets, 4.0 and 4.1

iate value otherwise you'll garbage your data on import/export. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- > From: Bruce Dembecki [mailto:[EMAIL PROTECTED] > Sent: 04 February 2005

RE: Export database to XML/UML/Webpage?

As long as you've only got 1 instance of Mysql and it's on the default port! Otherwise use one of the MySQL products. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > Fabforce's DBD

RE: server performance

ing a 'show tables' when a database instance is heavily loaded. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- > From: Ender Güler [mailto:[EMAIL PROTECTED] > Sent: 25 Januar

RE: mydb-bin.xxx files

Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > - to remove the bin logs: > > PURGE MASTER LOGS TO 'filename'; (where filename is the > name of the last bin log to keep) I prefer RE

RE: Specifying location of .my.cnf to load_defaults

The problem I have is how do I tell the MySQL client library, ie the load_defaults function where it is as there's no parameter to do this. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- >

RE: Specifying location of .my.cnf to load_defaults

load_defaults(); handle_options(); } So you need to be able to tell load_defaults where to locate the .my.cnf file so it can go and load the defaults. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message-

Specifying location of .my.cnf to load_defaults

he .my.cnf file (defaults to $HOME/.my.cnf). Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry P

RE: Does MySQL support server with 2 cpu??

Not sure what you mean. MySQL (4.0.0+) runs perfectly happily under Linux on multi-processor boxes. Allocation of processes to CPU's is an OS function not an application function. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetr

return from load_defaults when .my.cnf not found

assumes it works. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Woking

RE: 2 ways Replication in MySQL

the project we had the basic replication engine working but none of the conflict resolution stuff. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > The closest we got to this was having a master database in one place and >

Column restrictions in 4.1.x from 3.23.52

ented feature change? We're using MyIASM tables. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk ** ALCHEMETRICS LIMITED (ALCHEMETRICS)

RE: Prepared statement for MySQL 4.1

Re speed benefits There aren't any - at least not through the C API. It's at least twice as slow as writing embedded statements and parsing every time. I'm waiting for them to announce they've fixed it before we consider this route again. Kevin Cowley R&D Tel: 0118 902

RE: Select Binary Field when UTF8 and Collate

des the SELECT Statement in any query. As an aside using 'aaa' 'bbb' makes an incorrect statement about the comparison. The comparator value I used is typical but the character value for any of the 5 bytes in either the key fields or comparator can be 0-255 Kevin Cowley R&

Select Binary Field when UTF8 and Collate

e get around this? We're running 4.1.5a gamma and the table encoding is set to utf8. SELECT searchsss FROM searchdata WHERE '$D6@/' BETWEEN key_low AND key_high; Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http:

RE: Can't connect to DB after upgrading to mysql 4.1.5

Claire The Authentication protocols changed with 4.1. If you do a search on the archive this subject has come up several times. Either upgrade your perl interface or make 4.1.5 use the old protocol. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web:

RE: Migrating from Oracle to mySql [online stats]

Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 05 October 2004 16:03 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >

RE: Indexing problem with UTF8 in 4.1.4?

> -Original Message- > From: Harald Fuchs [mailto:[EMAIL PROTECTED] > Sent: 30 September 2004 12:16 > To: [EMAIL PROTECTED] > Subject: Re: Indexing problem with UTF8 in 4.1.4? > > In article > <[EMAIL PROTECTED]>, > Kevin Cowley <[EMAIL PROTECTED]>

RE: Indexing problem with UTF8 in 4.1.4?

Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- > From: gerald_clark [mailto:[EMAIL PROTECTED] > Sent: 29 September 2004 17:29 > To: Kevin Cowley > Cc: [EMAIL PROTECTED] > Subject

Indexing problem with UTF8 in 4.1.4?

characters we get a different error 1170 (BLOB/TEXT column 'dataAddress_Part1' used in key specification without a key length) Can I have an explanation or are these both bugs? Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alch

RE: Mailing Address Deduplication

that uses something like SSA's Name3 matching Technology. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Andrew Kuebler [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 15:04 To: [EMAIL PROT

RE: average in Group By

If buyrate and quantity are per row fields then SELECT symbol, ((sum(buyrate*quantity))/sum(quantity)) as average from portfolio group by symbol; Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message-

RE: Running MySQL and PostgreSQL on the same hardware

Mysql-4.1.1, and Mysql-4.1.2-alpha-nightly. All our partitions are Reiser and the test box in question is a twin processor PIV with Raided 144GB disc on which all the databases sit. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetr

RE: Running MySQL and PostgreSQL on the same hardware

or over a month. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 10:47 To: [EMAIL PROTECTED] Subject: Running MySQL and PostgreSQL o

RE: upgraded hardware: new server is faster, but "GROUP BY" opera tions are slower???

Don't tell me - you upgraded a PIII server to a PIV server? The cache on the PIV is les than half the size of a PIII. We've hit this problem with our own apps that by the way they operate cache a lot of data. A PIII 1.4GHz will match a 2.4 GHz PIV. Kevin Cowley R&D Tel: 0118 90

RE: how do i encrypt the .frm file with a password

Which OS? Doesn't 2000/2000 pro allow you to run a service as one user with similar access restrictions but allow other users to connect to the service? Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Origina

RE: how do i encrypt the .frm file with a password

n't access the table. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: David Crane [mailto:[EMAIL PROTECTED] Sent: 11 May 2004 17:45 To: [EMAIL PROTECTED] Subject: how do i encrypt the .frm fi

RE: Two problems with prepared statements in ver 5.0.0

The documentation is wrong. The API for 5 hasn't been implemented yet - it still uses the 4.1.1/4.1.2 API. See my other posts on performance etc (should be on both the bugs and Mysql lists). I suggest you download the latest 4.1.2 snapshot and work with that. Kevin Cowley R&D Tel:

RE: MySQL Control Center - One quick question...

ltaneously by setting up multiple connection instances. Again the server for each must be running before you can connect to it. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Scott Fletcher [mailto:[EM

Why are compiled queries 50% slower than parsed queries

871 0.525871 150 0.527045 0.527045 160 0.085946 0.085946 170 0.108599 0.108599 180 0.526602 0.526602 190 0.119850 0.119850 Anyone care to shed some light on this? Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web:

RE: Help with a basic question I can't seem to find an answer.

sqld as you. The rest of the admin/user configuration is standard. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: B. Fongo [mailto:[EMAIL PROTECTED] Sent: 29 April 2004 11:45 To: [EMAIL PROTECTED]; [EMAIL PRO