回复： Re: about partition key type

Thank you for your help. I find the following statement from PartitioningRestrictions and Limitations on Partitioning section in the MySQL-5.1 reference manual: A partitioning key must be either an integer column or an expression that resolves to an integer. The column or

Re: revoke SELECT on a column [ MySQL 4.1 ] + column privileges

Hi, The thing is, we cannot dynamically pass columnnames to GRANT or REVOKE statements through procedures from mysql. Hence invoke it through script. like the one: create procedure gg(IN c varchar(20)) BEGIN declare cnt int; declare i int default 1; declare col_name varchar(30);

why not set GLOBAL SQL_SLAVE_SKIP_COUNTER to 2?

Hello,all friends in a master -slave setup ,that's all Ver 14.7 Distrib 4.1.14 I create a test table in master without any records, with auto-increment property. and then,I insert three rows in slave's test table. again ,I return to master,insert the same three rows in test table, in order

Re: A 'Simple' Protocol for Manual MySQL Slave Promotion to Master

Here's another howto on this using keepalived instead: http://www.austintek.com/LVS/LVS-HOWTO/HOWTO/LVS-HOWTO.failover.html#ha_mysql Kishore Jalleda schrieb: HB, MON, IPFail would work well for this , here is some info from my website that I wrote very long ago, hope it helps

Multiple-table UPDATE unexpected result

Dear listmembers On mysql version 4.1.13 I execute a query of this type: UPDATE a LEFT JOIN b ON a.col = b.col SET a.x = a.x + b.y WHERE b.col IS NOT NULL; I expect that column a.x is updated for every match in the join but this is not the case. Table a is updated for the first match only

implementation of SELECT ... ORDER BY RAND() LIMIT 1

2007/2/7, Jos Elkink [EMAIL PROTECTED]: Hi all, I have a question about the combination of RAND and LIMIT 1. If I have a query like: SELECT ... ORDER BY RAND() LIMIT 1 with the ... replaced with a normal query on one table. How is this implemented? Is this optimized for the fact that it only

problem with update innodb table

Hello, I am trying to update two fields of a table that are a composed foreign key to another table. These fields cant be updated with this kind of warning: Warning | 1292 | Truncated incorrect DOUBLE value: 'A05' Both tables are InnoDB and I have tried with all types of constraints, ON UPDATE

Re: problem with update innodb table

Posting you table difinitions and queries would be helpful. Olexandr Melnyk, http://omelnyk.net/ 2007/2/8, Alicia Amadoz [EMAIL PROTECTED]: Hello, I am trying to update two fields of a table that are a composed foreign key to another table. These fields cant

Re: problem with update innodb table

Fortunately I have solved this problem. I think it was something about being a two field composed foreign key and updating these two fields at the same time gave some kind of error. I solve it by adding a temporary row in the referenced table with one of the fields already changed and then

Re: myISAM Max File Size?

Phil Butterworth wrote: Can anyone please tell me what the Max size a myISAM file can grow too? Thanks Best Regards Phil Butterworth mailto:[EMAIL PROTECTED] http://lists.mysql.com/mysql/204119 Funny what google can do for you, wot say? -- MySQL General Mailing List For list

Compiling mysql on Solaris 10

Hi all, I'm having trouble compiling MySql on a Sun Sparc machine with Solaris 10. MySql is 5.0.27 Solaris is sparc.sun.solaris2.10 (64 bits) gcc version 3.4.3 (csl-sol210-3_4-branch+sol_rpath) I've installed zlib-1.2.3, but got no better luck. I'm using to compile: CC=gcc CFLAGS=-O3 -m64 \

Binary distribution of the PBXT pluggable Storage Engine now available

Hi All, I have just posted the first binary distribution of the PrimeBase XT storage engine for MySQL. You can download the package from: http://www.primebase.com/xt To install: 1. Unpack the .tar.gz package. 2. Start your MySQL server. 3. Execute: sudo ./install The installer

function select now()

Hi, I upgrade my mysql server and machine from Conectiva linux 8 and mysql 3.23.57 to Debian 3.1 and mysql 4.1.11 and my program don't work. This program was made in Delphi with zeos component to conect mysql and the program use function select now(). With conectiva 8 and mysql 3.23.57 this

Re: revoke SELECT on a column [ MySQL 4.1 ] + column Comment

Hello, thanks again to ViSolve DB Team. so, it turns out that for MySQL4.1, il will have to built a sql file, built with script (shell or perl). [ note that so far I use MySQL 4.1 on production server, and I only test features on MySQL 5 on an other machine linux Debian]. at last, my LAST

Re: max mysql under windows

Hi Charles, The manual has a few options for running multiple mysql instances on windows. See: http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-servers.html On 2/5/07, Brown, Charles [EMAIL PROTECTED] wrote: Hello All. Is it possible to setup two instances of MySQL under windows? I

Re: INSERT IGNORE BUG?

Hi Ed, Can you please reply with a repeatable test case? On 2/1/07, Ed Pauley II [EMAIL PROTECTED] wrote: I am importing a file into a table in which I want it to ignore duplicate rows. When I specify --ignore (this also happens if I do a SELECT IGNORE INTO from the client also) I get a

Problem with new mysql versions. (They hang)

Hi, I am running relatively complex queries to analyse a dataset. I have query execution times of around half an hour with version 5.27 I tried both version 5.33 and 5.34, and experienced the following: The first few queries ar run faster than with version 5.27, but after a while a query