Remote APIs
Hey there. Wanted to know what security is built into MySQL with respect to writing SQL to remote tables. I have clients that want reads and writes to their tables, but I don't want to share their information. Any idea what I can do? Any SSL type implementation from rdbms to rdbms? Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - 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: sysctl process limitations
On Sat, Feb 02, 2002 at 09:14:27PM -0700, Randy Arabie wrote: I don't think so. I raised the limit for mysqld descriptors to 5000. # sysctl -w proc.220.rlimit.descriptors.hard=unlimited # sysctl -w proc.220.rlimit.descriptors.soft=unlimited The kernel maxfiles was already set to 5000. Those commands raised the limit for process 220 (mysqld) to 5000. And, the load still fails with Errcode: 23. This is really strange, I suspect the '23' isn't an error code from sys/errno.h then. Sorry, I don't have more ideas. I have mysqld with several databases, and I don't have problems with it ... -- Manuel Bouyer [EMAIL PROTECTED] -- - 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: Fulltext problems 4.0.1 part two (fwd)
I found out, that the fulltext engine is misbehaving with less than 5 entries. Seems to me, that this is exactly the same case... Perhaps a flush inside the engine or so isn't made with such less entries? The bug is also in 3.23 gamma. Workaround: Enter more rows to fix it. :) I send this bug 1 month ago to the developer who has done the fulltext engine (I just forgot the name and the adresses are in the company - a russian name). Perhaps I should have sent it better to bugs... -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris -- Forwarded message -- Date: Sat, 2 Feb 2002 11:41:36 +0300 From: Alexander Belyaev [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Fulltext problems 4.0.1 part two Hello, I have found a bug( or bad feature? :) ) in 4.0.1 boolean fulltext search Please help... Test case with table can be found at http://logo.nino.ru/fulltextbug.tar.gz Alexander ( sql database query table for you, spam protector:) -- show variables like 'ft%' -- +--++ | Variable_name| Value | +--++ | ft_min_word_len | 2 | | ft_max_word_len | 254| | ft_max_word_len_for_sort | 20 | | ft_boolean_syntax| + -()~*:| | +--++ 4 rows in set (0.00 sec) -- show index from logo_text -- +---++--+--+-+-- -+-+--++--+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++--+--+-+-- -+-+--++--+ | logo_text | 0 | PRIMARY |1 | id | A | 38347 | NULL | NULL | | | logo_text | 1 | |1 | txt | A | 38347 |1 | NULL | FULLTEXT | +---++--+--+-+-- -+-+--++--+ 2 rows in set (0.00 sec) -- check table logo_text -- ++---+--+--- --+ | Table | Op| Msg_type | Msg_text | ++---+--+--- --+ | test.logo_text | check | warning | Found 38347 parts Should be: 0 parts | | test.logo_text | check | status | OK | ++---+--+--- --+ 2 rows in set (0.40 sec) -- repair table logo_text -- +++--+--+ | Table | Op | Msg_type | Msg_text | +++--+--+ | test.logo_text | repair | status | OK | +++--+--+ 1 row in set (3.02 sec) -- check table logo_text -- ++---+--+--- --+ | Table | Op| Msg_type | Msg_text | ++---+--+--- --+ | test.logo_text | check | warning | Found 38347 parts Should be: 0 parts | | test.logo_text | check | status | OK | ++---+--+--- --+ 2 rows in set (0.45 sec) -- select id,txt from test.logo_text where match(txt) against ('+desig* +service' in boolean mode) -- +---+--- -+ | id| txt | +---+--- -+ | 26570 | wave design a full service design agency seth brewer http://www.wavedesign.com | | 38847 | manucom hands on it service j.shannon design | +---+--- -+ 2 rows in set (0.03 sec) -- select id,txt from test.logo_text where match(txt) against ('+design +service' in boolean mode) -- +---+--- -+ | id| txt | +---+--- -+ | 1405 | design service ?? ?? | | 1480 | edv-service grafik-design | | 26570 | wave design a full service design agency seth brewer http://www.wavedesign.com | | 38847 | manucom hands on it service j.shannon design | +---+--- -+ 4 rows in set (0.03 sec) Bye - Before posting, please check:
Arabic Charset support.
Hi all, When will Arabic charset be included as a supported charset? Anyone solved this problem? sql : this word is needed by the lists filter. Waheed - 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
Regarding BLOB class
Hello sir, We are using Mysql database for our applications.We are very happy to use this and it's havingvery good features. But one thing i would like to know, in my application i want to store files(like resumes)into the database and i want to open it from browser(IE). while retieving the file we are getting gunk characters,to avoid this we want to use one BLOB class like we have a class in java.sql package.Oracle is supporting this,so in mysql we have any options to solve this problems.If you have any solutions please try to help me to solve this problem. thanks for your cooperation bye madhu sudhan.a - 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
Selecting several columns using DISTINCT
I am trying to normalize some MySQL tables and need to move a few columns from one table to another while maintaining the relationship between the two. I realize I cannot do a subselect, but in effect what I am wanting to do is to select the Distinct rows for the column ProductID and then select the columns from the rows that are found by the DISTINCT. This is the kind of query I have in mind: SELECT DISTINCT ProductID (SELECT ProductID, SmImage, ProductName, Description, LgImage WHERE ProductID=ProductID) FROM productSKU How do I rewrite this query to get what I am after? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - 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
SQL question regarding JOIN
I have two tables, one contains user account info the other contains active sessions in a web app. In the user account table I have a column that contains each user's 'access level'. I'm somewhat new to relational databases and SQL, and though the following is working for me, I want to find out if it is the best way to handle it. Obviously, during the user's session it is often necessary to determine their specific access level. Right now I am doing it in this fashion... The session table looks like this: session_id int(10) primary key, username varchar(16) 'this is the foreign key related the user table' created datetime, updated datetime The user table looks like this: username varchar(16) primary key, password varchar(16), firstname varchar(30), lastname varchar(30), email varchar(100), access int(10) So when I need to determine the access level of a user during a given session I use the following query: select user.access from user, session where session.session_id = '$id' and session.username = user.username; This is working fine right now... but exactly how it is working and/or what it is actually doing still confuses me a little bit. The reason I did it this way is because at any given time I know the $id (session id) variable. It seemed more elegant to do it as a join rather than first grab the username from the session table with a select statement, and then use the username to grab the access level from the user table with another select statement. Is this a good looking query?? Or is there a better way to do this? Thanks! - Ben - 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
Bandwidth Throttling - a followup
A few weeks ago I posted a question regarding bandwidth management for a very busy mysql server that is swamping my cable modem upload bandwidth and impacting the rest of my network. I was seeking a way to manage connections by capping the data transferred and I wondered if this would impact MySQL. The consensus was no, and that was good :) Even though my solution had nothing really to do with MySQL I want to post it here in case anyone else has a similar situation. I thought that I needed to modify my ipchains firewall rules, when in fact what I really needed to do was built into iproute2 traffic shaping commands.FYI tc qdisc was exactly what I needed. Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - 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: Bandwidth Throttling - a followup
Yes, the other option is to move it to a server with more bandwidth :) Most People that are running it from home either don't know how or don't know that they are running a firewall or have an ISP that won't let them touch the configuration of the modem/router. So you are one of the lucky ones. -Original Message- From: Gary Huntress [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 03, 2002 10:21 AM To: [EMAIL PROTECTED] Subject: Bandwidth Throttling - a followup A few weeks ago I posted a question regarding bandwidth management for a very busy mysql server that is swamping my cable modem upload bandwidth and impacting the rest of my network. I was seeking a way to manage connections by capping the data transferred and I wondered if this would impact MySQL. The consensus was no, and that was good :) Even though my solution had nothing really to do with MySQL I want to post it here in case anyone else has a similar situation. I thought that I needed to modify my ipchains firewall rules, when in fact what I really needed to do was built into iproute2 traffic shaping commands.FYI tc qdisc was exactly what I needed. Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - 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 - 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
Edit a MySQL Record
How would I go about editing a certain record in a MySQL database; Items? I want to be able to change a value that was already inserted into the table. -Nick McBride __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com - 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: Edit a MySQL Record
This topic is covered quite well in the manual. http://www.mysql.com/doc/U/P/UPDATE.html On Sun, 3 Feb 2002 08:58:33 -0800 (PST), Nick McBride wrote: How would I go about editing a certain record in a MySQL database; Items? I want to be able to change a value that was already inserted into the table. -Nick McBride - 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: Edit a MySQL Record
Here you go... update MyDB set FIRST_NAME = JOE, LAST_NAME = BLO where RECNO = - Original Message - From: Nick McBride [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 03, 2002 8:58 AM Subject: Edit a MySQL Record How would I go about editing a certain record in a MySQL database; Items? I want to be able to change a value that was already inserted into the table. -Nick McBride __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com - 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 - 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: Edit a MySQL Record
Nick, How would I go about editing a certain record in a MySQL database; Items? I want to be able to change a value that was already inserted into the table. You neglected to mention which tool(s) you have at your disposal. SELECT the pertinent row. View the data. Amend it as required. UPDATE the row with the changed data. Regards, =dn - 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
Data Logging based on MySQL using serial Interface
I'm receiving ASCII Data Records (Microsoft CSV Format; Delimiter = ;) through the serial interface of a linux-based pc. Now I'm seraching for a script or program to put this records in a mysql database. Peter - 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
Memory Leaks ?
HI, Firstly I hope this is the right list as the enquiry I have I do not class as a bug due to my uncertainty about where the problem lies. I have been using the C API for MySQL 2.22.32 on Linux 2.2.14 and I have noticed that my program was getting to an unmanageable size in memory, there is a steady increase in size. Admitedly I am playing with reasonable amounts of data ( repeated calls retreiving 2000+ rows) however I am using the mysql_free_result on every MYSQL_RES that I am using and I am still seeing the program incerase in size. Usually I would blame this on myself for forgeting to free some malloc'ed memory however after running an mtrace on the program it returns rather a lot of the following lines: 0x084ac688 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084ae670 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084b0658 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] 0x084b2640 0x1fe4 at /lib/libmysqlclient.so.10:(my_malloc+0x2a)[0x4002aa7a] which leads me to beleive that there maybe an issue with the my_malloc function in the client lib. Am I completely incorrect ? has anyone seen this before and if so how is it cured as my program is running out of memory within 5 mins of starting. thanks Iain Machine Spec: Athlon 800 (over clocked to 1Ghz) 300Mb RAM (ish) SuSE Linux 2.2.14 gcc V2.95.2 ld V2.9.5 - 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
simple backup methods: how to test for success
I realize this is a very elementary question and explained somewhat in the mysql manual. The manual describes three different methods for backing up databases Copying the files themselves using mysqldump to dump all the tables into a single file using mysqlhotcopy The most straightforward way from an admin's point of view is just to copy the directories containing the tables. I couldn't get mysqlhotcopy to work on first try, but mysqldump did exactly as advertised. Are there any reasons to avoid the first solution (which is obviously the easiest)? I understand you'd probably need to turn mysqld off while you are running this (which is no problem for me). . How would you test if copied files could produce a viable backup? Is it as easy as changing the name of the db and then trying to access the tables? Robert Nagle - 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
mysql crash during large insert from MYIASM to INNODB table.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I just started using innodb tables to help with some locking problems. The table I am trying to convert is large (100 Million rows, 23 GigByte). I setup 20 2Gig ibdata files. (I choose a size of 2 Gig as this is the maximum size I can easily transfer to another machine for backups. The files system can handle larger files). I did create a new table, and transfered the old table to the new tables using 'insert into newtable select * from oldtable'. (as a test, I did try 10 Million rows first which worked fine and took about 30 minutes). After a while (1 hr?), mysql crashed. Here are the details: Resolved stack: 0x80b39c6 handle_segfault__Fi + 406 0x4003b935 _end + 937197517 0x8184f3f fil_io + 607 0x816ca99 buf_read_page + 89 0x8164e3a buf_page_get_gen + 278 0x814a835 btr_cur_search_to_nth_level + 1101 0x812a970 ibuf_insert_low + 1256 0x812b2a0 ibuf_insert + 380 0x814a89a btr_cur_search_to_nth_level + 1202 0x812d6fb row_ins_index_entry_low + 143 0x812dbc8 row_ins + 504 0x812dd30 row_ins_step + 272 0x812e697 row_insert_for_mysql + 151 0x80fbc82 write_row__11ha_innobasePc + 394 0x80de7ff write_record__FP8st_tableP12st_copy_info + 527 0x80e036d send_data__13select_insertRt4List1Z4Item + 93 0x80dd68f end_send__FP4JOINP13st_join_tableb + 111 0x80d8788 sub_select__FP4JOINP13st_join_tableb + 240 0x80d84a1 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 393 0x80d1a75 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemRt4List1Z15Item_func_matchP8st_orderT5T3T5UiP13select_result + 6953 0x80bb154 mysql_execute_command__Fv + 5736 0x80bcb77 mysql_parse__FP3THDPcUi + 211 0x80b9252 do_command__FP3THD + 1286 0x80b8798 handle_one_connection__FPv + 632 /usr/local/mysql/libexec/mysqld: ready for connections InnoDB: Assertion failure in thread 38951 in file fil0fil.c line 977 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist 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=402649088 record_buffer=2093056 sort_buffer=2097144 max_used_connections=45 max_connections=200 threads_connected=6 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1211610 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x80b39c6 0x4003b935 0x8184f3f 0x816ca99 0x8164e3a 0x814a835 0x812a970 0x812b2a0 0x814a89a 0x812d6fb 0x812dbc8 0x812dd30 0x812e697 0x80fbc82 0x80de7ff 0x80e036d 0x80dd68f 0x80d8788 0x80d84a1 0x80d1a75 0x80bb154 0x80bcb77 0x80b9252 0x80b8798 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0xbf602658 is invalid pointer thd-thread_id=3604 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 3604 did to cause the crash. In some cases of really bad corruption, the above values may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 0 020203 20:10:16 mysqld restarted 020203 20:10:16 Can't start server: Bind on TCP/IP port: Address already in use 020203 20:10:16 Do you already have another mysqld server running on port: 3307 ? 020203 20:10:16 Aborting 020203 20:10:16 /usr/local/mysql/libexec/mysqld: Shutdown Complete 020203 20:10:16 mysqld ended - As I start things back up, here is what is happening: 020203 20:15:03 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 2 3711717251 InnoDB: Doing recovery: scanned up to log sequence number 2 3711782400 InnoDB: Doing recovery: scanned up to log sequence number 2 3711847936 InnoDB: Doing recovery: scanned up to log sequence number 2 3711913472 InnoDB: Doing recovery: scanned up to log sequence number 2 3711979008 (more like this ommited) InnoDB: Doing recovery: scanned up to log sequence
Re: simple backup methods: how to test for success
On Monday 04 February 2002 03:46, Robert Nagle wrote: I realize this is a very elementary question and explained somewhat in the mysql manual. The manual describes three different methods for backing up databases Copying the files themselves using mysqldump to dump all the tables into a single file using mysqlhotcopy The most straightforward way from an admin's point of view is just to copy the directories containing the tables. Except that mysql won't know there's a database in the new directory. And the only way to tell it (that I know) is to CREATE TABLE. Which means recreating the schema, the data, and then the indices. And you have to lock the tables and flush them first. Look in the archives for my simple script for all this, it also works better than the next two solutions. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:96818:200201:eakgpmohmnggidifgola I couldn't get mysqlhotcopy to work on first try, but mysqldump did exactly as advertised. Yes it does, but if you have a really big database it's not much help, since your text dump will be (a) too big to fit on your hard drive and (b) devoid of indexes, which may then require days to regenerate. My script or monty's mysqlhotcopy works better. Mysqlhotcopy has the same functionality as my nameless script but is written in Perl with DBI (which I found a pain to get running on a Redhat system with their stupid RPM). It's also got way too many options for my taste. And yes, I used the code of mysqlhotcopy to make sure I wasn't forgetting something crucial. And tested on a honking big database with lots of indexes and over 3GB data, 3GB index files. Best wishes, Steve - 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 - 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
FW: Purchasing MYSQL for multiple platforms
(I originally sent this to sales@mysql, but got no response - thought I'd try this way). I have nearly completed a port of our companies Unix based software (ISAM based) to use mysql (version 4.0.1). I've been extremely impressed with the performance we are getting from mysql, and are looking to release it to our customer base. The server platforms that KIWIPLAN software runs on are, HPUX 10.20 HPUX 11.x AIX 4.x SCO 5.0.x Linux MS windows (a client/server subset) ATT SVR4 HP MPE/ix (I doubt very much that this is supported!!!) With the exception of the latter two, mysql supports all of these platforms (Question: ATT SVR4? not sure about - it'd be nice to drop it though). If our customers were to purchase a server licence for their server platform, do they get (can they get) an installable binary of mysql for that platform from mysql? I cannot see my customers wanting to (or being able to!) install from source code. Can KIWIPLAN act as resellers of mysql, or would our customers purchase mysql individually? Cheers, Ian Collins. - 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: FW: Purchasing MYSQL for multiple platforms
On Mon, Feb 04, 2002 at 04:34:21PM +1300, Ian Collins wrote: (I originally sent this to sales@mysql, but got no response - thought I'd try this way). That's odd. Try [EMAIL PROTECTED] directly. 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 32 days, processed 697,315,045 queries (250/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
Jailed MySQL for hosting customers
We are offering our hosting customers MySQL databases. Ideally, I would like to offer everyone unlimited databases. What I would like is an option that when connecting to a database as a user, the MySQL server would access the actual database in the directory of the username. That way users could create and delete databases normally, and no names would conflict with other users. For example, if the user databases were stored in /db/, it would lookup the authentication info from the mysql database in /db/mysql/ as normal. Then when user joe successfully authenticated, it would give him access to all of the databases stored in /userdb/joe/, and allow him to create and delete as normal. This would be a very powerful feature, but I don't know how difficult it would be to implement it. Can anyone who has worked with the MySQL codebase commenton this? Is there a point to working on it for the 3.23 branch? I would really like to have this feature, but I don't know the direction to take with this. Thanks, -- David Phillips [EMAIL PROTECTED] http://david.acz.org/ - 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
MySQL - row,table level locking?
Hello Guru, I am web programmer using PERL, MySQL. I need help from you, could you please clarify my doubt? 1. How many methods or functions in PERL-DBI/DBD module will actually will get communicates with MySQL? I know one that's $sth-fecth() or $sth-fetchArrayref() after $sth-execute(); where $sth = $dbi-open(dbi:mysql:...); 2. Is it possible to Row level lock and Table level lock in MySQL, if yes, How could we achieve this in PERL-DBI ? Please, kindly clarify. Thanks in advance. ~ SubbaReddy .M Regards, ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad http://www.frontlinesoft.com Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - 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
Help, Root User Password Lost!
Hello Friends: My root user password get lost. I just can't get in the database again. Anyone know the way to get access to mysql without password. Or is there a way to change the password? I get access denied with the Error No. 1044, and 1045. Thanks Cathy - 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
How to index Optimization on 20 million record
Hi Brothers and Sisters, I need to know how to optimazion index in MySQL, i was read on the manual, but i did not found solution. My case, i have a 20 million record on the one table, yhe table name TABLE_1 i have a field on TABLE_! as indexed and primary key named FIELD_1 (varchar(64) not null ) my structure like this CREATE TABLE `TABLE_1`( `FIELD_1` varchar(64) NOT NULL default '', `FIELD_2` varchar(16) NOT NULL default '', `FIELD_3` varchar(150) default NULL '', PRIMARY KEY (`FIELD_1`), KEY `FIELD_1` (`FIELD_1`), ) TYPE=MyISAM PACK_KEYS=1 but, i do query sintax, just simple select count(*) from TABLE_1 where FIELD_1 = XXX_CC; But i got the result very long timemore 10 minutes I used Sun Solarys with 2 Gygabyte RAM. What wrong with my strusture database... thank's for your answer, i with you always fine and happiness Best Regard, Hery Yulianto - 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
DBI + mysql
Hello all, Just a simple question. I am using perl DBI to connect to mysql. Its like a daemon, so its always running. But whenever i get a signal it connects to a database( different database each time). So there are 2 ways to do it 1. I disconnect and connect each time 2. I connect and keep the database handle and use 'use $database' each time to change database. Can anybody throw some light as to which one is better and are there any problems involved? thanks -- Best regards, Neeraj mailto:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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: Help, Root User Password Lost!
zhu cathy wrote: Hello Friends: My root user password get lost. I just can't get in the database again. Anyone know the way to get access to mysql without password. Or is there a way to change the password? I get access denied with the Error No. 1044, and 1045. Thanks Cathy - Cathy: Please, refer to the manual. There's no successful career path for a hand-held dba. This is basic: http://www.mysql.com/doc/A/c/Access_denied.html Van -- = Linux rocks!!! http://www.dedserius.com/ = - 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
Regarding BLOB
Hello sir, We are using Mysql database for our applications.We are very happy to use this and it's havingvery good features. But one thing i would like to know, in my application i want to store files(like resumes)into the database and i want to open it from browser(IE). while retieving the file we are getting gunk characters,to avoid this we want to use one BLOB class like we have a class in java.sql package.Oracle is supporting this,so in mysql we have any options to solve this problems.If you have any solutions please try to help me to solve this problem. thanks for your cooperation bye madhu sudhan.a -- A.Madhu Sudhan M.Tech, MIGS Software Engineer infoGLYPTIC Software Pvt. Ltd. Level #1, Sigma Arcade Air port Road, Marthahally Bangalore-560037-India Voice: 091-080-5234448/49/50 fax: 091-080-5234451 visit:www.infoglyptic.com - 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