I have been looking high and low but am having trouble finding good
info. I need to try to lock down mysql with strong passwords
password expiry yadda yadda. I've looked at securich and am not sure
I want to use it.
All I really want is to prevent users from be able to change their
the proper gcc line is to link
everything in right is...
On Thu, Oct 24, 2002 at 10:36:49AM -0400, Anthony R. J. Ball wrote:
Hi all... I am attempting to play with the myisam
api to try to make loading hordes of data a little
simpler/faster, and so am trying out the myisam interface
... bah!
On Fri, Oct 25, 2002 at 01:32:14PM -0500, Paul DuBois wrote:
At 10:42 -0400 10/25/02, Anthony R. J. Ball wrote:
Does no one know how to compile a program with the myisam
library?
Not me. Never tried it. Maybe no one else has, either.
I will gladly put together a simple
Hi all... I am attempting to play with the myisam
api to try to make loading hordes of data a little
simpler/faster, and so am trying out the myisam interface...
specifically, eventually to try an wrap it in a perl
module. Herein lies my problem...
I know enough C to get by, but am having
Do you have the date field keyed in the table definition?
I assume you have numbers after the date, or text, otherwise
you should be doing an = without the %...
Really to speed it up you should have a date field you query on,
which is keyed, and whatever is in the record after the date
I just installed the 4.0.3 binary of mysql on our
solaris 2.7 development box, and whenever I do a show variables,
mysql crashes... I can view some variables, and going through
the list is seems that querying 'log_slave_updates' is the one that
is killing mysql...
mysql show variables like
Just out of interest, do you see the equivalent of a core file when this
happens? Or anything in the mysql logs?
Don't see any cores... here is the error log entry
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was
wrote:
* Anthony R. J. Ball
I am trying to figure out the best way to select
the row of data for a specific id that is the most
recent entry on or before a specific date.
What about:
SELECT * FROM table
WHERE
id = $specific_id AND
date = '$specific_date'
ORDER BY date
I just noticed that mysqldump -d outputs
/*!4 ALTER TABLE equity_ind1 DISABLE KEYS */;
at the end of the dump of the table def...
If I understand this correctly... this will be executed
by any version of mysql version 4 and up...
That would be fine, except that since it is not dumping
MySQL 3.23.41 on Solaris
Is it possible to select only the latest entries
from a table?
For instance I have a table of datasets that get
loaded each day. I want to find the latest date that
each dataset was loaded.
I thought maybe a join against itself might be the
answer, but this
I have a database of financial data that I am try to
match a holdings file against... The holdings file has
cusips that I look up in a lookup table to identify
what dataset/table they are in.
I need to check that the cusip is in the lookup
table, and that it has the proper type before
I
key buffer is about 8M
key_buffer_size | 8388600
I just tried bumping my settings up to these that I found in the
manual...
safe_mysqld -O key_buffer=64M -O table_cache=256 \
-O sort_buffer=4M -O record_buffer=1M
It shaved a second off... 2.29, and later call took
only .88
3.23.41 on Solaris
I have an indexed table of cusips (9 character identifiers)
which I am comparing against a lookup tables of over
1,000,000 securities, also keyed by cusip, both fields are
char(9) fields.
My query is taking over 3 seconds, which may be the best I
can do, but I'm hoping I
MySQL 3.23.41 on Solaris
Alright, I have a system where data comes in once... or maybe
a few times a day. I use this data to recreate a table, and then
I need to safely and quickly replace the old table. I was thinking
lock original table, drop it, and then rename the new table, but
I
Ahhh! Excellent. I didn't think my idea was quite right.
Thanks.
On Thu, Nov 15, 2001 at 09:32:38AM -0600, Paul DuBois wrote:
At 10:06 AM -0500 11/15/01, Anthony R. J. Ball wrote:
MySQL 3.23.41 on Solaris
Alright, I have a system where data comes in once... or maybe
a few times
I was just reading DOCS for MERGE tables... and they
look like exactly what I want.
I have a large lookup table that I use to track down
where I want to find my data, which gets loaded into
different tables at different times of the day
(financial data). Now I am loading all the data into
Ok, so to follow... Paul Dubois told me the little
RENAME TABLE trick to swap out a table... Will that work
on a table in a MERGE, or are there different hoops to
jump through?
On Thu, Nov 15, 2001 at 02:01:44PM -0800, Bill Adams wrote:
Anthony R. J. Ball wrote:
I was just reading
with the new merged table.
I will try it out tomorrow and see... no problems with it being
the same, I will be generating the tables from a perl script :)
On Thu, Nov 15, 2001 at 03:04:35PM -0800, Bill Adams wrote:
Anthony R. J. Ball wrote:
Ok, so to follow... Paul Dubois told me
Hi all, just thought I'd let people know. I recently
developed a way to pass protected config file data to
unprotected perl scripts (system user scripts/cgis).
The project can be found at
http://psc.sourceforge.net/
It is a C setuid wrapper that opens a protected file
and drops its
HAHA! You'll be a good example, since I'm pretty
sure you buy data from us... hehe.
FT Interactive Data
We use MySQL quite a lot and even manage to generate money once in a
while...
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408)
Unless you're going to have a LOT of users accessing a HUGE database, the
system you've outlined below will be overkill (do you have any current usage
statistics ? Are you using the system (is it an E450 ?) for any other
applications/processes ?).
It would be, if it was dedicated to
Now that our use of MySQL is being questioned (but
they are pretty much convinced). What the higher-ups
want to know is a few examples of medium to large
companies using mysql for mission critical stuff.
If any one can provide some I would be much appreciated.
We are a financial company
Hehe, yeah, I mentioned slashdot... for some reason,
they just weren't impressed :)
You know the type... unless they are a big money
company, then they can't be doing anything mission critical :)
www.livejournal.com www.slashdot.org www.everything2.com
--
___ __ ____ _ _
I have been getting this error quite a bit, and
keep losing my access to the database from my
persistent connection, it seems... any idea where
I should be looking to solve the problem?
Mysql 3.23.34 on Solaris 2.7
Error is:
010315 10:41:55 Aborted connection 27 to db: 'events' user:
24 matches
Mail list logo
