tags:

views:

13

answers:

1
Q: 

Mysql client ran out of memory

Hi,

When i try to combine 3 tables having 50K records and write a MySQL select query:

I get "mysql client ran out of memory"

Any help on how to overcome this will be highly appreciated.

Thanks

A: 

What client do you use? For mysql you can try running it with --quick option

a1ex07  2010-07-26 18:00:52
Thanks, can it be used with a select statement? am not able to use it correctly.
Sharpeye500  2010-07-26 18:12:56
When you run mysql client, instead of typing "mysql" in command line, type "mysql --quick".
a1ex07  2010-07-26 18:19:23
Ok thanks, but am running through sql yog.
Sharpeye500  2010-07-26 18:24:28

related questions

Updating a table within a select statement
How do I make an expression inside a select statement without it being returned as column?
Updating multiple rows with a value calculated from another column
How to perform grouped ranking in MySQL
MySql : UNION is not getting executed when executed as a view
MySql Union not getting executed in a view
Removing an Appended " In front of Every Column
Best way to prevent a value from going negative in mysql
Copy MySQL structure across servers via PHP
How can I query from 2 dates ranges (mysql)
MySQL function to insert record if update fails?
Rather difficult mySQL problem ...
PHP / MySql Verbosity VS over the wire
SQL to search and replace in mySQL
How to Avoid Throwing An Error When SQL Select Returns Nothing
MySQL permissions issue - should be non-issue
mysql stored procedure question
Mysql efficient "select id else insert" query
MySQL - A difficult INSERT...SELECT on the same table [MySQL 5.051]
Can I concatenate multiple MySQL rows into one field?
search question
Checking if mysql_query returned anything or not
How can I create a MySQL JOIN query for only selecting the rows in one table where a certain number of references to that row exist in another table?
MySQL Query: LIMITing a JOIN
Multiple Updates in MySQL