Re: SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message

you can set up more slaves to spread the workload even more From what you told about the completion time of your dump it seems you should re-design your whole MySQL setup. Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str

InnoDB buffer cache internals available?

Hi, in order to size the innodb buffer cache optimally it would really be beneficial to see what it is composed of and how much memory each of the components (also internal structures!) consumes. Is there any chance to get this information? Regards, Frank. -- Dr. Frank Ullrich, DBA

Re: innodb file per table

(*.ibd). Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Optimizing Per-Table-Tablespaces

://www.mysqluc.com/pub/w/35/sessions.html New InnoDB Features David Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General

Re: Trouble w/ mysqldump (images attached)

://lists.mysql.com/[EMAIL PROTECTED] -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Show Innodb Status: Output truncated

long. What causes that behaviour and can you work around the problem? Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL

Re: What is the default database?

/doc/mysql/en/Information_functions.html Michael -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List For list archives: http

What is the default database?

the question remains: what is the default database? Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List

Re: Insert problems with InnoDB (big table)

(cost) create index smallname on smalltest (name) __ Thanks for any help. Luc Charland -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49

Re: MySQL Crashing On Index Creation/Select count(*) statement - InnoDB tables

memtest86 on the machine to see if it was memory, and played musical chairs with the memory to see if we had a bad DIMM. We tried disabling the cache on the SCSI card in case it had bad RAM. Does anyone have any suggestions? David -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise

Re: Not using index?

Good Morning! Sasha Pachev wrote: Keith Thompson wrote: I've got a query that's not using an index and I don't understand why. Here's a stripped down version of what the tables look like: create table t1 ( id int(10) unsigned not null auto_increment, x1 date not null, ... 8 other small, fixed

Re: MySQL Lost 3 Weeks of Data

restart the database was like 19th jan. Has someone ideas why this happened? I couldn't explan to me why this happened! grds, Michael Schmuck p.s. sorry for bad english -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625

Re: Advise on High Availability configuration

one and falls over to master two when other slaves can still see master one. Don't you then have inconsistencies in your data? Russell. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49

Re: Too slow recovering mysqldump files

PROTECTED] -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

realistically' and so on ... But that's the funny thing: when everything is done and deployed and __slow__ then 'the database is so slow, do something (immediately!)'. Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7

Re: Can I really have no_wait row-locks in MySQL+InnoDB?

://lists.mysql.com/[EMAIL PROTECTED] -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List For list archives: http

Re: innodb-errors

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49

Re: Why are my sorts so slow?

are the different ways that mysql can sort a result set? thanks, --brl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH

Re: Is there anything equivalent to Oracle9i's list partitioning?

that query against every member table (sort of a UNION operation). --cut Regards, Frank. -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538

Re: C API problems with InnoDB

/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Frank. -- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag GmbH Co

Re: MyISAM or InnoDB

--- --cut Kind Regards, -- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538

Re: Constraint Hell

-- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 - Before posting, please check

Re: Write Conflict when accessing MySQL tables in Access (link table)

: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Dr. Frank Ullrich

Re: Don't even know where to start on this one

) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag

Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's included.

call_notes group by ticket_id. After you have come to a conclusion you just have to teach MySQL to process your tables in the appropriate order; rephrase your SQL and use straight join. HTH Regards, Frank. -- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG

Re: Select with Order By that don't use my INDEX :(

=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538

Re: Replication Issues

a replication bug introduced in 3.23.32! --cut Regards, Frank. -- Dr. Frank Ullrich, Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538

Re: DELETE returns incorrect value

) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Dr. Frank Ullrich, Netzwerkadministration Verlag Heinz Heise GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL

Re: Redhat 7.2 Linux Maximum Database/Table Size

Hi, Jeremy Zawodny wrote: On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote: Benjamin, can you also grow MyISAM tables to such sizes? You can. that implies that MySQL itself (and all its tools) is able to handle files bigger than 2 GB? Is that the case with MySQL

Re: Curious result: Indexing numbers vs. strings

unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Dr. Frank Ullrich, Netzwerkadministration Verlag Heinz Heise GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538

Re: Redhat 7.2 Linux Maximum Database/Table Size

(the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Dr. Frank Ullrich, Netzwerkadministration Verlag Heinz Heise GmbH

Re: MySQL Book

(the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Dr. Frank Ullrich, Netzwerkadministration Verlag Heinz

Re: example using temporary tables

each other (I guess there's no User with an ID=NULL). How to section: create temporary table ... [TYPE=HEAP] does it! Choose the HEAP type if you want to create the table in main memory. Regards, Frank. -- Dr. Frank Ullrich, Netzwerkadministration Verlag Heinz Heise GmbH Co KG

Re: Query seem to be using the wrong index / InnoDB

: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Dr. Frank Ullrich

Replication problem (with temporary heap tables ?)

Error running query, slave aborted. Fix the problem, and Regards, Frank. -- Dr. Frank Ullrich, Netzwerkadministration Verlag Heinz Heise GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538