Re: temp table and view/function/procedure dilemma

2011-04-06 Thread petya
Hi, You can always create any table from procedures. However, it seems to me that flexviews can solve all of your problems, take a look at it. It will provide you incrementally refreshable materialized views. Peter Boros On 04/05/2011 08:15 PM, Bgs wrote: Hi all, I have a problem here and

Highest version of MySQL available for 2.4 kernel (RH/Cent OS 3.5)?

2011-04-06 Thread Hank
What is the highest version of MySQL available for a 2.4 kernel (Redhat/Cent OS 3.5)? And where can I find it to download? Thanks, -Hank

Re: temp table and view/function/procedure dilemma

2011-04-06 Thread S�ndor Hal�sz
2011/04/05 20:15 +0200, Bgs I have a temporary table which is a smaller table generated from a rather big one. The full table is too big to make real gimmicks on it, so I do need the temp table. Later I do several queries on the temp table. So my initial setup and needs are: - tempora

Re: efficient use of varchar?

2011-04-06 Thread petya
Hi, There is difference between varchar(63) and varchar(38). Instead of selecting MAX(LENGTH()) you can do PROCEDURE ANALYZE() on the table, which will tell you about the optimal record type for the data you currently have in the table. When you are using inreasonably large varchar columns,

Re: smsdrc

2011-04-06 Thread Santhosh Kumar
Hello Martin, I am using the supportable hardware only With Regards, Never Say No, Santhosh V.Kumar +919840411410 http://santhoshvkumar.110mb.com/ "I am because we are" On Wed, Apr 6, 2011 at 6:18 PM, Martin Gainty wrote: > Gammu currently supports: majority of Nokia phones from DCT3 generat

efficient use of varchar?

2011-04-06 Thread John G. Heim
Does it make any difference if I allocate a particular number of bytes for a varchar? I mean, just as an example, maybe its more efficient to use a power of 2 as the field length. Or maybe power of 2 minus 1. I'm guessing not and that anything less than 255 is the same. I'm converting some dat

Policies in the DBSPI MySQL OpenView on linux server

2011-04-06 Thread LACORRE, Joel
Hi everybody, I would like install the policies in the DBSPI MySQL OpenView on the server Linux. My server is SUSE Linux Enterprise Server 10 SP1 (i586). I know policies for db Oracle and MSSQL, but I don't know the policies MySQL who can be install for monitoring database. For this moment, the

MySQL - licensing data recovery environments

2011-04-06 Thread Radoulov, Dimitre
Hi all, does anybody know where can I find a recent guide/information regarding the licensing of data recovery environments with /MySQL Enterprise Server/? Regards Dimitre -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

smsdrc

2011-04-06 Thread Santhosh Kumar
Hi all, I did the connfiguration with my-sql gammu and try to hit a sms whenever changes happen in database I followed steps from the manual which I got from gammu site. When I give* gammu-smsd-inject +9840411410 TEXT -text "msg"* it is showing *written message with ID /var/spool/gammu/out