ng that my machine should be fast enough for
that kind of application?
I have included below all diagnostic output i could think of; if you need
more please ask.
Thank you very much for your help in advance
Henning Schroeder
---
Hi,
> > Looking in the process table reveals (when the page is fast) lots of
> > sleeping processes, sometimes (when the page is slow -- 30sec to load a
> web
> > page) lots (20+) processes that are locked. Usually they are some SELECTs
> > and UPDATEswaiting for a single table that is the most
stand why this would return
>different answers.
Yes there is, and it has caused me some grief a while ago. phpmyadmin (at
least my installation) seems to add "limit 0,30" to every select query you
enter into the input field. i think this is to make sur
At 01:10 06.09.01, you wrote:
>Hello All,
>
>I got a sql query I seemed to be missing the obvious or just can't see.
>Database Table structure:
>CREATE TABLE `membership` (
> `tagid` int(8) NOT NULL default '0',
> `startdate` date NOT NULL default '-00-00',
> `expdate` date NOT NULL defa
>
>When I attempted to change the MySQL root user with the command "mysqladmin
>-u root -p password 'new-password' " I received the following error:
>"Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock '(2)' check that mysqld is running and that the
>socket; '/var/lib/
At 02:58 06.09.01, you wrote:
>I get the results:
>Impossible WHERE noticed after reading const tables
>
>Not sure this has anything to do with it, but there is no data in either table
>yet,
yes, that´s exactly the reason. the query optimizer found out very early
that your select would not retu
hi wesley and the gang,
thank you very much for your help so far. i optimized the indexes and added
another one i obviously forgot before, and the database is smoother now. a
bit at least, it now maxes out at 65q/s instead of 50...
At 13:12 06.09.01, you wrote:
> > idea? And how am I supposed
Hi!
Is there a way or command for mysql that shows me
a) what tables are currently locked
b) with what kind of lock
c) which query caused the lock
d) and maybe how long the lock exists?
I usually try to figure out via mysqladmin processlist and look for the one
query that isn´t locked as the c
At 17:52 06.09.01, you wrote:
>It is copying ALL of the results into the temp table. If you can (e.g.
>you know you will
>never want more than N records), add a LIMIT 0,N to the end of the SELECT
>so that when you
>have an old timestamp it will not hang the database.
as i use
select count (
At 17:25 06.09.01, you wrote:
>Or ENUM:
>ALTER TABLE myTable CHANGE COLUM myColumn ENUM( 'T', 'F' );
>
>Of course if you are using this to drive a web page Mike's solution is better.
> Or you would want to enum( 1, 0 ) or enum( '1', '' );
yes, but do *not* use enum('t','f') because with some fo
At 22:53 06.09.01, you wrote:
>mysql> SELECT receiver_id, associate_of, user_name FROM receivers;
>+-+--+-+
>| receiver_id | associate_of | user_name |
>+-+--+-+
>| 1 |0 | arnold |
>| 2
ent as in:
SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER
BY count DESC HAVING count>10
hand
henning schroeder
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
At 01:46 11.09.01, you wrote:
>I'm having a lot of trouble tracing the origin of the problem --
>sometimes it seems that accessing a particular large table is causing
>it, sometimes it seems that a combination of factors is causing it.
>Regardless, what I observe is that within 1 minute my load
At 11:03 11.09.01, you wrote:
> > does MYSQL.COM has a table type same as GEMINI ( GEMINI
>
>yes. MySQL contains support for BDB and InnoDB tables, that are
>transaction-safe.
I don´t want to provoke any anger here, maybe i´m still too new on the list.
But actually, i´m a bit sick of the curren
Hello,
it´s me again. For the new readers: mysql 3.23.41, ~50q/s, load jumps to 200.
If have been experimenting with the slow log to find out about these slow
queries that are apparently locking too long. Much to my horror, I have
lots of queries of this type popping up:
# Time: 21 Lock_tim
vious statement
// must update
// should be even rarer
UPDATE stats
assert(number_of_affected_rows==1) //must always be true else bomb
}
}
in most of the cases there is just one query being executed.
bye
he
16 matches
Mail list logo
