VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
I've made some experiments and can
VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
SELECT ...
FROM positionReports p
Can you supply us with an example? Some explain plans to corroborate your
reported slowness.
-Original Message-
From: Andrey Chernyh
To: [EMAIL PROTECTED]
Sent: 3/9/04 3:35 AM
Subject: Performance problem with 4.0.18
Hello All!
After we converted our tables from MyISAM to InnoDB the
Hello All!
After we converted our tables from MyISAM to InnoDB the database
became very slow!
The same database on another machine on MySQL 3.23.58 works very good.
The machines are identical, my.cnf files are the same.
What can be the reason of such slow performance?
Thank you!
Best regards, An
Andrea Riela wrote:
Andrea Riela wrote:
Could you help me?
well, I've tryed with ktrace, see my kdump:
http://www.nesys.it/kdump
Andrea:
Could you ktrace mysqld itself rather than mysqld_safe ?
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For
Andrea Riela wrote:
> Could you help me?
well, I've tryed with ktrace, see my kdump:
http://www.nesys.it/kdump
It's possible, a pid file problem?
thanks for your support
Regards
Andrea
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
well,
I've reinstall from pkg.
My sys: openbsd 3.3
Mysql: 4.0.18
When I try to start the server:
mysqld_safe --user=_mysqld &
I receive that:
observe# mysqld_safe --user=_mysql &
[1] 6694
observe# Abort
Abort
Starting mysqld daemon with databases from /var/mysql
040227 17:38:56 mysqld ended
Andrea Riela wrote:
Hi folks,
my system: openbsd 3.3
mysql ver: 4.0.18
Well, I was working on phpBB conf, when I've seen errors from mysql:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't fin
Hi folks,
my system: openbsd 3.3
mysql ver: 4.0.18
Well, I was working on phpBB conf, when I've seen errors from mysql:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in ta
