Connect To Foreign Tables

The application I'm working on uses MySQL 5.0.41 and we also need to retrieve some data from a SQL-Server database in another department. SQL-Server has a feature (that I haven't tested) that allows it to make an ODBC connection to a foreign database and treat its tables as if they were loc

Re: How to change "long_query_time" with mySql 3.23

I wouldn't be surprised if this feature is broken in 3.23. You said you installed it yourself. Can you possibly upgrade to 4.1 instead? thomas Armstrong wrote: It looks like mySQL is taking ok the "long_query_time" value by using set-variable=long_query_time=5 If I display

Re: How to change "long_query_time" with mySql 3.23

It looks like mySQL is taking ok the "long_query_time" value by using set-variable=long_query_time=5 If I display mySQL parameters: -- long_query_time current value: 10 -- However, there are tons of lines like this one: -- # [EMAIL PROTECTED]: root[root] @ loca

Re: LIMIT within GROUP BY

Miroslav >My goal is to sum 7 greatest results for each person. Have a look at 'Within-group quotas (Top N per group)' at http://www.artfulsoftware.com/infotree/queries.php. PB - Miroslav Monkevic wrote: Hello, MySQL 4.1 I have query: SELECT SUM(points) as ranking FROM results GROUP

access privileges

Hi All, Today I installed mysql for debian OS. After the installation, i started mysql using mysqld_safe &. Now if i try to connect to mysql using "mysql -uroot -p", it fails, but if i use "-habc" it works. Do i need to set some parameters or give privileges, please let me know. regards anandkl

Re: connections limit

It is set in mysql's config file. Have you traced into your program? Albert Sanchez: > Is there a limit of connections (open and close) that mysql can carry? or a > limit by second? > > I have a big memory crash (double free or corruption) in my program and I > smell that it could be mysql, > >

MySQL Manager Issue

Sorry for posting this here, but 1) I didn't see a 3rd party MySQL list, and 2) I tried several times to post a support ticket on the SQLManager.net site, and it simply would not save my ticket. There doesn't seem to be any other way to request support from them either, except through their brok

Re: How to change "long_query_time" with mySql 3.23

I also tried with: --- set-variable=long_query_time=5 -- mySQL starts ok, but all queries within the file are: # Query_time: 0 Lock_time: 0 Rows_sent: 119 Rows_examined: 238 The aren't slow queries, are they? On 10/4/07, thomas Armstrong <[EMAIL PROTECTED]> wrote: > Hi. > > I'm sufferi

How to change "long_query_time" with mySql 3.23

Hi. I'm suffering a severe slowness of my server (mySQL 3.23), and want to detect Slow Queries. I installed mySQL on '/usr/local/mysql', and works ok. But if I insert this line into '/etc/my.cnf': - log-slow-queries = /usr/local/mysql/log/slow-queries.log long_query_time = 5 - it won't re

RE: Speeding Up Process

"For Each" is always best avoided, think set based! Might be better if you could forward your SQL. Rhys -Original Message- From: Neil Tompkins [mailto:[EMAIL PROTECTED] Sent: 04 October 2007 12:19 To: My SQL Subject: Speeding Up Process Hi I've the following process/queries which I wa

Speeding Up Process

Hi I've the following process/queries which I want to speed up, for a product inventory/warehouse which we have a number of items available to sell each day For Each Company For Each Product For Next 7 Days CheckQuantityUpdateQuantity Next Day Next Product Nex

Re: single line inserts with on duplicate key

Scott Haneda wrote: Is it possible, in single-line inserts, with on duplicate key clauses, to get back a list of last insert id's for what was inserted? I get strange results, just one single insert id, which makes sense from the perspective of what was just inserted, however, I need to know wha

connections limit

Is there a limit of connections (open and close) that mysql can carry? or a limit by second? I have a big memory crash (double free or corruption) in my program and I smell that it could be mysql, thanks a lot, Albert

Re: LIMIT within GROUP BY

Hi, Miroslav Monkevic wrote: Hello, MySQL 4.1 I have query: SELECT SUM(points) as ranking FROM results GROUP BY person_id ORDER BY ranking DESC My goal is to sum 7 greatest results for each person. In more general, my question is: is there a way to limit number of records within groups i

Hotel availability system

Hi I'm looking to design a hotel reservation/availability system to be used online. Has anyone had any experience with regards table / database design ? Thanks Neil _ 100’s of Music vouchers to be won with MSN Music https://www.mus

LIMIT within GROUP BY

Hello, MySQL 4.1 I have query: SELECT SUM(points) as ranking FROM results GROUP BY person_id ORDER BY ranking DESC My goal is to sum 7 greatest results for each person. In more general, my question is: is there a way to limit number of records within groups in "group by" query. Thank yo

Re: “Out of memory; check if mysqld or some other process uses all available memory;” error

Hi, Configure my.cnf in such a way so that it uses 3.5 GB of physical memory. Please check max_connecions. Out of memory problem also occur due to lots of connections Thanks Krishna On 9/27/07, Amarnath Shivashankar <[EMAIL PROTECTED]> wrote: > > We have found that the MYSQL on all Email DB serv