Help - SQLBindParameter not used for all parameters error
I have trouble writing a character into the database (the column is declared as char(2) not null) because I figured that if it appends a null at the end of the character data I want to insert (i.e.'A\0'), it would still fit. I bound the parameters first before assigning the data and executing a statement to write into the database. This is how I bind it: --- g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 2, 0, (SQLPOINTER)chDataPart, 1, NULL); -if I put NULL in the last parameter in the SQLBindParameter function, I get the following error for the SQLParamData function call, Error code: HY090 Error message: SQLBindParameter not used for all parameters. However, I see many working examples that sets the last parameter to NULL when it is a string. I'm not sure if it works for a character. I've checked the manual and list archives and found out that the above error message means [there is an error in the number of parameters in an insert statement]. What does this mean? --- g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 2, 0, (SQLPOINTER)chDataPart, 1, 0); -the funny thing is, if I put 0 in the last parameter in the SQLBindParameter function I don't get any error but the character data (i.e. 'A') that I assigned to the bound parameter would not be written into the database. Am I missing out something here? Please advise. Thanks in advance, lisze
Re: Please give me a good FQ about mysql install.
I had some problem when I install MySQL. Could you kindly give me a good FQ about mysql install? Thank you. www.devshed.com has some interesting info on using/installing MySQL. Also on PHP and other stuff. Greetz, B. - 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
JDBC-MySql==Sex?????????
Hi Everyone, Sorry for the subject but I am in a very very desperate state 'coz the whole site is down and if I cannot connect to the database through my servlet my @ss is grass. Everything seems to be working fine except when I execute the servlet I get this @$#$@$# error: " Server configuration denies access to data source " And to connect my servlet code is: Class.forName("org.gjt.mm.mysql.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://jumac.com:3306/DBNAME?user=ryanpassword=pw007"); Is the problem with my code or my hosting service? What should I do? Please give me detailed instructions as I am not too familiar with MySql so if you are telling me to make changes in the database please be specific. Remember if you help me, when I become a LITTLE richer than Bill Gates I won't forget you either! Cheers, Ryan. ([EMAIL PROTECTED]) __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.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
Problem with C API : LINK 'libmysqlclient.a'
Hi, Sorry for my stupid question, I have probleme when i use C API : LinK Problem. MY COMMAND : bashgcc -o fic.ex NA_PEC_Sin.c -L/usr/local/REP-MYSQL/mysql-3.23.32-pc-linux-gnu-i686/lib -lmysqlclient (the 3 lignes represent 1 ligne for my command ) ERROR MESSAGE : -- /usr/local/REP-MYSQL/mysql-3.23.32-pc-linux-gnu-i686/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' /usr/local/REP-MYSQL/mysql-3.23.32-pc-linux-gnu-i686/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status Remark : --- I think, that it's OK for the way of my library 'libmysqlclient.a'. Thank you very much, MEBTOUCHE, _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
Maximum Capacity and Stability
Can anyone tell me the maximum capacity (number of tables, records) of MySQL database, and the stability comparison with other databases like MS Access, Oracle, MS SQL, etc.? Since it is important for decision of database in my project. Thank you very much! - 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 switch to SCSI HD for mysql?
"mike thomas" [EMAIL PROTECTED] writes: Greg, Well, I'm doing like "%stuff%" selects on a single column table with 20 million records, so any speed gain would be great. Would I be correct in saying that a select of this type will always do a table scan? Pretty much. I think I'll go with SCSI and increase the RAM so I can use a heap table. A cheap first step might be to go with a couple of decent 7200 rpm, ATA100 (or whatever the hell they're calling themsevles this week) disks and RAID0 them. Striping Good. Also, make sure your IDE is spiffed up to the max. Do an: hdparm /dev/hda (or whatever). Make sure it's using DMA, unmasked IRQ, 32 bit i/o and, a multcount of 16. Benchmark your drive before and after, with: hdparm -t /dev/hda You should see 10MB per second after tuning up. However, I can't help thinking for your application There Must Be A Better Way. Do you really need to do substring matching all the time? Can you pre-build an intermediate results set that can be optimally queried? Dave. -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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 switch to SCSI HD for mysql?
Hi, I think I'll go with SCSI and increase the RAM so I can use a heap table. A cheap first step might be to go with a couple of decent 7200 rpm, ATA100 (or whatever the hell they're calling themsevles this week) disks and RAID0 them. Striping Good. Also, make sure your IDE is spiffed up to the max. Do an: hdparm /dev/hda (or whatever). Make sure it's using DMA, unmasked IRQ, 32 bit i/o and, a multcount of 16. Benchmark your drive before and after, with: hdparm -t /dev/hda You should see 10MB per second after tuning up. Yes, the performance of such a system is really not all that bad. I have a MySQL server running in just such a fashion that handles a fair load. It has two 20Gb ATA-66 drives (although only 5400 RPM) in a software RAID 0 array with tune-up options set using hdparm. BTW, there's a good guide on this at the O'Reilly site: http://www.oreillynet.com/pub/a/linux/2000/06/29/hdparm.html I recommend reading it thoroughly, as well as the hdparm man page. Personally, these are the settings I'm using: multcount= 16 (on) I/O support = 3 (32-bit w/sync) unmaskirq= 1 (on) using_dma= 1 (on) keepsettings = 0 (off) nowerr = 0 (off) readonly = 0 (off) readahead= 8 (on) geometry = 2491/255/63, sectors = 40031712, start = 0 Also, if you don't like the sound of software-controlled RAID (i.e. by the Linux kernel), then you could go for one of the plethora of recent motherboards sporting hardware IDE RAID controllers, or one of the Promise or Adaptec PCI adapters if you don't want to change motherboards. Regards, Basil Hussain ([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: Is WHEN a reserved word in MySQL?
As of 3.23.xx, WHEN is a reserved word. regards, P On Thu, 8 Feb 2001, Andy Woolley wrote: Hi All, Does anyone know if a field called WHEN could cause trouble with queries? Many Thanks Andy Woolley www.databasewatch.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
Downloading MySql
Dear sir , I was browsing the whole site to down load the windows NT version of mysql but i could not get any proper guidence or the proper downloading page.. could u please guid me in downloading mysql.. Thanking you. Pradeep Rangdal Cybage Software Ltd Pune
BDB
Hello mysql, 1) Today I tried to reload my tables with backuing up and recovering whole database by mysqldump - it seems like it does not work - mysqld crashed during loading data back even after I've removed all bad tables and bdb logs to have a clean system. This looks like the same problem as I reported with insert test - BDB hanges/crashes during huge multiple insert queries. I've uploaded the mysqldump output wich crashes mysqld during load to the secret directory as layers_la00.sql.gz. The thing is after I've dumped the same data without the extended insert I could load it back without any problems. 2) Then I was loading the data from .sql file I saw the followings: onyx:/spylog/db # mysqladmin processlist | grep -v Sleep +-+---++-++--+---+--+ | Id | User | Host | db | Command| Time | State | |Info | | +-+---++-++--+---+--+ | 34 | root | localhost | la00| Field List | 494 | Repair by sorting | | | | | 36 | root | localhost | lacontrol | Query | 64 | System lock | |insert into layers_la00.g00keywords (counter_id,keyword) values (106339,'RSBAC') | | | 38 | root | localhost | la00| Field List | 468 | Waiting for table | | | | | 39 | root | localhost | layers_la00 | Query | 0| update| |INSERT INTO g03dirs VALUES (110912,8288,'pictures/company/itartass/calendar') | | | 81 | root | localhost | la00| Field List | 296 | Waiting for table | | | | | 121 | titan | php.local | counter | Query | 5| System lock | |SELECT lsh.begin AS period, sh.hosts7d,sh.visitors7d FROM layers_la00.g00layers_stat_hits AS ls | | 125 | root | localhost | | Query | 0| | |show processlist | | +-+---++-++--+---+--+ as you see here one thread is doing repear as this happened after mysqld crash, but note first insert query in system lock state (I've saw several queries at this place, but all of them spent in system lock time several tenths of seconds) this can nothing to do with recovery (this table was just created by mysqldump couple of minutes before) - I habe the only explanation which looks ok the system lock takes place while many inserts are going to othe table (g03dirs) - as soon as the table changed all other queries which was in system lock state got a chance to run. The other thing is mysqldump does not uses lock tables to insert data so this looks like real perfomance (concurency) problem Some more examples: onyx:/spylog/db # mysqladmin processlist | grep -v Sleep +-+---++-+-+--++--+ | Id | User | Host | db | Command | Time | State | Info | | +-+---++-+-+--++--+ | 36 | root | localhost | lacontrol | Query | 384 | update | replace into |layers_la00.g00stat_404refs (layer_id,id,visitors,loads,hits) values (2,2,0,4,0), (2,9, | | 39 | root | localhost | layers_la00 | Query | 0| update | INSERT INTO |g03stat_404pages VALUES (149,1563,0,1,0) | | | 272 | root | localhost | | Query | 0|| show processlist | | +-+---++-+-+--++--+ as you see here replace is "hanged" - it's simple query wich should not take so long. But just few seconds after: onyx:/spylog/db #
Re: Problem with mysql++...
Mike Baranski writes: This gives me a seg fault, I know I have the correct user/pw, but I can't get the thing to run past "First", any ideas why the connect is not working properly? #include iostream.h #include sqlplus.hh #include string void main() { string dbname = "test2"; string hostname = "localhost"; string uname = "mike"; string paswd = "1woodydogCONIFER2701Cmwb2diG"; cout "First\n"; Connection con(dbname.c_str(), hostname.c_str(), uname.c_str(), paswd.c_str()); cout "Second\n"; Query query = con.query(); cout "Third\n"; query "CREATE DATABASE MWB"; cout "Fourth\n"; Result res = query.store(); cout "Fifth\n"; } Thanks! MWB. HI! As it is outlined in many places in our manual streaming a Query object should be performed only with commands that return a result set, like SELECT, SHOW, DESCRIBE etc For other stuff, like CREATE, use exec() method. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Downloading MySql
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-win.zip This is the link to the Win32 binary of the latest version. To find the downloads page on the website, visit www.mysql.com and click on the "Downloads" link in the menu on the left of the screen. HTH Jon -Original Message- From: Pradeep Rangdal [mailto:[EMAIL PROTECTED]] Sent: 08 February 2001 11:27 To: [EMAIL PROTECTED] Subject: Downloading MySql Dear sir , I was browsing the whole site to down load the windows NT version of mysql but i could not get any proper guidence or the proper downloading page.. could u please guid me in downloading mysql.. Thanking you. Pradeep Rangdal Cybage Software Ltd Pune - 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 switch to SCSI HD for mysql?
Dave Hodgkinson wrote: "mike thomas" [EMAIL PROTECTED] writes: Greg, Well, I'm doing like "%stuff%" selects on a single column table with 20 million records, so any speed gain would be greatWould I be correct in saying that a select of this type will always do a table scan? Pretty much. I think I'll go with SCSI and increase the RAM so I can use a heap table. A cheap first step might be to go with a couple of decent 7200 rpm, ATA100 (or whatever the hell they're calling themsevles this week) disks and RAID0 them. Striping Good. This still does not help the seek time of SCSI vs EIDE (ATA100 only helps the bus speed AFAIR). Some calc's I did a while back implied that SCSI seek time is 40% better (or less) - this was comparing IBM SCSI 10k drives to IBM EIDE. Agreed that striping is good tho. Also, make sure your IDE is spiffed up to the max. Do an: hdparm /dev/hda (or whatever). Redhat is very bad for not tweeking the UDMA - but they do not as they are afraid of damaging old drives that do not support it. Make sure it's using DMA, unmasked IRQ, 32 bit i/o and, a multcount of 16. Benchmark your drive before and after, with: hdparm -t /dev/hda You should see 10MB per second after tuning up. Once you've tweaked it put the hdparm setting at the end of your /etc/rc.d/rc.local (if on redhat - your's may be in a different location) so that it gets loaded at each boot. You may also wish to mount your disks with no atime (each time your disks are access the access time of the file is update - if you do not need this then switch it off) eg an example line from my /etc/fstab: /dev/hda2 / ext2noatime,defaults 1 1 However, I can't help thinking for your application There Must Be A Better Way. Do you really need to do substring matching all the time? Can you pre-build an intermediate results set that can be optimally queried? (Dave sometimes you worry me ;-) Dave's right - substring matching is bad performance wise. Greg Dave. -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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: latin5
Murat KARABEK writes: hi all, i'm testing mysql 3.23.32 on windows and i need to use Turkish character set in sorting or using string functions such as upper etc. do you know where i can find latin5 files for windows? thnx. HI! All our last 3.23 releases, including the above one have a latin5 set in charsets subdirectory under share. Hope that helps. Many regards from Cyprus. Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: API help
Konstantin Osipov writes: Hi All! Is this code buggy? -- MYSQL* mysql = new MYSQL; mysql_init(mysql); mysql_real_connect(mysql, "localhost"); /* some work*/ mysql_close(mysql); mysql_real_connect(mysql, "otherhost"); /* some work*/ mysql_close(mysql); delete mysql; -- In other words, if struct MYSQL allocated manually, should i call mysql_init(mysql) after mysql_close(mysql) if i want to connect using this struct to other database? WBW, Konstantin Yes, the above code is very buggy. Delete your first and last line and check the result from the subsequent functions !!! Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: MySQL and PHP Question
This is really a JavaScript problem if you don't want to use the submit button. Use PHP to load the values of both tables into a JavaScript array. Then write JS code that will change the contents of the City control based on what is selected in the country control. Not terribly difficult. Cal http://www.calevans.com -Original Message- From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 12:01 AM To: [EMAIL PROTECTED] Subject: MySQL and PHP Question Hi, I have two tables city and country +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(5) | | PRI | 0 | auto_increment | | city | varchar(35) | | MUL | || | countryid | int(5) | | MUL | 0 || +---+-+--+-+-++ 3 rows in set (0.00 sec) mysql desc country; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-++ | id | int(5) | | PRI | 0 | auto_increment | | country | varchar(35) | | MUL | || +-+-+--+-+-++ 2 rows in set (0.00 sec) I am trying to write a php script that does the following. In an html page I have two dropdowns one country which will get the data from the country table and city which should get the data from the city table based on the one selected from the country drop down. I do not want to use a submit button. I use a javascript and using onChange pass the country.id to the javascript but do not know how to pass it back to the php script. Any pointers Adrian -- === Adrian D'Costa [EMAIL PROTECTED] www.pcsadvt.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: Help with SQL statement please.
I see, I need a recursive algorithm Can you get them in Woolworths? - Original Message - From: "Tommie Jones" [EMAIL PROTECTED] To: "Phil Latio" [EMAIL PROTECTED] Cc: Sent: Thursday, February 08, 2001 12:18 PM Subject: Re: Help with SQL statement please. If I am not mistaken I think you are trying to do a nested select. This is not possible in Mysql. I've had similar problems. You will have to use some sort of recursive algorithm in your perl code (if you are using perl) to accomplish this. Phil Latio wrote: I hope somebody may of come across this sort of problem before dealing with counting total records in subcategories. I have two tables sslinks which contains links (URL) information and sslinkcats which contains category information. The category table "sslinkcats" has a field called "lcat_id" (which is an autonumber) and also "lcat_cat" which is the "lcat_id" value of the parent category. For example cricket would be under sport and the "lcat_cat" of cricket would be "lcat_id" of sport. The problem is that the below statement will only count the number of links in each particular category. $sql = "SELECT sslinkcats.lcat_id, COUNT(*) AS NumLinks FROM sslinks, sslinkcats WHERE link_cat = sslinkcats.lcat_id AND link_validated = 'yes' GROUP BY link_cat"; I want to display the total amount of links under the category sport to include all subcategories like football,cricket,cricket rugby. Also if cricket had subcategories, then I would these counted too. I am sure the answer is looking at me but I just can't see it. Therefore any pointers or assistance would be very welcome. (ps. If you have read this message before, apologies but I was informed that this is the correct category for this type of question. Sorry) - 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 - 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 switch to SCSI HD for mysql?
Thanks for the info on tuning an IDE. I'll go ahead and do that. Regarding " Do you really need to do sub string matching all the time? Can you pre-build an intermediate results set that can be optimally queried?" I'll have to think about this one. My application just consists of a huge table of domain names and users will be able to search for full strings and partial strings. So I'm not sure how I could create an intermediate results set from this table that would speed up queries? Thanks everyone for the feedback. Mike -Original Message- From: Dave Hodgkinson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 1:32 AM To: mike thomas Cc: Greg Cope; Mysql@Lists. Mysql. Com Subject: Re: Should I switch to SCSI HD for mysql? "mike thomas" [EMAIL PROTECTED] writes: Greg, Well, I'm doing like "%stuff%" selects on a single column table with 20 million records, so any speed gain would be great. Would I be correct in saying that a select of this type will always do a table scan? Pretty much. I think I'll go with SCSI and increase the RAM so I can use a heap table. A cheap first step might be to go with a couple of decent 7200 rpm, ATA100 (or whatever the hell they're calling themsevles this week) disks and RAID0 them. Striping Good. Also, make sure your IDE is spiffed up to the max. Do an: hdparm /dev/hda (or whatever). Make sure it's using DMA, unmasked IRQ, 32 bit i/o and, a multcount of 16. Benchmark your drive before and after, with: hdparm -t /dev/hda You should see 10MB per second after tuning up. However, I can't help thinking for your application There Must Be A Better Way. Do you really need to do substring matching all the time? Can you pre-build an intermediate results set that can be optimally queried? Dave. -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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: How can I create concatenated primary keys and insert thedata into it?
Dear Sir I am new to MySQL. I've created a table with three keys inside like this: CREATE TABLE reservation ( reservation_id INT UNSIGNED NOT NULL AUTO_INCREMENT, hotel_id INT UNSIGNED NOT NULL, customer_id INT UNSIGNED NOT NULL, PRIMARY KEY(reservation_id, hotel_id, customer_id), and I tried to insert the data by using the following sql statements: INSERT INTO reservation (reservation_id, hotel_id, customer_id,business_trip, checkin_month, checkin_day, checkin_year, checkin_time, checkout_month, checkout_day, checkout_year, total_num_guest, room_type, hotel_recommendation, customer_request, customer_comments) VALUES (NULL, NULL, NULL, 'yes_business', 'January', '01', '2002', '11:00', 'January', '07', '2002', '3', 'Triple', 'no_recommendations', 'Morning call', 'No') The book says that I should put NULL in order to let AUTO_INCREMENT generate the id for me. However, it kept telling me that hotel_id can't be null (I guess it was because the hotel_id has been generated in the "hotel" table by using AUTO_INCREMENT as well). How am I supposed to connect different primary keys into one table (I mean how can I transfer the hotel_id in Hotel table to the Reservation table)? And after that how can I insert those primary keys inside one table? Thank you very much for your time. Sincerely, Cheri Peng Ma'am, you don't have three keys. You have declared a PRIMARY KEY with three columns. However, only the first column is a key. The auto_increment column is all that is necessary to uniquely identify each row. The other two columns appear to be foreign keys and should be removed from your PRIMARY KEY clause. You are correct about the NULLs. Since you've declared each of the columns in your primary key as NOT NULL, you must insert a non-NULL value in each of the three columns. Only the first column is auto-increment, so your INSERT statement must have a value for the other two. Instead of a VALUES list, use a SELECT statement in your INSERT statement that returns the necessary values for the two fields. The field list in the SELECT clause of the SELECT statement would be identical to the VALUES list in your present statement, except that the second and third NULLs would be replaced by the names of the columns you are extracting the hotel_id and customer_id values from. Your constant values would remain unchanged. Also, remove the first NULL from the VAlUES list and the reservation_id column from the INSERT field list. INSERT INTO reservation (hotel_id, customer_id,business_trip, checkin_month, checkin_day, checkin_year, checkin_time, checkout_month, checkout_day, checkout_year, total_num_guest, room_type, hotel_recommendation, customer_request, customer_comments) SELECT hotel_id, custumer_id, 'yes_business', 'January', '01', '2002', '11:00', 'January', '07', '2002', '3', 'Triple', 'no_recommendations', 'Morning call', 'No' whatever FROM and WHERE clauses are necessary to return appropriate values for hotel_id and customer_id; Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: how to get SELECT to return 0 or 1 for WHERE match ?
I want to SELECT on one term have the SELECT return as quickly as possible on the first TRUE instance. Ideally I'd like it to after the first matching case stop looking for other matches ( for speed ) and return 1. If there's no matches at all I want it to return 0. This works OK but returns either the date or an empty set. SELECT thread_last_post_date FROM threads WHERE thread_last_post_date '2001-02-01' LIMIT 1; I know from Perl or PHP I can check the number of returned rows but I'd like something that just returns 0 or 1 so I don't have to special case. I'd like something like below but which work (it returns 2 rows of 1 for some reason ) : SELECT 1 FROM threads WHERE thread_last_post_date '2001-02-01' LIMIT 1; thanks, - Sam. Sir, SQL deals with sets of rows. You supply the specifications, and SQL returns the set of all rows that match your specifications. SQL is deliberately designed not to deal with a database one row at a time. Try SELECT Count(*) FROM threads WHERE thread_last_post_date '2001-02-01' Treat zero as zero and anything greater than zero as one. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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
MyODBC with C++ Builder
Hi. Sometimes I need make software to administrate specifics databases on MySQL for my clients running Windows. I already did it before using an API, but I would like to use the MyODBC to make things go faster. I'm trying to use MyODBC with C++ Builder 3.0 Standard. When I open the Database Explorer out of Builder I can connect to MySQL normally, but when I open the Database Explorer or use a MySQL database in my applications I receive the following message: "Your application is not enabled for use with this driver." I red the manual in the section about MyODBC, checked the database configurations and the OBBC NDS is configured. If someone have some information about it, please mail me. Guilherme M M - 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 daemon fails to start.
Hi, After trying to install mysql succesfully on RH7 (yes, it finally worked), I discovered that the daemon doesn´t start at boot. I tailed the log and it says this: 010208 10:25:03 mysqld started 010208 10:25:04 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010208 10:25:04 mysqld ended Can someone explain me what´s wrong? Thanks!!! Ezequiel. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.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: Replication issues
Jeremy Wilson: I tested replication recently and found it extremely lacking. Even the most minor of errors causes the daemon to stop replicating, effectively rendering the ability useless to me, as I use mysql for authentication. What errors are you talking about? Errors like duplicate entries? Those aren't "minor". They're serious data inconsistency problems. What does that mean? Does that means that, if I try to insert something in a table that already exists (for example, an existing value to a primary key), the slave would STOP RUNNING? If that happens, we should carefully change our whole application here... -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - 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 Server configuration denies access to data source
Hi Everyone, I am in a very very desperate state 'coz my whole site is down and if I cannot connect to the database through my servlet my @ss is grass. Everything seems to be working fine except when I execute the servlet I get this frustrating error: " Server configuration denies access to data source " And to connect my servlet code is: Class.forName("org.gjt.mm.mysql.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://jumac.com:3306/DBNAME?user=ryanpassword=pw007"); Is the problem with my code or my hosting service? What should I do? Please give me detailed instructions as I am not too familiar with MySql so if you are telling me to make changes in the database please be specific. Remember if you help me, when I become a LITTLE richer than Bill Gates I won't forget you either! Cheers, Ryan. ([EMAIL PROTECTED]) __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.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
FYI: Known bug in replication
I keep seeing users asking about a problem they are having with replication (I ran into the bug myself). I saw a message a week or so ago acknowledging the bug and noting that it was self-inflicted (while cleaning up code) and has been corrected. The problem will not exist in the next release (.33). The problem is that replication will fail if you stop and restart the slave. The master.info file gets corrupted on the slave (added lines) so your IP address and such are not read correctly and the slave cannot connect to the master. In working to set up replication I also ran into the issue another user noted of having the error log grow rather large. The longer you let it grow, the bigger it gets (or that's how it seemed). Is there a page where known issues with the current release are tracked? It may be a good idea. That would hopefully alleviate repeated users asking questions to this list about known issues (resolved or otherwise). I can only imagine how discouraging it is when following this list to have to respond to the same issues constantly. A page with known issues and known workarounds (if any) could come in handy. Jeff - 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
Another problem with REPLICATIOn
It's amazing. Configuration is fine (same as our test machines here). We are trying to use it on production machines now. These are the errors I get: 010208 12:35:29 Slave thread: error re-connecting to master:Binary log is not open, last_errno=0, retry in 0 sec I also have got this one: 010208 12:06:58 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (111)(107), retry in 200 sec That '0' already changed to '' and to '4'. my.cnf on the master reads: [mysqld] bin-log server-id = 1 my.cnf in the slave reads: [mysqld] master-host = 200.212.x.y #we're using IP master-user = replication_user master-password = replication_password server-id = 2 When I started it at once, it seemed to be working fine. Now the slave just won't connect. What could be wrong? -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - 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: FYI: Known bug in replication
Leonardo Dias wrote: "Mayville, Jeffrey" wrote: I keep seeing users asking about a problem they are having with replication (I ran into the bug myself). I saw a message a week or so ago acknowledging the bug and noting that it was self-inflicted (while cleaning up code) and has been corrected. The problem will not exist in the next release (.33). The problem is that replication will fail if you stop and restart the slave. The master.info file gets corrupted on the slave (added lines) so your IP address and such are not read correctly and the slave cannot connect to the master. In working to set up replication I also ran into the issue another user noted of having the error log grow rather large. The longer you let it grow, the bigger it gets (or that's how it seemed). Is there a page where known issues with the current release are tracked? It may be a good idea. That would hopefully alleviate repeated users asking questions to this list about known issues (resolved or otherwise). I can only imagine how discouraging it is when following this list to have to respond to the same issues constantly. A page with known issues and known workarounds (if any) could come in handy. Geez! That's what's been going on with me in the last 30 minutes. :-)) This message came very handy. I now got the slave and the master running and sync'ing, with time updates so that both have the same clock. :) I still don't know one thing: imagine that I try to insert a number in a field which is PRIMARY KEY. If there's that number already in the table, would the slave stop running just because of that? That would be terrible. -- Why don't you try it. I did. - 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
Problems with mySQL and DBTools
I am a web/database developer and we have a new Unix administrator who admits to having never installed/configured PHP or mySQL. He was tasked with setting up our development server with Apache, PHP and mySQL. Since he made this attempt I have not been able to connect to the server with DBTools without crashing mySQL on the server. I used PHPWebAdmin to administer the database, but now I need to move it to a production environment and DBTools is the most efficient way to do that. When setting up the connection in DBTools the test is always successful, but fails during the actual connection. I am able to connect to two other production servers fine, so I know that there is no problem with DBTools. Now, I am not a unix guru, and am not familiar with how to set up Apache,PHP and mySQL to run in a stable union. So here are my questions: 1. Has anyone ever experienced this problem before? If so, what was your resolution? 2. Is there a detailed outline to use to compile Apache with PHP and mySQL effectively? Thanks in advance, -Lorenzo - 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 - SQLBindParameter not used for all parameters error
At 17:05 08/02/2001 +0800, Li Sze wrote: Hi! If you only need room for 1 character you don't need a column with size 2. The last parameter of SQLBindParameter is a pointer to a buffer for the parameter's length. Then error HY090 means: (DM) The argument ParameterValuePtr was a null pointer, the argument StrLen_or_IndPtr was a null pointer, and the argument InputOutputType was not SQL_PARAM_OUTPUT. (DM) SQL_PARAM_OUTPUT, where the argument ParameterValuePtr was a null pointer, the C type was char or binary, and the BufferLength (cbValueMax) was greater than 0. Take a look in the sample from Microsoft Documentation: #define SALES_PERSON_LEN 10 #define STATUS_LEN 6 SQLSMALLINT sOrderID; SQLSMALLINT sCustID; DATE_STRUCT dsOpenDate; SQLCHAR szSalesPerson[SALES_PERSON_LEN]; SQLCHAR szStatus[STATUS_LEN); SQLINTEGER cbOrderID = 0, cbCustID = 0, cbOpenDate = 0, cbSalesPerson = SQL_NTS, cbStatus = SQL_NTS; SQLRETURN retcode; SQLHSTMT hstmt; /* Prepare the SQL statement with parameter markers. */ retcode = SQLPrepare(hstmt, "INSERT INTO ORDERS (ORDERID, CUSTID, OPENDATE, SALESPERSON, STATUS) VALUES (?, ?, ?, ?, ?)", SQL_NTS); if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) { /* Specify data types and buffers for OrderID, CustID, OpenDate, SalesPerson, */ /* Status parameter data. */ SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, 0, 0, sOrderID, 0, cbOrderID); SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, 0, 0, sCustID, 0, cbCustID); SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_TYPE_DATE, SQL_TYPE_DATE, 0, 0, dsOpenDate, 0, cbOpenDate); SQLBindParameter(hstmt, 4, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, SALES_PERSON_LEN, 0, szSalesPerson, 0, cbSalesPerson); SQLBindParameter(hstmt, 5, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, STATUS_LEN, 0, szStatus, 0, cbStatus); /* Specify first row of parameter data. */ sOrderID = 1001; sCustID = 298; dsOpenDate.year = 1996; dsOpenDate.month = 3; dsOpenDate.day = 8; strcpy(szSalesPerson, "Johnson"); strcpy(szStatus, "Closed"); /* Execute statement with first row. */ retcode = SQLExecute(hstmt); /* Specify second row of parameter data. */ sOrderID = 1002; sCustID = 501; dsOpenDate.year = 1996; dsOpenDate.month = 3; dsOpenDate.day = 9; strcpy(szSalesPerson, "Bailey"); strcpy(szStatus, "Open"); /* Execute statement with second row. */ retcode = SQLExecute(hstmt); } Regards, Miguel I have trouble writing a character into the database (the column is declared as char(2) not null) because I figured that if it appends a null at the end of the character data I want to insert (i.e.'A\0'), it would still fit. I bound the parameters first before assigning the data and executing a statement to write into the database. This is how I bind it: --- g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 2, 0, (SQLPOINTER)chDataPart, 1, NULL); -if I put NULL in the last parameter in the SQLBindParameter function, I get the following error for the SQLParamData function call, Error code: HY090 Error message: SQLBindParameter not used for all parameters. However, I see many working examples that sets the last parameter to NULL when it is a string. I'm not sure if it works for a character. I've checked the manual and list archives and found out that the above error message means [there is an error in the number of parameters in an insert statement]. What does this mean? --- g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 2, 0, (SQLPOINTER)chDataPart, 1, 0); -the funny thing is, if I put 0 in the last parameter in the SQLBindParameter function I don't get any error but the character data (i.e. 'A') that I assigned to the bound parameter would not be written into the database. Am I missing out something here? Please advise. Thanks in advance, lisze __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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: [win32,mysql v. 3.23.32]Now() function and ERROR in enum
Christian, a DEFAULT value in a CREATE (or ALTER) statement must be a static value, try using a TIMESTAMP field instead. To use 'ERROR' in as an 'ENUM' DEFAULT it must be included in the definition, i.e. ENUM('ERROR','TRUE') Hope this helps... John On Thursday 08 February 2001 09:09, Christian Ribeaud wrote: Hi, I tried the following code: CREATE TABLE news (... published date DEFAULT 'NOW()' NOT NULL, ..., showIt ENUM('TRUE') DEFAULT ERROR, ...); and I was surprised to get an '-00-00' as date after doing a SELECT. I would like that the table put automatically the today's date for every INPUT as default value. What is wrong? Another question, 'showIt ENUM('TRUE') DEFAULT ERROR' did not work but 'showIt ENUM('TRUE','FALSE') DEFAULT FALSE' worked fine. I would like to have something like bits or boolean values in my table. How to achieve this? Thanks for the help and have a nice day. Greetings, christian - 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: MySQL and PHP Question
Adrian D'Costa wrote: Hi, I have two tables city and country +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(5) | | PRI | 0 | auto_increment | | city | varchar(35) | | MUL | || | countryid | int(5) | | MUL | 0 || +---+-+--+-+-++ 3 rows in set (0.00 sec) mysql desc country; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-++ | id | int(5) | | PRI | 0 | auto_increment | | country | varchar(35) | | MUL | || +-+-+--+-+-++ 2 rows in set (0.00 sec) I am trying to write a php script that does the following. In an html page I have two dropdowns one country which will get the data from the country table and city which should get the data from the city table based on the one selected from the country drop down. I do not want to use a submit button. I use a javascript and using onChange pass the country.id to the javascript but do not know how to pass it back to the php script. Any pointers You have to submit via javascript the country id whenever the dropdown selection changes. You have to be carefull using a hidden field so your php-script recognices when you pushed your form submition button or you just had changed your country. Adrian -- === Adrian D'Costa [EMAIL PROTECTED] www.pcsadvt.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: table too big to dump?
On Wed, Feb 07, 2001 at 05:38:49PM -0600, Dan Nelson wrote: It's probably trying to read the whole table into memory. Try adding "--opt" to the mysqldump commandline. OK, I've had _many_ responses that in effect say 'use -q' (--opt is a superset). It works. Thanks. Dumb question: why isn't the -q behavior the default bahavior? Under what conditions is it advantageous to _not_ use -q? -- Dan Nelson [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
Parallelism.
Rather a tall order (still reading docs, can't see anything about this), but can two MySQL instances on two servers be connected to the same disks? For failover purposes. Any pointers to documentation on the subject greatly appreciated. J. -- Justin Rowles Technical Consultant Sellers Information Pack - 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
developer wanted
Hi, We require a developer with very good Mysql skills and experiance of getting big databases running fast. The database structure is built but we need someone to look it over and tune it up to run much faster than it does at the moment. DB is spread over 5tables, one with 3million records. We need to get it running fast enough for the web. Prob only one or two days work via Telnet. This is quite urgent so anyone interested, please respond ASAP. Regards Danial Subhani PRO-NET INTERNET SERVICES LTD 2nd Floor Hyde House, London, NW9 6LH Tel: +44 (0)20 8 200 3565 Fel: +44 (0)20 8 205 8365 - 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: Client library - Exception handling?
Are you suggesting that I look at the mysql++ code as an example, or actually use the mysql++ code instead of the "mysql.h" included libraries? Chris Sinisa Milivojevic wrote: Chris Hundley writes: Can I implement some sort of exception handling when using the mySQL client library? I'm running an application and when I issue a query with an error in it, I catch the error and print output, but the software throws a general exception. Should this code be in a try { } catch {} routine? If so, what type of exception should I be catching? Sorry if this is a stupid question, I'm newer to C++. Chris Hi! This feature is fully supported in our C++ API, MySQL++, which even has two different optional ways in catching the errors, as explained in it's manual. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Building mysql-3.23.32 on AIX-4.3.2 with IBM's C++ v5 compiler...
Hi All, I've built previous versions of mysql with gcc/g++ or other IBM C++ compilers, but I'm having some problems with their VisualAge C++ V5.0.1 compiler. Curently I have an error while compiling sql/sql_lex.cc. My command-line (reduced to the minimum) is xlC_r -DMYSQL_SERVER -DHAVE_CONFIG_H -I../../db-3.2.3h/build_unix \ -I./../include -I./../regex -DHAVE_INT_8_16_32 \ -DUNDEF_HAVE_INITGROUPS -c sql_lex.cc which produces the following error messages: "/usr/include/netinet/in.h", line 377.17: 1540-1125 (W) The data member "char ip_opts[40]" cannot have the same name as its containing class. "item_sum.h", line 173.31: 1540-0063 (S) The text "*" is unexpected. "item_sum.h", line 208.31: 1540-0063 (S) The text "*" is unexpected. "sql_map.h", line 49.10: 1540-0274 (S) The name lookup for "map_file" did not find a declaration. "sql_map.h", line 37.24: 1540-1298 (I) "mapped_files *map_file(const my_string, byte *, uint)" needs to be declared in the containing scope to be found by name lookup. A relavent extract from item_sum.h is class Item_avg_field :public Item_result_field { public: Field *field; Item_avg_field(Item_sum_avg *item); enum Type type() const { return FIELD_AVG_ITEM; } double val(); longlong val_int() { return (longlong) val(); } String *val_str(String*); void make_field(Send_field *field); void fix_length_and_dec() {} }; Can anyone suggest a modification? After running configure I modified congig.h to decalre HAVE_GETHOSTBYNAME_R_RETURN_INT (although AIX's basic gethostbyname is itself thread-safe). I also modified include/*global.h to remove "_AIX32_CURSES", since the AIX-3.2 version of the include defines bool as a char which the compiler didn't like. Thanks for any pointers, Ciaran +-+ Ciaran DeignanTel: (France) 04 76 29 79 92 BULL XS-BU (http://www-frec.bull.com) HA and Consolidation Mail to: [EMAIL PROTECTED]Bullcom: 229 79 92 PGP: B1 78 FB 88 FD 86 58 A8 89 7B 22 8C D0 E8 71 FC Fax: 229 75 18 +-+ - 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: Table suggestions..
I am writing an application that will poll up to 500 devices every 5 minutes. For this application I need to keep at least 6 months of data. If I were to use a single record for every update, I would have ~25 million records. Obviously this is not an ideal solution. Why not? Given the proper HW and a carefully designed table layout, MySQL would have no trouble handling this amount of data. MySQL may have trouble handling 100 inserts/minute if you need to extract a lot of data at the same time, but that's a different beast entirely. Remember that MySQL was built to effectively handle e.g. SELECTs on huge amounts of data, while concurrency on e.g. INSERTS/UPDATE/SELECTs has always had a lower priority. I am interested in getting ideas on how to tackle this. I was thinking that I would have a table that stored all the values for the current day and a table for historical data. After 24 hours the data would be averaged into a daily snapshot and stored in another table. The data from that day would then be cleared. This would only require ~90k recoo s. I would appreciate any ideas. I have written a ton of web applications using mySQL, but have never had to scale above 100k entries :) I would consider writing the log data into a flat file, then import it into MySQL, with reasonable intervals, say every half hour or so. Once a day (or once a week?), I would execute a query to delete old records. - though I wonder: If you're only interested in the daily average, then why do you need to poll every 5 minutes??? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
ERROR 1130: Host '' is not allowed to connect to this MySQL server
I am getting the same error when I try to connect. Mine is a brand new install. Have you have any luck trouble shooting this problem? Jen - 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: mysql daemon fails to start.
Suse 7.0 when I ran rpm -Uhv MySql*3.23.32-1.i386.rpm against the sever, the client and the shared rpms.It ran without error and created the appropriate files on a 10 gig /var/lib/mysql. I moved the contents of mysql to /dbshare and created a symbolic link in /var/lib called mysql which pointed to /dbshare.I had that error until I set the ownership of the link, /dbshare, /dbshare/mysql and everything in /dbshare/mysql to "mysql w group root". When I did that, safe_mysqld was successful in starting mysql from root. You mught look at the permissions and ownership of your /usr/sbin/mysqld: and everything in it. The only thing which should have an ownership and group of mysql/deamon is myslq.sock. everything else should be mysql/? maybe root. Ezequiel Chernitsky wrote: Hi, After trying to install mysql succesfully on RH7 (yes, it finally worked), I discovered that the daemon doesnt start at boot. I tailed the log and it says this: 010208 10:25:03 mysqld started 010208 10:25:04 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010208 10:25:04 mysqld ended Can someone explain me whats wrong? Thanks!!! Ezequiel. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.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 - 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: developer wanted
Danial Subhnai wrote: Hi, We require a developer with very good Mysql skills and experiance of getting big databases running fast. The database structure is built but we need someone to look it over and tune it up to run much faster than it does at the moment. DB is spread over 5tables, one with 3million records. We need to get it running fast enough for the web. Prob only one or two days work via Telnet. This is quite urgent so anyone interested, please respond ASAP. Would someone from BRazil do it? -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - 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: how to get SELECT to return 0 or 1 for WHERE match ?
Check manual on ISNULL or another MYSQL functions that deal with NULL and return 0 or 1. - Original Message - From: S A [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 3:34 AM Subject: how to get SELECT to return 0 or 1 for WHERE match ? I want to SELECT on one term have the SELECT return as quickly as possible on the first TRUE instance. Ideally I'd like it to after the first matching case stop looking for other matches ( for speed ) and return 1. If there's no matches at all I want it to return 0. This works OK but returns either the date or an empty set. SELECT thread_last_post_date FROM threads WHERE thread_last_post_date '2001-02-01' LIMIT 1; I know from Perl or PHP I can check the number of returned rows but I'd like something that just returns 0 or 1 so I don't have to special case. I'd like something like below but which work (it returns 2 rows of 1 for some reason ) : SELECT 1 FROM threads WHERE thread_last_post_date '2001-02-01' LIMIT 1; thanks, - Sam. - Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices.
Finding Duplicates and Deleteing
Does anyone know how to find duplicates in a table and deleting them. I can't figure out how to structure the query. Linsen
Re: table too big to dump?
"BR" == Brian Reichert [EMAIL PROTECTED] writes: BR When I try to do a mysqldump on the localhost, I get an out-of-memory BR error: BR # mysqldump -uroot -proot customer audit_trail_271 BR mysqldump: Out of memory (Needed 8164 bytes) BR mysqldump: Got error: 2008: MySQL client run out of memory By default mysql client reads the whole result set into memory then writes the output. You can alter this behavior with the "-q" option to mysqldump, so it writes out as it reads from the server without buffering in 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: Finding Duplicates and Deleting
Does anyone know how to find duplicates in a table and deleting them. I can't figure out how to structure the query. Linsen http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_6_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
AW: API help
Hello Konstantin, this code is buggy, because 'new' is not a valid C operator. And MYSQL is a struct not an object. The 'new' operator allocates memory for objects (C++). In C you?ve to use the malloc function. Take a look at the libmysqltest example, which comes with your distribution. Regards Andy -Ursprungliche Nachricht- Von: Konstantin Osipov [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 8. Februar 2001 10:30 An: [EMAIL PROTECTED] Betreff: ó API help Hi All! Is this code buggy? -- MYSQL* mysql = new MYSQL; mysql_init(mysql); mysql_real_connect(mysql, "localhost"); /* some work*/ mysql_close(mysql); mysql_real_connect(mysql, "otherhost"); /* some work*/ mysql_close(mysql); delete mysql; -- In other words, if struct MYSQL allocated manually, should i call mysql_init(mysql) after mysql_close(mysql) if i want to connect using this struct to other database? WBW, Konstantin - 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: ERROR 1130: Host '' is not allowed to connect to this MySQL server
Please look in the mysql manual before you ask questions (if you already haven't) http://www.mysql.com/doc/P/r/Privilege_system.html :) --Atle On Thu, 8 Feb 2001, Jen Carroll wrote: I am getting the same error when I try to connect. Mine is a brand new install. Have you have any luck trouble shooting this problem? Jen - 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: Problems with mySQL and DBTools
On Thu, 8 Feb 2001, Curtis, Lorenzo wrote: 2. Is there a detailed outline to use to compile Apache with PHP and mySQL effectively? www.devshed.com/Server_Side/PHP/Soothingly_Seamless/print.html -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: Finding Duplicates and Deleting
- Original Message - From: "Linsen Limsico" Does anyone know how to find duplicates in a table and deleting them. I can't figure out how to structure the query. Linsen Exact duplicates or where only one field is duplicated? Anna - 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: [win32,mysql v. 3.23.32]Now() function and ERROR in enum
I tried the following code: CREATE TABLE news (... published date DEFAULT 'NOW()' NOT NULL, ..., showIt ENUM('TRUE') DEFAULT ERROR, ...); and I was surprised to get an '-00-00' as date after doing a SELECT. I would like that the table put automatically the today's date for every INPUT as default value. What is wrong? First of all, you're trying to use the STRING 'NOW()' as a default value in a DATE field. MySQL will try to convert this string to a date on every insert, fail, and use the zeroed date instead. Secondly, MySQL does not accept functions as default values. You should use the function only on INSERT. Another question, 'showIt ENUM('TRUE') DEFAULT ERROR' did not work but 'showIt ENUM('TRUE','FALSE') DEFAULT FALSE' worked fine. I would like to have something like bits or boolean values in my table. How to achieve this? Thanks for the help and have a nice day. ERROR cannot be a default value, unless you specify it as part of the enumeration. If you need TRUE/ERROR, define ERROR instead of FALSE. If you need a tri-state value, use 'TRUE', 'FALSE', 'ERROR' as the enumneration values. ... or I don't get what you're trying to do... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: Finding Duplicates and Deleteing
On Thu, 8 Feb 2001, Linsen Limsico wrote: Does anyone know how to find duplicates in a table and deleting them. I can't figure out how to structure the query. Linsen Hello, Being new to this I don't know the coding however I would look at making another table and then use the UNIQUE command to place these unique (not duplicated) entires into the table. Regards Peter [EMAIL PROTECTED] -- Blessings are upon the head of the just: but violence covers the mouth of the wicked. - 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: Problems with mySQL and DBTools
do any one knows about a mailling list of oracle? wich is the eamil address for subscribing to it? please mail me back ASAP, cheers On Thu, 8 Feb 2001, clay bond wrote: Date: Thu, 8 Feb 2001 13:23:08 -0500 (EST) From: clay bond [EMAIL PROTECTED] To: unlisted-recipients: ; Cc: [EMAIL PROTECTED] Subject: Re: Problems with mySQL and DBTools On Thu, 8 Feb 2001, Curtis, Lorenzo wrote: 2. Is there a detailed outline to use to compile Apache with PHP and mySQL effectively? www.devshed.com/Server_Side/PHP/Soothingly_Seamless/print.html -- /"\ \ / ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \ AND POSTINGS - 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: problems running mySQL via Telnet
I suppose you mean that you've been using telnet to access the server and mysql to access the mysql server. From a security standpoint, you should probably install sshd, deinstall telnet, rsh, rexec, etc. and use ssh exclusively to login to your server. Of course, this is only a tiny piece of an overall security strategy, and you should invest some time in developing a complete security solution, if you haven't already. However, this is now almost completely off-topic. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: John Jensen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 18:10 Alright, you've got me worried. I have been using telnet to access mysql. Could that have something to do with the problems I have been having with the server? (The root password was erased, but there was no other evidence of a breakin.) On 8 Feb 2001, at 7:56, Quentin Bennett wrote: You don't connect to mysql server using telnet, you use the mysql command line client 'mysql'. -Original Message- From: @ndYD [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 February 2001 07:13 server version: 3.22.34-shareware-debug OS: Windows 98 I tried to access the mySQL- server via the Win-Telnet Client. If the connection is established, the following mysterious string appears: ( 3.22.34-shareware-debugk7qS,~Z), After that, I entered some characters. Then the connection will be closed by the server and the error string "Bad Handshake" appears. Question: Is this feature (Telnet) not available in the shareware-version. Or is this a basically problem? - 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: Finding Duplicates and Deleteing
Depending upon the function of the table, you might consider designing your table such that duplicates aren't possible (e.g. putting a UNIQUE index on a column or set of columns). Other than that, try dumping your table, removing the rows you don't want, and reloading the table. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Linsen Limsico [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 12:09 Does anyone know how to find duplicates in a table and deleting them. I can't figure out how to structure the 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
Re: Finding Duplicates and Deleting
"Carsten H. Pedersen" wrote: Does anyone know how to find duplicates in a table and deleting them. I can't figure out how to structure the query. Linsen http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_6_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq I wouldn't recommend that solution for a large table, it will take forever and require enough disk space for a potentialy very large index.. not to mention it has to modify your existing index file since indexes are not in separate containers... Not to mention the fact that alter table must copy the entire table to another temp table and lock out writters.. If you have very small tables I suppose that is a reasonable solution. - 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
optimize table LOCK
If OPTIMIZE TABLE appears to be writting to a temporary file while it works (.TMM).. Why must it lock readers out of the original table file? - 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 do I contribute a binary distribution?
How do I post a new binary distribution for inclusion in the page http://www.mysql.com/downloads/mysql-3.23.html ? I would like to contribute a standard binary distribution for DEC OSF 4.0D (Alpha) [mysql-3.23.32-dec-osf4.0d-alphaev56]. Compiling mysql on this platform is a major pain, requiring operating system patches, painful gcc/gmake upgrades, as well as makefile editing. So I would like to save someone else the trouble if possible. Please reply directly to me. Thanks, Eric - 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: Windows DSN NAme
Actually I got "A connection could not be made using the data source parameters entered. Save non-verified file DSN? "(Mr) Pekka Gaiser" wrote: Hi, I got no solution, just a few ideas, probably you have checked them already. - Windows DSN name doesn't matter. Type in anything you want. - I dont know if mysql is case sensitive when specifying the database name? - Ensure that mySQL accepts all referer IPs and not only "localhost". If you get an error like "access denied for [EMAIL PROTECTED] (using password: YES)" you got to change mysql's Security settings. Regards, Pekka I need to set up a file DSN on my Win98 machine to access MySQL on the Linux Box with the database. I have tried to setup the DSN from the control panel the process always errors out. I know that mysql is running and I know the IP of the Server. I have Samba Share defined so that I can see the database directory and the database from my windows machine and Using KMySqlAdmin on the Linux side I have the edit grants window open for this database. MyODBC is installed on the Win98 machine and I can start the process of adding a new MySQL DSN from the control panel. Since the Samba share makes the database directory visible I will browse out there to Tad106 and select the dbshare directory. In this directory is a Metrics folder which is in fact a MySql database so I will specify MetricsDsn to be placed there. The next button on the Create New Data Source displays "File Data Source" "Filename: ||TAD106\dbshare\MeteicsDsn.dsn" "Drive: MySQL" Finish now takes me to a window called TDX mysql Driver connect asking for the following: Windows DSN name = ?? MySQL host (name or IP) = 192.168.2.5 MySQL database name = Metrics User = % Passsword = % Port: (if not 3306) I do not know what to enter for Windows DSN NAme. Everything I have tried errors out. - Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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
auto_increment
I encountered something really handy while playing around with mysql. The documented behavior for auto_increment is that it uses the next highest number no matter what. I noticed though, when I have a two element primary key, that the auto_increment behavies in a majik uber-cool way. I want to use this new found majik, but I'm afraid that since it's not documented I won't be able to rely on it in future versions. Is it here to stay? Example: CREATE temporary TABLE neato ( type smallint unsigned not null, id smallint unsigned not null auto_increment, PRIMARY KEY (type, id) ); insert into neato(type) values (1), (1), (1), (2), (2), (2), (2); select * from neato; +--++ | type | id | +--++ |1 | 1 | |1 | 2 | |1 | 3 | |2 | 1 | |2 | 2 | |2 | 3 | |2 | 4 | +--++ 7 rows in set (0.19 sec) Will it do this in the future? or just in the version I have? - 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: Maximum Capacity and Stability
I can't speak for the maximum capacities (but I think they are in the manual or FAQ) but as to stability, I've never had MySQL crash or corrupt a table, and I've been running it for several months; almost a year, actualy. j- k- On Thursday 08 February 2001 01:19, Chan, Kwok-Hing wrote: Can anyone tell me the maximum capacity (number of tables, records) of MySQL database, and the stability comparison with other databases like MS Access, Oracle, MS SQL, etc.? Since it is important for decision of database in my project. Thank you very much! - 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 -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - 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
AW: Maximum Capacity and Stability
If that's the case u r running it but not really using it ... !! -Ursprngliche Nachricht- Von: Joshua J. Kugler [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 8. Februar 2001 22:24 An: Chan, Kwok-Hing; '[EMAIL PROTECTED]' Betreff: Re: Maximum Capacity and Stability I can't speak for the maximum capacities (but I think they are in the manual or FAQ) but as to stability, I've never had MySQL crash or corrupt a table, and I've been running it for several months; almost a year, actualy. j- k- On Thursday 08 February 2001 01:19, Chan, Kwok-Hing wrote: Can anyone tell me the maximum capacity (number of tables, records) of MySQL database, and the stability comparison with other databases like MS Access, Oracle, MS SQL, etc.? Since it is important for decision of database in my project. Thank you very much! - 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 -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - 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: mysql-3.23.32-dec-osf5.1-alphaev6 dies on DECthread error in OSF1 V5.1
See bugreport below. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, 09 February, 2001 10:38 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:mysql-3.23.32-dec-osf5.1-alphaev6 dies on DECthread error in OSF1 V5.1 MySQL binary 3.23.32-dec-osf5.1-alphaev6 version dies on a Decthreads operating system call Description: /usr/local/mysql-3.23.32-dec-osf5.1-alphaev6/bin/mysqld: ready for connections 010209 07:55:25 mysqld started /usr/local/mysql-3.23.32-dec-osf5.1-alphaev6/bin/mysqld: ready for connections %DECthreads bugcheck (version V3.18-042), terminating execution. % Reason: schReadyForInterrupt: invalid substate 0x3 for blocked state % Running on OSF1 V5.1(732) on Compaq AlphaServer ES40, 8192Mb; 4 CPUs, pid 101603 010209 08:22:25 mysqld restarted /usr/local/mysql-3.23.32-dec-osf5.1-alphaev6/bin/mysqld: ready for connections %DECthreads bugcheck (version V3.18-042), terminating execution. % Reason: schReadyForInterrupt: invalid substate 0x3 for blocked state % Running on OSF1 V5.1(732) on Compaq AlphaServer ES40, 8192Mb; 4 CPUs, pid 101851 010209 08:51:59 mysqld restarted /usr/local/mysql-3.23.32-dec-osf5.1-alphaev6/bin/mysqld: ready for connections The same error message is given for an earlier mysql version running on a different compaq alpha server: /data/mysql-3.22.30-dec-osf4.0f-alphaev6/bin/mysqld: ready for connections %DECthreads bugcheck (version V3.18-042), terminating execution. % Reason: schReadyForInterrupt: invalid substate 0x3 for blocked state % Running on OSF1 V5.1(732) on Compaq AlphaServer ES40, 4096Mb; 4 CPUs, pid 217925 mysqld restarted on Fri Feb 9 06:16:00 NZDT 2001 I had hoped that by going to a mysql version for 5.1 the problem would disappear, but it does not. How-To-Repeat: It happened when creating a database,later while creating a table. This is done by a test program using an odbc connection, as part of an installation. It does not always fail on the same mysql command. Fix: No known fix; Submitter-Id: [EMAIL PROTECTED] Originator:Hanneke Kroon Organization: Genesis Research Development Corporation, Auckland New Zealand MySQL support: none Synopsis: mysql-3.23.32-dec-osf5.1-alphaev6 dies on DECthread error in OSF1 V5.1 Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.32 (Official MySQL binary) Environment: System: OSF1 iris V5.1 732 alpha Machine: alpha Some paths: /usr/bin/perl /sbin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/alphaev56-dec-osf4.0f/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jan 18 16:11 /lib/libc.a - ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Jan 18 16:11 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-prefix=/usr/local/mysql --with-mysqld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared Perl: This is perl, version 5.005_03 built for alpha-dec_osf - 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
No Key on LIKE% (was: Performance issues.)
Quentin Bennett wrote: Hi, For an indexed column, the index is used if the start of the string is used: LIKE 'a string of text%' may use an index LIKE '%any old string%' will not, since the start of the string is unknown. The index will only be used if the server decides that it will be quicker than a full table scan. Have you got the results of 'explain select ' to see if your index is actually being used. Regards Quentin While we are (were) on the subject.. Any thoughts why like would not be using an index in this case? mysql explain select * from _data where datatime like '12:00:%'; +---+--+---+--+-+--+-++ | table | type | possible_keys | key | key_len | ref | rows| Extra | +---+--+---+--+-+--+-++ | _data | ALL | dataTime | NULL |NULL | NULL | 5751070 | where used | +---+--+---+--+-+--+-++ 1 row in set (0.06 sec) mysql explain select * from _data where datatime like '12%'; +---+--+---+--+-+--+-++ | table | type | possible_keys | key | key_len | ref | rows| Extra | +---+--+---+--+-+--+-++ | _data | ALL | dataTime | NULL |NULL | NULL | 5751070 | where used | +---+--+---+--+-+--+-++ 1 row in set (0.00 sec) There is a key on dataTime and there are only 94 unique values for datatime... So why in 5.7mil rows it doesn't use key? I have the same issue on a datadatetime column which has 191,000 unique values and it doesn't use the index either - 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 vs Access; you'd *think* the choice is obvious...
Hi, Question 1: --- We've got a server app that does a lot of 'small' database reads and writes. We were originally using MS Access via DAO (Jet Engine) and we wanted to tighten up DB performance, so we've written a general ODBC database wrapper object, but mainly just to connect to MySQL. I figured there'd be ODBC overhead, but its a lot worse than I imagined. I want to know: does it make sense that our original system, connecting via 'Jet-engine' to Access, is actually much faster than connecting to MySQL via ODBC? This seems to be what's happened. I'm wondering if it has to do with the overhead of connecting to a server-based database via a tcp socket (even on localhost) rather than the direct-to-disk Jet engine; maybe because we do so many small reads/updates it's actually faster with Access? Any thoughts? Is it worth my time to look into using MySQL directly instead of thru ODBC? I'm obviously working on Windows (NT), connecting at ODBC version 2.0 to MySQL server 3.23, using a database converted directly from Access to MySQL using the cool (but unstable) DBTools GUI, which kindly retained all keys and indexes (which have been reviewed for speed). Question 2: --- Is there any way in MySQL to compute, inline SQL, the difference between two datetime values? I couldn't find a function which could do anything but subtract intervals from datetimes... what I need is the interval! Many thanks in advance, Jesse - 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: Maximum Capacity and Stability
Well, only use Access if it's a small project. I've used both MS SQL, Oracle 7.3 and MySQL. My MS db is about 8 Gigs and I've only had to rebuild damaged tables once in the last year...I just upgraded it to SQL server 2000, and it seems fine so far, as well. Oracle, I had bunches of problems with..my db on oracle was around 5 gigs, but I got corruption like every few months..not sure what the problem was, but I don't use oracle anymore. I've been using MySQL for about 9 months now, for a linux project, the db is only a few hundred megs, but i've never had problems with it yet. Speed wise, in my projects, MS and oracle were about the same...with MySQL a little faster than both, but MySQL can't so some of the heavier stuff that MS/Oracle can...that's my experience with the three...it could be very different for you, though. jon - Original Message - From: "Joshua J. Kugler" [EMAIL PROTECTED] To: "Chan, Kwok-Hing" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 4:24 PM Subject: Re: Maximum Capacity and Stability I can't speak for the maximum capacities (but I think they are in the manual or FAQ) but as to stability, I've never had MySQL crash or corrupt a table, and I've been running it for several months; almost a year, actualy. j- k- On Thursday 08 February 2001 01:19, Chan, Kwok-Hing wrote: Can anyone tell me the maximum capacity (number of tables, records) of MySQL database, and the stability comparison with other databases like MS Access, Oracle, MS SQL, etc.? Since it is important for decision of database in my project. Thank you very much! - 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 -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - 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: MySQL vs Access; you'd *think* the choice is obvious...
Quickling wrote: Hi, Question 1: --- We've got a server app that does a lot of 'small' database reads and writes. We were originally using MS Access via DAO (Jet Engine) and we wanted to tighten up DB performance, so we've written a general ODBC database wrapper object, but mainly just to connect to MySQL. I figured there'd be ODBC overhead, but its a lot worse than I imagined. I want to know: does it make sense that our original system, connecting via 'Jet-engine' to Access, is actually much faster than connecting to MySQL via ODBC? This seems to be what's happened. I'm wondering if it has to do with the overhead of connecting to a server-based database via a tcp socket (even on localhost) rather than the direct-to-disk Jet engine; maybe because we do so many small reads/updates it's actually faster with Access? Any thoughts? Is it worth my time to look into using MySQL directly instead of thru ODBC? I'm obviously working on Windows (NT), connecting at ODBC version 2.0 to MySQL server 3.23, using a database converted directly from Access to MySQL using the cool (but unstable) DBTools GUI, which kindly retained all keys and indexes (which have been reviewed for speed). If your tables are very small. I've found the same thing that you did, Access was actually faster on some small queries.. When your tables get bigger (and it didin't take much 100,000+ rows) then Access started to go down-hill quickly, occasional corruption, unable to repair, and very slow on many queries. Question 2: --- Is there any way in MySQL to compute, inline SQL, the difference between two datetime values? I couldn't find a function which could do anything but subtract intervals from datetimes... what I need is the interval! Many thanks in advance, Jesse UNIX_TIMESTAMP(DATE2) - UNIX_TIMESTAMP(DATE1) = seconds TO_DAYS(DATE2) - TO_DAYS(Date1) = days - 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: MySQL vs Access; you'd *think* the choice is obvious...
On Thu, 8 Feb 2001, Quickling wrote: Date: Thu, 08 Feb 2001 17:02:59 -0500 From: Quickling [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MySQL vs Access; you'd *think* the choice is obvious... Hi, Question 2: --- Is there any way in MySQL to compute, inline SQL, the difference between two datetime values? I couldn't find a function which could do anything but subtract intervals from datetimes... what I need is the interval! Try converting both to seconds using UNIXTIME and then subtract the converted result. Second option, form the target datetime in MMDDHHMMSS format and do a straight comparison (assuming that the target comes from a program). Many thanks in advance, Jesse - 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: Backup database
Hola alguien habla espaol. que pueda ayudarme como se hace copia de seguridad a tablas exageradamente grande. He consultado el comando backup table tablas, to 'ruta' . hay otra forma?. Gracias. Roger Retamoza ICQ 102090754 Barranquilla Colombia - 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: MySQL vs Access; you'd *think* the choice is obvious...
Actually there is no reason to expect MySQL to perform better than Access for a nominally sized database and everything running on one PC. Access was designed and optimized for JET whereas ODBC is a general-purpose API. Also, the connection method impacts this significantly, as do the complexity of the query. For a simple test I did comparing connection methods from Access check http://www.trewtech.com/sqltest.html However, to see Access flounder horribly, simply put your MDB backend at the other end of an ethernet connection from your frontend. Now, for even more pain, add a few more users connecting to it at the same time. Access is _not_ a server and the kiss of death for an access database is to try to use it as a backend over a network. It's amazing how inefficient a query is when the "server" is actually the network filesystem. Add in absurdly long-running bugs that Microsoft denies exist - well, rather, since it's extremely difficult to actually report a bug to Microsoft without paying them for the privilege, perhaps they just don't know - such as randomly corrupting memo fields - and it's essentially useless for anything but a very small database with a very small number of users, or only running on one PC with no network. Jamie Regards, Jamesmailto:[EMAIL PROTECTED] Thursday, February 08, 2001, 5:02:59 PM, you wrote: Q We've got a server app that does a lot of 'small' database reads and Q writes. We were originally using MS Access via DAO (Jet Engine) and we Q wanted to tighten up DB performance, so we've written a general ODBC Q database wrapper object, but mainly just to connect to MySQL. I figured Q there'd be ODBC overhead, but its a lot worse than I imagined. Q I want to know: does it make sense that our original system, connecting via Q 'Jet-engine' to Access, is actually much faster than connecting to MySQL Q via ODBC? This seems to be what's happened. Q I'm wondering if it has to do with the overhead of connecting to a Q server-based database via a tcp socket (even on localhost) rather than the Q direct-to-disk Jet engine; maybe because we do so many small reads/updates Q it's actually faster with Access? Any thoughts? Is it worth my time to Q look into using MySQL directly instead of thru ODBC? Q I'm obviously working on Windows (NT), connecting at ODBC version 2.0 to Q MySQL server 3.23, using a database converted directly from Access to MySQL Q using the cool (but unstable) DBTools GUI, which kindly retained all keys Q and indexes (which have been reviewed for speed). - 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: MySQL vs Access; you'd *think* the choice is obvious...
Hi, One thing I have always wondered, how do you deal with table locking if you have a number of people using mySQL with ODBC? Does ODBC handle it? Does Access do it? Can mySQL do it with Berkeley? I am esp talking if you are using mySQL from many different locations and working on the same table. Thanks, Eric At 05:50 PM 2/8/01 -0500, James Treworgy wrote: Actually there is no reason to expect MySQL to perform better than Access for a nominally sized database and everything running on one PC. Access was designed and optimized for JET whereas ODBC is a general-purpose API. Also, the connection method impacts this significantly, as do the complexity of the query. For a simple test I did comparing connection methods from Access check http://www.trewtech.com/sqltest.html However, to see Access flounder horribly, simply put your MDB backend at the other end of an ethernet connection from your frontend. Now, for even more pain, add a few more users connecting to it at the same time. Access is _not_ a server and the kiss of death for an access database is to try to use it as a backend over a network. It's amazing how inefficient a query is when the "server" is actually the network filesystem. Add in absurdly long-running bugs that Microsoft denies exist - well, rather, since it's extremely difficult to actually report a bug to Microsoft without paying them for the privilege, perhaps they just don't know - such as randomly corrupting memo fields - and it's essentially useless for anything but a very small database with a very small number of users, or only running on one PC with no network. Jamie Regards, Jamesmailto:[EMAIL PROTECTED] Thursday, February 08, 2001, 5:02:59 PM, you wrote: Q We've got a server app that does a lot of 'small' database reads and Q writes. We were originally using MS Access via DAO (Jet Engine) and we Q wanted to tighten up DB performance, so we've written a general ODBC Q database wrapper object, but mainly just to connect to MySQL. I figured Q there'd be ODBC overhead, but its a lot worse than I imagined. Q I want to know: does it make sense that our original system, connecting via Q 'Jet-engine' to Access, is actually much faster than connecting to MySQL Q via ODBC? This seems to be what's happened. Q I'm wondering if it has to do with the overhead of connecting to a Q server-based database via a tcp socket (even on localhost) rather than the Q direct-to-disk Jet engine; maybe because we do so many small reads/updates Q it's actually faster with Access? Any thoughts? Is it worth my time to Q look into using MySQL directly instead of thru ODBC? Q I'm obviously working on Windows (NT), connecting at ODBC version 2.0 to Q MySQL server 3.23, using a database converted directly from Access to MySQL Q using the cool (but unstable) DBTools GUI, which kindly retained all keys Q and indexes (which have been reviewed for speed). - 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 Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - 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
Antwort: [win32,mysql v. 3.23.32]Now() function and ERROR in enum
On 08.02.2001 15:09:47 Christian Ribeaud wrote: would like that the table put automatically the today's date for every INPUT as default value. What is wrong? Uhm, why don't you use a timestamp column type then? Okay, it will also save the time, but it's easy to extract only the date, if that's all your after. With a timestamp, you could either not set any value when inserting or set it to NULL which both would enter the current time (like in NOW()). Another question, 'showIt ENUM('TRUE') DEFAULT ERROR' did not work but 'showIt Sure, because your ENUM did not contain the value 'ERROR' - it's just containing 'TRUE'. ENUM('TRUE','FALSE') DEFAULT FALSE' worked fine. I would like to have something like bits or boolean values in my table. How to achieve this? Thanks for the I use a TinyINT and store a 0 for FALSE and something other than 0 (like 1, or whatever) for TRUE. That will only take 1 byte to store what you need. - 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
Error 127 when doing query and mysqldump
Hi, I am using Mysql-3.23.22. Recently I encounter one of my database tables give me "error 127", whenever I do a "select *" query and mysqldump. I did a perror command and it does not give me any idea what is the meaning of this error number. Can anybody help? Thanks in advance... Daniel
Mac OS X
Has anybody successfully built 3.23 on Mac OS X Public Beta? Does anybody know if the version it supposedly builds under is a later beta? I still can't seem to get it to work properly. Thanks, Geoff - 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
Rookie...
Hi, I'm a total newbie to MySQL. I am creating an application in Java/JSP/Oracle. However, my client wants to move to MySQL because of the low costs, and I have no idea about MySQL. I just downloaded the API from MySQL.com I now need to know the following things : 1. Is there a graphical utility (like SQL Plus for oracle) that I can use to manage the database ? 2. I saw something about a MySQL GUI on the site. But it was full of classes and stuff. How do I install/use them? 3. I saw a tcFM JDBC driver on the web. Is that the best ? Are there any known bugs ? 4. What are the potential problems that could arise with using MySQL in the long run ? How easy is it to maintain from the backend ? Do I have to necessarily write 'raw code' like CREATE. to create a table ? I would really really appreciate any kind of information and/or insight into any of the stuff above, or even just URL's to good resources on the web. I've been searching the web, and the resources I've been seeing are pretty vague and are not answering my questions. I feel like the way I felt 5 years back when facing the web for the first time - totally LOST!! Thanks, Ravi http://BabyNamesIndia.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
General MySQL Questions
Greetings! I am one of the developers of a MUD, and we have recently decided to rewrite our entire driver to C++/OOP and use MySQL to store our data, so it has become my duty to begin to learn about all the facets of MySQL. I have been going through FAQs, manuals, etc, and we are also using MySQL++ to interface to the database. Here are a few general questions that I've got at this point: 1. We would like to make saving/retrieving information from the database non-blocking, if possible. Does anyone have any suggestion for this? Our thoughts were to write an external program to fetch information and return it to our main program; is there any easier way to handle this? Is it even necessary to make calls to the database non-blocking? 2. When our driver boots and begins accepting connections, would it be more feasible to read the various tables into memory structures, rather than querying the database everytime we need information on a specific item within the game? Thanks for your help! Also, if anyone might be willing to help us in a forum other than the list, a personal reply would be great. (it would not, of course, be a paying position, but just for asking advice) --- Jon A. Nielsen Lazarus of Spear of Insanity MUD http://spear.kilnar.com/ telnet://spear.kilnar.com:1066/ - 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 - SQLBindParameter not used for all parameters error
Thanks for responding. I've changed the column back to size 1. However, if I follow the example from the Microsoft Documentation, that is setting the last parameter to cbValue where cbValue = SQL_NTS, and BufferLength to 0, I get a handling exception error when the last SQLParamData is called. The SQLParamData is used for my last column where I insert binary data using SQLPutData. The example is for a string of length more than 1 and as such I do not know if there is a different workaround to this for single character entries. I have tried applying all the working examples that I have come arcross to my program but to no avail. I really have no idea what is going on here. Are there any other approaches that I may try out? Thanks, lisze At 17:05 08/02/2001 +0800, Li Sze wrote: Hi! If you only need room for 1 character you don't need a column with size 2. The last parameter of SQLBindParameter is a pointer to a buffer for the parameter's length. Then error HY090 means: (DM) The argument ParameterValuePtr was a null pointer, the argument StrLen_or_IndPtr was a null pointer, and the argument InputOutputType was not SQL_PARAM_OUTPUT. (DM) SQL_PARAM_OUTPUT, where the argument ParameterValuePtr was a null pointer, the C type was char or binary, and the BufferLength (cbValueMax) was greater than 0. Take a look in the sample from Microsoft Documentation: #define SALES_PERSON_LEN 10 #define STATUS_LEN 6 SQLSMALLINT sOrderID; SQLSMALLINT sCustID; DATE_STRUCT dsOpenDate; SQLCHAR szSalesPerson[SALES_PERSON_LEN]; SQLCHAR szStatus[STATUS_LEN); SQLINTEGER cbOrderID = 0, cbCustID = 0, cbOpenDate = 0, cbSalesPerson = SQL_NTS, cbStatus = SQL_NTS; SQLRETURN retcode; SQLHSTMT hstmt; /* Prepare the SQL statement with parameter markers. */ retcode = SQLPrepare(hstmt, "INSERT INTO ORDERS (ORDERID, CUSTID, OPENDATE, SALESPERSON, STATUS) VALUES (?, ?, ?, ?, ?)", SQL_NTS); if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) { /* Specify data types and buffers for OrderID, CustID, OpenDate, SalesPerson, */ /* Status parameter data. */ SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, 0, 0, sOrderID, 0, cbOrderID); SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, 0, 0, sCustID, 0, cbCustID); SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_TYPE_DATE, SQL_TYPE_DATE, 0, 0, dsOpenDate, 0, cbOpenDate); SQLBindParameter(hstmt, 4, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, SALES_PERSON_LEN, 0, szSalesPerson, 0, cbSalesPerson); SQLBindParameter(hstmt, 5, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, STATUS_LEN, 0, szStatus, 0, cbStatus); /* Specify first row of parameter data. */ sOrderID = 1001; sCustID = 298; dsOpenDate.year = 1996; dsOpenDate.month = 3; dsOpenDate.day = 8; strcpy(szSalesPerson, "Johnson"); strcpy(szStatus, "Closed"); /* Execute statement with first row. */ retcode = SQLExecute(hstmt); /* Specify second row of parameter data. */ sOrderID = 1002; sCustID = 501; dsOpenDate.year = 1996; dsOpenDate.month = 3; dsOpenDate.day = 9; strcpy(szSalesPerson, "Bailey"); strcpy(szStatus, "Open"); /* Execute statement with second row. */ retcode = SQLExecute(hstmt); } Regards, Miguel I have trouble writing a character into the database (the column is declared as char(2) not null) because I figured that if it appends a null at the end of the character data I want to insert (i.e.'A\0'), it would still fit. I bound the parameters first before assigning the data and executing a statement to write into the database. This is how I bind it: --- g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 2, 0, (SQLPOINTER)chDataPart, 1, NULL); -if I put NULL in the last parameter in the SQLBindParameter function, I get the following error for the SQLParamData function call, Error code: HY090 Error message: SQLBindParameter not used for all parameters. However, I see many working examples that sets the last parameter to NULL when it is a string. I'm not sure if it works for a character. I've checked the manual and list archives and found out that the above error message means [there is an error in the number of parameters in an insert statement]. What does this mean? --- g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 2, 0, (SQLPOINTER)chDataPart, 1, 0); -the funny thing is, if I put 0 in the last parameter in the SQLBindParameter function I don't get any error but the character data (i.e. 'A') that I assigned to the bound parameter would not be written into the database. Am I missing out something here? Please advise. Thanks in advance, lisze __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ /
Re: auto_increment
At 4:00 PM -0500 2/8/01, Paul E. Miller wrote: I encountered something really handy while playing around with mysql. The documented behavior for auto_increment is that it uses the next highest number no matter what. I noticed though, when I have a two element primary key, that the auto_increment behavies in a majik uber-cool way. I want to use this new found majik, but I'm afraid that since it's not documented I won't be able to rely on it in future versions. Is it here to stay? Yes, it was added in version 3.23.5. You've discovered the meaning of this item in the 3.23.5 change notes: @item One can now with MyISAM have the auto_increment part as a sub part: @code{CREATE TABLE foo (a int not null auto_increment, b char(5), primary key (b ,a))} Just make sure the AUTO_INCREMENT column is the last column of the index. Example: CREATE temporary TABLE neato ( type smallint unsigned not null, id smallint unsigned not null auto_increment, PRIMARY KEY (type, id) ); insert into neato(type) values (1), (1), (1), (2), (2), (2), (2); select * from neato; +--++ | type | id | +--++ |1 | 1 | |1 | 2 | |1 | 3 | |2 | 1 | |2 | 2 | |2 | 3 | |2 | 4 | +--++ 7 rows in set (0.19 sec) Will it do this in the future? or just in the version I have? -- Paul DuBois, [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: Help with SQL statement please.
A recursive algorithm is the term used for an algorithm where a function calls itself. Listing the entire directory structure of your hard drive would employ such an algorithm. Any good book on programming should explain recursive algorithms. You may find that helpful. - Original Message - From: "Phil Latio" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 20:52 Subject: Re: Help with SQL statement please. I see, I need a recursive algorithm Can you get them in Woolworths? - Original Message - From: "Tommie Jones" [EMAIL PROTECTED] To: "Phil Latio" [EMAIL PROTECTED] Cc: Sent: Thursday, February 08, 2001 12:18 PM Subject: Re: Help with SQL statement please. If I am not mistaken I think you are trying to do a nested select. This is not possible in Mysql. I've had similar problems. You will have to use some sort of recursive algorithm in your perl code (if you are using perl) to accomplish this. Phil Latio wrote: I hope somebody may of come across this sort of problem before dealing with counting total records in subcategories. I have two tables sslinks which contains links (URL) information and sslinkcats which contains category information. The category table "sslinkcats" has a field called "lcat_id" (which is an autonumber) and also "lcat_cat" which is the "lcat_id" value of the parent category. For example cricket would be under sport and the "lcat_cat" of cricket would be "lcat_id" of sport. The problem is that the below statement will only count the number of links in each particular category. $sql = "SELECT sslinkcats.lcat_id, COUNT(*) AS NumLinks FROM sslinks, sslinkcats WHERE link_cat = sslinkcats.lcat_id AND link_validated = 'yes' GROUP BY link_cat"; I want to display the total amount of links under the category sport to include all subcategories like football,cricket,cricket rugby. Also if cricket had subcategories, then I would these counted too. I am sure the answer is looking at me but I just can't see it. Therefore any pointers or assistance would be very welcome. (ps. If you have read this message before, apologies but I was informed that this is the correct category for this type of question. Sorry) - 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 - 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: Help - SQLBindParameter not used for all parameters error
At 10:10 09/02/2001 +0800, Li Sze wrote: Hi Li, I will take a look in MyODBC code about the SQLBindParameter and when I will have a reasonable answer I will send you the reply. Regards, Miguel Thanks for responding. I've changed the column back to size 1. However, if I follow the example from the Microsoft Documentation, that is setting the last parameter to cbValue where cbValue = SQL_NTS, and BufferLength to 0, I get a handling exception error when the last SQLParamData is called. The SQLParamData is used for my last column where I insert binary data using SQLPutData. The example is for a string of length more than 1 and as such I do not know if there is a different workaround to this for single character entries. I have tried applying all the working examples that I have come arcross to my program but to no avail. I really have no idea what is going on here. Are there any other approaches that I may try out? Thanks, lisze At 17:05 08/02/2001 +0800, Li Sze wrote: Hi! If you only need room for 1 character you don't need a column with size 2. The last parameter of SQLBindParameter is a pointer to a buffer for the parameter's length. Then error HY090 means: (DM) The argument ParameterValuePtr was a null pointer, the argument StrLen_or_IndPtr was a null pointer, and the argument InputOutputType was not SQL_PARAM_OUTPUT. (DM) SQL_PARAM_OUTPUT, where the argument ParameterValuePtr was a null pointer, the C type was char or binary, and the BufferLength (cbValueMax) was greater than 0. Take a look in the sample from Microsoft Documentation: #define SALES_PERSON_LEN 10 #define STATUS_LEN 6 SQLSMALLINT sOrderID; SQLSMALLINT sCustID; DATE_STRUCT dsOpenDate; SQLCHAR szSalesPerson[SALES_PERSON_LEN]; SQLCHAR szStatus[STATUS_LEN); SQLINTEGER cbOrderID = 0, cbCustID = 0, cbOpenDate = 0, cbSalesPerson = SQL_NTS, cbStatus = SQL_NTS; SQLRETURN retcode; SQLHSTMT hstmt; /* Prepare the SQL statement with parameter markers. */ retcode = SQLPrepare(hstmt, "INSERT INTO ORDERS (ORDERID, CUSTID, OPENDATE, SALESPERSON, STATUS) VALUES (?, ?, ?, ?, ?)", SQL_NTS); if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) { /* Specify data types and buffers for OrderID, CustID, OpenDate, SalesPerson, */ /* Status parameter data. */ SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, 0, 0, sOrderID, 0, cbOrderID); SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_SSHORT, SQL_INTEGER, 0, 0, sCustID, 0, cbCustID); SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_TYPE_DATE, SQL_TYPE_DATE, 0, 0, dsOpenDate, 0, cbOpenDate); SQLBindParameter(hstmt, 4, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, SALES_PERSON_LEN, 0, szSalesPerson, 0, cbSalesPerson); SQLBindParameter(hstmt, 5, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, STATUS_LEN, 0, szStatus, 0, cbStatus); /* Specify first row of parameter data. */ sOrderID = 1001; sCustID = 298; dsOpenDate.year = 1996; dsOpenDate.month = 3; dsOpenDate.day = 8; strcpy(szSalesPerson, "Johnson"); strcpy(szStatus, "Closed"); /* Execute statement with first row. */ retcode = SQLExecute(hstmt); /* Specify second row of parameter data. */ sOrderID = 1002; sCustID = 501; dsOpenDate.year = 1996; dsOpenDate.month = 3; dsOpenDate.day = 9; strcpy(szSalesPerson, "Bailey"); strcpy(szStatus, "Open"); /* Execute statement with second row. */ retcode = SQLExecute(hstmt); } Regards, Miguel I have trouble writing a character into the database (the column is declared as char(2) not null) because I figured that if it appends a null at the end of the character data I want to insert (i.e.'A\0'), it would still fit. I bound the parameters first before assigning the data and executing a statement to write into the database. This is how I bind it: --- g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 2, 0, (SQLPOINTER)chDataPart, 1, NULL); -if I put NULL in the last parameter in the SQLBindParameter function, I get the following error for the SQLParamData function call, Error code: HY090 Error message: SQLBindParameter not used for all parameters. However, I see many working examples that sets the last parameter to NULL when it is a string. I'm not sure if it works for a character. I've checked the manual and list archives and found out that the above error message means [there is an error in the number of parameters in an insert statement]. What does this mean? --- g_rc = SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_CHAR, 2, 0, (SQLPOINTER)chDataPart, 1, 0); -the funny thing is, if I put 0 in the last parameter in the SQLBindParameter function I
Need guidance regarding constant table corruption
Hello, Until recently I have spent most of my time using the major databases such as Oracle, DB2, Sybase etc. I am new to MySQL. At first I was excited about such a low cost alternative such as MySQL, and I have found Mysql to be a great database for very small databases, but for large databases it has been a nightmare due to constant table corruption that is happening many times on a daily basis. The corruption is so bad that sometimes even myisamchk -r won't fix the data and I have to use --safe-recover. Hopefully someone can give me some guidance as I really do not want to go back to using those proprietary and expensive database systems. I am not able to move to an Unix operating system because the DSL modem being used requires Windows and also for other reasons. My setup is very simple with only computer, the database resides on that computer, just one Mysql database server, and only one database with one table. Here are the specific details: An example of the error message I get: "[TCX][MyODBC]Incorrect key file for table: 'domain'. Try to repair it" This happens while inserting a large number rows at high speed being read from a text file. It crashes usually around the 1,000,000th inserted row into a table. Hardware: Atlas CS9000 Operating system: Windows 98 Second Edition 4.10.A CPU: One Intel Pentium III/Coppermine Processor 800Mhz Motherboard: Shuttle AV11 VIA 693A Motherboard with PC133 UDMA66 Support Memory 128MB PC-133 SDRAM Server version 3.23.32 Protocol version 10 Connection localhost via TCP/IP TCP port 3306 Uptime: 19 hours 50 min 34 sec Threads: 2 Questions: 4551989 Slow queries: 0 Opens: 13 Flush tables: 1 Open tables: 0 Queries per second avg: 63.723 Here is the contents of the mysql.err error log: C:/MYSQL/bin/mysqld-opt.exe: ready for connections 010207 23:32:23 C:/MYSQL/bin/mysqld-opt.exe: Normal shutdown 010207 23:32:23 C:/MYSQL/bin/mysqld-opt.exe: Shutdown Complete C:/MYSQL/bin/mysqld-opt.exe: ready for connections mysqladmin status gives: Uptime: 71416 Threads: 2 Questions: 4551985 Slow queries: 0 Opens: 13 Flush tables: 1 Open tables: 0 Queries per second avg: 63.739 +--+--+ | Variable_name| Value| +--+--+ | Aborted_clients | 0| | Aborted_connects | 0| | Bytes_received | 0| | Bytes_sent | 0| | Connections | 8| | Created_tmp_disk_tables | 0| | Created_tmp_tables | 0| | Created_tmp_files| 0| | Delayed_insert_threads | 0| | Delayed_writes | 0| | Delayed_errors | 0| | Flush_commands | 1| | Handler_delete | 0| | Handler_read_first | 1| | Handler_read_key | 0| | Handler_read_next| 0| | Handler_read_prev| 0| | Handler_read_rnd | 0| | Handler_read_rnd_next| 8| | Handler_update | 0| | Handler_write| 4544830 | | Key_blocks_used | 7764 | | Key_read_requests| 38159880 | | Key_reads| 3032717 | | Key_write_requests | 9364345 | | Key_writes | 9364345 | | Max_used_connections | 1| | Not_flushed_key_blocks | 0| | Not_flushed_delayed_rows | 0| | Open_tables | 0| | Open_files | 0| | Open_streams | 0| | Opened_tables| 13 | | Questions| 4551966 | | Select_full_join | 0| | Select_full_range_join | 0| | Select_range | 0| | Select_range_check | 0| | Select_scan | 0| | Slave_running| OFF | | Slave_open_temp_tables | 0| | Slow_launch_threads | 0| | Slow_queries | 0| | Sort_merge_passes| 0| | Sort_range | 0| | Sort_rows| 0| | Sort_scan| 0| | Threads_cached | 0| | Threads_created | 7| | Threads_connected| 2| | Threads_running | 1| | Uptime | 71310| +--+--+ +-+- -+ | Variable_name | Value | +-+- -+ | ansi_mode | OFF | | back_log| 50 | | basedir |
Simple datatype question
Hello, I'm looking at the manual, and I cannot find the answer to this simple question. What is the datatype in mysql for boolean? In Access it's yes/no. What about mysql? Thanks Joel
Re: PHP - working with two MySQL serwers
Anna wrote: No. As long as you give them different names. :-) $connectionLocal=mysql_connect(bleah, bleah, bleah); $connectionOther=mysql_connect(bleah, bleah, bleah); Then in any mysql_query you must, of course, specify which connection you are using. Anna Thanx, I've already tried (I use Vmware software to "simulate" two linux servers on my home computer) and it works fine. Regards -- Mariusz Brzezinski WBK SA tel. +48 61 856 53 57 mobile +48 501 623 123 - 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: HOW DO I CAN DO THIS...
"MAN ..." wrote: HI THERE, I HAVE A PROBLEM WITH THE ETTIQUETES OF THE DATABASE, I MEAN HOW DO I CAN MAKE A SITE WHERE I CAN UPLOAD INFORMATION WITH A DATABASE, FOR EXAMPLE: IF I WANT A PAE WHERE SAYS "PUT YOUR NAME HERE" AND YOU HAVE TO PUT IT IN AN TEXTAREA HOW DO I MAKE THAT THAT NAME CAN GO TO MY DATABASE I TRIED PUTIN' THIS FORM NAME="AND HERE I PUT THE DATABASE'S NAME" METHOD="GET" ACTION="URL OF THE DATABASE" INPUT TYPE="" NAME="CAMP NAME"BRINPUT TYPE="SUBMIT" VALUE="UPLOAD" BUT I DIDNT GET THAT IT ONLY OFFERS ME TO DOWNLOAD THE DATABASE. HELP MEE Read the manual please. And also please buy new keyboard with working CapsLock key. Current keyboard annoys users. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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