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

the version on the database, edit the .txt to add the MAX_ROWS parameter to the create statement and then re-import. Changing the table using the ALTER TABLE command will take forever. Full details of the MAX_ROWS parameter can be found in the manual under the CREATE TABLE command. Kevin Cowley Product

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) Web

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 DATA

RE: table join question

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- From: Rob Brooks [mailto:[EMAIL

RE: MySql error...

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] Sent: 08 March 2005 16:44 To: 'mel

RE: MySql error...

/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 [mailto

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 9099

RE: Join Limits

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 Bergen [mailto:[EMAIL

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

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http

RE: Two versions of MySQL on same machine

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk

RE: Two versions of MySQL on same machine

the mysqld_safe version that corresponds to the version you want. Kevin Cowley RD 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 To: 'mysql

RE: Two versions of MySQL on same machine

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL

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','Y','Y','Y'),. .. Kevin Cowley RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http

RE: Character Sets, 4.0 and 4.1

/export. Kevin Cowley RD 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 14:55 To: mysql@lists.mysql.com Subject: Character Sets, 4.0 and 4.1 So

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk Fabforce's DBDesigner 4 is fantastic

RE: mydb-bin.xxx files

Kevin Cowley RD 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 RESET MASTER - it clears and deletes

RE: server performance

instance is heavily loaded. Kevin Cowley RD 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 January 2005 19:10 To: mysql@lists.mysql.com Subject: server performance

Specifying location of .my.cnf to load_defaults

file (defaults to $HOME/.my.cnf). Kevin Cowley RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds

RE: Specifying location of .my.cnf to 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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Jigal van

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Steve Bacher

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk

return from load_defaults when .my.cnf not found

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

Column restrictions in 4.1.x from 3.23.52

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

RE: 2 ways Replication in MySQL

into the project we had the basic replication engine working but none of the conflict resolution stuff. Kevin Cowley RD 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 read-only

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 RD Tel: 0118 902 9099 (direct line) Email

RE: Select Binary Field when UTF8 and Collate

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL

Select Binary Field when UTF8 and Collate

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk

RE: Migrating from Oracle to mySql [online stats]

Kevin Cowley RD 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] Subject: RE: Migrating from

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http

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] writes: If I knew why I wouldn't be asking. Now

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk

RE: Indexing problem with UTF8 in 4.1.4?

Kevin Cowley RD 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: Re: Indexing problem

RE: Mailing Address Deduplication

that uses something like SSA's Name3 matching Technology. Kevin Cowley RD 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 PROTECTED] Subject

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From

RE: Running MySQL and PostgreSQL on the same hardware

a month. Kevin Cowley RD 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 on the same

RE: Running MySQL and PostgreSQL on the same hardware

-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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original

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 RD Tel: 0118 902 9099 (direct

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

. Kevin Cowley RD 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 file with a password I need

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From

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 RD Tel: 0118 902 9099

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

connection instances. Again the server for each must be running before you can connect to it. Kevin Cowley RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -Original Message- From: Scott Fletcher [mailto:[EMAIL PROTECTED] Sent: 05 May 2004

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

to start the mysqld as you. The rest of the admin/user configuration is standard. Kevin Cowley RD 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

Why are compiled queries 50% slower than parsed queries

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 RD Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk