Am 15.03.2012 17:31, schrieb Malka Cymbalista:
> We are running MySQL version 5.0.45 on a Linux machine. Most of our tables
> are MyIASM but we have recently installed drupal 7 and drupal 7 requires
> INNODB tables. Every now and then when we restart MySQL using the commands
> /etc/init.d/mys
On 9/7/06, Paul McCullagh <[EMAIL PROTECTED]> wrote:
It sounds like you program allows ad-hoc queries, so why don't you
just limit the number of rows returned by a select?
For example you could limit the number of rows to 1001. If the server
returns 1001, then display 1000 and tell the user the
On Sep 7, 2006, at 3:32 PM, <[EMAIL PROTECTED]> wrote:
I need to know the number of rows that a query will return before
actually executing the query. So I am sending select count(*) before
sending select *. Actually I need to reject queries if the number of
records that it will return is huge,
On 9/7/06, [EMAIL PROTECTED] wrote:
I need to know the number of rows that a query will return before
actually executing the query. So I am sending select count(*) before
sending select *. Actually I need to reject queries if the number of
records that it will return is huge, to avoid my server
:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 10:39 AM
To: Prasad Ramisetti (WT01 - Broadband Networks)
Cc: MySQL List
Subject: Re: problem with InnoDB
Hi Prasad
A primary key automatically creates an index and not-null and unique
constraints, too. So you don't need to explicitly crea
:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 10:39 AM
To: Prasad Ramisetti (WT01 - Broadband Networks)
Cc: MySQL List
Subject: Re: problem with InnoDB
Hi Prasad
A primary key automatically creates an index and not-null and unique
constraints, too. So you don't need to explicitly crea
Hi Prasad
This question got me a bit interested as we're thinking of moving
some MyISAM tables to InnoDB and I haven't used it much.
I decided to test some of these ideas so I created an innodb table
and put some data into it and tried some selects:
(Running on MacBook Pro, 2.0ghz, 1gb RA
In the last episode (Sep 07), [EMAIL PROTECTED] said:
> Hi Dan,
>
> Thanks for yur response. Does it makes sense to create an index on a
> primary key ..as that is my smallest field ?
It might, because in an InnoDB table, your primary index also holds
your row data. So it's actually your largest
mysql@lists.mysql.com
Subject: Re: problem with InnoDB
In the last episode (Sep 04), [EMAIL PROTECTED] said:
Actually there is some requirement, where I need to know the
number of
rows that I will get for my queries before actually executing the
query. Could you please suggest some way for this
[EMAIL PROTECTED] wrote:
Hi Dan,
Thanks for yur response. Does it makes sense to create an index on a
primary key ..as that is my smallest field ?
A primary key already has an index.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Networks)
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: problem with InnoDB
In the last episode (Sep 04), [EMAIL PROTECTED] said:
> Actually there is some requirement, where I need to know the number of
> rows that I will get for my queries before actually executing the
> query.
In the last episode (Sep 04), [EMAIL PROTECTED] said:
> Actually there is some requirement, where I need to know the number
> of rows that I will get for my queries before actually executing the
> query. Could you please suggest some way for this.
Your best bet is to create an index on the smalles
PROTECTED]
Sent: Wednesday, August 16, 2006 9:58 AM
To: Prasad Ramisetti (WT01 - Broadband Networks)
Cc: mysql@lists.mysql.com
Subject: Re: problem with InnoDB
[EMAIL PROTECTED] wrote:
> Hi ,
>
>
> select count(*) is painfully slow in case of innoDB when the number of
> records are a
Subject: RE: Problem with INNODB transactions
What connection pool code are you using? My guess is that the problem is
in your code somewhere. Either transactions are not being closed (i.e.
because of a connection pool flaw maybe?) or you have two threads trying
to update the same row at the same
behavior).
R.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006 9:31 AM
To: mysql@lists.mysql.com
Subject: Problem with INNODB transactions
Hi,
I am facing a strange problem with INNODB. My application communicates
with mysql server
Hi,
I am facing a strange problem with INNODB. My application communicates with
mysql server using JDBC. I am using mysql 5.1 version.
Even after issuing connection.commit() / connection.rollback() commands, still
on the sql side the transactions are not getting closed properly. In our
[EMAIL PROTECTED] wrote:
Hi,
There is a problem with CPU utlization when using INNODB. The CPU
utilization goes to 100% in a dual processor solaris box. With the same
setup, myISAM uses only 60% of the CPU.
As I said before, stuff like 'count(*)' queries cannot use an index in
innodb - if y
Hi,
There is a problem with CPU utlization when using INNODB. The CPU
utilization goes to 100% in a dual processor solaris box. With the same
setup, myISAM uses only 60% of the CPU.
Could someone please let me know what could be the problem. There are
some other processes running on the same b
Hi,
There is a problem with CPU utlization when using INNODB. The CPU
utilization goes to 100% in a dual processor solaris box. With the same
setup, myISAM uses only 60% of the CPU.
Could someone please let me know what could be the problem. There are
some other processes running on the same b
[EMAIL PROTECTED] wrote:
Hi ,
select count(*) is painfully slow in case of innoDB when the number of
records are around 1 million. Ths select count(*) query in myISAM takes
0.01 secs and the same query in InnoDB takes around 20.15 secs.
Can anybody suggest me how to speed up this query ?
Yo
Hi ,
select count(*) is painfully slow in case of innoDB when the number of
records are around 1 million. Ths select count(*) query in myISAM takes
0.01 secs and the same query in InnoDB takes around 20.15 secs.
Can anybody suggest me how to speed up this query ?
Thanks
Prasad
The informatio
Hi!
I have copied all the files from mysql/data folder and burned them
on CD. Then i've formated old hard drive. Now i'm trying to copy
them back on the fresh mysql installation. Unfortunately after I
copy iblogs and ibdata1 mysql is not working anymore. What I can
read in error log file is:
Inno
Paul,
- Original Message -
From: "Paul W" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 25, 2004 11:33 AM
Subject: Cloned machine mysql startup problem with innodb
For backup purposes I have what amounts
to a complete clone of a live se
For backup purposes I have what amounts
to a complete clone of a live server.
During the process of copying
everything, the MySQL data was copied
over in its entirety. My problem is that
the mysqld won't start now on this
second machine. I don't need the
databases to be preserved here (inten
table scan.
Regards,
Heikki
Innobase Oy
sql query
- Original Message -
From: "Natale Babbo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 5:52 PM
Subject: please help me - problem with innodb foreign keys
> # - PLEASE HELP
Hello,
I've just switched to InnoDB table from myISAM and it's been running pretty smoothly
except on this SQL statement it doesn't use any indexes when there are, and therefore
is very slow.
mysql> explain select
pn.timestamp,ne.viewpoint,pn.id,pn.type,ne.type,ne.newsid,ne.hidestamp from
ne
Sounds good. Thanks for the info, Heikki.
--Walt
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Benchmarking MyISAM, InnoDB, and Oracle: a problem with
InnoDB
Walt,
this is probably a
Hey,
I dunno whether it's a bug or just I don't know how to use transactions
properly. I've got 3.23.36 on FreeBSD 4.2-STABLE, and when I do this:
CREATE TABLE test TYPE=Innobase SELECT * otherdb.sometable;
MySQL hangs. If I limit the SELECT query to 10-100 rows, it executes quite
fast (same if
28 matches
Mail list logo
