On Thu, Sep 06, 2001 at 05:26:53PM +0200, Henning Schroeder wrote:
Find all the queries that interact with this table. EXPLAIN them. Time them.
*all* of them? there are lots.
Well, perhaps not initially but you may want to have EXPLAINed a majority
of the queries that are issued against
On Thu, Sep 06, 2001 at 12:02:07AM +0200, Henning Schroeder wrote:
All the updates to the table are of the style described above (one to three
colums changed, row indexed by primary key). Well, with SELECTs it´s a
different story: many queries join in different ways to the table. FYI,
it´s
On Thu, Sep 06, 2001 at 01:02:59PM +0200, Kristoffer Larsson wrote:
I just tried to create a table called order, with this command:
create table order (
orderID INTnot null,
constraint P_Key_6 primary key (orderID)
);
It didn't work, I
On Wed, Sep 05, 2001 at 11:10:49PM +0200, Henning Schroeder wrote:
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
Hi,
On Thu, Aug 16, 2001 at 02:04:25PM +0100, Ken Guest wrote:
At the moment, what I am doing is:
execute LOCK TABLES foo READ
select info from foo
//next lock implictly unlocks previous one
//as it's done by the same thread/process
//chances of conflicts
Hi All,
On Tue, Mar 27, 2001 at 02:28:05PM +0100, Rafael Martinez wrote:
I am thinking to install our DB server in a 4-way machine with
Intel Xeon processors/1MB cache. I can see in the mysql documentation that mysql
works OK in a 2-way machine but that in a 4-way system has to be tested.
Howdy,
On Tue, Jan 09, 2001 at 11:53:12AM +0800, [EMAIL PROTECTED] wrote:
I've got a linux server running MySQL 3.22.32 on kernel version
2.4.0-test8.
I'd be tentatively inclined to blame the problems on 2.4.0-test8. Do
the problems still occur under (say) 2.2.18?
The database server has a
Hi David,
On Tue, Jan 09, 2001 at 01:02:34PM +, David Lane wrote:
I am having major problems with MySQL 3.22.32 running on a
Linux-Mandrake 7.1 box with RAID 1 drives... Although mysqld is running
(through safe_mysqld, initiated by /etc/rc.d/init.d/mysql.server start),
any command line
Hi,
On Wed, Jan 10, 2001 at 02:02:40PM -, Steven Clifford wrote:
how much higher would you estimate the resource / memory
consumption of 3.23.30 compared to 3.22.26 ?
(both from the statically linked Linux i686 binary distribution)
After using 3.22.26 for quite some time now, I feel