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 - quite

"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="

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 o

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 ) W

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 us

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 > -Orig

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, disab

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, d

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 www.mraente

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 abo

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 is

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 HAV

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 ha

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(*) F

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;

Re: Best way to backup three live databases

Daevid, another idea is to consider InnoDB Hot Backup. While it is not free (perhaps NOT the most important point!), it does have the ability to do online ("hot" backups) of InnoDB tables while they are being used and updated. It also backs up MyISAM tables, with a minimal period of time wh