Re: Trasfer SQL requests

2002-05-30 Thread Dmitry Alyabyev
Philip Mak wrote: > On Thu, May 30, 2002 at 05:53:03PM +0300, Dmitry Alyabyev wrote: >> Is it possible to set up one mysql server *only* for listening on >> socket and transfer client requests to another one server through >> network connection ? Of course I mean return re

Trasfer SQL requests

2002-05-30 Thread Dmitry Alyabyev
Hello Is it possible to set up one mysql server *only* for listening on socket and transfer client requests to another one server through network connection ? Of course I mean return results too :-) -- Dimitry - Before posti

Re[2]: Dropped database

2002-02-15 Thread Dmitry Alyabyev
Friday, February 15, 2002, 2:23:52 AM, Lars Heidieker wrote: > Just copy the backup files into the database dir and the database should be > back. Are you sure that it's not need to CREATE it first ? > At 08:22 AM 2/15/2002 -0500, Paul wrote: >>Hello mysql, >> >> I dropped an entire database

Re[2]: renaming a database

2002-01-30 Thread Dmitry Alyabyev
What would I do if there are InnoDB tables ? -- Dimitry Wednesday, January 30, 2002, 9:31:09 PM, Paul DuBois wrote: > At 11:10 -0800 1/30/02, JC wrote: >>-BEGIN PGP SIGNED MESSAGE- >>Hash: SHA1 >> >>I'm kind of interested to find if there is a way to rename a database >>with something

Re: server problems and CPU usage issues

2002-01-29 Thread Dmitry Alyabyev
Tuesday, January 29, 2002, 1:57:21 AM, David Piasecki wrote: > I have a server here that is troubling me - > I have a database server that is lagging no matter what I do. When I > start the server, I can watch CPU usage slowly creep up to 99% and it > never drops. The queries that are hitting t

Re[2]: 3.23.40 overload

2002-01-20 Thread Dmitry Alyabyev
Saturday, January 19, 2002, 9:21:04 AM, Jeremy Zawodny wrote: > On Fri, Jan 18, 2002 at 10:38:43AM +0200, Dmitry Alyabyev wrote: >> Hello >> >> Time to time I see strange overload of MySQL on dedicated >> server. The server is powerful enough to handle ~ 500 req/s.

3.23.40 overload

2002-01-18 Thread Dmitry Alyabyev
Hello Time to time I see strange overload of MySQL on dedicated server. The server is powerful enough to handle ~ 500 req/s. MySQL version is 3.23.40 and runs on Linux 2.4.16-SMP. The overload which I mean leds to stop answering to queries and looks like: 6:24pm up 6 days, 2:34, 2 users, l