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
]
Subject: Re: NT service problem
Check the location of the configuration file (should be either c:\my.cnf
~
OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a
sample:
[client]
#password=my_password
port=3306
#socket=MYSQL
#
[mysqld]
port=3306
#socket=MYSQL
skip-locking
#enable
Check the location of the configuration file (should be either c:\my.cnf ~
OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a
sample:
[client]
#password=my_password
port=3306
#socket=MYSQL
#
[mysqld]
port=3306
#socket=MYSQL
skip-locking
#enable-locking
set-variable = key_buffer
:43 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: NT service problem
Hi,
What version of MySQL are you trying to get up and running ? If this version
is the mysql max, You will have to run the standalone first in order to
create the InnoDB datafiles, then it should start as
Hi,
What version of MySQL are you trying to get up and running ? If this version
is the mysql max, You will have to run the standalone first in order to
create the InnoDB datafiles, then it should start as a service.
I have had this exact same issue and it seemed to go away once I have run
the