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 local. Is there any way to accomplish something similar in MySQL? I'd love to be able to create a view that joins data from my local tables with that from SQL_Server. -- James Card 209-578-5580 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 mySQL parameters: -- long_query_time current value: 10 -- However, there are tons of lines like this one: -- # [EMAIL PROTECTED]: root[root] @ localhost [] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 20 This is not a slow query, is it? On 10/4/07, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote: On Thursday 04 October 2007 14:06, thomas Armstrong wrote: 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 restart. If I comment the second line, it works ok. Try to remove the spaces in the two lines. If my memory is correct, I had the same problem some time ago and it went away when removing the spaces. -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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] @ localhost [] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 20 This is not a slow query, is it? On 10/4/07, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote: > On Thursday 04 October 2007 14:06, thomas Armstrong wrote: > > 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 restart. If I comment the second line, it works ok. > > Try to remove the spaces in the two lines. If my memory is correct, I had the > same problem some time ago and it went away when removing the spaces. > > -- > Jørn Dahl-Stamnes > homepage: http://www.dahl-stamnes.net/dahls/ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 you!
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, > > thanks a lot, > > Albert > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 broken Support Ticket system. Anywhere, here's my question. I'm hoping that someone out there uses the MySQL Manager 2007 tool in Windows to visually manager their MySQL Databases, and can answer this question. When I'm typing in a query, it is constantly annoying me by popping up function, table, or field suggestions as I type. I have to constantly press the escape key to get rid of the box. Is there some way to turn this "feature" off that anyone's aware of? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 restart. If I comment the second line, it works ok. > > Does anybody know how to set the slow queries time? Thank you very much. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 restart. If I comment the second line, it works ok. Does anybody know how to set the slow queries time? Thank you very much. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 Next Company Is it possible to re-write this routine so that it executes quicker ? Thanks,Neil _ Get free emoticon packs and customisation from Windows Live. http://www.pimpmylive.co.uk This email is confidential and may also be privileged. If you are not the intended recipient please notify us immediately by telephoning +44 (0)20 7452 5300 or email [EMAIL PROTECTED] You should not copy it or use it for any purpose nor disclose its contents to any other person. Touch Local cannot accept liability for statements made which are clearly the sender's own and are not made on behalf of the firm. Touch Local Limited Registered Number: 2885607 VAT Number: GB896112114 Cardinal Tower, 12 Farringdon Road, London EC1M 3NN +44 (0)20 7452 5300 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Next Company Is it possible to re-write this routine so that it executes quicker ? Thanks,Neil _ Get free emoticon packs and customisation from Windows Live. http://www.pimpmylive.co.uk
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 what the
returned insert id is for each of an arbitrary amount of single-line
inserts.
Defining what I am calling single line insets, I mean:
INSERT INTO foo (a, b, c) VALUES ('x', 'y', 'x'), ('x', 'y', 'x'), ('x',
'y', 'x'), etc etc
I know of no way to do this.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 in "group by" query. Try this: http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.musicmashup.co.uk
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 you! -- Best regards, Miroslav Monkevic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 servers starts throwing "Out > of > memory; check if mysqld or some other process uses all available memory;" > error. The error goes once we restart MySQL. But after a week again the > same > problem occurs. We have 4 GB of physical memory on the server but Mysql > utilizes only up to 2.5 GB & starts throwing Out of memory error > > Please help me to resolve this. >
