Re: mysqldump running out out of memory

: Have you tried this flag? -q, --quick Don't buffer query, dump directly to stdout. On Sun, 29 Apr 2007, Fredrik Carlsson wrote: Hi, I have a problem with mysqldump, its exiting with the message mysqldump: Error 5: Out of memory (Needed 22042208 bytes) when dumping table `theTable

mysqldump running out out of memory

command: /usr/pkg/bin/mysqldump -h localhost -B theDatabase --skip-opt --max_allowed_packet=1024M -q Any tips on how to get the dump running? the dump should be about 15-20GB in size the fully dumped, but I never seems to get there. // Fredrik Carlsson -- MySQL General Mailing List For list

Performance

? // Fredrik Carlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question about innodb, ibdata1

to do with it? I'm using MySQL 4.1.11 // Fredrik Carlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Max connections being used every 10-12 day.

Hi, My original query was a UNION query :) and that one is really fast. The problem i had was that every 8-12 day mysql sad that all of my max_connections was in use. I think i will stick with my UNION query it seems faster. // Fredrik. Bill Easton wrote: Fredrik, I haven't read all of

Re: Max connections being used every 10-12 day.

mysql describe art; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | parent

Re: Max connections being used every 10-12 day.

I really appreciate your help :) I did some cleanup of my indexes(there are a couple of them left to clean out but it takes so long time): mysql show index from art;

Re: Max connections being used every 10-12 day.

| | | art | ref | parent | parent | 5 | const |2 | Using where; Using filesort | ++---+--+-+-+---+--+-+ // Fredrik Carlsson Donny Simonton wrote: What

Re: Max connections being used every 10-12 day.

The inner join statement returned the same stuff but it was not as fast as the union is and the inner join seems to use more cpu resources. Could these union queries really be the problem behind my occasional lock ups and that 200 connections being used? i mean the server is not that loaded

Max connections being used every 10-12 day.

the connections. // Fredrik Carlsson # The MySQL server [mysqld] port= 3306 socket= /tmp/mysql.sock skip-locking key_buffer = 280M max_allowed_packet = 32M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size

Re: Max connections being used every 10-12 day.

mysql has about 50GB of temp space to work with so thats not the problem. Its strange because the server is not that loaded and around 12-04 at night no cronjobs that affects mysql or general server performance are being run. Is is possible to se how many queued up questions mysql has at the

converting to Innodb.

during the fulltext search everything else stops working. I read at dev.mysql.com that myisam uses per table lock and innodb per row lock so my question is if i convert my tables to innodb will i be able to use the tables during a fulltext search? // Fredrik Carlsson -- MySQL General Mailing List

Re: converting to Innodb.

Roger Baklund wrote: Fredrik Carlsson wrote: Hi list, I have a question regarding mysql and innodb. My current setup uses myisam and the db size is about 1.6 GB with two table that each have about 500k rows. I perform alot of fulltext search on these tables and they can sometimes take along time

mysqld segfaults.

and mysql 4.0.21 What can cause these segfaults? and is there anything i can tune to get rid of them? // Fredrik Carlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

CHECK TABLE looks up all databases.

Hi, I have some questions regarding CHECK TABLE, OPTIMIZE TABLE. When i run these commands on table1 mysql seems to lock up all other databases, is it possible to run these things in the background so that other databases can be accessible. // Fredrik Carlsson. -- MySQL General Mailing List

Fulltext performance problem.

about 300 000 rows and the size is ~1GB. // Fredrik Carlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fetch data and search on different tables.

? // Fredrik Carlsson Egor Egorov [EMAIL PROTECTED] wrote: Something like: SELECT ... FROM one, two WHERE textid=two.id AND MATCH(text) AGAINST() .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fetch data and search on different tables.

Carlsson Fredrik Carlsson [EMAIL PROTECTED] wrote: Hi, I have a question regarding to search with fulltext on table and fetch the data from another. Table one: id, textid, name, number, url Table two: id, text On table two there is a fulltext index. These two tables recently was one

Fetch data and search on different tables.

) having relevance 0.9 order by relevance DESC But due to the split of the table i cant really figure out how to make the question. I want to search with fulltext on table2(text) and fetch all the corresponding data from table1 where textid=(table2.id). Any tips? Best regards // Fredrik Carlsson