hostname.err says
(Got an error reading communication packets)
(Got an error writing communication packets)
I had to shut down the server. What does this mean?
This relates to SHOW PROCESSLIST
Id Command Time State Info
6 Query 81 Locked SELECT * FROM staticStrings
WHERE ruri = 'staticAnzeigenRubriken'
14 Query 38 Locked REPLACE INTO staticStrings (ruri, staticString)
VALUES ('static/Rassen/%40_e4e8', ' <!doctype ht
21 Query 83 Locked REPLACE INTO staticStrings (ruri, staticString)
VALUES ('staticPferdQuAlter/5', '<DIV ALIGN=\'CE
22 Query 35 Locked REPLACE INTO staticStrings (ruri, staticString)
VALUES ('staticAnzeigenQuUnterbringung/t', '<A N
348 Query 129 Copying to tmp table SELECT * FROM staticStrings
ORDER BY RAND() LIMIT 0,10
349 Query 66 Locked SELECT * FROM staticStrings
ORDER BY RAND() LIMIT 0,10
350 Query 9 Locked SELECT * FROM staticStrings
ORDER BY RAND() LIMIT 0,10
table definition
CREATE TABLE staticStrings (
auto mediumint(4) unsigned NOT NULL auto_increment,
ruri varchar(255) DEFAULT '0' NOT NULL,
staticString mediumtext NOT NULL,
PRIMARY KEY (auto),
UNIQUE ruri (ruri)
);
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
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