RE: Need to store a Guid as an Id

Hi, I was able to get the binary storate I needed in a TinyBlob but I can't set this to a primary key. Can be done: mysql CREATE TABLE tb - ( - id TINYBLOB NOT NULL, - PRIMARY KEY (id(255)) - ); Query OK, 0 rows affected (0.00 sec) You need to say how many chars you want

RE: Upgrading MySQL. Caveats or Cautions anyone?

Hi, I found that the Intel C++ version needed some libraries which weren't on my RH9.0 system (this was when upgrading to 4.1.4g): libcprts.so.5 libcxa.so.5 libunwind.so.5 This seems to have been reported many times e.g. http://bugs.mysql.com/bug.php?id=4408 The resolve was to get the

DELETE IGNORE fails for foreign key references with InnoDb

Hi there, I'm finding that DELETE IGNORE doesn't actually ignore all errors when using InnoDb and trying to remove rows that would result in a foreign key error. I've checked the docs and think that what I'm doing should work, but doesn't - I'm using server 4.1.4-gamma: Welcome to the MySQL

RE: DROP TEMPORARY TABLE and implicit commits

Subject: Re: DROP TEMPORARY TABLE and implicit commits Michael, - Alkuperäinen viesti - Lähettäjä: Michael McTernan [EMAIL PROTECTED] Vastaanottaja: Mysql [EMAIL PROTECTED] Kopio: [EMAIL PROTECTED] Lähetetty: Monday, June 14, 2004 9:40 PM Aihe: DROP TEMPORARY TABLE and implicit

RE: Mysqld stalls

Dear Mark, You should be tweaking your mailer such that your mails originate fom [EMAIL PROTECTED], and not my own email address. Thanks, Mike -Original Message- From: Michael McTernan Sent: 27 May 2004 10:00 To: [EMAIL PROTECTED] Subject: Mysqld stalls I've been trying to fine

RE: MySQL4 and phpBB

Message- From: Michael McTernan Sent: 19 April 2004 10:22 To: [EMAIL PROTECTED] Subject: MySQL4 and phpBB I have recently setup a new server running EnsimPro 3.7 (Fedora) and upgraded the MySQL to 4.0.17-max per their tech notes. Now, I'm having troubles with tables related to my most

RE: PHP + MySQL Not Playing Nice Any More

Dear Mark, Please set your from address to [EMAIL PROTECTED], and don't use my email address. Thanks, Mike -Original Message- From: Michael McTernan Sent: 16 April 2004 10:21 To: Joseph A. Nagy, Jr.; MySQL General Subject: Re: PHP + MySQL Not Playing Nice Any More On 4/15/04 11

RE: Dumping mass inserts?

Dear Mark, And when I go to move them to the new db, I do use the mysqldump command since I am dumping to the new db? You need to correctly setup your mailer such that the from address is [EMAIL PROTECTED], and not my email address. Thanks, Mike -Original Message- From: Michael

RE: Corruption and my.cnf

