Hi,
My database is mostly made up of MyIsam tables, and some InnoDB tables.
One particular Innodb table works fine with an auto increment field.
The table is updated often, records being added and deleted at pretty
much the same rate.
So, there are only a very few records in the table at any giv
on my site
cannot access, I should be safe.
I am afraid this method is going to cost me in terms of time though.
Any comments/ suggestions are welcome.
Rishi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ySQL4.0.12. Some of the senior folks at the lab think that it may be
because lockd and/or statd has issues running over NFS from a Mac OS X
box. Anyone have experience with this before?
Thanks for all your help.
Rishi
Try rebuilding the table in a local directory, and then copy the file
to the N
nix OSFI V5.1.
I have rebuilt several tables before but have never faced this
problem. Google did not yield much either. It would be great if someone
could tell me what is going on/ what I can do to rebuild the table.
Thanks in advance.
Sincerely,
Rishi Pande
smime.p7s
Descri
Hi,
I am getting a problem with my select query with the limit statement like
for eg,
select table1.field1,table1.field2 from table1 limit 5000,500;
The query will take a lot of time to execute.
The table in question in only 16000 records.
Could anybody advise me on this issue!
Rishi,
Advance
Any suggestions?
-rishi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubs
