At 06:21 PM 10/3/2011, Angela liu wrote:
Thanks, what about if mysqld restart, does auto_increment gets reset ?
No. The next auto increment value stays with the table. As another
person already stated, you should never manually change the auto
increment value on a table that already has rows
Am 03.10.2011 23:46, schrieb Angela liu:
> Hi, Folks:
>
>
> I have questions regarding how MyISAM handles auto_increment clolumn?
>
> 1. is there a auto_increment counter for MyISAM to assign a new value to
> auto_increment columns?
> 2. if MyISAM has the counter, is the counter stored in mem
Thanks, what about if mysqld restart, does auto_increment gets reset ?
I saw this happened to Innodb, if table is empty and server restart,
auto_incremnet gets reset to 0
From: mos
To: mysql@lists.mysql.com
Sent: Monday, October 3, 2011 3:01 PM
Subject: Re: H
I need two fields from two different tables. I could either run two
queries, or a single INNER JOIN query:
$r1=mysql_query("SELECT fruit FROM fruits WHERE userid = 1");
$r2=mysql_query("SELECT beer FROM beers WHERE userid = 1");
--or--
$r=mysql_query("SELECT fruits.fruit, beers.beer FROM
At 04:46 PM 10/3/2011, you wrote:
Hi, Folks: I have questions regarding how MyISAM handles
auto_increment clolumn? 1. is there a auto_increment counter for
MyISAM to assign a new value to auto_increment columns?
Yes
2. if MyISAM has the counter, is the counter stored in memory or
disk? Thn
Hi, Folks:
I have questions regarding how MyISAM handles auto_increment clolumn?
1. is there a auto_increment counter for MyISAM to assign a new value to
auto_increment columns?
2. if MyISAM has the counter, is the counter stored in memory or disk?
Thnaks
Dear MySQL users,
This is the list of bug fixes. For the functional enhancements, see part
1 of this mail:
Bugs fixed:
* Incompatible Change: For socket I/O, an optimization for the
case when the server used alarms for timeouts could cause a
slowdown when socket timeouts were used
Dear MySQL users,
MySQL Server 5.6.3 (Milestone Release) is a new version of the world's
most popular open source database.
The new features in these releases are of beta quality. As with any
other pre-production release, caution should be taken when installing on
production level systems or sy
Can you run show processlist in another connection while the select
count(*) query is running and say what the state column is?
On Mon, Oct 3, 2011 at 7:00 AM, Joey L wrote:
> this is not a real query on the site - it is just a way i am measuring
> performance on mysql - I do not know if it is su
this is not a real query on the site - it is just a way i am measuring
performance on mysql - I do not know if it is such a great way to test.
Looking for a better way to get a performance read on my site...do you have
any ?? besides just viewing pages on it.
thanks
mjh
On Mon, Oct 3, 2011 at 9:5
have you tried
select count(yourindex) instead of select count(*) ?
On Mon, Oct 3, 2011 at 7:53 AM, Joey L wrote:
> Thanks for the input -
> 1. I will wait 48 hours and see what happens.
> 2. can you tell me what are some performance tests I can do to help me
> better tune my server ?
> 3. I a
Thanks for the input -
1. I will wait 48 hours and see what happens.
2. can you tell me what are some performance tests I can do to help me
better tune my server ?
3. I am concerned about this table : | w6h8a_sh404sef_urls |
MyISAM | 10 | Dynamic| 8908402 |174 |
File per table is required if you want to implement compression via the
barracuda file format.
On 3 Oct 2011 06:39, "Adarsh Sharma" wrote:
> innnodb_file per table creates ibdata files for each table and What to
> do if some tables data are deleted frequently.
> I have a innodb table which was tru
13 matches
Mail list logo
