| 512 |
+--+--+
Regards,
Zhe
[EMAIL PROTECTED] wrote:
Zhe Wang <[EMAIL PROTECTED]> wrote on 07/28/2005 10:40:08 AM:
Hi, there,
I am have a hard time figuring out why a simple query is extremely
slow. I would greatly appreciate if yo
Hi, there,
I am have a hard time figuring out why a simple query is extremely
slow. I would greatly appreciate if you can shed some light!
The table is in InnoDB:
CREATE TABLE `rps_hits` (
`gi` int(10) unsigned NOT NULL default '0',
`cddid` int(10) unsigned NOT NULL default '0',
Hi, there,
I am using MySQL 4.1.10. I have a table which has a LONGBLOB field.
Some length of the blob field of the records varies from a few hundred
bytes to more than 64 MB. I've set max_allowed _packet to 128M on the
server side. I first created the table in MyISAM and the data was added
On Mon, 28 Feb 2005 10:05:32 -0500, Zhe Wang <[EMAIL PROTECTED]> wrote:
> > Hi, there,
> >
> > I have MySQL 4.1.10. I need to add a timestamp column to an existing
> > table. I am having a problem of setting the newly added column to
be the
> > current time.
>
Hi, there,
I have MySQL 4.1.10. I need to add a timestamp column to an existing
table. I am having a problem of setting the newly added column to be the
current time.
This is what I did:
CREATE TABLE try (id INTEGER); INSERT INTO try VALUES(1), (2), (3);
ALTER TABLE try ADD timestamp TIMESTAMP
Hi, there,
I am in the middle of replacing a MyISAM database with InnoDB.
Queries "show table status" and "select count" are extremely slow which
gave me some pain. I am wondering if there are any other queries on
InnoDB that are significantly slower than those on MyISAM other than
these t
Hi, there,
We have a huge database (84 tables of about 360 G of data in MyISAM
tables). Recently, we converted the entire database to InnoDB (in one
table space) and set up replication. Then we experienced some slower
performance.
For example, "show table status" on the master took more
Hi, everyone,
I created two databases DB_A and DB_B whose tables were all in
InnoDB. DB_A has data of approximately 500 G, DB_B has data of about
200G. Later I dropped the entire DB_B because it served only purpose of
testing. I noticed that the size of the table files ibdata1 and ibdata2
di
Hi, all,
I am having trouble of revoking global privileges. Your help will be
greatly appreciated.
I created a user called "dummy" identified by password "dummy" by :
grant usage on *.* to 'dummy'@'%' identified by 'dummy';
Then I did:
mysql> show grants for dummy;
+
