Prevent user from changing passwords?
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 password directly. If I can do that, then strong passwords, password expiry etc are all very trivial using some sort of script/webpage whatever to change passwords. Is there a way to prevent users from being able to change their password other than modifying the code to break set password? -- www.suave.net - Anthony Ball - a...@suave.net -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Excuse me. Haven't we met somewhere before? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: libmyisam help...
Does no one know how to compile a program with the myisam library? I will gladly put together a simple document on it for others if someone can just point me in the proper direction, i.e. which header files are required (I get a bunch of warnings if I just include myisam.h), and what 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... 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 some problems with getting the myisam lib linked right, and the includes right... Could someone give me the proper compiler arguments and header includes to get me started? I tried -lmyisam, but when I compile I get /tmp/ccTiEnWS.o: In function `main': /tmp/ccTiEnWS.o(.text+0x13): undefined reference to `mi_open' I would appreciate any help, I haven't been able to find any sample code online... I may even be able to release the perl module (if I can get it to work...) I am testing for now on Linux, but in the end I want this to work on Solaris... Here are the words sql and query, so this message will post ;) -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) These are the times that try men's souls. - T. Paine - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) These special effects aren't very special. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: libmyisam help...
Heh... it seems like a perfect solution to me... I am loading a few million records a day into tables... building a new table and swapping out the old... I have to process the data a little, so to speed it up I've been forking children and passing 1 record files to load into LOAD DATA INFILE to keep it paralell... I figure if I write it straight into the apam, I wont have to hassle with all the forking around, so to speak... may even pick up some speed. I'd eventually like to wrap it in perl possibly, but I can't even make a regular C program yet... blah. query and sql... 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 document on it for others if someone can just point me in the proper direction, i.e. which header files are required (I get a bunch of warnings if I just include myisam.h), and what the proper gcc line is to link everything in right is... -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) How many roads must a man walk down before you call him a cab? - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: libmyisam help...
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 some problems with getting the myisam lib linked right, and the includes right... Could someone give me the proper compiler arguments and header includes to get me started? I tried -lmyisam, but when I compile I get /tmp/ccTiEnWS.o: In function `main': /tmp/ccTiEnWS.o(.text+0x13): undefined reference to `mi_open' I would appreciate any help, I haven't been able to find any sample code online... I may even be able to release the perl module (if I can get it to work...) I am testing for now on Linux, but in the end I want this to work on Solaris... Here are the words sql and query, so this message will post ;) -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) These are the times that try men's souls. - T. Paine - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can anybody tell me!!!
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 should be in a separate field... On Fri, Oct 25, 2002 at 04:45:00AM +0300, svens wrote: Hello I have server Intel P-4 2,8Ghz 2Gb RAM so and I hve INNODB and table with 145000 records and when Im trying to query select * from bla where date like 20021025% order by date DESC limit 20 searhc time is 2,4 to 3,2 seconds what a hell is going on? What can I do to fast up these quesry requests ?? I cant imagine if my table will contain some of 96 rows it will search my query a hundred years is it some way to get resuls faster -- much more fuster ?? - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) The trouble with reality is, there's no background music. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SHOW VARIABLES bug in 4.0.3 on solaris 2.7?
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 'log_slave_updates'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:12 Current database: *** NONE *** ERROR 2013: Lost connection to MySQL server during query mysql 020909 11:30:54 mysqld restarted Any ideas? -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Scream. I'll save you later. The Doctor, No Future. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SHOW VARIABLES bug in 4.0.3 on solaris 2.7?
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 linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=201322496 read_buffer_size=8192 sort_buffer_size=33554424 max_used_connections=11 max_connections=100 threads_connected=12 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3474203 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 020909 11:30:54 mysqld restarted 020909 11:30:55 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. 020909 11:30:55 InnoDB: Started /idcom/mysql-max-4.0.3/bin/mysqld: ready for connections -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) The mind boggles...the taste buds shudder. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting the most recent record per id before date X
Ack, sorry (to you and Gurhan)... I've done this trick, but I was actually looking at it with more than one ID, hence the group by... either select from a whole table for a date or joining against another table with the desired ids... On Thu, Apr 04, 2002 at 06:59:30PM +0200, Roger Baklund 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 DESC LIMIT 1 -- Roger query - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) You can't jump a canyon in two leaps. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Possible bug in mysqldump -d on mysql-max 4.0.1
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 data, if you use this verbatim, there is no ENABLE KEYS at the bottom, like when you dump the table with the data. Is that right? Or does the disable keys only work for the life of the connection or something like that? -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) I am a mental tourist. My mind wanders. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting only the latest entries in a table...
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 doesn't seem to work :) SELECT B.* from lkup_info AS A, lkup_info AS B WHERE A.did = B.did AND MAX(A.date) = B.date GROUP BY A.did; But that is basically what I want... Is this possible, or do I need to maintain a table for latest updates? -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) It's the same thing said Pooh. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem restricting a large left join...
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 grab any external info on it. The problem is that I have a highly normalized structure, and am using left joins so that I can retain the info from the holdings file and just not get the extended data. The table structure is a follows... Holdings +-lookup +-lookup info +-datasets +-dataset types I left join the holdings to the lookup file on cusips, then get the ids to left join into the info table which links cusips to their datasets. I left join down the line until I get the type. The problem is... I want everything beyond the holdings table to fail if the cusip is not present or if it is present and the type specified in the holdings file does not match the type at the end of the chain. Can this be done? The current query I am working with is below it is trying to get a summary of all the types with their counts. But one group of cusips is under treas type and corp type, and if you ask for treas type it also counts it under Unknown because of the corp fork... SELECT IFNULL(T.type,'Unknown') as type,COUNT(DISTINCT H.cusip) FROM $table AS H LEFT JOIN pool_lookup.lkup AS L ON H.cusip = L.cusip LEFT JOIN pool_lookup.lkup_info AS I ON I.lid = L.lid LEFT JOIN pool.datasets AS D ON D.did = I.did LEFT JOIN pool.dataset_types AS T ON T.tid = D.tid AND T.type = H.type GROUP BY T.type ORDER BY T.type; -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Brought to you by the anarcho-syndicalist commune. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query speed seems wrong...
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 seconds once it was cached... This is running on a solaris box with... I believe 16 processors and 6 gigs of ram... Although... it is by no means dedicated to MySQL :) How large is your key buffer? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 74 days, processed 1,610,499,363 queries (249/sec. avg) - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Life is fragile, handle with prayer. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query speed seems wrong...
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 am missing something. Also, unless I use STRAIGHT_JOIN, it takes MUCH longer, since the optimizer is starting with the 1,000,000 record table (which is a MERGE table, BTW). The explains look like: mysql explain select lid from TEST_1006199805 AS A, pool_lookup.lkup AS L WHERE A.cusip = L.cusip; +---++---+-+-+-+-+-+ | table | type | possible_keys | key | key_len | ref | rows| Extra || +---++---+-+-+-+-+-+ | L | ALL| cusip | NULL|NULL | NULL| 1296422 | || | A | eq_ref | PRIMARY | PRIMARY | 9 | L.cusip | 1 | Using index || +---++---+-+-+-+-+-+ mysql explain select lid from TEST_1006199805 AS A STRAIGHT_JOIN pool_lookup.lkup AS L WHERE A.cusip = L.cusip; +---+---+---+-+-+-+--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+-+-+-+--+-+ | A | index | PRIMARY | PRIMARY | 9 | NULL| 1995 | Using index | | L | ref | cusip | cusip | 9 | A.cusip | 768 | | +---+---+---+-+-+-+--+-+ I'm not sure what the 768 rows in L is, since all but 4 of the 1995 records in A have matches L... though sometimes there will be more than one match, but not more than 4 or so... Any suggestions on speeding this up? -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) An attacker must vanquish, a defender need only survive. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replacing a table safely...
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 wasn't sure the lock would stay once the table was dropped. Is this the right way to go about it? -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Do not follow in the footsteps of men of old; seek what they sought. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replacing a table safely...
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 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 wasn't sure the lock would stay once the table was dropped. Is this the right way to go about it? Use RENAME TABLE to rename them both in the same statement, then drop the old one: RENAME TABLE t TO t_old, t_new TO t; DROP TABLE t_old; RENAME TABLE is available as of MySQL 3.23.23. -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Do not follow in the footsteps of men of old; seek what they sought. -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) I am not a number! I am a free man! -- The Prisoner - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Should I use a MERGE table?
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 one table, but since this table needs to stay available I have to insert into it with lots of keyed data. I am thinking that I can create a new table, and replace the proper underlying table with the new data. That way I don't slow doen the lookup table when I am loading, and I can load my data MUCH faster by loading with no keys. Am I right in thinking this way. So I can make a muni lookup and a CMO lookup and an MBS lookup but just select from the merged table for a cusip in any of them? This is all read only data (except the initial load) This would be very good... since I want the data to load quick, and may be loading hundreds of thousands of records at a time. Thanks! -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Don't crush that dwarf! Hand me the pliers! - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Should I use a MERGE table?
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 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 one table, but since this table needs to stay available I have to insert into it with lots of keyed data. I am thinking that I can create a new table, and replace the proper underlying table with the new data. That way I don't slow doen the lookup table when I am loading, and I can load my data MUCH faster by loading with no keys. Am I right in thinking this way. So I can make a muni lookup and a CMO lookup and an MBS lookup but just select from the merged table for a cusip in any of them? This is all read only data (except the initial load) This would be very good... since I want the data to load quick, and may be loading hundreds of thousands of records at a time. Merge table sound like they fit the bill. Beware that they are very finicky and the columns MUST be the same and the index order must be the same. Search the lists (esp. for my name) for more info. b. -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Once I thought I was wrong - but I was mistaken - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Should I use a MERGE table?
Hrm... so it is going to need to rebuild all the indexes, not just the table I am adding... doh... oh well, should still be faster, I'd guess. Probably my best bet in this case is to create a new merged table with the new table and all the other old ones, then replace the old merged table 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 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? Your table names need to be unique. Then it should work just fine. o If you do rename a table that is part of the merge, you will need to rebuild the merge table. o If you want to reindex the tables that are merged, be sure to either drop the index in the merge table or drop the merge table BEFORE you reindex the real tables. This is not fatal if you forget: just you might get weird errors. o If you do a SELECT ... WHERE indexed_column=value and get back a bunch of records where everything is blank, your indexes (or possibly columns) are not the same between the real tables and/or merge table. Remember ORDER MATTERS! b. On Thu, Nov 15, 2001 at 02:01:44PM -0800, Bill Adams wrote: Anthony R. J. Ball wrote: 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 one table, but since this table needs to stay available I have to insert into it with lots of keyed data. I am thinking that I can create a new table, and replace the proper underlying table with the new data. That way I don't slow doen the lookup table when I am loading, and I can load my data MUCH faster by loading with no keys. Am I right in thinking this way. So I can make a muni lookup and a CMO lookup and an MBS lookup but just select from the merged table for a cusip in any of them? This is all read only data (except the initial load) This would be very good... since I want the data to load quick, and may be loading hundreds of thousands of records at a time. Merge table sound like they fit the bill. Beware that they are very finicky and the columns MUST be the same and the index order must be the same. Search the lists (esp. for my name) for more info. b. -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Once I thought I was wrong - but I was mistaken -- Bill Adams TriQuint Semiconductor - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) I don't suffer from insanity, I enjoy every minute of it. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A Way to protect DBI passwords in perl
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 priviledge, then execs the proper perl script leaving the filehandle available to it. There is then a module Config::Secure, which initializes the script and optionally parses the conf data. I originally came up with this idea in the search for a way to pass DBI passwords to scripts that needed to be available to users but connected to a database, so I thought others here might appreciate it. It is still alpha, but I would appreciate any input. The project is all GPL, free for use. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) A clear conscience is usually the result of bad memory. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need examples of companies using mysql
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) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Corruption. The most infallible symptom of liberty - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need examples of companies using mysql
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 mysql :) One of their concerns is load testing, which we haven't done a lot of yet. I'm confident it'll hold up, I am a little worried it may generate enough load to annoy them, but worse comes to worse we can set up a dedicated box. -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) I/O, I/O, it's off to work we go... - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need examples of companies using mysql
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 using mysql to back a bunch of our new fast-cgi stuff that is about to be opened to users, so anything in that genre would be all the better. Examples of generally what kinds of machines there are run on could be cool too, but by no means necessary. We are currently running on Solaris 2.7 with like, 4 processors and 4 gigs of RAM, I myself have full faith in mysql. Thanks - Ant -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Go ahead, jump. 100,000 lemmings can't be wrong. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need examples of companies using mysql
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 -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) "DesqView!" ...Gesundheit. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Got an error reading communication packets
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: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 10:41:55 Aborted connection 2 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 12:57:26 Aborted connection 41 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 12:57:26 Aborted connection 42 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 13:29:28 Aborted connection 56 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 13:29:28 Aborted connection 57 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 14:39:23 Aborted connection 5 to db: 'dashboard' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 14:58:40 Aborted connection 58 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 14:58:40 Aborted connection 59 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Money talks: Mine says goodbye! - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php