Hi Mike,
The architectures of the engines are radically different, so you can
expect different performance characteristics.
But the main differences and advantages will show in the future, as
the engines are developed further. I spoke about the future directions
of PBXT at the last
Hi,
I would like to develop a commercial application using MySQL Community
Server as database platform. Can I do this?
Thanks and regards.
Greetings List,
We have a medium-large size database application which we are trying
to optimize and I have a few questions.
Server Specs
1 Dual Core 2.6 Ghz
2GB Ram
Database Specs
51 Tables
Min 10 rows, Max 100 rows
Total size approx 2GB
My.cnf
[mysqld]
set-variable=local-infile=0
Jim,
Retrieving 100,000 rows will always take some time. Do you really
need to return that many rows? Are you selecting just the columns you need?
What are the slow queries?
Mike
At 12:05 PM 9/3/2008, Jim Leavitt wrote:
Greetings List,
We have a medium-large size database application
What are the queries? Are they straight forward selects or joins? Are the
columns you select from indexed and are the indexes up-to-date?
On Wed, Sep 3, 2008 at 12:05 PM, Jim Leavitt [EMAIL PROTECTED] wrote:
Greetings List,
We have a medium-large size database application which we are
I've been trying to backdown a production database for some time and
can't seem to get around MySQL crashing at about 1GB of backup data.
(the database is about 400GB).
I have a page corruption, but it isn't found when I do a CHECK TABLE on
*any* of the tables. InnoDB is running in
That's a lot of data to return, make sure you factor in data load and
transfer time. You may try breaking your query into smaller parts and
recombining the results in a scripting language. If you are searching
on a range (i.e. date range), break the range into smaller parts and
run multiple
Right... and perhaps try MySQL Enterprise Monitor. A trial is available from
mysql.com. It may give you hints on your mysql.cnf.
Kind regards,
TomH
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2008 11:35 PM
To: Jim Leavitt
Cc:
How are you performing the backup? What tools are involved? Are
there any ther users of the database while you are doing this?
- michael dykman
On Wed, Sep 3, 2008 at 4:43 PM, L'argent [EMAIL PROTECTED] wrote:
I've been trying to backdown a production database for some time and can't
seem
On Wed, Sep 3, 2008 at 1:05 PM, Jim Leavitt [EMAIL PROTECTED] wrote:
We are having trouble with certain queries which are returning anywhere
from 10 - 30 rows. Total query time is taking approx 1 - 2 mins
depending on load. Is there anything in our conf file which could improve
our
All,
We're seeing a huge surge in our qps and I'd like to make sure we're
tuned as well as we can be. I'm wondering if I've got some variables
maybe set too large (is that even possible?) ? We do have a fair bit
of innodb, so perhaps I should add some non-defaults there, but I'm
not so
11 matches
Mail list logo