Lost connection to MySQL server during query

hi,all: we met a problem that: * Lost connection to MySQL server during query SHOW TABLE STATUS WHERE ENGINE='MyISAM' *sometimes it works well, sometimes not our mysql version is 5.0.84 our system is FreeBSD 6.2 thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/

ssl questions

I'm trying to set up my mysql 5.1 server to work over ssl, I'm following the directions at http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html. I've confirmed that my server supports ssl mysql> SHOW VARIABLES LIKE 'have_ssl'; +---+---+ | Variable_name | Value | +---

[ANN] Alpha release v05.09 of the BLOB Streaming Engine

Hi, Alpha version 5.09 of the BLOB streaming engine for MySQL has been released. The BLOB Streaming Engine is a MySQL storage engine which enables the storage and streaming of BLOB data directly in and out of a MySQL database. You can download the source code from http://www.blobstreaming.org/d

RE: Queue / FIFO in MySQL?

>-Original Message- >From: Gavin Towey [mailto:gto...@ffn.com] >Sent: Tuesday, September 08, 2009 1:41 PM >To: Allen Fowler; mysql@lists.mysql.com >Subject: RE: Queue / FIFO in MySQL? > >You can add a LIMIT n to your update clause. > >Regards, >Gavin Towey > >-Original Message- >Fro

RE: Queue / FIFO in MySQL?

You can add a LIMIT n to your update clause. Regards, Gavin Towey -Original Message- From: Allen Fowler [mailto:allen.fow...@yahoo.com] Sent: Monday, September 07, 2009 5:18 PM To: mysql@lists.mysql.com Subject: Queue / FIFO in MySQL? Hello, I need to create a system where records are g

How to remove stagnant stock returns?

Here there, One of my tables, called mr, looks like this, codendate mr 130042199402 0.96 130042199403 0.97 130042199404 0.95 130042199405 1 130042199406 1.1 130042199407 1 130042199408 1 130042199409 1 130043199205

RE: Tuning mysql concurrent running threads

Hello Mike, Thank you very much for your answer. MySQl is on Ubuntu server and i tried thread_concurrency=x, it doesn't work. Do you mean, i should configure MySQL with INNODB engine ? How to do that ? Thanks again ! Nabila -Message d'origine- De : mos [mailto:mo...@fastmail.fm] Envo

Re: Tuning mysql concurrent running threads

If you are talking about MyISAM tables, in my.cnf you can set the thread_concurrency=x where x=2*# of CPU's but this unfortunately only works on Solaris and not on Linux. It may work on Windows, I'm not sure. InnoDb has their own innodb_thread_concurrency variable that you can see the value

Re: Prevent execution of queries without a WHERE clause

Hi Darren, Once I knew the name of the command I could Google it and find all the relevant documentation, so I've put additional directives in place to override the limits on SELECTS. Thanks for the thought, though. On Tue, 2009-09-08 at 15:32 +0100, Darren Cassar wrote: > Hi, > > You can check

Re: Prevent execution of queries without a WHERE clause

Hi, You can check this feature out on section 2.9 on the mysql 5.0 certification guide (page 44). this feature has some side effects other than requesting a where with deletes and updates i.e. Quoting for whoever doesn't have the MySQL certification study guide 1.UPDATE and DELETE statments are a

RE: Prevent execution of queries without a WHERE clause

Thanks John, that's done the trick On Mon, 2009-09-07 at 18:24 +0100, John Daisley wrote: > Add the option 'safe-updates' to the mysql section of your 'my.cnf' / > 'my.ini' file and restart the mysqld service. > > [mysql] > Safe-updates > > Regards > > John Daisley > Mobile +44(0)7812 451238 >

Tuning mysql concurrent running threads

Hello, I have a mysql server where thousands of users connect. I configured max connections but i didn't found how to configure concurrent raunning threads. When i do show status, always RUNNING THREADS=1, even several threads are pending. How to change this please ? Anyone can help me