I'm not sure if there is a built-in, but what I usually do
for similar things is to use general purpose table to force
iteration.
E.g. create a table called ITERATE with one column, x, and
populate with values 0,1,2,3,4,... -- in your case up to 10
-- and index the column.
Then it's easy - I only s
Hi,
I am running 4.0.4 using innodb tables on a linux box.
My innodb config is
innodb_data_file_path = ibdata1:1800M;ibdata2:1800M;...ibdata10:1800M
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=500M
set-variable = innod
Yes that makes sense, thanks Heikki.
I monitored the ib_logfiles some more and see
the cycling between pairs logfile0+logfile1 and
logfile0+logfile2.
Heikki Tuuri wrote:
John,
- Original Message -
From: "John Thorpe" <[EMAIL PROTECTED]>
I am running 4.0.4 using innodb t
I've been using comand line piping through awk to handle
mass tables modifications and listings. E.g. in your case
something like the following would hit every index, except
the primary keys, in table tablename in the test database.
echo "show index from tablename" |
| mysql -uuser -ppswd test
| aw
If I'm reading this correctly, a self-join might
work if you have a primary key defined:
select
t1.a as a1
,t1.b as b1
,t1.c as c1
,t2.a as d1
from
thetable as t1
,thetable as t2
where
t2.primaryid = t1.primaryid+1
John
David L. Van Brunt, Ph.D. wrote:
I have a table of data...
A1 B1 C1
A2 B2 C
We have been running two 3.23.47 and one 4.0.4 (innodb) on
a single machine the past 2 years. We haven't had stability
or any ongoing problems. If something happens to one instance,
it has not affected any other. The main issue is resource
allocation. Also be sure that the different instances do
I know this is not elegant, but have have you tried using a temporary
table? It adds up your function column correctly. There was an
example of this earlier today from Oyekanmi - "Re: getting around a
subselect",
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:123911:200211:onbajmklkgifeckohcpa
