Enabling Slow query log in Mysql 5.0

2010-02-15 Thread Machiel Richards
Hi All I hope that someone can assist me with this. We have a client with a production MySQL database running MySQL 5.0. Their slow query counts have skyrocketed over the last week and I found that their slow query logs are

Re: Problems posting to the list lists.mysql.com

2010-02-15 Thread Octavian Rasnita
Is the MySQL mailing list admin subscribed to the list? I have also sent a message or more telling about this issue, with no response. -- Octavian "mos" wrote in message news:6.0.0.22.2.20100215120015.02cd4...@mail.messagingengine.com... > At 10:51 AM 2/15/2010, Frank Becker wrote: >>Hello, >>

Mainframe, AS400, COBOL and others

2010-02-15 Thread Helen Young
We work with your competitors and help them to reach their target audiences from companies using following technologies, Ø Companies running on mainframesØCompanies running on AS 400'sØCompanies with applications built in COBOL We also have other 1

RE: Mysql crashes, do not understand backtrace

2010-02-15 Thread Gavin Towey
When running with force-recovery, the database will indeed be read-only. This is on purpose. When you have an error of this nature, the procedure is to find a force-recovery level which allows you to start mysql, then export all the data. Then you can shut down mysql, wipe your innodb tablesp

Re: Problems posting to the list lists.mysql.com

2010-02-15 Thread mos
At 10:51 AM 2/15/2010, Frank Becker wrote: Hello, I tried to response to a posting on the list named in the subject. But it is rejected with the following message: SMTP error from remote mail server after end of data: host lists.mysql.com [213.136.52.31]: 552 spam score exceeded thresho

Re: how things get messed up

2010-02-15 Thread Ann W. Harrison
Martijn Tonies wrote: For example, the Firebird DBMS stores (longer) Blob data not right there in the record, so whenever you don't request the blob (that is, not selecting it), it ignores it completely and it can go through the file quickly. As do most of the MySQL storage engines. InnoD

Problems posting to the list lists.mysql.com

2010-02-15 Thread Frank Becker
Hello, I tried to response to a posting on the list named in the subject. But it is rejected with the following message: SMTP error from remote mail server after end of data: host lists.mysql.com [213.136.52.31]: 552 spam score exceeded threshold (#5.6.1) Neither this emailaddress is

Re: version 5 to 4

2010-02-15 Thread Peter Brawley
> i need this data in version 4 Create the mysqldump script with the --compatible-mysql4 option. PB - Prathima Rao wrote: hi mysql tem, i have a version 5 on which i have developed a database now one of the systmem has 4 i tried to migrate from 5 to 4 it says "THE TABLES HAVE BEEN C

MySQL University session on February 18: Performance Schema: Instrumenting Code

2010-02-15 Thread Stefan Hinz
Performance Schema: Instrumenting Code http://forge.mysql.com/wiki/Performance_Schema:_Instrumenting_Code This Thursday (February 18th, 17:00 UTC - note the different starting time!), Marc Alff will present the brand new Performance Schema: Instrumenting Code. Marc is the implementor of the Perfor

Mysql crashes, do not understand backtrace

2010-02-15 Thread Wesley Wajon
On one of the servers we maintain mysql recently crashed. In safe mode (innodb_force_recovery = 4) it runs but then you can't do any mutations to the databases. When we try to start it in normal mode it crashes and we do not really understand the backtrace. We eventually ended up in flushing a

Re: SQL query for unique values.

2010-02-15 Thread Manasi Save
Hi, A simple group by function should work for this: Select Fruit,GrownInStates From tbl1 Group By Fruit; and if you want grownstates in comma separated format then you can use Group_Concat function Select Fruit, Group_Concat(GrownInStates, SEPARATOR ',') From tbl1 Group By Fruit; Hope th

SQL query for unique values.

2010-02-15 Thread Ravishankar BV .
Hi, I'm very new to SQL and databases. I need a query for the following: (I'm sure google would have found the answer, but I could not really frame the sentence for the task I'm looking for. Also, please let me know how do I search in google for such tasks - so that I can try it myself in fut

Re: version 5 to 4

2010-02-15 Thread Glyn Astill
--- On Mon, 15/2/10, Prathima Rao wrote: > From: Prathima Rao > Subject: Re: version 5 to 4 > To: mysql@lists.mysql.com > Date: Monday, 15 February, 2010, 7:09 > hi mysql tem, > > i have a version 5 on which i have developed a database > now one of the systmem  has 4 > i tried to migrate fro

Re: how things get messed up

2010-02-15 Thread Martijn Tonies
Hi Ann, From: "Ann W. Harrison" Martijn Tonies wrote: For example, the Firebird DBMS stores (longer) Blob data not right there in the record, so whenever you don't request the blob (that is, not selecting it), it ignores it completely and it can go through the file quickly. As do most of t

Re: how things get messed up

2010-02-15 Thread Martijn Tonies
I am in the situation to storing student and staff images. every year 2000 new photos has to be added in our application. Can i have your suggestion, which is the best one, storing as a blob Or using NFS? It will be great help to me, because such experts are sharing your own experience on this

Re: how things get messed up

2010-02-15 Thread Martijn Tonies
Sounds logical, what's also nice to see, is that even though people here tend to say "don't put binaries in the database", apparently Facebook thought it would be nice to do so (for all sorts of reasons) and even took the time to write their own blob storage mechanism ;-) The whole point is t