Good Oracle Forum
This forum has been very helpful. There is always somebody that is willing to respond to queries. Does anybody know of a good Oracle forum? TIA Dan
mysqlconnecernet not closing connections w/2003
I posted this late last Friday. I'm hoping everyone missed it and that someone has an answer. :-) We have a quote server on both a 2003 server and an XP machine. The quote server is an asp.net server. The XP machine is closing the connections without a problem. For some reason the mysqlconnecernet is not closing the connections when used on the 2003 server. It connection count climbs to 100 our maximum connection setting, and then we get a Time out when attempting to get a connection from the pool Has anyone run into this problem? Any help you can give use will be greatly appreciated. TIA Dan
RE: mysqlconnecernet not closing connections w/2003
Robert- I apologize for not being clearer. The operating system is Windows 2003 Server. Dan -Original Message- From: Robert Dunlop [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 3:09 PM To: Daniel Cummings; mysql@lists.mysql.com Subject: Re: mysqlconnecernet not closing connections w/2003 Dan, What is a 2003 server? Do you mean Win2K? I'm not aware of any OS that references 2003. Perhaps that is part of the reason for no response? I don't have any MySQL systems running on Windows machines, so I can't answer your question, but perhaps there are those out there who can, if you ask the right question Bob Dunlop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlconnecernet not closing connections w/2003
We have a quote server on both a 2003 server and an XP machine. The quote server is an asp.net server. The XP machine is closing the connections without a problem. For some reason the mysqlconnecernet is not closing the connections when used on the 2003 server. It connection count climbs to 100 our maximum connection setting, and then we get a Time out when attempting to get a connection from the pool Has anyone run into this problem? Any help you can give use will be greatly appreciated. TIA Dan
Insert Delayed
Does Insert Delayed work on any version of MySql for INNODB tables? The docs state that it does but I keep getting the error that the engine doesn't support this. TIA Dan
speed issue - inserts slowing down selects
We have what is called a data grabber for quotes that is inserting rows into both InnoDb and MyIsam tables. When the data is being imported ( inserted ), it is dramatically slowing clients down that are running queries against the table. Our first attempt at a solution was to insert one row at a time. This doesn't seem to make a difference. The next thing we tried is the Insert Delayed which as I stated in an earlier post, doesn't seem to work for InnoDb tables. We are also looking at Insert Low_Priority. Does anyone have any suggestions? TIA Dan
RE: Insert Delayed
Thanks for verifying that. Dan -Original Message- From: John McCaskey [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 12:23 PM To: Daniel Cummings Cc: [EMAIL PROTECTED] Subject: Re: Insert Delayed I verified the same error for myself, and then found: http://bugs.mysql.com/bug.php?id=5777 Sounds like the documentation is just wrong, and it is not supported for innodb period. John On Wed, 2004-10-13 at 11:53 -0700, Daniel Cummings wrote: Does Insert Delayed work on any version of MySql for INNODB tables? The docs state that it does but I keep getting the error that the engine doesn't support this. TIA Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need to store a Guid as an Id
MySql doesn't support Guids but we were attempting to use a VarChar. We set the VarChar to binary, but from what I'm reading the binary setting doesn't affect storage just sorting and evaluations. I was able to get the binary storate I needed in a TinyBlob but I can't set this to a primary key. Is there a work around for this? TIA Dan
Show Index Into Cursor?
Is there a way to force the results of Show Index From table Into a table? TIA Dan
RE: Show Index Into Cursor?
Victor, Natively you can't do this? With SqlPassthrough into FoxPro it returns a cursor but I was hoping to store it into a temporary table on the Backend (MySql) because the access code is so much cleaner. Dan -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 11:35 AM To: 'Daniel Cummings '; '[EMAIL PROTECTED] ' Subject: RE: Show Index Into Cursor? You will have to put the value in a resultset and scroll through the resultset. Natively you can do this with MySQL 4.0.x but you could use a programming language. -Original Message- From: Daniel Cummings To: [EMAIL PROTECTED] Sent: 7/16/04 1:19 PM Subject: Show Index Into Cursor? Is there a way to force the results of Show Index From table Into a table? TIA Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Get Updated Rows
Is there a way of getting the number of updated rows without using the API calls? TIA Dan
RE: Comparisons Through VFP not working properly
Shawn- Thanks for responding. The field UserId is Int and its length is 11. I could try different types of INTs. In reference to this comment I used the following code. I created a table from the parameter and it stored it in a table as a double. Create Table ChkValues Select ?pnUserId From Roles This was just to determine how MySql was translating the parameter. It turned out to be a double in this new table. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 7:00 AM To: Daniel Cummings Cc: [EMAIL PROTECTED] Subject: Re: Comparisons Through VFP not working properly I would change the storage type on the table to an int and see how your pass-through works then. Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Daniel Cummings [EMAIL PROTECTED] wrote on 07/14/2004 09:08:55 PM: I'm using SqlPassthrough In VFP 8.0 Ive got a Sql statement that looks like this. This following fails: Update User Set Active = True Where UserId = ?pnUserId pnUserId is 222 in this instance. The following works fine: Update User Set Active = True Where UserId = 222 The workaround is to cast the parameter ?pnUSerId to a signed integer but I'm trying to understand why this is happening. I created a table from the parameter and it stored it in a table as a double. It's probably storing it as 221.998 which is why the comparison is failing. Has anyone seen this behavior? TIA Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Comparisons Through VFP not working properly
I'm using SqlPassthrough In VFP 8.0 Ive got a Sql statement that looks like this. This following fails: Update User Set Active = True Where UserId = ?pnUserId pnUserId is 222 in this instance. The following works fine: Update User Set Active = True Where UserId = 222 The workaround is to cast the parameter ?pnUSerId to a signed integer but I'm trying to understand why this is happening. I created a table from the parameter and it stored it in a table as a double. It's probably storing it as 221.998 which is why the comparison is failing. Has anyone seen this behavior? TIA Dan
RE: Understanding Explain in 4.1
Victor- It's a little misleading. It looks like it's going to do a full table scan of the Monday table. Dan -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 6:18 AM To: 'Daniel Cummings '; '[EMAIL PROTECTED] ' Subject: RE: Understanding Explain in 4.1 It does not have to use an index because you have not supplied row restriction criteria. An index is being used to relate the two tables. -Original Message- From: Daniel Cummings To: [EMAIL PROTECTED] Sent: 5/24/04 6:05 PM Subject: Understanding Explain in 4.1 These are two simple stock quotes tables that contain a symbol and a close amount. Explain Select Monday.Symbol, Friday.Close, Monday.Close From Monday Force Index(Symbol) Inner Join Friday Force Index(Symbol) ON Monday.Symbol = Friday.Symbol Symbol is a VarChar(20) in both tables. There is an index on Symbol for both of these table. The resultant Explain shows that +--+--+-++-+ ---+---+-+ | table | type | possible_keys | key | key_len | ref | rows| Extra | +--+--+-++-+ ---+---+-+ | Monday | All| Symbol | [Null] | [Null] | [Null] | 60134| | +--+--+-++-+ ---+---+-+ | Friday | ref | Symbol | Symbol| 21| Monday.Symbol |1| where used | +--+--+-++-+ ---+---+-+ Why aren't both using the Symbol key? Why isn't the Force Index working? TIA Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Understanding Explain in 4.1
These are two simple stock quotes tables that contain a symbol and a close amount. Explain Select Monday.Symbol, Friday.Close, Monday.Close From Monday Force Index(Symbol) Inner Join Friday Force Index(Symbol) ON Monday.Symbol = Friday.Symbol Symbol is a VarChar(20) in both tables. There is an index on Symbol for both of these table. The resultant Explain shows that +--+--+-++-+ ---+---+-+ | table | type | possible_keys | key | key_len |ref | rows| Extra | +--+--+-++-+ ---+---+-+ | Monday | All| Symbol | [Null] | [Null] | [Null] | 60134| | +--+--+-++-+ ---+---+-+ | Friday | ref | Symbol | Symbol| 21| Monday.Symbol |1| where used | +--+--+-++-+ ---+---+-+ Why aren't both using the Symbol key? Why isn't the Force Index working? TIA Dan
Heap table limitations
We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from InnoDb to MyIsam table but converting to a heap table would give an even bigger performance boost. Does making a heap file this large make any sense? Are there size limitations to heap tables? TIA Dan
Multi-threading problems in MySql
We have one query which takes approximately 2 minutes. MySql seems to be unresponsive to any other threads until this query has completed. Are there some settings that aid with this kind of problem? TIA Dan