Re: increasing InnoDB search performance
Eric, Eric Mayers wrote in message ... I have an application that stores a large (up to 6gb) database in an InnoDB table. I'm using an InnoDB table to have concurrent inserts and selects and to get beyond the 2gb limitation. I have to allow read-only remote database connections and cannot enforce that users use any kind of special query to access the database (e.g., implementing my own fulltext-like index and using the index at an application layer). The content consists of log entries which are each under 255 characters long. use the VARCHAR type instead of CHAR type. Otherwise your columns will take a full fixed length of space and the table will be bigger and slower. I'd like to know what I can do to improve the response time of the database under these restrictions. So I have a few questions: Would adding ram help? I can't imagine that an operation that requires searching 6gb (a disk bandwidth or processing bottleneck problem) would be improved much by adding ram.. ? If every query needs to scan the whole 6 GB table, or access it totally at random, then adding RAM does not help. But usually queries have a restricted working set, and a much smaller buffer pool can serve most queries quickly. Adding RAM and incresing the buffer pool size helps in most cases. Can I do anything (short of hardware changes) to increase performance? The usual way is to use EXPLAIN SELECT, and in very problematic cases use the STRAIGHT JOIN and USE INDEX (index1, index2, ...) clauses of MySQL to force a query plan. The MySQL 'slow query log' can be used to track slow queries. The Unix 'top' and the Windows Task Manager are the best way to determine if the load is CPU-bound or I/O-bound. innodb_monitor prints very detailed statistics on the internal working of InnoDB, and you can also innodb_lock_monitor to track lock waits, if they are a problem. And long term question: I've noticed that a fulltext index feature doesn't appear on the InnoDB todo list. From my (limited) research, it looks like this is a feature a lot of people would find very useful. Is this a long term goal, or has it been excluded for some reason? There has been demand of a fulltext indexing capacity on InnoDB type tables. If there are enough paying customers requesting it, we can assign a developer to port the MyISAM fulltext search on InnoDB. Fulltext indexes will work also on a transactional database. Thanks Eric Mayers Software Engineer Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - 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
Strange problem
Hi, I work with a rel. 3.23.36 of MYSQL and I have found this problem: I have two tables named t_payments and t_payment_lang; these are their descriptions and data: t_payments (description): +-+---+--+-+-+ + | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+ + | pay_key | int(11) | | PRI | NULL| auto_increment | | pay_enabled | tinyint(1)| YES | | 0 | | | pay_fixed_comm | decimal(18,4) | YES | | 0. | | | pay_perc_comm | decimal(18,4) | YES | | 0. | | | pay_step_height | decimal(18,4) | YES | | 0. | | | pay_step_width | decimal(18,4) | YES | | 0. | | | pay_tax_id | int(11) | YES | | 1 | | | pay_default | tinyint(1)| YES | | NULL| | | pay_en_download | tinyint(1)| YES | | NULL| | +-+---+--+-+-+ + t_payments (data, some fields) +-+-++-+-+ | pay_key | pay_enabled | pay_fixed_comm | pay_default | pay_en_download | +-+-++-+-+ | 1 | 1 | 0. | 1 | 1 | | 2 | 1 | 0. | 0 | 1 | | 3 | 0 | 0. | 0 |NULL | | 4 | 1 | 0. | 1 |NULL | +-+-++-+-+ t_payment_lang (description): +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | pyl_key | int(11) | | PRI | NULL| auto_increment | | pyl_pay_id | int(11) | | | 0 || | pyl_lang_id | int(11) | | | 0 || | pyl_description | varchar(100) | YES | | NULL|| +-+--+--+-+-++ t_payment_lang (data) +-++-+--+ | pyl_key | pyl_pay_id | pyl_lang_id | pyl_description | +-++-+--+ | 1 | 1 | 1 | Cash on delivery | | 17 | 2 | 1 | Credit Card | | 18 | 3 | 1 | Credit Card 2| +-++-+--+ The result of this query: SELECT pay_key, pyl_description, pay_en_download FROMt_payments,t_payment_lang WHERE t_payments.pay_key = t_payment_lang.pyl_pay_id AND t_payment_lang.pyl_lang_id = 1 AND t_payments.pay_enabled 0; is: +-+--+-+ | pay_key | pyl_description | pay_en_download | +-+--+-+ | 1 | Cash on delivery |NULL | | 2 | Credit Card |NULL | +-+--+-+ the correct (aspected!) result is: +-+--+-+ | pay_key | pyl_description | pay_en_download | +-+--+-+ | 1 | Cash on delivery | 1 | | 2 | Credit Card | 1 | +-+--+-+ I obtain the correct result if i write the same query in this way: SELECT pay_key, pyl_description, pay_en_download FROMt_payments LEFT JOIN t_payment_lang ON t_payments.pay_key = t_payment_lang.pyl_pay_id WHERE t_payment_lang.pyl_lang_id = 1 AND t_payments.pay_enabled 0; or if I drop the column pay_fixed_comm column from table t_payments. I don't understand why ! Thanks for any advice. Luca - 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 create table error
Hi! You have not created an index on your foreign key. From http://www.innodb.com/ibman.html : ... An example: CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id)) TYPE=INNODB; Both tables have to be InnoDB type and there must be an index where the foreign key and the referenced key are listed as the first columns. InnoDB does not auto-create indexes on foreign keys or referenced keys: you have to create them explicitly. If MySQL gives the error number 1005 from a CREATE TABLE statement, and the error message string refers to errno 150, then the table creation failed because a foreign key constraint was not correctly formed. . Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Demirchyan Oganes-AOD098 wrote in message ... I have the following create table, and I get the following error when I create it. It used to work before. Can anyone help? CREATE TABLE PROTOCOL_GROUPING( PROTOCOL_GROUPING_ID MEDIUMINT(20), GROUP_NAMEVARCHAR(50)NOT NULL, PROTOCOL_ID MEDIUMINT(20) NOT NULL, PROTOCOL_STEP_NO MEDIUMINT(10) NOT NULL, foreign key (PROTOCOL_ID, PROTOCOL_STEP_NO) REFERENCES PROTOCOL_STEP(PROTOCOL_ID, PROTOCOL_STEP_NO), UNIQUE INDEX PROTOCOL_GROUPING_PK (PROTOCOL_GROUPING_ID))Type=InnoDB; I get the following error: can't create table .\test\protocol_grouping.frm (errno 150) Oganes Demirchyan Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 11:02 AM To: Demirchyan Oganes-AOD098 Subject: Re: mysql create table error Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,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
Regarding disk accesses and main memory ussage
Dear Members, How can I know the no. disk acesses and the main memory used to execute a particular query in mysql ? Plz mail me asap. in anticipation Praveen Sirupa - 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: Network drive for datadir
That's a bit of a pain :) Any idea if this will be supported at some point? Cheers, Neil Victoria Reznichenko wrote: Neil, Monday, February 04, 2002, 6:00:18 PM, you wrote: NF Hi, NF Ideally I wish to keep all of my database files on a network drive NF (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which NF resides in my WINNT directory. NF my.ini contents... NF [mysqld] NF basedir=C:/mysql NF #bind-address=127.0.0.1 NF datadir=X:/Shared/MyData/data NF #language=C:/mysql/share/your language directory NF #slow query log#= NF #tmpdir#= NF #port=3306 NF #set-variable=key_buffer=16M NF [WinMySQLadmin] NF Server=C:/mysql/bin/mysqld-nt.exe NF user=guest NF password=guest NF Upon starting the MySQL service though I receive the error message NF Could not start the Mysql service on \\DELL02. Error 1067: The process NF terminated unexpectedly. I have copied the databases to a local drive NF (D:\) and altered the my.ini file and all works well. NF Does anyone know why I cannot use MySQL to access databases on a NF networked drive??? MySQL doesnt support loading files from Windows/samba shares. NF Neil -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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 *** This message was virus checked with: SAVI 3.53 Jan 2002 last updated 30th January 2002 *** -- Email: [EMAIL PROTECTED] [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: performance help required. (2G - 4G Ram upgrade)
Hi, We use Red Hat Linux release 7.1 (Seawolf) Kernel 2.4.3 on a 2-processor i686 Only around 5000 of the rows match out of the 58,000,000. As I understand it, we do have single indexes on each of the columns. Given the replies below, I feel that mysql is not getting the optimisation correct. Do I need to analyse the key distribution or something to give MySQL more up to date information. If so, can I do that without locking the table / taking the database down? When I use USE INDEX(log_id_idx) it still ignores me and does what it wants. Is that right? Thanks again for your help, Robin -Original Message- From: Almar van Pel [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 00:02 To: [EMAIL PROTECTED]; Robin Keech Subject: RE: performance help required. (2G - 4G Ram upgrade) Hi, Your problem is that your query uses all of the rows in the table. That means that the indexes on the table are incorrect. You should try putting a single index on prev_e3_id and a single index on the other table. It'll probably improve your performance a lot. BTW. Schedule some time for maintenance periodically to optimize these heavy tables. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 5 februari 2002 0:04 Aan: Robin Keech CC: '[EMAIL PROTECTED]' Onderwerp: Re: performance help required. (2G - 4G Ram upgrade) On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote: (Please reply directly, I am only on the digest list, thanks) I have an SQL statement that is taking far too long to run, around 11 minutes (while locking inserts/updates). We have installed some more RAM, and I need help with my.cnf and the troublesome SQL. Can anyone suggest some config values to best utilise the extra RAM I have just fitted? We have gone from 2G to 4G On what operating system? The table in question is very large, ie e3_id_chain.MYD = 3.7G ~ 53 million records e3_id_chain.MYI = 3.2G These are my current settings # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=512M set-variable= max_allowed_packet=2M set-variable= max_connections=500 set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= wait_timeout=1800 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M log-bin low-priority-update When doing an SQL select it takes 11 minutes mysql explain SELECT e3_id, prev_e3_id, log_id FROM e3_id_chain WHERE prev_e3_id IS NOT NULL AND log_id IS NOT NULL; +-+--+---+--+-+--+-- ++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+-- ++ | e3_id_chain | ALL | prev_e3_id_idx,log_id_idx | NULL |NULL | NULL | 58179805 | where used | +-+--+---+--+-+--+-- ++ 1 row in set (0.00 sec) But its not using the index??? Correct. And that key_buffer won't help much. How many of the rows actually match your query? Can anyone explain this behaviour, and suggest a solution? MySQL will decide not to use an index in cases when it believes there is a faster way, such as a full table scan. This is often the case when a significant percentage of the rows are likely to match. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,771,714 queries (385/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/02 - 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: Programming with C API question
Hi, all MySQL team Thanks for your former help. Here is another question: As MySQL support multiple instances, each instance will run with different socket file and tcp/unix port number. I want to know when using MySQL client programs like mysqladmin to connect different instances, are both socket file and port number parameter necessary(without any Option file)? For example: we have 2 instances running on one machine Instance West runs with /var/lib/mysql/west.sock and port: 3307 Instance East runs with /var/lib/mysql/east.sock and port: 3308 So if we want to connect to instance East using mysqladmin, is following safety enough (not specify port number)? /usr/bin/mysqladmin -u root -p -S /var/lib/mysql/east.sock status In addition, how about with C API like mysql_real_connect()? Thanks for your help and best wishes Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) +86 10 6731 1652 (H) Fax:+86 10 8529 8979 E-mail: [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
What is ROWNUM of oracle in mysql
Hi, What is the alternative in mysql for ROWNUM of Oracle? Thanks, Rama Raju - 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: OT: *nix text editor?
On Mon, Feb 04, 2002 at 08:01:39PM -0700, Matthew Walker wrote: I need to find a text editor for Linux that doesn?t load the whole file into memory. I need to edit a 1.5 gig text flatfile to add two lines. But I don?t have enough ram to open it in most programs. Can anyone recommend something? echo 'select 1 from all; ' myfile.sql echo 'select 2 from all; ' myfile.sql is that editor enough? :) (table etc) -- The Moon is Waning Crescent (41% of Full) nieuw.nl - 2dehands.nl: 15463 - 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
Which is Faster
Dear all, Which of the following SQL queries is faster and better select thefield from thetable group by thetable Or select distinct thefield from thetable? and WHY? Best Regards Hayan Get your own 800 number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag - 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
sorting the varchar field?
hi again, Now I need to sort a field of varchar type. But the filed values are like... b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12 meaning thereby, an integer prefixed by some character. Is there any straight way to frame the query? thanx in advance for your time, regards, -vishi - 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
update failing when statement includes
Kinney, Monday, February 04, 2002, 9:06:45 PM, you wrote: KB Hi, KB I'm playing with PHP/MySQL for the first time having used Perl and MySQL KB for years. KB In one of my first update scripts, PHP is automatically escaping quotes and KB such, which I assumed was a good thing. KB However, I'm noticing that MySQL is rejecting statements like: KB Update faqs SET subject='Adding FAQ\'s' WHERE id=110 ; KB It also rejects: KB Update faqs SET subject=Adding FAQ\'s WHERE id=110 ; KB I've tested these out on the MySql command line and find the same thing. KB Rows matched: 1 Changed: 0 Warnings: 0 KB It finds the row but doesn't make the change. I tested your example and it had worked fine in both cases. KB Thanks. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
Hi, Help!
Erin, Tuesday, February 05, 2002, 12:37:33 AM, you wrote: EL Hi, this is Erin Lilly, I've used support before with you all for EL bodyconsultant.com and you were extremely helpful. I'm installing mysql on EL erinlilly.net and have run into that common /tmp/mysql.sock (111) error EL version: 3.23.45-pc-linux EL you then need to type in /usr/local to see where I've installed the EL mysql-3.23.45 EL Please take a look where I had installed it in EL /usr/local/mysql-3.23.45-pc-linux-i686 EL I've created a ln -s from tmp to /usr/local/mysql-3.23 EL have created a ln -s from mysql-3.23.45 and mysql EL What's the problem?? When I go to do the ./bin/safe_mysql command it turns EL server on then logs off. Also when I do bin/mysqladmin -u root -p password EL it gives me the /tmp/mysql.sock (111) not found - even though I have ln -s EL that tmp directory to the mysql-3.23.45 ... EL Have tested the telnet erinlilly.net 3306 - and no connection. EL MY QUESTIONS: EL 1. What do I need to do to get the connection going. EL 2. How can I be sure the tables were created. I ran install_db and it EL appeared to do everything. You should do : ls data_dir/mysql data_dir is the MySQL data directory. EL 3. What do I need to do to make things right here? EL 4. Have all my ln -s created some inherent problems? Check the following links: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html http://www.mysql.com/doc/m/y/mysql_install_db.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
BEGIN/COMMIT statements not written to the binary log : may it cause problems with replication ?
Hello there, I use MySQL (4.0.1) with InnoDB tables with binary logging on. I see that the BEGIN and COMMIT statements that wrap my queries are not written to the binary log. I perfectly understand this if I have one server. But assume I have a master server, and a slave server that replicates the master. Let's say I distribute reads. Let's say I issue the following queries on the master (I use BEGIN and COMMIT for consistency) : BEGIN; update accounts set sum=sum-100 where num=10; update accounts set sum=sum+100 where num=12; # I don't work in a bank !! COMMIT; then only update accounts set sum=sum-100 where num=10; update accounts set sum=sum+100 where num=12; is written to the master's binary log, and then propagates to the slave. Assume that, while it is propagating I issue a reading query on the slave : select sum from accounts where num in(10,12); Then, to my mind, this select might be treated AFTER the first update being processed by the slave, and BEFORE the second update being processed by the slave. Then I'll get not-consistent results. This would not happen if BEGIN and COMMIT had been written to the master's binary log. Does anyone here agree or am I misunderstanding anything ? If this problem really exists, is it to be fixed ? Thanks ! Guilhem BICHOT IPSN/DIR/SG/SI 01 46 54 92 31 mailto:[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: Which is Faster
Dear Hayan, Which of the following SQL queries is faster and better select thefield from thetable group by thetable Or select distinct thefield from thetable? and WHY? =if you use the MySQL command line to issue a query, a summary report follows any output giving number of rows affected and the time taken. =which of the two is quicker? =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transaction
hi, is mysql support transaction? how to setup it? please help thx felik __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with MySQL: Bind on unix socket error
On Tue, 2002-02-05 at 02:42, Joe Villari wrote: I'm hoping I can get some help here, I'm trying to get MySQL running on YellowDog Linux 2.4.17 kernel. I've installed the mysql, mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD. Ran mysql_install_db then changed the group and owner on /var/lib/mysql to root. I think that, at least, the owner of /var/lib/mysql should be mysql. This way, mysql can create the /var/lib/mysql/mysql.sock Hope this helps.. Also, be shure that there is no other mysqld process runnig. -- Diana Soares (sql) - 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: sorting the varchar field?
On Tue, 2002-02-05 at 10:18, Vishakha Mali_Wagh wrote: Now I need to sort a field of varchar type. But the filed values are like... b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12 meaning thereby, an integer prefixed by some character. Is there any straight way to frame the query? OK, if the prefix is always one character you could use: SELECT ... FROM ... ORDER BY left(field,1), SUBSTRING(field,2)/XX where XX is the upper limit of the integer part of the field. I'm shure there are much better ways to do this, because this only applies when your field has a prefix of only one character and when you know the upper limit of the integer part of the field. Note that if you are using MySQL 4.0.2, you don't need this because you have the CAST() and CONVERT() functions. -- Diana Soares (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Regarding Disk Accesses Main memory ussage in mysql
Dear Members, How can I get the no. of disk accesses main memory used to execute a particular query in mysql ? Plz reply asap. Thanx in advance. Praveen Sirupa - 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: transaction
Yes MySQL supports transaction. But you have to use certain table types : for example InnoDB or BDB (and not MyISAM). I use InnoDB ; read the following section of the manual : http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I nnoDB it will tell you which options you may have to set in your my.cnf or my.ini file. After that, you will have BEGIN/COMMIT/ROLLBACK, automatic crash recovery, etc. Guilhem -Message d'origine- De : Felik Harmanto [mailto:[EMAIL PROTECTED]] Envoye : mardi 5 fevrier 2002 12:10 A : [EMAIL PROTECTED] Objet : transaction hi, is mysql support transaction? how to setup it? please help thx felik __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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
How do I get a new working mysql.sock?
Stuart, Monday, February 04, 2002, 7:36:39 PM, you wrote: SO some stupid fool has deleted the mysql.sock file from our redhat server SO system. (me!) SO How do I regenerate one? You should restart your MySQL server. SO thanks a mil SO StuartO -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl process limitations
On Mon, 4 Feb 2002, Manuel Bouyer wrote: What a minute ... you're loading the tables to a 'mysqld' process, using the 'mysql' command, rigth ? Maybe it's just the mysql command which runs out of files descriptors ? Did you try to raise the limit of the shell before starting it ? On Mon, 4 Feb 2002, Randy Arabie wrote: Right. Like this: mysql -u someuser -p -D somedatabase ./data.sql No. I didn't raise the shell limits, I rose the kernel maxfiles and the mysqld process proc.pid.rlimit.descriptors.soft limit. I'll try the shell tonight. Summary of Last Nights activities: 1) Switched back to the GENERIC kernel. 2) Edit /etc/sysctl.conf; added a line kern.maxfiles=5000 3) Reboot 4) Bump hard and soft proc.[mysqld_pid].rlimit.descriptors up to 2500. 5) Bump hard and soft proc.[shell_pid].rlimit.descriptors up to 2500. 6) Attempt to load the data, failure once again, same error message: ERROR 1017 at line 445: Can't find file: './geeklog/userinfo.frm' (errno: 23) 7) fstat | wc -l shows 203 open files (done immediately following step 6 above. 8) fstat | grep mysqld | wc -l shows mysqld only has 64 open files. 9) The database only has 38 tables, and the datafile I'm trying to load is only 37 KB. Someone suggested a few days ago that perhaps the error reported is not accurate. How would I test that? My 'gut' says this is probably an easily resolved configuration issue, but I'm stumped on where to go next. -- Cheers! Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl process limitations
On Tue, Feb 05, 2002 at 07:59:20AM -0700, Randy Arabie wrote: On Mon, 4 Feb 2002, Randy Arabie wrote: Right. Like this: mysql -u someuser -p -D somedatabase ./data.sql No. I didn't raise the shell limits, I rose the kernel maxfiles and the mysqld process proc.pid.rlimit.descriptors.soft limit. I'll try the shell tonight. Summary of Last Nights activities: 1) Switched back to the GENERIC kernel. 2) Edit /etc/sysctl.conf; added a line kern.maxfiles=5000 3) Reboot 4) Bump hard and soft proc.[mysqld_pid].rlimit.descriptors up to 2500. 5) Bump hard and soft proc.[shell_pid].rlimit.descriptors up to 2500. 6) Attempt to load the data, failure once again, same error message: ERROR 1017 at line 445: Can't find file: './geeklog/userinfo.frm' (errno: 23) 7) fstat | wc -l shows 203 open files (done immediately following step 6 above. 8) fstat | grep mysqld | wc -l shows mysqld only has 64 open files. 9) The database only has 38 tables, and the datafile I'm trying to load is only 37 KB. Someone suggested a few days ago that perhaps the error reported is not accurate. How would I test that? My 'gut' says this is probably an easily resolved configuration issue, but I'm stumped on where to go next. Now I would try to ktrace both mysqld and the mysql loading the tables ... -- Manuel Bouyer, LIP6, Universite Paris VI. [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: Which is Faster
At 04:21 AM 2/5/2002 , you wrote: Dear all, Which of the following SQL queries is faster and better select thefield from thetable group by thetable Or select distinct thefield from thetable? and WHY? Best Regards Hayan Hayan, I believe the Select Distinct.. gets translated into a Group By so they should both be identical. Brent - 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
Spam Filtered - Re: Making Unique Pairs ??
HUH ? Oh well lets try again, please read below ... SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%' Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a table such as IDpath_idword ID is the primary key unqigned int path_id is a foreign key unsigned int word is a single word of text varchar (32) How can I set up the table such that all -pairs- of PATH_ID and WORD are unique? The table should look like the following 12jim 23tom 32joe 47jack but if I try an insert '2' and 'jim' again, the statement fails. Any thoughts? - 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
PHP and pconnect
Hi The I have noticed that the number of Aborted Clients and Aborted Connections has increased sharply recently on our two production servers, but not on our development server. Yesterday we started getting a number of blocked host errors, which we had to clear up with flush hosts. http://www.mysql.com/doc/B/l/Blocked_host.html This morining, I increased the max_connect_errors from 10 to 1, and the problem has thankfully disappeared. I know that this hides the problem, but I am at a loss to explain the cause. The favourite causes are - use of mysql_pconnect (introduced in Novemeber) - use of fsockopen($Primary, 3306, $errno,$errstr,5) (closed by fclose()) to test if connection possible before attempting connection (introduced last week) - much high web activity causing recycling of httpd processes mysql_pconnect was used to improve performance, and reduce load -- it works fsockopen is used to determine if the web process should use the local, or remote database. Can anyone shed any light on the causes of Aborted Clients and Connects, and whether mysql_pconnect and fsockopen would have an effect ? Simon - 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: Spam Filtered - Re: Making Unique Pairs ??
alter table your_table add unique index (path_id,word) ; -Message d'origine- De : Jon Shoberg [mailto:[EMAIL PROTECTED]] Envoyé : mardi 5 février 2002 16:40 À : [EMAIL PROTECTED] Objet : Spam Filtered - Re: Making Unique Pairs ?? HUH ? Oh well lets try again, please read below ... SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%' Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a table such as IDpath_idword ID is the primary key unqigned int path_id is a foreign key unsigned int word is a single word of text varchar (32) How can I set up the table such that all -pairs- of PATH_ID and WORD are unique? The table should look like the following 12jim 23tom 32joe 47jack but if I try an insert '2' and 'jim' again, the statement fails. Any thoughts? - 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: sysctl process limitations
On Tue, 5 Feb 2002, Manuel Bouyer wrote: On Tue, Feb 05, 2002 at 07:59:20AM -0700, Randy Arabie wrote: On Mon, 4 Feb 2002, Randy Arabie wrote: Right. Like this: mysql -u someuser -p -D somedatabase ./data.sql No. I didn't raise the shell limits, I rose the kernel maxfiles and the mysqld process proc.pid.rlimit.descriptors.soft limit. I'll try the shell tonight. Summary of Last Nights activities: 1) Switched back to the GENERIC kernel. 2) Edit /etc/sysctl.conf; added a line kern.maxfiles=5000 3) Reboot 4) Bump hard and soft proc.[mysqld_pid].rlimit.descriptors up to 2500. 5) Bump hard and soft proc.[shell_pid].rlimit.descriptors up to 2500. 6) Attempt to load the data, failure once again, same error message: ERROR 1017 at line 445: Can't find file: './geeklog/userinfo.frm' (errno: 23) 7) fstat | wc -l shows 203 open files (done immediately following step 6 above. 8) fstat | grep mysqld | wc -l shows mysqld only has 64 open files. 9) The database only has 38 tables, and the datafile I'm trying to load is only 37 KB. Someone suggested a few days ago that perhaps the error reported is not accurate. How would I test that? My 'gut' says this is probably an easily resolved configuration issue, but I'm stumped on where to go next. Now I would try to ktrace both mysqld and the mysql loading the tables ... You mention that, mysqld AND mysql. You will note above that when I checked mysqld with fstat, there were only 64 files open. That, coincidentally, is the default proc.curproc.rlimit.descriptors.soft setting. Does mysqld fork they mysql process, which may not be inheriting the limits set for mysqld? Can I add a line in /etc/sysctl.conf to allow all processes to have a greater default soft limit for descriptors? Or could I recompile my kernel to change that? I looked in kernel config and didn't see the options to change such things. -- Cheers! Randy - 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
insert into.. select from mult. tables
Hello, I'm relatively new to mysql and I've come across a problem while trying to insert values from multiple tables into a single, existing table. Here's the syntax that I'm using: insert into table1 (col1,col2,col3,col4) select Foo.col1, Foo.col2, Bar.col3, Bunk.col4 from table2 as Foo, table3 as Bar, table4 as Bunk where Foo.col1 = 5 and Bar.col1 = 5 and Bunk.col1 = 5; This works fine so long as the where clause is true. Now here's my problem: I used AND in the above example however, what I want is for each expression to be evaluated individually, like an OR that will not stop if the first expression is true. So, each of the source tables may or may not satisfy the condition, if they do, then the proper value is inserted into table1, if they do not, then some default value should be inserted into table1 (null). This is an if / else problem but I don't know if mysql supports anything of the sort or if I need to use some sort of script to work around this prolem. Any advice would be greatly appreciated. Thanks. Justin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sysctl process limitations
On Tue, Feb 05, 2002 at 08:34:34AM -0700, Randy Arabie wrote: You mention that, mysqld AND mysql. You will note above that when I checked mysqld with fstat, there were only 64 files open. That, coincidentally, is the default proc.curproc.rlimit.descriptors.soft setting. Does mysqld fork they mysql process, which may not be inheriting the limits set for mysqld? Can I add a line in /etc/sysctl.conf to allow all processes to have a greater default soft limit for descriptors? The sysctl stuff should be enouth. Did you check that the values have really been raised ? The 'safe_mysqld' script I use has an option to raise the limit: /usr/pkg/bin/safe_mysqld --open-files-limit=256 Anyway the error code doesn't match a per-process limit but a system limit. This is why I would use ktrace to check what the error really is. -- Manuel Bouyer, LIP6, Universite Paris VI. [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: libc6 binary same as i686?
Steve [EMAIL PROTECTED] writes: I'm trying to pick the best path, but between this older K62 and the warning about gcc 2.96, I'm having trouble :) (I'll be using a K62 with RH7.1) The rpms here http://people.redhat.com/teg/mysql/ should work just fine (they're built in a RHL 7.2 environment, but don't think mysql uses anything which changed). -- Trond Eivind Glomsrød Red Hat, Inc. - 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
mysqld
I have problems with starting mysqld. When i put down command: ./safe_mysql it returns message: Starting mysqld deamon with databases from /usr/local/mysql/var 020205 15:07:03mysql ended I've instaled latest mysql from source distribution on Linux Slackware 8.0. Lp jure - 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: PHP and pconnect
- use of mysql_pconnect (introduced in Novemeber) - use of fsockopen($Primary, 3306, $errno,$errstr,5) (closed by fclose()) to test if connection possible before attempting connection (introduced last week) - much high web activity causing recycling of httpd processes You're putting more load on everything by opening the connection with fsockopen. Simply do the following: $db = @mysql_pconnect(...); if (!$db) die(connection failed); Can anyone shed any light on the causes of Aborted Clients and Connects, and whether mysql_pconnect and fsockopen would have an effect ? I'd guess your fsockopen calls are causing Aborted Clients to rise. If you still have problems after fixing that, then my first idea would be that PHP does not clean up properly when a client aborts the page by pressing the stop button. This would be rather easy to test. If you're using Apache, you can also try setting MaxRequestsPerChild to something like 1, so that after a while the process will die and hopefully close any open connections to the MySQL server. Or if you're already doing this, try disabling it and seeing if it helps. - 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
admin privilege problems
hello, i made the mistake of changing my root password manually in the mysql database. after doing so, i 'flushed privileges'. now i'm unable to log on using the root. i've tried to log on using the new password a number of times, but i'm always denied access. strangely enough, other users (that have passwords) can log on successfully without providing a password. does anybody have any recommendations for logging on as the root user ... and fixing this privileges problem? version 3.23.46 thx jeremy - 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
Installing MySQL in Home Directory
Dave, Monday, February 04, 2002, 10:08:04 PM, you wrote: DM I'm currently trying to install MySQL in my home directory on a server which DM I do have root access to. I follow the steps outlined in O'Reilly's DM 'MySQLmSQL' book and I get through the first several steps before problems DM occure. To set the stage, I'm using mysql-3.23.47. I'm able to 'configure', DM 'make', and 'make install' without any issues, but when I go to run DM 'mysql_install_db', it gives me permission errors trying to access DM '/var/lib/mysql'. When I ran the 'configure', I added the '--prefix' and DM '--localstatedir' flags with directories which my login would be able to DM access, including one which I thought would override '/var/lib/mysql'. Have you compiled the source tree after you reconfigured? DM Dave Mittner -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
How can I create InnoDB table
sreedhar, Tuesday, February 05, 2002, 6:42:51 AM, you wrote: s How can I create InnoDB table. If I tried create a InnoDB Table on my RedHat s Linux MySQL 3.23.26 . Can any body give details that how can I create InnoDB s table. You can find info about it in the manual: http://www.mysql.com/doc/U/s/Using_InnoDB_tables.html s Thanks in advance, s sreedhar -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
FULL-TEXT Index / Searching Question
Hello, I have two tables in my database as such: CREATE TABLE `skill_names` ( `id` bigint(20) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) ); CREATE TABLE `skills` ( `skills_id` int(11) NOT NULL auto_increment, `member_id` int(11) NOT NULL default '0', `schooling` varchar(100) default NULL, `certifications` varchar(20) NOT NULL default '', `description` blob NOT NULL, `skill_name_id` bigint(20) NOT NULL default '0', PRIMARY KEY (`skills_id`) ); I would like to make full text indexes of the skills table as well as the other tables in the database. My question is that I would like to be able to search for the Member_ID's that have a certain skill name. How would I accomplish this? Also, right now the database has about 300 records, the database runs on a Pentium 200 with 96Mb. Can it handle this not much traffic? Thanks. Matt Rudderham I am running MySQL 3.23.38 - 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
Table join question
Hi, I'm trying to build a query to solve a fairly simple problem. I have two tables (A and B) linked by a common ID. I want to locate a specific record in A that is linked to two or more records in B based on second field in B matching certain criteria. I've tried every type of inner, outer, left, and right join to accomplish this, but can't come up with anything that works. EG: Select * from A inner join B on A.ID=B.ID where B.Val='25' and B.Val='35'; This will rturn zero matching records since B.Val can't equal 25 and 35 at the same time. If I substitute and with or, I will get multiple records from A that are linked to either 25 or 25. I just want the one record that is linked to both 25 AND 35. Thanks for any help. Barry Wiegan Senior Software Engineer The Scout Project http://www.scout.cs.wisc.edu/ - 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 join question
On Tuesday 05 February 2002 9:59 am, Barry J. Wiegan wrote: Hi, I'm trying to build a query to solve a fairly simple problem. I have two tables (A and B) linked by a common ID. I want to locate a specific record in A that is linked to two or more records in B based on second field in B matching certain criteria. I've tried every type of inner, outer, left, and right join to accomplish this, but can't come up with anything that works. EG: Select * from A inner join B on A.ID=B.ID where B.Val='25' and B.Val='35'; This will rturn zero matching records since B.Val can't equal 25 and 35 at the same time. SELECT * FROM A inner join B on A.ID = B.ID inner join B AS C on A.ID = C.ID where B.Val = '25' and C.val = '35'. Or something similar. I can't be bothered to open my SQL reference at the moment. :) (For the sake of completeness, it is worth realising that you would _often_ need to ensure that the row in B and C are not the same row... not necessary here, though as you know they aren't as B.val and C.val are different). - 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
admin privilege problems
jeremy, Tuesday, February 05, 2002, 6:40:29 PM, you wrote: jr hello, jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. jr thx jr jeremy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sql gurus
Hi I am working on a search logging script to count the most popular word or phrases searched for. Table I could add a line for each search, and aggregate the results for reports, but I was wondering about the following which would keep table sizes down. | search word | count | = | Nuts |125 | | Bolts|119 | | Screws |110 | | Washers | 98 | If the word is already in the table increment the counter, if not add the word and set counter to 1 query 1 = update counter where word = search word if no records updated query 2 = insert word and set counter to 1 Is there a single query that will do this or does it have to be 2? thanks Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- - 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
Using SQL in a C Program
Most of my experience with SQL comes from an SQL environment in which the program will run through and end fairly quickly. I'm now up against a constantly running C program which utilizes the database on a regular basis. In this case, is it better practice to only open the connection for the duration of use, or have it open constantly and run a check to reconnect if it dies for some reason? I'm not sure if there's any correct answer to this, but I'd welcome opinions. The speed of the connection is of the utmost importance and if time can be saved by keeping the connection constant, I think I'd prefer that way. Thanks, Dave Mittner - 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: Using SQL in a C Program
Whoops! Forgive me, I meant to say a CGI environment. This should be a lesson to me to proofread no matter the time restraints. :) - Original Message - From: Dave Mittner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 05, 2002 10:37 AM Subject: Using SQL in a C Program Most of my experience with SQL comes from an SQL environment in which the program will run through and end fairly quickly. I'm now up against a constantly running C program which utilizes the database on a regular basis. In this case, is it better practice to only open the connection for the duration of use, or have it open constantly and run a check to reconnect if it dies for some reason? I'm not sure if there's any correct answer to this, but I'd welcome opinions. The speed of the connection is of the utmost importance and if time can be saved by keeping the connection constant, I think I'd prefer that way. Thanks, Dave Mittner - 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: Sql gurus
Hi Peter, I am working on a search logging script to count the most popular word or phrases searched for. Table I could add a line for each search, and aggregate the results for reports, but I was wondering about the following which would keep table sizes down. | search word | count | = | Nuts |125 | | Bolts|119 | | Screws |110 | | Washers | 98 | If the word is already in the table increment the counter, if not add the word and set counter to 1 query 1 = update counter where word = search word if no records updated query 2 = insert word and set counter to 1 Is there a single query that will do this or does it have to be 2? Two - sorry! =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Network drive for datadir
Neil, Tuesday, February 05, 2002, 11:19:35 AM, you wrote: NF That's a bit of a pain :) Any idea if this will be supported at some point? Apparently it will not be supported. Disk file system differs from networking file system. MySQL will not work via networking file system. NF Cheers, Neil NF Victoria Reznichenko wrote: Neil, Monday, February 04, 2002, 6:00:18 PM, you wrote: NF Hi, NF Ideally I wish to keep all of my database files on a network drive NF (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which NF resides in my WINNT directory. NF Upon starting the MySQL service though I receive the error message NF Could not start the Mysql service on \\DELL02. Error 1067: The process NF terminated unexpectedly. I have copied the databases to a local drive NF (D:\) and altered the my.ini file and all works well. NF Does anyone know why I cannot use MySQL to access databases on a NF networked drive??? MySQL doesnt support loading files from Windows/samba shares. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
resetting a password
hello, following the instructions for resetting a password ( http://www.mysql.com/doc/R/e/Resetting_permissions.html ), i was not able to find the .pid file. is it possible to continue the process without killing it? what would be the command to restart the daemon using the --skip-grant-tables option? i wasn't able to figure it out. any help would be appreciated ... thx jeremy - 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: Obtaining GMT time in mySQL
MySQL: DATETIME vs. INT http://forums.devshed.com/showthread.php?s=threadid=29754forumid=4 C:heers! -Original Message- From: DL Neil -- Sent: Tuesday, February 05, 2002 1:28 AM Checking the MySQL manual (6.3.4 Date and Time Functions) UNIX_TIMESTAMP() UNIX_TIMESTAMP(date) ...returns a Unix timestamp (seconds since '1970-01-01 00:00:00' GMT) ...in local time: - 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
PHP - MySQL - SQL7 Server - Visual Basic.
Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. Thanks, Bob Hiller - 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: Network drive for datadir
At 16:00 04/02/2002 +, Neil Freeman wrote: Hi! I did the test in my small network and works. The only care I did is to mapped the network drive, assign a letter (in my case F). Please take a look if effectively you had mapped the drive X (trying to access the X drive with an DOS prompt). Regards, Miguel Hi, Ideally I wish to keep all of my database files on a network drive (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which resides in my WINNT directory. my.ini contents... [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=X:/Shared/MyData/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=guest password=guest Upon starting the MySQL service though I receive the error message Could not start the Mysql service on \\DELL02. Error 1067: The process terminated unexpectedly. I have copied the databases to a local drive (D:\) and altered the my.ini file and all works well. Does anyone know why I cannot use MySQL to access databases on a networked drive??? Neil Email: [EMAIL PROTECTED] [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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.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: Privileges - Replication
After reviewing the MySQL documentation about the available privileges and what they would be used for, I still was not able to find my answer. Can another user, besides root, use the replication commands? What would be the minimum set of privileges that could use SLAVE START, SLAVE STOP, SHOW SLAVE STATUS ? Luc Foisy - 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 Client/Server problem
Hi all, I want to connect a MySQL client from Windows NT to SUN Solaris 2.6. How can I do this? I need some services running in the Server (in my case, SUN Solaris). What means the message: Host my_IP is not allowed to connect to this MySQL server ?? Thanks in advance, Marcelo Muzilli Support Analyst Datacom/Access Ericsson Serviços de Telecomunicaçoes Ltda. +55 11 6224-8935 [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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: PHP - MySQL - SQL7 Server - Visual Basic.
Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? =Please clarify, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to setup mysql with Solaris 8?
I downloaded the following file from mysql.com. mysql-3.23.47-sun-solaris2.8-sparc.tar I untarred it into /mysql, then I have the following files. Look here: # ls bin include scripts sql-bench tests data lib share support-files # Then I went into /mysql/bin and tried running mysql like so: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # And I get the error message shown above. What should I do to set it up? Thanks. Jack __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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
more problems: session ends immediately ...
hello again, still learning ... i'm experiencing some unusual behaviors from the daemon. it stops immediately. [localhost:/usr/local/mysql] root# sudo ./bin/safe_mysqld --user=mysql [localhost:/usr/local/mysql] root# Starting mysqld daemon with databases from /usr/local/mysql/data 020205 15:13:40 mysqld ended any ideas ... always appreciated jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Memory limit issue with 64 bit mysql.3.23.46
We are running an extremely large instance of mysql version 3.23.46 on Solaris 2.8. We are attempting to use a software version compiled 64 bit and have been experiencing memory related server crashes. The behavior suggests that we are still unable to use more than 4G of memory. If the server is started with the following settings: key_buffer=4608M max_allowed_packet=1M table_cache=1024 record_buffer=1M sort_buffer=1M thread_cache=12 thread_concurrency=12 myisam_sort_buffer_size=512M We observe the following symptoms / problems: (1) A mysqladmin variables call shows that the key_buffer is set to be 1 G, not 4.5G. (2) Under any sort of database load, the server crashes with the following error output: mysql got signal 10; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=4831834112 record_buffer=1044480 sort_buffer=1048568 max_used_connections=0 max_connections=512 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 5765112 K bytes of memory Hope that's okay, if not, decrease some variables in the equation. If the server is started with more modest settings (e.g., key_buffer_size=2G), mysql operates correctly. Additionally, mysqladmin variables shows a correct key_buffer value. System memory is not a constraint ( 6 G real memory and 14.5 G swap). - 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: PHP - MySQL - SQL7 Server - Visual Basic.
Bob, I've posted this back onto the list because there are others here who will be much more able to assist. Clarification: I currently have 22 NT workstation that send data to various tables in a SQL7 database running on a NT sever. The visual basic front end organizes this data in to a neat fashion and allows the user to graph and print data and comparisons from the various tables. The front end also responds to e-mail requests for information from the tables. Currently there are only 12 authorized e-mail accounts so it is easy to manage. We are now going to add about 100 workstations, More tables and 200 authorized e-mails accounts. With this addition I have decided to eliminate the e-mail accounts and post all of this information to a secure web server that I will administer. So what I need to do is have a VB program write this data to a MySql database that will only allow users to view the data. I have extensive VB experience and have created and updated many types of databases using it, however I have never used MySql and need some pointers. Can Vb create and write to MySql databases? =yes, using an ODBC or ADO interface. What syntax do I use in PHP to read the MySql database? =PHP has a wide range of interface functions 'built-in'. =Why use two RDBMS'? PHP can access MS-SQL to provide the web service. =dn Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? - 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
deleting var=0.1
dear all. I have a problem using mysql(occured at using phpMyAdmin): i send the query: DELETE FROM test WHERE user = test AND timestamp = 2002-02-05 21:42:53 AND var1=1000.1 LIMIT 1 and 0 effect. but when var1 has a (INT) value there's no problem: DELETE FROM test WHERE user = test AND timestamp = 2002-02-05 21:42:53 AND var1=1000 LIMIT 1 might there be a problem using such values? has this error already occurded? I just joined this list -Matthias Hoffmann - 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: deleting var=0.1
In the last episode (Feb 05), Matthias Hoffmann said: dear all. I have a problem using mysql(occured at using phpMyAdmin): i send the query: DELETE FROM test WHERE user = test AND timestamp = 2002-02-05 21:42:53 AND var1=1000.1 LIMIT 1 and 0 effect. but when var1 has a (INT) value there's no problem: DELETE FROM test WHERE user = test AND timestamp = 2002-02-05 21:42:53 AND var1=1000 LIMIT 1 might there be a problem using such values? has this error already occurded? I just joined this list I assume var1 is a float in the first case? Due to rounding issues, the = operator will almost never work on fractions. Use the primary key to select which record to delete, or use a number range (var1 BETWEEN 1000.009 AND 1000.1001). -- Dan Nelson [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
Accessing large memory with 64-bit MySQL on Solaris
We've built MySQL 3.23.46 on Solaris 8/SPARC as a 64-bit executable using the Sun C compiler. Everything built OK. We built against ncurses, readline, and zlib, all built as 64-bit libraries. Are there any special settings to get MySQL to work properly in this environment or should things work as expected. If the server is started with the following settings: key_buffer=4608M max_allowed_packet=1M table_cache=1024 record_buffer=1M sort_buffer=1M thread_cache=12 thread_concurrency=12 myisam_sort_buffer_size=512M then mysqladmin variables shows key_buffer as 1G, not 4.5G. The Solaris 8 machine this is running on has 6GB real memory and 14.5GB of swap. -- albert chin ([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: deleting var=0.1
On Tuesday 05 February 2002 13:03, Matthias Hoffmann wrote: dear all. I have a problem using mysql(occured at using phpMyAdmin): i send the query: DELETE FROM test WHERE user = test AND timestamp = 2002-02-05 21:42:53 AND var1=1000.1 LIMIT 1 and 0 effect. but when var1 has a (INT) value there's no problem: DELETE FROM test WHERE user = test AND timestamp = 2002-02-05 21:42:53 AND var1=1000 LIMIT 1 might there be a problem using such values? has this error already occurded? I just joined this list There was just a thread on this topic. See the archives for the thread with the title Problem with where clause on the 1st of February. At the bottom of each e-mail on the list is a set of useful URLs to things like the archives. Best, Kyle - 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
LOAD DATA LOCAL queries
When using the LOCAL option to the LOAD DATA INFILE query, does the client program read in the file or does the server read in the file? I'm asking because I'm hoping that there is a way to disable the LOCAL option or make it so that the File_priv will even apply to the LOCAL option. Right now, I'm guessing that there currently isn't a way to do this. -- mark.krenz [EMAIL PROTECTED] ___ That's the only thing I'm not getting. -jeremy - 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
Permissions Problem
Hi; I get this error when I try to access a database as root: mysql use antigo; Can't read dir of './antigo/' (Errcode: 13) What does this mean and how do I fix it? TIA, BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to save image to MySQL ?
hi,forks, Now I try to save image to MySQL, I create a table with longblob field, i try two ways as follows but both did not work 1. use appendchunk, i succeed in saving image to MS SQL with this funtion. but i can't save image to MySQL with it. 2. using Load_File insert a bmp file (size is 102k) into database and use select into outfile to retrieve it, but the outfile size turned into 1k rather than 102k. Can anybody give me a hand? thank very much amy _ Do You Yahoo!? µ½ÊÀ½ç±Ö÷Ì⹫԰ÍæÒ»Í棬ӮȡÊÀ½ç±ÃÅƱÀÖÒ»ÀÖ¡£ http://cn.worldcup.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: mysql.sock
When I try to connect to the mysql server (mysql -u root -p table), I get an error about /tmp/mysql.sock. Anyway, what is the problem here? Do I have to take it down and start it up again? I'm pretty sure the problem is that the file has been deleted, probably a cron job, but I can't remember the fix. Tried touching it to make it exist again, but of course no go. (And a pointer to the documentation would be welcomed, too...) What does the mysqld.log file say? If the mysql.sock is gone, stopping (killing) mysqld and then starting it again will fix it. Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to save image to mySQL
hi forks, I try to save image to MySQL and I create table with longblob field. but i failed with following two ways: 1. use appendchunk and getchunk which are succeful in MS SQL but failed in MySQL 2 insert a bmp file(size is 54k) into table with load_file and get data from table using select into outfile, but the size of outfile turned into 1k. Can anybody give me a hand? Thanks in advance amy _ Do You Yahoo!? µ½ÊÀ½ç±Ö÷Ì⹫԰ÍæÒ»Í棬ӮȡÊÀ½ç±ÃÅƱÀÖÒ»ÀÖ¡£ http://cn.worldcup.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
EMS MySQL Manager 1.51
Hi All, I'm glad to inform you that the new (1.51) version of EMS MySQL Manager has been released today. In this version we've included the fixes of all bugs which had been found by our users. Many thanks to all who sent us their bug reports. Also a lot of small improvements was added, which will make your work with MySQL Manager more easy and comfortable. You can download the latest version of EMS MySQL Manager from http://www.mysqlmanager.com/download.phtml . What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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
a problem with a database
I have a site using PHP Mysql. About a month ago to now one of the tables gets corrupted with the message Got Error 127... I fix it and everything works OK, except every time I loose 1 record. Today I could obtain mysql.err from the machine and I could see whenever an error is produced by date, previously I have the following line: 020205 9:57:46 Aborted connection 137 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Server shutdown in progress) 020205 9:57:46 Aborted connection 124 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Server shutdown in progress) or 020205 12:55:51 Aborted connection 377 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Unknown error) 020205 13:05:37 Aborted connection 504 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Unknown error) It doesn´t seems too clear for me because no ODBC client should be accessing to the database. Should I suppose that an unautorized ODBC client is breaking the table or could be another problem? Thanks a lot. Emiliano. - 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.sock
Try: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock C:heers! -Original Message- From: Cindy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: mysql.sock Sorry, I know this is documented somewhere, because I've seen it, but I can't find it now, nor remember exactly what it said. When I try to connect to the mysql server (mysql -u root -p table), I get an error about /tmp/mysql.sock. I've searched both http://lists.mysql.com/ and http://www.mysql.com/manual.php using the available search functions, and leafed through Paul's mysql book and can't find it, which drives me bats because I KNOW I've seen it somewhere Anyway, what is the problem here? Do I have to take it down and start it up again? I'm pretty sure the problem is that the file has been deleted, probably a cron job, but I can't remember the fix. Tried touching it to make it exist again, but of course no go. (And a pointer to the documentation would be welcomed, too...) Thanks, --Cindy - 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: deleting var=0.1
On 5 Feb 2002, at 15:11, Dan Nelson wrote: I assume var1 is a float in the first case? Due to rounding issues, the = operator will almost never work on fractions. Use the primary key to select which record to delete, or use a number range (var1 BETWEEN 1000.009 AND 1000.1001). Matthias Hoffmann should also consider whether FLOAT is the right type. The fact that he's trying to see whether the value is exactly equal to 1000.1 suggests that it's not, since floats aren't good for storing exact values. If the column represents some sort of code, then a string type (like VARCHAR) is probably what he wants. If it's a currency amount, then an integer type stored as the smallest unit (cents, for example) will work much better. Fodder for the idiotic filter: sql,query -- Keith C. Ivey [EMAIL PROTECTED] Washington, DC - 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 to MSActiveDirectory
I would like to authenticate my IntrAnet users against our Microsoft Active Directory database. Has someone done this before? How would I connect MySQL to the AD? Thanks -Allen --- [This E-mail has been scanned for viruses and is clean] - 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: Sql gurus
Oh well worth a try Thanks Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 17:58 To: Peter Lovatt; [EMAIL PROTECTED] Subject: Re: Sql gurus Hi Peter, I am working on a search logging script to count the most popular word or phrases searched for. Table I could add a line for each search, and aggregate the results for reports, but I was wondering about the following which would keep table sizes down. | search word | count | = | Nuts |125 | | Bolts|119 | | Screws |110 | | Washers | 98 | If the word is already in the table increment the counter, if not add the word and set counter to 1 query 1 = update counter where word = search word if no records updated query 2 = insert word and set counter to 1 Is there a single query that will do this or does it have to be 2? Two - sorry! =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 Question
Hi there, I have installed MySQL 3.23.37-sun-solaris2.7-sparc. Some times the server starts and when i try to connect it using my password it hangs. It doesn't allow me in. Neither does it say anything about the password or about the connection. How do i solve this. This is the second time it is happening to me. The first time it happenend it automatically got rectified after a few days. It is strange... Regards, Hari ---\ Hariprasad N Davanagere 1007 Bolling Ave, Apt 49 Norfolk, Va -23508 (h) (757) 489 8839 (c) (757) 348 3647 ---\ - 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-3.23.47 Compile Error on Linux
Running Kernel 2.4.17 gcc-2.95.3 glibc-2.2.5 I read through the manual for hints and searched the mailing list archives but couldn't find a similar report. Here's the build output: c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr\ -DDATADIR=\/var/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DHAVE_CONFIG_H -I/usr/include -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBU G_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc mysqld.cc: In function `int main(int, char **)': mysqld.cc:1767: implicit declaration of function `int regex_init(...)' make[3]: *** [mysqld.o] Error 1 Can anyone offer help? ~Jason -- - 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 and question
hello, This is my problem and question: I installed mysql-3.23.36 when I installed the RedHat7.1, but now I want to install mysql-3.23.47 to the platform and I hope the two versions are both useful. How should I configure the parameters when I configure? I want mysql supporting the BDB tables as well,is that using '--with-berkeley-db=./bdb' enough? I'm waiting for your replying and thank you for that! admin [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
Set up help needed
Hi, I am used to using Microsoft SQL or Sybase servers where there is a simple client setup mechanism or I can connect using DBArtisan etc. (this is from previous employment) What we have is MySql and PHPadmin setup on a Linux Box (done by someone else). Its only just been setup. What is the best or easiest client to set up on my NT4 workstation so I can connect to the MySql server and create tables, etc via scripts? I tried downloading one or two from the MySql site but none of them seem to have any instructions as to how to set them up or get the connection going. Any help is appreciated Janet Cook CSDD NEC Australia Pty Ltd Ph +613 9264 3813 Email: [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: Set up help needed
If you want to get the most out of MySQL, then you really need to learn to use the command line tools. MySQL has the easiest to use tools and language of any database I've used. SQL allows you to do really powerful things easily. Download the Windows version and install it. You can use the mysql client to connect to the remote server from your Windows box. Alternatively, and probably even easier, download an SSH client for Windows (do a Google search for putty) and SSH in to your Linux box. Then use the mysql client locally there. For long SQL queries like creating tables, I find it useful to type them up in Notepad and then paste them into the client. If you made a mistake, fix it in Notepad and paste it again. mysqldump is also a very handy tool for viewing a table's schema. What is the best or easiest client to set up on my NT4 workstation so I can connect to the MySql server and create tables, etc via scripts? I tried downloading one or two from the MySql site but none of them seem to have any instructions as to how to set them up or get the connection going. - 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
making arrays while GROUP-ing
Hi list, I'd like to generate arrays into a field for the result-set by means of grouping... myTable ( MySQL 3.23.33 / MyISAM table ) ++--+ | id| type | ++--+ | 002 | 'CD' | | 002 | 'LP' | | 011 |'DVD' | | 081 | 'CD' | | 081 | 'LP' | | 081 |'DVD' | | 087 | 'MC' | | 087 | 'LP' | ++--+ myWish *** SELECT id, makeArray(type) FROM myTable GROUP BY id; ++---+ | id| ? makeArray(type) | ++---+ | 002 | ('CD','LP') | | 011 | ('DVD') | | 081 | ('CD','LP','DVD') | | 087 | ('MC','LP') | ++---+ I know, when GROUPing, you can ask for a COUNT like: *** SELECT id, COUNT(*) FROM myTable GROUP BY id; ++--+ | id| COUNT(*) | ++--+ | 002 |2 | | 011 |1 | | 081 |3 | | 087 |2 | ++--+ How should I tackle this ? Thanks ! Best Regards, Bart - 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: Set up help needed
At 14:10 06/02/2002 +1100, WG4- Cook, Janet wrote: Hi, What is the best or easiest client to set up on my NT4 workstation so I can connect to the MySql server and create tables, etc via scripts? I tried downloading one or two from the MySql site but none of them seem to have any instructions as to how to set them up or get the connection going. Read in the Manual, how to set the user privileges (user name, host, password). Having in the Linux server the privileges, from the NT workstation you can connect using the mysql.exe client using the parameters of user, host and password. At the prompt of the mysql client you can type SQL commands or use \. script_file_path to execute script files. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.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
MySQL 4.0.1 bug ... no returned results using GROUP and ORDER
Description: When issuing a command containing both a GROUP BY and an ORDER BY clause, the server is returning no results. This issue has arisen since upgrading from 3.23.47 to 4.0.1 How-To-Repeat: Table Creation: CREATE TABLE statarchive (uid INT unsigned NOT NULL AUTO_INCREMENT, referal VARCHAR(15), date DATE, uniques int unsigned, raws int unsigned, site VARCHAR(10), signups INT unsigned, payout decimal(8,2), bsff mediumint unsigned, PRIMARY KEY(uid)); example select code: SELECT date, sum(uniques) as cnt1, sum(signups) as cnt2, sum(payout) as cnt3 FROM statarchive WHERE date BETWEEN '2002-01-29' AND '2002-02-05' GROUP BY date ORDER BY date DESC; Will return 0 results constantly (with any use of ORDER BY, ASC or DESC). Without the ORDER BY clause the server returns the 7 days worth of stats appropriately calculated Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: GROUP BY w/ and ORDER BY clause returns no results Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.47 (Source distribution) Server: /bin/mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 3 days 1 hour 7 min 1 sec Threads: 132 Questions: 4144248 Slow queries: 0 Opens: 1677 Flush tables: 1 Open tables: 16 Queries per second avg: 15.744 Environment: System: Linux clarke 2.2.20 #2 SMP Tue Jan 29 13:22:41 CST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jan 29 03:30 /lib/libc.so.6 - libc-2.1.2.so -rwxr-xr-x 1 root root 1008844 Sep 9 1999 /lib/libc-2.1.2.so -rw-r--r-- 1 root root 20019674 Sep 15 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 15 1999 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql Perl: This is perl, version 5.005_03 built for i386-linux - 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: PHP - MySQL - SQL7 Server - Visual Basic.
Hi bob, I have do everything you need but may be a little diff. I have MS SQL 6.5 on NT, MySQL 3.23.47 on Linux and using PHP / VB 6 for client. The first thing you must define some role of usage and other, how to manipulate your data. I have PHP update routing in some project (transfer via ftp function, read along text file and then update data to MySQL). If you need to access to MS SQL via PHP try to use FreeTDS on Linux (may be they have copy on NT). All you need about MySQL are on the Web. If you need to access MySQL via VB: try to use MyVBQL at www.icarz.com/mysql/. MyVBQL using libmysql.dll to access MySQL and let you used recordset style in your application. Sommai, At 20:53 5/2/2002 +, DL Neil wrote: Bob, I've posted this back onto the list because there are others here who will be much more able to assist. Clarification: I currently have 22 NT workstation that send data to various tables in a SQL7 database running on a NT sever. The visual basic front end organizes this data in to a neat fashion and allows the user to graph and print data and comparisons from the various tables. The front end also responds to e-mail requests for information from the tables. Currently there are only 12 authorized e-mail accounts so it is easy to manage. We are now going to add about 100 workstations, More tables and 200 authorized e-mails accounts. With this addition I have decided to eliminate the e-mail accounts and post all of this information to a secure web server that I will administer. So what I need to do is have a VB program write this data to a MySql database that will only allow users to view the data. I have extensive VB experience and have created and updated many types of databases using it, however I have never used MySql and need some pointers. Can Vb create and write to MySql databases? =yes, using an ODBC or ADO interface. What syntax do I use in PHP to read the MySql database? =PHP has a wide range of interface functions 'built-in'. =Why use two RDBMS'? PHP can access MS-SQL to provide the web service. =dn Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? - 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
compression
Hi, I need to know that MySQL has any compression method when it store data? If the answer is Yes, How the different compression between MySQL and other tools (zip, gzip)? I asked this question because I need to store some text file for future used (at least 1 Mbyte per day). I was used Winzip in Windows to compress and keep in file server. If MySQL could compress some byte of data I think it better than flat file. Sommai - 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: Obtaining GMT time in mySQL
My apologies, what I said in this previous post is incorrect. It appeared as if the time was UTC (except for daylight savings) to me, but it was mearly because of the format string As Paul DuBois quite rightly pointed out is that %h in select FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x'); returns the hour in 12hour format, I assumed it was in 24hour format which makes it appear close to UTC in my timezone. Thus select FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x'); does not return GMT time but local time. At 02:13 PM 5/02/2002 +1100, Oliver Mannion wrote: I am close to a solution: select FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x'); UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT Convert this to a date format and you have a GMT date. Thanks to Chris Land for pointing the UNIX_TIMESTAMP() function out to me. The only prob is daylight savings. We in NSW, Australia are currently in daylight savings and the date returned doesn't accomodate for that. Any one have any ideas why? [mysql] - 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
Problem: mysqld restarts automatically
Hi, I have install mysql-RPM 3.23.38 on red hat linux 6.2 machine, which was running properly for more than 3 months . recently , It started restarting after every 30 min. I am trying to find the problem but, error file shows stack trace which I could not understand. I have upgraded mysql version to the latest one 2.23.47, thinking that might solve the problem. Does any one know the reason why this is happens? please reply immediately. Regards, Bharat - 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: EMS MySQL Manager 1.51
That's great but... do you know there is some FREE products to manage MySQL DB. I propose MySQL Front, you can find it at http://www.anse.de/mysqlfront/ Hope This Help All Folks theOtherOne - Original Message - From: Igor Brynskich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 05, 2002 2:00 PM Subject: EMS MySQL Manager 1.51 Hi All, I'm glad to inform you that the new (1.51) version of EMS MySQL Manager has been released today. In this version we've included the fixes of all bugs which had been found by our users. Many thanks to all who sent us their bug reports. Also a lot of small improvements was added, which will make your work with MySQL Manager more easy and comfortable. You can download the latest version of EMS MySQL Manager from http://www.mysqlmanager.com/download.phtml . What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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