Re: +1MB query gets "Out of memory"

Hi, Hope query_cache does not relate with the error. Because, if the query is larger than the query_cache size, automatically that will not be cached. So that query, on executing any no of times, will never utilize the cache. Also as of our understanding, packet_size does not produce out of me

mysql_pconnect() made things worse

I have many sites accessing one MySQL server, all using the same IP, username, password via a PHP $connection = mysql_connect($ip,$user, $pass);. The server is extremely busy, hammered 24x7, but almost all traffic is coming from one very short script. About once a day we're getting "No dat

Re: Trying to create a new table in memory.

Charles Danko wrote: > Hi, > > I am trying to write a new table into main memory, but I am getting an out > of memory error. > > Each entry consists of 2 medium_int and 1 tiny_int variables, and the table > contains just over 100,000,000 rows. By my count, this makes just over > 700MB of data.

Trying to create a new table in memory.

Hi, I am trying to write a new table into main memory, but I am getting an out of memory error. Each entry consists of 2 medium_int and 1 tiny_int variables, and the table contains just over 100,000,000 rows. By my count, this makes just over 700MB of data. The machine I am using has 2GB, but

Move from mysql 4.0.24 to 5.0.22

Hello, i would like to move my Databases from one linux host (running 4.0.24) to a diffrent linux box (running 5.0.22). 4.0.24 is running with charset latin1, therefore i also selected that charset when i did my import on 5.0.22. Although, i get (charset?) format erros such as "Gästebuch" ins

unable to create function in MySQL 5.0

I got an error that I don't understand: Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3080 to server version: 5.0.18-log mysql> create function do_system returns integer soname 'raptor_udf.so'// ERROR 1146 (42S02): Table 'mysql.proc' doesn't

Using mysql for huge data warehouse - recommendations

so i'm debating between mysql and postgresql so far for choosing our data warehouse platform, and i've been using mysql for about 8 years now and would hate to move into postgresql if possible. mysql definitely has it's pros and cons, but so far, more pros than cons except for big joins. mysql

Re: +1MB query gets "Out of memory"

nocturnal wrote: Hi A client used to get Out of memory when trying to send a query that was a bit more than 1MB. The problem was solved when i increased query_cache to 2MB but now the problem is back and this time the line reported by the Out of memory error has a query that is just a bit ove

+1MB query gets "Out of memory"

Hi A client used to get Out of memory when trying to send a query that was a bit more than 1MB. The problem was solved when i increased query_cache to 2MB but now the problem is back and this time the line reported by the Out of memory error has a query that is just a bit over 1MB again. The

RE: SELECT...GROUP BY WITHIN GROUP BY

Donna, Just to say thanks. Played a bit more with the code and options and got most of what I wanted. A little procedure gives me the rest. Many thanks for pointing me in the right direction. Kerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 November 2

Unable to GRANT REPLICATION REQUIRE X509 and SSL

Is it possible to require both secure connections and x509 verification on a replication user? If so, what's the syntax? I couldn't find references to this use in the manual, lists or bug tracking system. Using mysql 4.1.21 10x, Amit -- MySQL General Mailing List For list archives: http://lists.m