Thanks first,
I checked MySQL 5.1 manual, looks like , 'create tablespace' is ok only with
NDB and NDBCLUSTER, NOT INNODB
And I did not find 'create tablespace' in MySQL 5.5 manual:(
looks like MySQL5.5 does not offer 'create tablespace' anymore.
--- On Mon, 1/17/11, Eric Bergen wrote:
Fro
reply inline
On Mon, Jan 17, 2011 at 9:30 PM, Angela liu wrote:
> Folks :
>
> two questions:
>
> 1. can Innodb create per database table space , not per table table space?
No. The only available options are creating a global tablespace which
can be many files or a file per table.
> 2. can we st
Folks :
two questions:
1. can Innodb create per database table space , not per table table space?
2. can we store table on specific tablespace like Oracle or DB2 when creating
table?
Many thanks.
Make sure the following things:
- /tmp folder is having 1777 permissions
- mysql folder is having the ownership from which it is running. Refer
/etc/my.cnf
- Make sure you have space on your MySQL partition
Regards
Sushant Chawla
On Tue, Jan 18, 2011 at 10:51 AM, Yogesh Kore wro
May be db files are not as MySQL user. Check owner ship for the files of the
table.
It should be mysql user ownership.
On Tue, Jan 18, 2011 at 6:36 AM, Peng Yu wrote:
> Hi,
>
> I run the following command. But I got the following error. I'm not
> sure what causes the problem. I have seen the sam
On 1/17/11 9:52 AM, Jerry Schwartz wrote:
[JS] I don't understand how an index on a timestamp would help. Theoretically,
each record could have a unique value for the timestamp; so the index would
have an entry for each record. Would MySQL really use that in preference to,
or in combination with,
Hi,
I run the following command. But I got the following error. I'm not
sure what causes the problem. I have seen the same issue before, but
it disappeared even I didn't take any action. Could anybody let me
know how to fix the problem?
mysql -ugenome -hgenome-mysql.cse.ucsc.edu mm9 -A
mysql> se
On Mon, 2011-01-17 at 14:50 +0200, Michael Widenius wrote:
> Hi!
>
> > "Noel" == Noel Butler writes:
>
> Noel> In all previous versions we were able to run -Aao --auto-repair
>
> Noel> Anyone know WHY, in 5.5, -a and -o , must be run separately, this
> Noel> is kind of silly I think
>>
>> SELECT COUNT(*) AS num FROM alerts WHERE stamp > DATE_SUB(NOW(),
>> interval 300 second) AND devid=244;
>>
>> With this query, MySQL will run DATE_SUB() once, and then use the
>> index on stamp (which I assume you have) to narrow down the result set.
>>
[JS] I don't understand how an index o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
He meant the execution order, please use the agregation function as
suggested.
On 11-01-17 05:03, Jørn Dahl-Stamnes wrote:
> On Monday 17 January 2011 09:53, Steve Meyers wrote:
>> On 1/16/11 5:22 AM, Jørn Dahl-Stamnes wrote:
>>> mysql> select album_
Hi!
> "Noel" == Noel Butler writes:
Noel> In all previous versions we were able to run -Aao --auto-repair
Noel> Anyone know WHY, in 5.5, -a and -o , must be run separately, this
Noel> is kind of silly I think, requiring two passes now.
I checked the 5.0 code and even there you coul
On Monday 17 January 2011 09:53, Steve Meyers wrote:
> On 1/16/11 5:22 AM, Jørn Dahl-Stamnes wrote:
> > mysql> select album_id, updated_at, created_at from album_stats group by
> > album_id order by updated_at desc limit 8;
>
> I believe that your problem is that the group by happens before the
>
On 1/16/11 5:22 AM, Jørn Dahl-Stamnes wrote:
mysql> select album_id, updated_at, created_at from album_stats group by
album_id order by updated_at desc limit 8;
I believe that your problem is that the group by happens before the
order by. Since you're grouping, the updated_at column is not
13 matches
Mail list logo
