> > Pros? Cons? I know the windows box would need a good reboot now
> > and then and what is the performance hit on a WinTel 98/XP Pro
> > platform vs Linux? Looking at a 40K record database with maybe
> > 3 users at a time running 5-10 Large (length of the select
> > statment is over 500 chara
> Hi group,
>
> I have read in the MySQL manual that the client/Server
> Compression protocol adds some security to the application.
>
> Does anyone have more information on this?
>
It adds security by compressing the network trafic, which is more security
by obscurity, as this might stop a ca
I'd up your buffer sizes - the mysql manual has some clues as to setting
these values? You might want to increase the query cache size.
I'd then run it and watch the stats.
Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Hiya,
tried LD_ASSUME_KERNEL=2.2.5?
See here:
http://sources.redhat.com/ml/libc-hacker/2003-06/msg00032.html
May work, then again your machine may blow up! So use at your own risk as I
am guessing!
Greg
> -Original Message-
> From: Owen Scott Medd [mailto:[EMAIL PROTECTED]
> Sent: 03
Hi All,
I may be confused here but it would appear that when you issue a LOCK TABLES
tbl_name { READ|WRITE }; You cannot read from another unlocked table in the
same connection eg:
mysql> LOCK TABLES users read;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from Logger limit 1;
ERROR 110
Hi All,
I may be confused here but it would appear that when you issue a LOCK TABLES
tbl_name { READ|WRITE }; You cannot read from another unlocked table in the
same connection eg:
mysql> LOCK TABLES users read;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from Logger limit 1;
ERROR 110
> From: Michael She [mailto:[EMAIL PROTECTED]]
> > > I have no problems using MySQL as a lightweight database
> for simple
> > > chores, but I'm a bit weary about putting into a mission critical
> > > environment.
> >
> >Why, exactly?
>
>
> Mainly for 2 reasons:
>
> 1. MySQL hasn't been "proven
> From: Akash [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2003 11:52
> To: [EMAIL PROTECTED]
> Subject: how to write a scheduled job for MySQL
>
>
> Hi,
> I want to periodically delete some records from a table.
> Is there any
> mechanism by which I can schedule a job, which will execute a
Hi All,
Downloaded
mysql-standard-4mysql-standard-4.0.10-gamma-sun-solaris2.8-sparc.tar.gz.
If this is NOT installed in /usr/local/mysql and you try and start it using
support-files/mysql.server it fails with error:
$ ./support-files/mysql.server start
./support-files/mysql.server: /usr/local/my
Dear All,
It would appear that setting:
set-variable= open_files_limit = 200
Within the [mysqld] stanza in a data/my.cnf does not appear to work as
mysqld exits with:
ERROR: unknown variable 'open_files_limit = 200'
Yet a bin/mysqladmin variables has:
open_files_limit 0
I cannot fi
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
>
> Here's what I recently wrote about RAID tables. Try to ignore the
> funny markup. :-)
>
> snip lots of usefull stuff.
>
> Does that answer your question a bit?
>
Thanks Jeremy, I was a bit unsure as to RAID
> -Original Message-
> From: pwxgao [mailto:[EMAIL PROTECTED]]
> Subject: PERL/SQL, again? - Re: Procedures
>
>
I have been using languages like Smalltalk, Perl and Java for
about xx years. I am a huge fan of putting one in the DB for
embedded server procedures.
I also beleive the bes
> -Original Message-
> From: Marc Prewitt [mailto:[EMAIL PROTECTED]]
> Sent: 11 April 2002 14:46
> To: [EMAIL PROTECTED]
> Cc: paul
> Subject: Re: How to automate bin-log clean-up with replicated MySQL
> servers?
>
>
> PFIZER GLOBAL RESEARCH AND DEVELOPMENT
> --
You need to get logrotate to flush-logs otherwise mysql will still write to
the old file.
eg add after the create 0644 mysql mysql line:
postrotate
if test -n "`ps acx | grep mysql`";then
/path/to/mysqladmin -u logflusher -ppassword flush-logs
fi
endscript
Assuming a mysql users called
> From: Ramasubramanian [mailto:[EMAIL PROTECTED]]
> Hi,
> I tried to flush the logs but still the rotation doesn't happen.
> What else could be the problem ??
> I get the same message again
> My config file read like this
> "/var/log/mysqld.log" {
> ro
> From: Francois Joubert [mailto:[EMAIL PROTECTED]]
> Sent: 16 August 2002 14:46
> To: MySQL List
> Subject: Migrating Oracle To MySQL
>
> Hi
>
> I am new to the world of databases. We will be installing an Oracle9i
> database shortly as the backend for our current financial package. We
> hope t
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: 04 December 2001 12:47
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: 64bit mysql and gcc
>
>
> PFIZER GLOBAL RESEARCH AND DEVELOPMENT
> --
> -Original Message-
> From: Michael Widenius
> Yes; Our Solaris binaries are currently 32 bit.
>
Hi,
> The main reason for this is that I haven't seen any reports that gcc
> should be able to produce production quality code on 64 bit sparc.
>
I've been involved with 64bity stuff h
> -Original Message-
> From: Barry Roomberg [mailto:[EMAIL PROTECTED]]
A few notes:
> 1) All data is readonly. No write requirement except
> monthly load.
use myisam pack to compress the data / indexs.
Also use -rq --analyse --sort-index as myisam arguments to rebuild the index
> -Original Message-
> From: Richard S. Huntrods [mailto:[EMAIL PROTECTED]]
> I have database mysqldump outputs that were 15 megabytes (now 10 megs,
> as I removed some report storage from the system). I have restored my
> system from these dumps many, many times. I have 4 systems in u
20 matches
Mail list logo
