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 lib

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

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 monit

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 cou

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

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 1

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: [EMA

RE: Dumping mass inserts?

-- > From: Michael McTernan > Sent: 09 April 2004 18:30 > To: James E Hicks III; [EMAIL PROTECTED] > Subject: Re: Dumping mass inserts? > > > >> Ah..I see now. I was still using mysqldump..instead of mysql. Yes I'm > >> trying to import the data from backup, int

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

RE: MySQL4 and phpBB

Original 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. > > No

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 > &g

RE: DROP TEMPORARY TABLE and implicit commits

004 13:00 > To: Mysql > Subject: Re: DROP TEMPORARY TABLE and implicit commits > > > Michael, > > - Alkuperäinen viesti - > Lähettäjä: "Michael McTernan" <[EMAIL PROTECTED]> > Vastaanottaja: "Mysql" <[EMAIL PROTECTED]> > Kopio:

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, > > Ma

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 FOREIGN_KEY_CHECKS

RE: Gripe with MySQL

database... again. I don't see why you object to making things easier 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: 'Mi

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 > -Origina

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

is in the past too. I'll be looking out for slow queries in the logs and then EXPLAINing them to see where I can make 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- &

RE: InnoDb Table Performance problem

partitioning between the tables on disk. I'm guessing that the real problem here is that some of my queries are secretly doing table scans when they shouldn't, and that is causing a huge slowdown, although I might split the BLOB column into a different table such that table scans don

RE: InnoDb Table Performance problem

Original Message- > From: Benoit St-Jean [mailto:[EMAIL PROTECTED] > Sent: 12 February 2004 14:04 > To: Michael McTernan > Cc: Mysql > Subject: Re: InnoDb Table Performance problem > > > Michael McTernan wrote: > > >Hi, > > > > > > > >

RE: InnoDb Table Performance problem

doesn't impact tablescan 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 &

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 da

RE: best-practices backups

[mailto:[EMAIL PROTECTED] > Sent: 11 February 2004 19:27 > To: 'Michael McTernan'; Michael Collins > Cc: [EMAIL PROTECTED] > Subject: RE: best-practices backups > > > > > -Original Message- > > > From: Michael Collins [mailto:[EMAIL PROTECTED]

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 > -Ori

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 |

RE: LOCK TABLES and multi table UPDATE

ion, but I've certainly learnt 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 > &

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 |

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 when

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 slash

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 L

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:[EMAI

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

RE: DROP TEMORARY TABLE

EMAIL PROTECTED] > Sent: 28 October 2003 15:54 > To: mysql > Cc: MySQL Java > 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 To

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

Original Message- > From: 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 dropp

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 interfe

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 DROP