Updating MySQL using MS ACCESS
Hello, Does anybody know how MySQL works with MS Access especially when it comes to preventing concurrent updates from more than two users? I use InnoDB tables and link them through ODBC driver to MS Access for viewing and updates. Will there be any issues if two or more people have this type of ODBC link updating the same record? If yes, is there any way around it to prevent this from happening? How do I set the row locking from MS-Access or MySQL does this automatically? I'd appreciate any help on this. Martin **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - 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 turn on Slow Query Log?
Hi, I need help in turning on the slow query log option on the my.ini file. I've tried uncommenting it and when I tried to run the nt-max it says it couldn't recognize the option. Here's what I have for my.ini file, any other way I have to type it? Please advise. slow query log#=c:/slowquerylog/slowquery.log Thanks, Martin **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to turn on Slow Query Log?
Never mind with that.. I don't know why it was there, it was created automatically the 1st time you run the windows gui admin. And I had to modify it to log-slow-queries=filename and it turned out ok. Thanks anyway. Regards, Martin |-+ | | Jeremy Zawodny | | | jzawodn@yahoo-in| | | c.com | | || | | 03/07/2002 11:58 | | | AM | | | Please respond to| | | mysql| | || |-+ --| | | | To: [EMAIL PROTECTED] | | cc: [EMAIL PROTECTED] | | Subject: Re: How to turn on Slow Query Log? | --| On Thu, Mar 07, 2002 at 09:53:51AM -0800, [EMAIL PROTECTED] wrote: Hi, I need help in turning on the slow query log option on the my.ini file. I've tried uncommenting it and when I tried to run the nt-max it says it couldn't recognize the option. Here's what I have for my.ini file, any other way I have to type it? Please advise. slow query log#=c:/slowquerylog/slowquery.log What's the '#' doing there? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 28 days, processed 991,703,184 queries (406/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
Running MySQL as Service on 2000 Server
Hi, Anybody running MySQL on Win 2000 server here? I just installed MySQL 3.23.49-MAX (w/ InnoDB) on a 2000 Server (Dual 1.1 GHz - 1GB RAM - 15GB HD space) and I can run it without any problem from the command line as a standalone. However I couldn't run it as a service even though I already did 'mysqld-max-nt --install' the first time I ran it. Is there anything wrong with MySQL or is it more of permission issue on NT/2000 server. I also attached the my.ini file if it would help. Thanks. Regards, Martin [mysqld] basedir=G:/MySQL datadir=G:/MySQL/data #bind-address= log-slow-queries=h:/slowquery/slowquery.log set-variable=key_buffer=20M innodb_data_home_dir = g:/ibdata innodb_data_file_path = ibdata:2000M;ibdata2:2000M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=30M innodb_log_group_home_dir = h:/iblogs innodb_log_arch_dir = h:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=24M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=10 set-variable = innodb_lock_wait_timeout=50 [WinMySQLAdmin] Server=G:/MySQL/bin/mysqld-max-nt.exe **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - 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
NuSphere v. MySQL 4
Hello, I'm not sure if this list is appropriate for this issue but I'll go ahead ask for your input anyway. We're trying to decide to choose DBMS as a backend of our web portal. The portal will take online orders and other requests from end users and this is going to be available enterprise wide (WAN) for approx. 19,000 employees. As Oracle license cost is getting too high for this purpose, I'm thinking of using MySQL instead. However, I saw two different versions here (NuSphere vs. MySQL AB) and cannot decide which one is better to use. Now, my questions are: 1. What would be your recommendation for me to use, what are the advantages / disadvantages of using NuSphere's (or MySQL AB's) products other than the different pricing here? 2. Is it true that Gemini type table from NuSphere is much better than other types (e.g. InnoDB). How about the installation and config themselves, any issues I should know about from each product? We're going to install it on a W2000 server on the same box as the web portal. 3. Is it safe enough to use MySQL v.4.0.1 instead of 3.23.49. How about the MAX 4.0.1., is this better? Although reliability is important this application is not mission critical. Sorry for the many questions, but I'm really new to MySQL and I want to feel comfortable with it before I decide to use this. I'd greatly appreciate any input from all of you. Thanks, Martin **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - 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: NuSphere v. MySQL 4
Thanks for the article it is definitely helpful and narrow down my choice. Anything against the 4.0 MAX here? |-+ | | Tyler Longren | | | tyler@captainjac| | | k.com | | || | | 02/26/2002 12:24 | | | PM | | || |-+ --| | | | To: [EMAIL PROTECTED], [EMAIL PROTECTED] | | cc: | | Subject: Re: NuSphere v. MySQL 4 | --| I suggest you use MySQL from MySQL AB. Progress Software (parent of NuSphere), is having some legal troubles. http://www.newsforge.com/article.pl?sid=02/02/26/1825200 Tyler - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 1:01 PM Subject: NuSphere v. MySQL 4 Hello, I'm not sure if this list is appropriate for this issue but I'll go ahead ask for your input anyway. We're trying to decide to choose DBMS as a backend of our web portal. The portal will take online orders and other requests from end users and this is going to be available enterprise wide (WAN) for approx. 19,000 employees. As Oracle license cost is getting too high for this purpose, I'm thinking of using MySQL instead. However, I saw two different versions here (NuSphere vs. MySQL AB) and cannot decide which one is better to use. Now, my questions are: 1. What would be your recommendation for me to use, what are the advantages / disadvantages of using NuSphere's (or MySQL AB's) products other than the different pricing here? 2. Is it true that Gemini type table from NuSphere is much better than other types (e.g. InnoDB). How about the installation and config themselves, any issues I should know about from each product? We're going to install it on a W2000 server on the same box as the web portal. 3. Is it safe enough to use MySQL v.4.0.1 instead of 3.23.49. How about the MAX 4.0.1., is this better? Although reliability is important this application is not mission critical. Sorry for the many questions, but I'm really new to MySQL and I want to feel comfortable with it before I decide to use this. I'd greatly appreciate any input from all of you. Thanks, Martin **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrading MySQL on Windows Platform
Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I should run or should I just re-install the latest version 3.23.39. Will it overwrite the old version automatically while preserving all the tables and databases? Please help. Thanks. Martin - 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