Robert,
To stop a running query, you'll need to do a 'myqsladmin processlist'
and once you find the PID for the query, issues a "mysqladmin kill PID".
This should do the trick.
Thanks,
Ozette
Robert Citek wrote:
>Hello all,
>
>How do I stop a query once it has started without quitting the M
saraswathy saras wrote:
> Hi everybody,
>
> Can anybody help me?
I'll give it a shot.
> is there any other specific command instead order by ID DESC to select
> all the record from table where the ID is the last ID.The ID is
> autoincrement.
Try this:
select last_insert_id() as ID from TA
Patrick,
Try this from your shell:
You want to flush the tables (I'm assuming you want to keep the database
up and running), do a recover, safe recover, and check to make sure you
don't get the error messages when everything is finished.
$ mysqladmin flush-tables
$ myisamchk -r -o /var/lib/mys
Dan Nelson wrote:
> In the last episode (Mar 22), Ozette Brown said:
> > Andrey,
> >
> > Thank you for the reply.
> >
> > I read somewhere that when checking your maximum file descriptors your
>"kern.maxfiles
> > should be greater than kern.maxfi
ther mailing list entries where people have the exact same problem.
> > The only solution I received was to switch to a Linux OS.
> >
> > I've also read that there is a threading problem with FreeBSD+MySQL on
> > an SMP machine. I'm running a ma
ve also read that there is a threading problem with FreeBSD+MySQL on
an SMP machine. I'm running a machine with only 1 processor.
Do you have any idea as to what may be causing this problem and if so,
do you have a suggested so
MySQL Error: 1049 (Unknown database 'databasename')
I having a very weird unpredictable problem. I have a webserver which
makes database connections via Perl and DBI. For the most part it works
pretty much all the time but sometimes (2 or 4 times per month) it gives
an error: Unknown database
I'm in the process of converting all of my database tables from ISAM to
MYISAM table format. I'll run the mysql_convert_table_format script
which basically does an "Alter table". If during this conversion
someone accessed a web page which writes to the database (insert or
update), what will
>From time to time I seem to see error messages in my database.err log file
for MySQL.
020130 11:19:10 Aborted connection 40437 to db: 'xyz' user: 'abc' host:
`localhost' (Got an error reading communication packets)
I've been reading about the Morning Bug and here's what I extracted about it: