> If you are running close to the same setup with no problems then I feel a
> little better about it not being a issue of pure traffic.
Yes, we operate in a very similar way to you. (BTW, we have had very good
results with a PHP based cache facility that simply stores the db driven
pages over a se
SHOW STATUS (after 24 hrs uptime):
created_tmp_disk_tables = 597
created_tmp_tables = 8893.
SHOW VARIABLES:
tmp_table_size = 33554432.
Does this mean that 597 queries have created a result set in excess of 33MB?
How can I find these rogue queries and optimise them? I could increase the
tmp_table_
I have about 300 database tables that are mostly ISAM and some MyISAM
format. I would like to move them all into MyISAM - what's the
easiest/quickest way? I am running 3.23.54.
I was thinking of doing mysqldump, then using a search/replace in the file
CREATE TABLE .. TYPE=, then recreating the dat
I want to upgrade my MySQL version (3.23.51) because of the recently
revealed exploit; the only binary dist on mysql.com for solaris 2.7 is
3.23.53; will there be a problem compiling from source on this platform or
should I wait for the binaries to be updated? There is a .54 release for 2.8
and 2.9
I've made a few changes to my Solaris - MySQL setup, following some
instructions in the manual for tuning.
(512MB RAM - single SCSI disk - combined web/db server - about 150 db tables
all with small query returns / single updates / hardly any joins)
I have set
max-connections = 200
table-cache = 2
> $ perror 144
> 144 = Table is crashed and last repair failed
>
> Your table is corrupted, try to repair it with REPAIR TABLE or
> myisamchk:
> http://www.mysql.com/doc/en/Repair.html
Hmm. REPAIR TABLE gives
| mydb.IDRefs | repair | error| Can't create new tempfile:
'./mydb/IDRefs.T
> Error 144 that the table is crashed and the last repair failed. You should
> run a check and optimize on this table if possible. Error 13 indicates
that
> you do not have permission to access the file. If you are the System
> Administrator you may want to check the file permissions. Otherwise, yo
Another error!
PHP starts to output the error "Too many references: cannot splice - error
144"
When logging into mysql, I get:
"Didn't find any fields in table IDRefs"
started with -A, I get:
"cannot open file: IDRefs.MYD (error: 144)"
optimize table IDRefs;
"Can't open file: 'IDRefs.MYD'. (errn
> JP> 021022 18:20:16 mysqld ended
> JP> 243749 Query INSERT INTO IDRefs
> JP> VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not
available','','')
> MySQL server always crashes on this query? What is the structure of
> the table IDRefs?
Not always, just a few times in the last fe
This morning our MySQL exited for no good reason!
mysql.err:
021020 17:25:53
021020 17:
021022 18:20:16 mysqld ended
mysql.log:
021022 18:20:09
243748 Connect mysql_user@localhost on
243748 Init DB mydb
243749 Connect [EMAIL PROTECTED] on
243749 Init DB mydb
243748 Quit
243749 Qu
Hi All
I keep getting a problem with our MySQL database, I know what error 127 is
('Record-file is crashed / Network is down'), it keeps occuring on several
tables that are frequently accessed by our website.
I can fix the problem by running OPTIMIZE TABLE on the offending tables but
it seems to
I have two mysql servers, setup to replicate each other.
However, every so often, one or both starts logging;
010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL
server on '0' (11)(107), retry in 0 sec
010226 9:40:27 Slave thread: error connecting to master:Can'
I'm running Slackware Linux (2.0.36) and just set up a
binary version of MySQL 3.23.32. I followed the
directions exactly and all looks to be fine. However,
when I try and start MySQL by using typing
bin/safe_mysqld --user=mysql &
I get the following error:
www:/usr/local/mysql# Starting mysq
13 matches
Mail list logo