Brad Heintz wrote:
I've googled extensively, searched the list archives, and exhausted every
other avenue I could think of before posting to the list, but am no closer
to an answer. Does anyone have any ideas? Have I missed something in the
docs?
SELinux?
--
Florin Andrei
t's the only one currently maintained.
--
Florin Andrei
http://florin.myip.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
buy you so little performance gain, it's
> really not worth the hassle.
Wouldn't raw partitions fail less often if the power is yanked, just
because there are fewer components to fail?
I mean, if the database is on top of a FS, it's the database and the
FS that can fail. On a ra
ch extreme things like turning off the write
cache on the disk, because that would probably kill the performance.
But how about Ext3 with data=journal?
Using InnoDB would be better than MyISAM?
How about raw partitions?
Any other tips?
--
Florin Andrei
http://florin.myip.org/
--
MySQL General Ma
On Tue, 29 Mar 2005 20:39:54 -0800, Florin Andrei
<[EMAIL PROTECTED]> wrote:
> On Tue, 29 Mar 2005 19:28:56 -0800, bruce <[EMAIL PROTECTED]> wrote:
> >
> > we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are running
> > into some serious pr
e same situation, but it's probably even more complex.
If i were you, i would probably post on the fedora-test mailing list
and ask the same question.
Anyway, good luck and let us know how it goes.
--
Florin Andrei
http://florin.myip.org/
--
MySQL General Mailing List
For list archives:
't have much time to spend tweaking the system (upgrade
MySQL, recompile PHP, verify SELinux policies, etc.), but if there is a
really big performance difference, i may do the effort to upgrade MySQL
to the one offered in FC4-test.
--
Florin Andrei
http://florin.myip.org/
--
MySQL Gene
Anyone tried to use MySQL-4.0 and the precompiled PHP (the one from the
distribution packages) in Red Hat 8.0?
Any problems?
--
Florin Andrei
Many would-be screenwriters seem to have the impression that they can
write a script based only on an idea. This is similar to the impression
that many
the machine spends too much time just with switching context
between threads.
My question is: what's the reasonable limit of the number of client
connections to a MySQL server?
Am i going to get any benefit from upgrading to MySQL-4.0?
--
Florin Andrei
"The world is full of bad
ySQL to collect syslog stuff, and i
get _a_lot_ of messages; 30/second is not unusual, although i don't have
exact numbers.
You only need a reasonably fast CPU (i'm not saying get the latest one,
just don't use an old one) and a reasonably fast disk I/O.
And, yeah, don't index w
hen use this pattern to perform the search quicker.
Does this optimisation depend on the existence of an index on that
column, or is it used even without an index?
Either way, how big is the speed improvement?
--
Florin Andrei
"Cryptophiles had been so enrapture
roperly terminate
connections/flushing buffers), the init hierarchy would end up
SIGKILLing squid at the end, with the risk of terminating active
filedescriptors, etc.
You only have to SIGKILL it if indeed it takes an exagerated time to
shut down, and that means there's a problem hidden som
elay (like "sleep 2" or something like that) to the start
function in the init.d script. Or modify the start function to not
return until MySQL has booted up properly. Like:
while [it didn't started yet]; do
sleep 1
done
--
Florin Andrei
"You can get excited about just any
ate" into "current", then unlock "current".
Will it work this way?
I'm not sure what happens to locking after RENAME; if i lock "new" and
RENAME it to "current", will the lock be inherited by "current"?
--
Florin Andrei
You know you&
es" option, it works fine, thank you.
But now i have the same problem with MySQL-devel. In fact, i'm asking
you to make appropriate changes to all MySQL RPM packages, so that they
will provide "mysql-*", not only "MySQL-*".
The changes should be trivial, just as they were
Guys,
A while ago i asked you to modify the MySQL RPM package so that it will
also provide "mysql
--
Florin Andrei
"U is for Universe, everything there is. Possibly a large
computer simulation." - Alph
cking.
What is the answer to that (see message below)?
-Forwarded Message-
From: Robert Collins <[EMAIL PROTECTED]>
To: Florin Andrei <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: MySQL logging
Date: 29 Jan 2002 19:44:47 +1100
- Original Message -
From: "
On Wed, 2001-12-05 at 16:33, Arjen G. Lentz wrote:
>
> - Original Message -
> From: "Florin Andrei" <[EMAIL PROTECTED]>
>
> > SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM
> > event, iphdr, tcphdr WHERE event.cid = iphd
On Wed, 2001-12-05 at 15:01, Robert Alexander wrote:
> At 14:45 -0800 2001/12/05, Florin Andrei wrote:
> >The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
> >it run over night, in the morning i still didn't got any results, so i
> >killed the q
. But i want to use MySQL because i need
something that can do INSERTs very fast, and MySQL is very, very good at
this. The only problem is, it is slow when it comes to SELECTs on
multiple large tables, and i'm not sure how to optimize it for that.)
--
Florin Andrei
"Engin
g a modified Red Hat 7.1
kit, able to install itself directly on XFS, from here:
http://oss.sgi.com/projects/xfs/1.0_installer.html
--
Florin Andrei
-
Before posting, please check:
http://www.mysql.com/manual.php (
to leave it to you to test the gcc-2.96 binaries...
Regards,
--
Florin Andrei
"All operating systems suck.
Linux just sucks less" - an MIT guy
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
e package with
different name... no success.
Now, that's silly. Where can i find the required package?
What is the reason that you provide the MySQL-bench package if it cannot
be installed?
--
Florin Andrei
"All operating systems suck.
Linux just
t work with egcs/kgcc (same thing), but it's supposed to.
It does work with gcc, but it's not supposed to. :-)
Now what?
How are YOU building the RPM packages? Which distribution / compiler /
version / blah-blah ???
--
Florin Andrei
"All operating systems suck.
Linux just
" is available, and use the latter
instead)
--
Florin Andrei
"database, we have a problem"
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
t work (see previous problem).
What next? :-/
The patch for the .spec file that makes your binaries play well together
with the Red Hat collection :-P is attached to this message. It's just a
microscopic modification to the "Provides" line, and it shouldn't do any
harm. Please
: Bad exit status from /var/tmp/rpm-tmp.21106 (%build)
RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.21106 (%build)
[root@two /root]#
However, the compiler is installed, and it works (i have some other
programs build on that system).
database,sql,query :-P
--
Florin Andrei
I saw that MySQL now includes BDB in the source tree.
When will be released a binary package with BDB and transactions support
already compiled? I'm interested in the Linux, Irix and Windows
versions.
--
Florin A
y) will
surely send more.
> I've seen people
> report their MySQL installs doing hundreds or thousands of queries per
> second, and not even phasing the machine.
Ok, this sounds encouraging. ;-)
--
Florin Andrei
-
What is the maximum number of connections MySQL can handle?
I would like to use MySQL as a logging server, for some 500 machines,
but i'm not sure it is able to handle so many simultaneous connections
(the clients will do only INSERT or INSERT DELAYED).
--
Florin A
What happens if i use INSERT DELAYED and the client sends a lot of
messages, much more that mysql is able to handle?
(like when you log to a sql database, and you got lots of messages)
--
Florin Andrei
-
Before posting
31 matches
Mail list logo
