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
On Monday 10 October 2005 13:42, Hugh Sasse wrote:
> On Mon, 10 Oct 2005, Andrei wrote:
> > Hi list,
> >
Hi,
> > i have a linux server with mysql 4.1.14
> >
> > and i'm trying to execute a program wich read a file with 100's tohusands
> > line
ads_running| 1 |
| Uptime | 158850|
++---+
162 rows in set (0.02 sec)
Thank's,
Andrei
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
Is there any way to tell mySQL to return immediatly?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 02:44
Subject: Re: How does update low priority work?
>
If you execute UPDATE LOW PRIORITY table_name .. does mySQL automatically
return or does it wait for the update to execute? (that is, is it async or
sync)?
Andrei Cojocaru
[EMAIL PROTECTED]
-
Before posting, please check
There are no stored procedures in mySQL
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Pradeep.C.Pangi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 05:17
Subject: Regarding Store Procedures
> Hi All,
>
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
--+
2 rows in set (0.00 sec)
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 21, 2002 12:40 PM
Subject: Re: InnoDB, possible bug?
> Andrei,
>
> how many
try the command line version of the client first then a GUI based one
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Federico Coco" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 9:57 AM
Subject: Mysql Cli
I wouldn't know how likely it is to crash, but it will happen eventually,
nothing is perfect :(
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]>
To: "Andrei Cojocaru" <[EMAIL PROTECTED]>
u have heavy load, I
wouldn't use it.
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]>
To: "Andrei Cojocaru" <[EMAIL PROTECTED]>
Cc: "Sameer Maggon" <[EMAIL PROTECTED]>; <[EM
I believe mySQL uses B-Trees (not binary trees), that's about all I know :)
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Jan Peuker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 2:59 AM
Subject: MyISAM internal a
are you null terminating the string?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sameer Maggon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 7:51 AM
Subject: Binary Data mysql_real_escape_
> Hi,
> Ple
Try:
/usr/bin/mysql -uroot
then when you're connected type:
grant all on *.* to root@localhost identified by 'newpassword';
flush privileges;
and that should work
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Suresh Pun" <[EMAIL PROTE
Well how large is the BLOB field?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 2:51 AM
Subject: Performances with BLOB fields in mySql
> My application (C++, mySql++, WINNT) is ver
If I were you I would not store a binary file into the database, I'd store
the information required to fetch it from somewhere else like the mySQL
manual suggests
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]&g
d it doesn't use them at all. Could someone please
explain this to me and give me any advice on how to fix it?
Thanks for your help in advance.
words to bypass filter: sql queries
Andrei Cojocaru
[EMAIL PROTECTED]
---
lumns that are used in the query on the newsentries10
table and it doesn't use them at all. Could someone please explain this to me and give
me any advice on how to fix it?
Thanks for your help in advance.
Andrei Cojocaru
[EMAIL PROTECTED]
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
Hello fellow mySQL users,
I'd like to know if UPDATE/DELETE statements use indexes on the where
statement the same way as SELECTs.
If I build a SELECT using the WHERE statement that I use in an UPDATE/DELETE
statement, can I use that accurately to determine what indexes mySQL will
use?
Als
Hello fellow mySQL users,
I'd like to know if UPDATE/DELETE statements use indexes on the where
statement the same way as SELECTs.
If I build a SELECT using the WHERE statement that I use in an UPDATE/DELETE
statement, can I use that accurately to determine what indexes mySQL will
use?
Als
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: "
very
generic
CGI script for which the queries are completely controled by form
parameters. I cannot URL encode all returned values, also I can't
select a certain field and encde it without losing much of the generic
characteristic of the script.
=
ing. Andrei Boros
Centrul pt. Tehnologia
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
your local
machine.
You will also need openssl or ssleay and to create a certificate. Self
signed is acceptable.
Example:
MySQL runs on port 3306 and accepts connections only from localhost.
sslwrap runs on port 3305 and forwards to local port 3306.
=
ing. Andrei Boros
Centrul pt
our.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.
Given a Linux system without MySQL and without installing either the
source+compile or the binary ditribution on it, how can I install the
PERL modules on this system, so it can act as a client ?
Thank you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de
SERT, DROP ON logs.* TO 'www'@'localhost'
|
+---+
Why is it listed as "DROP" ?
User is able to do a LOAD DATA LOCAL INFILE ...
!!! Also, user is able to DROP tables in that datab
How can I install the perl MySQL module (along with DBI) on a system
that will only be used as a client without installing the MySQL source
tree ?
Thank you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
Is it possible to use in MySQL 3.23.xx data type DECIMAL with 20 (maybe
more) significant digits?
Tests so far failed above 16 digits.
Thanks you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
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
inputing data into my database
that will make more than one insert to more than one table ?
I already tried to build with autopilot 2 forms then copy all boxes
from one form to another. However, only the form's original fields
will be inserted into a table.
Thank you.
=
ing. Andrei Boros
Ce
hose features should be active for, but
no luck so far. Any ideas?
-Andrei
* Non-volatile, random-access, analog memory store... a book. *
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
Okay just checking a few basic things, have you indexed your table properly?
There is a manual section about performance, also make sure to play around
with the mysql configuration file (global one in /etc/my.cnf)
>From: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: MYSQL Problem
>Date: Mo
gt;
>>From: Sasha Pachev <[EMAIL PROTECTED]>
>>To: "Andrei Cojocaru" <[EMAIL PROTECTED]>
>>CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
>>Subject: Re: Problem - Possible Bug?
>>Date: Mon, 16 Apr 2001 08:25:26 -0600
>>MIME-Versio
as I said before I can give you root access on the machine which I believe
would be easier for you to disagnose the problem.
>From: Sasha Pachev <[EMAIL PROTECTED]>
>To: "Andrei Cojocaru" <[EMAIL PROTECTED]>
>Subject: Re: Problem - Possible Bug?
>Date: Mon
I suggest you get 3.23.36 it's the latest.
>From: "Thomas Morton" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Please assist me?
>Date: Mon, 16 Apr 2001 14:35:50 +0100
>MIME-Version: 1.0
>Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id
>MHotMailBCA4429B00C94004370AC0
ROTECTED]>
>Delivered-To: mailing list [EMAIL PROTECTED]
>Message-ID: <[EMAIL PROTECTED]>
>In-Reply-To: <[EMAIL PROTECTED]>
>References: <[EMAIL PROTECTED]>
>X-Mailer: VM 6.72 under 21.1 (patch 12) "GTK" XEmacs Lucid
>
>Andrei Cojocaru writes:
> &
Hello sorry for my ignorance but how do I apply a patch [diff file] to the
mysql source? Thanks for your help.
-Andrei Cojocaru
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
I suggest you try the mySQL C API and see if that works first.
-Andrei Cojocaru
>From: Luis E. Cruz Campos <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Problem with mysql++, Aborted (core dumped)
>Date: Mon, 16 Ap
I suggest PHP it's the easiest to learn.
>From: "Rolf Hopkins" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: www.kwwda.org
>Date: Mon, 16 Apr 2001 09:57:15 +0800
>MIME-Version: 1.0
>Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id
>MHotMailBCA3
dle_connections_sockets(0);
...
(gdb) info locals
No locals.
...
(gdb) up
#11 0x804b29d in _start ()
...
(gdb) info locals
No symbol table info available.
If any of the developers would like access to my machine, I can provide it
through ssh and you can see for yourself. I hope the solution
Did anybody succeed in compiling MySQL and Berkeley DB on a Slackware
7.x system and not get a SIGSEGV?
Please let me know how you did it.
Thank you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
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
hing
about staroffice.
Thank you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.
ysql, even before BDB
introduction, always the same error with a compiled server.
Please help.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
__
Do You Yahoo!?
Get email at your own domain with Yahoo! M
7ELF\1\1\1\0\0\0\0\0\0\0\0\0\3"..., 4096) = 4096
mmap(0, 233784, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x401a4000
mprotect(0x401dc000, 4408, PROT_NONE) = 0
mmap(0x401dc000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3,
0x37000) = 0x401dc0
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions
well I believe this has to do with the file descriptors, but I use RH 7.0
and you can change the file descriptor max under /proc/sys/fs/file-max and
inode-max
On Thu, 1 Feb 2001, Chuck Carson wrote:
>
> I was under the impression ulimit controlled this, but someone just told me
> that by defaul
does not matter you are signed up for this mailing list, to unsubscribe
send an email to [EMAIL PROTECTED] with any subject or
text message your heart desires, but make sure you use the email that you
are subscribed with on the mailing list
On Wed, 31 Jan 2001, Ha Linh Don wrote:
> HEllo,
>
> M
if my understanding is correct just have two joins using ors for the
categories :-)
On Tue, 30 Jan 2001, Beasley, Julien wrote:
> Hello everyone,
>
> I am in the process of building a search engine on a database. I have two
> tables that have a many-to-many relationship: A story table and a cat
on my server which runs an online game the values are all in the megabytes
On Wed, 31 Jan 2001, Tony Shiu wrote:
> I wonder the normalization and indexing of tables, Awa the complexity of
> queries submitted to server. For those variables you mentioned I use in
> production without significantly
nope sorry
On Mon, 29 Jan 2001, Ricardo Kleemann wrote:
> Hi everyone,
>
> I have twice posted a problem with replication and have since seen 2 or 3
> others post with similar replication questions and problems.
>
> However I have yet to see ANYONE respond to any of those posts.
>
> I dont u
Where can we find more information about gemini and when it will be done
exactly (date)?
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
increase the number of connections allowed, that might be it
On Mon, 29 Jan 2001, Leonardo Dias wrote:
> I don't know if any of you people have ever had this trouble, but it's
> been a messy one here.
>
> Whenever a website of ours get lots of traffic, MySQL gets too slow to
> connect. Whenever
so you want to list all of them starting with the highest level and going
up to the lowest level?
On Mon, 29 Jan 2001, Oliver Joa wrote:
> Hi,
>
> I have a recursive Problem. I have a Table with columns "id", "name" and
> "pid". E.g:
>
> name1
> name11
> name12
> name121
> name122
Where can I see a list of changes that were made in 3.23.3x versions of
mySQL?
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
rminal app?
> (various Unix shells.)
> i think i need a GUI to start though, don't you?
>
> At 11:48 AM -0700 1/28/01, Andrei Cojocaru wrote:
> >there is the mysql command-line client, it's under bin under the
> >mysql
there is the mysql command-line client, it's under bin under the mysql
base directory, it's called mysql on UNIX and mysql.exe on win32
:-) command line all the way!
ields, but I will also need to have an individual indexes on
those fields as well - is that a good way to do it?
-Andrei
As I was going up the stair, I met a man who wasn't there.
He wasn't there again today. I wish, I wish he'd stay away.
on_ID,Status | NULL |NULL | NULL | 10440 | where used
||
+--+--+---+--+-+--+---++
1 row in set (0.00 sec)
Why isn't it using index on the last query?
-Andrei
"When I get a little money, I
At 06:34 PM 1/20/01 -0800, Jeremy D. Zawodny wrote:
>MySQL does trailing whitespace removal on all VARCHAR data as
>described in the manual.
Hmm, well that presents a problem in my application that counts on exact
comparisons - I guess a way to do it is to use 'like' instead o
rch. Can
anyone shed light on this issue? This is with the 3.23.30-gamma.
-Andrei
* We are not a clone. *
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
87 matches
Mail list logo