Dear Mark, I think your emailer has also experienced corruption since your from address is actually mine. Please set it to your own email address, such as [EMAIL PROTECTED] Thanks, Mike -Original Message- From: Michael McTernan Sent: 09 April 2004 12:18 To: [EMAIL PROTECTED

RE: Using PHP to copy tables

Dear Mark, You also seem to have used my email address before. Please correctly configure your mailer such that the from address is correctly reported as [EMAIL PROTECTED], and not mine. Thanks, Mike -Original Message- From: Michael McTernan Sent: 08 April 2004 18:36 To: [EMAIL

RE: Too Many Connections

Dear Mark, The best way to fix this is by correctly setting your from address in your mailer to [EMAIL PROTECTED] Thanks, Mike -Original Message- From: Michael McTernan Sent: 08 April 2004 10:33 To: [EMAIL PROTECTED] Subject: Too Many Connections What is the best way

RE: GROUP BY across UNION

Hi John, Depending on the size of your datasets, you could merge the data into a TEMPORARY table and then compute from there? If the temp table is small enough it will fit in RAM as a heap table, and will probably be more efficient than fetching all the results and computing them in code. Of

DROP TEMPORARY TABLE and implicit commits

Hi there, I'm using MySQL 4.0.18 and finding that DROP TEMPORARY TABLE is performing an implicit commit, as is documented. The problem is that I have a complex query in a Java function, and I need to call it a number of times to get the overall, which I also want to do as a single transaction so

RE: Error dropping databases [in InnoDb]

Many Thanks :) Mike -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: 30 April 2004 11:56 To: Michael McTernan; Tom O'Neil Cc: [EMAIL PROTECTED] Subject: Re: Error dropping databases [in InnoDb] Michael, Marko has fixed this to 4.0.19. Best regards

RE: Error dropping databases [in InnoDb]

Hi, I have found this too. I think it is as a result of a change introduced in 4.0.18. From http://www.innodb.com/ibman.php#InnoDB.history : MySQL/InnoDB-4.0.18, February 13, 2004 - Do not allow dropping a table referenced by a FOREIGN KEY constraint, unless the user does SET

RE: Gripe with MySQL

Hi, ENUM columns can also trip you up if you insert a value outside of the ENUM; an empty string is inserted instead. This is documented behaviour (mysql.com seems to be going slowly though, so can't dig a reference right now), even if it is undesired in some cases. Thanks, Mike

RE: Gripe with MySQL

to use, even if it is only activated by a -n00b option in mysql_safe. Thanks, Mike -Original Message- From: Donny Simonton [mailto:[EMAIL PROTECTED] Sent: 20 April 2004 17:37 To: 'Michael McTernan'; 'Stormblade' Cc: [EMAIL PROTECTED] Subject: RE: Gripe with MySQL Everybody should

RE: Multiple concurrent transactions per connection

Hi there, Given this model, each thread is obviously going to want to have multiple transactions outstanding. Is this something that might be added to MySQL in future or am I totally overestimating the expense of using one thread per connection? I'm guessing you mean that each thread will

RE: InnoDb Table Performance problem

performance. Is this wrong? Or is this different for InnoDB vs MyISAM? Of course, I'm aiming not to use table scans at all though :) Thanks, Mike -Original Message- From: Benoit St-Jean [mailto:[EMAIL PROTECTED] Sent: 11 February 2004 22:47 To: Michael McTernan Cc: Mysql Subject

RE: InnoDb Table Performance problem

PROTECTED] Sent: 12 February 2004 14:04 To: Michael McTernan Cc: Mysql Subject: Re: InnoDb Table Performance problem Michael McTernan wrote: Hi, SELECT COUNT(*) for InnoDB tables is a know problem... The table handler (for InnoDB) has to do a table scan to count all rows

RE: InnoDb Table Performance problem

. Thanks, Mike -Original Message- From: Chris Nolan [mailto:[EMAIL PROTECTED] Sent: 12 February 2004 12:23 To: Michael McTernan Cc: Benoit St-Jean; Mysql Subject: Re: InnoDb Table Performance problem Michael McTernan wrote: Hi, SELECT COUNT(*) for InnoDB tables is a know

RE: InnoDb Table Performance problem

this improvement. Thankyou for all your help. While there is no simple solution, I'm a lot more sure of my options now :) Cheers, Mike -Original Message- From: Chris Nolan [mailto:[EMAIL PROTECTED] Sent: 12 February 2004 17:28 To: Michael McTernan Cc: Mysql; Benoit St-Jean

RE: best-practices backups

Hi, I'd love to see this too. Even if it was a book that cost ?40 to buy, I'd get a copy. Hey, maybe someone can recommend a book - I've looked hard and not really come up with anything better than the MySQL manual, which while great, is missing the 'best practices' :( Thanks, Mike

RE: best-practices backups

2004 19:27 To: 'Michael McTernan'; Michael Collins Cc: [EMAIL PROTECTED] Subject: RE: best-practices backups -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED] Is there any best-practices wisdom on what is the most preferable method of backing up moderately

InnoDb Table Performance problem

Hi there, I'm making something similar to a file revision control system, and using MySQL on Linux as the database to drive it. Almost all my tables are InnoDB, and generally it is going very well, with the exception of one table that is always very slow. This table holds the files within the

Removing sub-query

Hi there, I'm using MySQL 4.0.15 on RedHat 9.0. I've got problem for which I can't figure out how to do it efficiently without using a subquery. 4.1.0 isn't really an option since this is going into a stable environment. The table is like this. +--+--++ | revision | id |

LOCK TABLES and multi table UPDATE

Hi there, I've got a small issue which looks a little like a bug. I'm using MySQL 4.0.15-standard-log, on RedHat 9.0 with InnoDb tables. Essentially I have two tables, one table is a list of integers, while the second is a table of integer pairs. e.g. +---+ +-+-+ | A | | B.x | B.y

RE: LOCK TABLES and multi table UPDATE

something now :) Thanks, Mike -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 22 January 2004 16:38 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: LOCK TABLES and multi table UPDATE Michael McTernan said: I'm using MySQL 4.0.15-standard-log

Access rules for users from specific hosts

Hi there, I'm seeing some problems with the way I've granted access to different users. I've setup the server to allow access only from certain clients. For example, the backup user is only allowed access from some machines: GRANT SELECT ON testdb.* TO [EMAIL PROTECTED] The problem is that

RE: Backslash and full text searches

Hi there, I had a similar problem wanting to match 'words' like 42.3.1.1 as technical references. I couldn't get them to match using a fulltext index, I assume because the full stops are used by the parser in MySql to break the text into words for indexing - maybe this is the same for the

RE: maintaining size of a db

From the manual: 1.8.4.1 Subqueries Subqueries are supported in MySQL version 4.1. See section 1.6.1 Features Available in MySQL 4.1. Hope that helps, Mike -Original Message- From: Scott H [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 17:45 To: Dan Greene; MySQL Mailing List

RE: max_user_connections problem after upgrading

Hi, Have you tried netstat -a on the box with the MySQL server? This command (Linux) will show what is connected to where, and will help you double check that there really aren't any open connections to the server. Thanks, Mike -Original Message- From: Henrik Skotth [mailto:[EMAIL

RE: Viruses from the list

Hi, Since joining the list I'm getting about 6 virus emails a day. Fortunately the firewall is stripping them for me and just sending me alerts telling me the virus and the sender of the mail e.g. The message senders were [EMAIL PROTECTED] [EMAIL PROTECTED] The message title was latest

RE: Multiuser Programming

hi, -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: 30 October 2003 01:14 To: [EMAIL PROTECTED] Subject: RE: Multiuser Programming Chris said: I'm not familiar with that function in MS SQL, and you're a bit unclear, but it looks like you might be

RE: php temp table question

Hi Larry, I was wondering a similar thing, but for JDBC using connection pooling. In your example you say that 2 people will hit the script at the same time; if they are using independent connections this should cause no problems since TEMPORARY tables are local to the connection so don't

RE: DROP TEMORARY TABLE

: Steve Buehler [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 11:37 To: Michael McTernan; mysql Subject: Re: DROP TEMORARY TABLE TEMPORARY TABLES are suppose to work this way. They are only there during a connection and then dropped when the connection to the database is closed. One thing

RE: Foreigner keys in MySQL?

Hi, If you mean foreign key constraints, it's available with InnoDb tables under MySQL, as are atomic transactions (commit and rollback). I'm using this with MySQL4.0 and it works a treat :) Thanks, Mike -Original Message- From: Juliana Gubert Ehrensperger [mailto:[EMAIL PROTECTED]

RE: DROP TEMORARY TABLE

Subject: Re: DROP TEMORARY TABLE Michael McTernan wrote: My problem, that so far no one has been able to answer, is that I'm using connection pooling with the Tomcat server. TransactionA gets connection A from the pool. TransactionA creates a temporary table for some query

DROP TEMORARY TABLE

Hi there, I'm trying to restrict the access that a Tomcat server has to mysql 4.0.15-standard-log database server. Unfortunately some of the queries use temporary tables, so I've had to GRANT CREATE TEMPORARY TABLES to the user. However, since the server is using connection pooling, it also