Got a packet bigger than 'max_allowed_packet' - why is mysql so unkind?

Hi Everyone, I have had similar problems in the past, and have managed to usually stumble my way around them. But now this officially is just not making any sense... to me at least ;) Problem: I want to backup a database from server1 and restore it to server2. The database size is ~10GB,

how to use all system RAM for myisam db?

Hi all, we've a 16GB RAM host. one is configured to use InnoDB, where we can quite easily configure the amount of RAM to be used. but the other mashine is said to be configured using myisam, but we cannot really tweak it to use all of the 16GB of RAM the server has. there are - of course -

segment fault when using mysql++

below is my code;these code works very fine until, the length of the field content exceeds 30, then segment fault happened. how can I avoid this? mysqlpp::Query query = conn.query(); query select content from pages where id=id; mysqlpp::ResUse

Re: how to use all system RAM for myisam db?

In the last episode (Aug 01), Christian Parpart said: we've a 16GB RAM host. one is configured to use InnoDB, where we can quite easily configure the amount of RAM to be used. but the other mashine is said to be configured using myisam, but we cannot really tweak it to use all of the 16GB of

counting on a complex query

I have a nice little query that I can get the results from fine, but am having problems figuring out the best way to get the count directly from mysql. The query looks like the following: SELECT t1.id, t1.col1, t2.id, t2.col1, t2.col2, t2.col3, t2.col4 FROM t1 JOIN t2 ON ( t2.id = t1.col1 )

Re: how to use all system RAM for myisam db?

The real problem that you're running into (been there, done that) is that the MyISAM index code is only 32-bit clean. You can try to use more than 4GB for the key_buffer, but it won't work; I don't recall if the code implicitly limits the value, or just falls over. One possible workaround is to

RE: counting on a complex query

Will SELECT SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS() do what you want? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com

Re: counting on a complex query

On 8/1/07, Jerry Schwartz [EMAIL PROTECTED] wrote: Will SELECT SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS() do what you want? Be careful. While it will give the correct number of rows that would have been found if LIMIT had not been used, it makes the server compute the whole result set,

Mysql 5.0.41 Cross Compiler capable from source?

Hello all, I am trying to build mysql-5.0.41 under a cross compiling environment. Below is the beginning of the configure: -bash-2.05b$ ./configure --host=arm-none-linux-gnueabi --prefix=/view/mysql --with-mysqld-ldflags=-all-static configure: WARNING: If you wanted to set the --build type,

Re: Got a packet bigger than 'max_allowed_packet' - why is mysql so unkind?

Hi Gerald, I have set the max_allowed_packet to 1G on both servers. Any other ideas by any chance? Regards, Hartleigh Burton Resident Geek MRA Entertainment Pty Ltd 5 Dividend St | Mansfield | QLD 4122 | Australia Phone: (07) 3457 5041 Fax: (07) 3349 8806 Mobile: 0421 646 978

Re: segment fault when using mysql++

I'm replying to you both personally and to the MySQL++ mailing list, where this message is on topic. Please reply only on the list, not to me directly. wangxu wrote: below is my code;these code works very fine until, the length of the field content exceeds 30, How certain are you

Re: counting on a complex query

SQL_CALC_FOUND_ROWS isn't an option for us. Right now I am doing two queries, but I am just trying to see if there is a better way to do the count query than to just turn it into a dervied table and count the results i.e. SELECT COUNT(*) FROM (big nasty query) t1. I think what the question

Re: Returning All Rows That Repeat

You have your count in the wrong spot. I'm not even sure how that query would work. The count(*) should be part of a select field. By putting it in the HAVING clause it's calculating it after the query runs. SELECT jobs.*, count(*) AS Cnt FROM jobs GROUP BY customer_number, job_number

Re: question about data partitioning in application level.

I would use replication with multiple masters. You could setup 2, 3 or however many servers, that all replicate to 1 server (which you may be doing). I would just set the auto_increment increment larger than you need to allow for growth, like 10. If you are using auto_increment. You then

Re: counting on a complex query

On 8/1/07, Les Fletcher [EMAIL PROTECTED] wrote: SQL_CALC_FOUND_ROWS isn't an option for us. Right now I am doing two queries, but I am just trying to see if there is a better way to do the count query than to just turn it into a dervied table and count the results i.e. SELECT COUNT(*) FROM

Re: segment fault when using mysql++

actually I am using this piece of code,but I replaced fprintf to printf just to simplify the problem. and the field content actually stores string content. Shall this mean some thing different from your explanation? while (r = res.fetch_row()) { FILE *fp1;