RE: MySQL 5.0 creates 100,000 Window handles

You left in extreme tests. I would like to be able to answer that if it were so problematic, it would have gone up for a long time in a list of the known limits. But I do not know. It seems that if you're really falling in this extreme case (many many very small different queries in a big

RE: MySQL 5.0 creates 100,000 Window handles

Geoffroy, Thanks for the reply. Of course by now I figured out what's causing the large # of handles being allocated by Windoze XP. It's the query cache. Each query that gets added to the query cache uses 2 handles. If the query cache is large, say 150MB, as the cache fills up more and m

RE: mysql old 4.* query fails on 5.*

Hi, See 5.0 JOIN syntax at http://dev.mysql.com/doc/refman/5.0/fr/join.html Example: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id Regards, Geoffroy -Message d'origine- De : Gmail User [mailto:[EMAIL PROTECTED] Envoyé : samedi 2 juin 2007 22:55 À : mysql@lists.mys

Re: mysql old 4.* query fails on 5.*

> Anyone know whats wrong here? Try as ... >From (Klienter AS K, Tid As Td, Personal AS P) JOIN Uppdrag AS U ON K.Klient_ID = U.Klient_ID ... or ... >From Tid As Td, Personal AS P, Klienter AS K JOIN Uppdrag AS U ON K.Klient_ID = U.Klient_ID ... This is the problem I had in one of my queries

Re: high physical and buffer reads.

Hi, I never heard about an Oracle's counter named HIGH PHYISCAL. But if you think about "Scattered Read" / "Sequential Read" / " buffer busy waits", You can begin by reading this article: http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html Geoffroy. 2007/6/2, Baron Schwar

RE: MySQL 5.0 creates 100,000 Window handles

Hi, In fact, this is a good question. Therefore, I gonna try to answer. > 1) What is MySQL using the handles for? Handles are nothing and all on Windows. Nothing because they are only pointers to hidden internal struct. And all, because, Handle are everywhere if you try to develop Win32 App. Ther

Re: Exporting blob / text column with hyphen delimited text

Hi, SenTnel wrote: Hi all! I have a table that contains a column (blob, text type, formatted as MEDIUMTEXT) with text hyphen (-) delimited, listing rooms by numbers, and I need to export or insert that data into another table, where all other info on the other columns remains the same, but I

Re: Using the last_insert_id() function

Hi, gwh wrote: Hi everyone, I¹m trying to figure out the best sequence to enter data into my database (the SQL code for the structure is included below). If I have a number of tab delimited .txt files containing the data for the different tables, I thought as a first step I could use the follow

Re: high physical and buffer reads.

Hi, Ananda Kumar wrote: Hi All, Is it possible for us to know if a sql is doing HIGH PHYISCAL or BUFFER READS in mysql, something we can do in ORACLE. Just wanted to know, for the sake of sql tuning. I am no Oracle expert, so I'm not sure I know exactly what you mean. However, MySQL does exp

high physical and buffer reads.

Hi All, Is it possible for us to know if a sql is doing HIGH PHYISCAL or BUFFER READS in mysql, something we can do in ORACLE. Just wanted to know, for the sake of sql tuning. regards anandkl