Hello
We have the following setup: a host A is running several web
applications from different customers, each application/customer
(virtual host) having it's own different incoming IP. A host B is
running a MySQL instance, which is being used by the applications on A.
Note that every
.
#!/usr/bin/perl -w
# Fre Sep 30 12:46:38 MEST 2005
(my $email='christian%jaeger,mine,nu')=~ tr/%,/@./;
use strict;
my $slave_socket= --socket=/var/run/mysqld/mysqld_safe.sock;
$0=~ /(.*?)([^\/]+)\z/s or die ?;
my ($mydir, $myname)=($1,$2);
sub usage {
print STDERR map{$_\n} @_ if @_;
print
At 22:26 Uhr -0600 25.03.2003, mos wrote:
How many people out there are willing to pay $$$ to see it done??
Please reply to this thread to see if there is a general interest
and how much it is worth to you.
IIRC, last time I looked, fulltext was not very good for i.e. the
german language. If
Hello
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this should be documented. (Or better yet, not do a
scripts were (and are still) not prepared to be
published either. Maybe it's still worth something, see below.
Christian.
Date: Mon, 22 Jul 2002 23:59:59 +0100
To: Heikki Tuuri [EMAIL PROTECTED], [EMAIL PROTECTED]
From: Christian Jaeger [EMAIL PROTECTED]
Subject: Re: Innodb and unbuffered raw io
At 15:11 Uhr +0300 07.01.2003, Do-Risika RAFIEFERANTSIARONJY wrote:
Hi everybody,
I have always these mysql.err.1 files not unlinked in all my
mysqlservers, and only a mysqld restart resolve these (nor reload
neither mysqladmin refresh doesn't unlink them).
Does anybody in the list encounter
Sorry, I've restarted mysql again and am seeing that it normally does
not only write mysql ended but a whole bunch of other lines to the
logs. So yes it is a problem.
Christian.
At 15:11 Uhr +0300 07.01.2003, Do-Risika RAFIEFERANTSIARONJY wrote:
Hi everybody,
I have always these mysql.err.1
take some time
until I get to package the sources, though. See
http://www.ethlife.ethz.ch/newcms
Christian.
--
Christian Jaeger Programmer System Engineer
ETHLife CMS Project - www.ethlife.ethz.ch/newcms - www.ethlife.ethz.ch
of time aside for testing (or maybe more, but who
would pay me?...:)
Cheers,
Christian.
--
Christian Jaeger Programmer System Engineer +41 1 430 45 26
ETHLife CMS Project - www.ethlife.ethz.ch/newcms - www.ethlife.ethz.ch
Hello
[ It seems the post didn't make it through the first time ]
While programming a journal in perl/axkit I realize that the problems
of both creating useful indexes for searching content efficiently and
parse user input and create the right sql queries from it are sooo
common that there
Hello
I read in
http://www.mysql.com/doc/I/n/InnoDB_Disk_i_o.html
that Innodb supports raw partitions on some unixes. We look forward to use innodb on
debian (intel): are linux raw partitions supported?
Is it wise to try to use linux2.4 raw partitions with innodb on a production system?
I
On Mon, 20 Aug 2001 22:24:26 +0300
Heikki Tuuri [EMAIL PROTECTED] wrote:
My impression comes from a MySQL AB computer
with Red Hat 6.2 (kernel something like 2.2.19).
From what I read, RedHat often patches their kernels with inofficial stuff (and the
famous inofficial/buggy gcc thing (in 7.0)
At 0:17 Uhr +0200 20.8.2001, David Tonhofer wrote:
4) Make sure user 'fred' has an account on machine 'foo'. Unfortunately
this must be an account with a shell :-(
You could probably write a pseudo-shell and put that into /etc/passwd (i.e.
#!/usr/bin/perl
while(STDIN){exit if /^exit$/m;
At 0:09 Uhr -0400 15.8.2001, Hans Zaunere wrote:
Well I uncovered an interesting thing. If I use the regular old
bin/mysql client to connect to the database (both on the same machine)
and I run: ./mysql -uroot -p -h localhost
Then run netstat -an , it shows that another /tmp/mysql.sock
At 16:41 Uhr -0400 14.8.2001, Hans Zaunere wrote:
sort of thing. Would it be better to just switch to TCP/IP sockets?
my $dbh = connect(DBI:mysql:database:localhost, user, password);
Well it seems like you ARE using INET TCP/IP sockets, since there is
'localhost' there (which goes over
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
innodb_data_file_path=ibdata1:200M
innodb_data_home_dir=f:/mysql/innodb/ibdata
innodb_log_group_home_dir=f:/mysql/innodb/iblogs
The directories specified in the above variables exist.
However when I try to run the service I get the error Could
At 15:08 Uhr +0100 19.7.2001, Peter Duffy wrote:
database table sql query
I guess that it's thinking the tablespace is already initialised.
Yes, probably: it's the same if you have an ibdata file and no log
files and start mysql-innodb. I've noticed this while setting up
innodb with filesystem
database,sql,query,table
Just to the record: I've written a small program too, and it reports
correct sizes for normal disk devices under both linux 2.2 and 2.4,
as long as the partition sizes don't exceed the 2GB limit (I don't
have large file support, since I use debian potato with just the
Was the table inaccessible during these 4 days? Or is mysql able to
still write to the table while it's being altered?
Christian.
At 12:08 Uhr -0700 9.5.2001, David J. Potter wrote:
occur very fast. We use both Windows and Linux. Adding a column is the
only action that is slow (it took 4
At 13:35 Uhr -0400 6.4.2001, Vivek Khera wrote:
... LIMIT '3',2
and resulting in a parse error. The fix was to call
$sth-execute($start+0,$howmany+0) and then DBI did the right thing.
A similar problem may occur if you use a text variable in a ==
comparison before passing it to execute. If
At 20:43 Uhr -0600 17.3.2001, Dan Nelson wrote:
In the last episode (Mar 17), Christian Jaeger said:
innobase table:
autocommit=0, rollback after each insert: 59 insert+rollback/sec.
autocommit=0, one rollback at the end: 2926 inserts/sec.
autocommit=0, one commit at the end
:
LinuxPPC June 1999, Kernel 2.2.17-0.6.1,
glibc-2.1.3-0j
gcc-2.95.3-2f
Innobase data is written to an IDE harddisk.
Cheers
Christian Jaeger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
As far I can tell, you have to rebuild from source.
BDB works very bad for me (linuxppc). Extremely slow and errors.
Christian.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
statedir=/home/mysql
--
Web Office
Christian Jaeger
Corporate Communications, ETH Zentrum
CH-8092 Zurich
office: HG J43 e-mail: [EMAIL PROTECTED]
phone: +41 (0)1 63 2 5780 [EMAIL PROTECTED]
home: +41 (0)1 273 65 46
sql
Thanks for any insights
Christian Jaeger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To
25 matches
Mail list logo