delay_key_write usage
According to the documentation, when delay_key_write is active the index keys arent written to disk until the table(s) are closed. When is a table closed? Is it only when a connection is closed? Thank you, Dan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.737 / Virus Database: 491 - Release Date: 8/11/2004
Repair Table and USE_FRM
Is there any harm in using the USE_FRM directive by default whenever repairing a table? Thanks, Dan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.703 / Virus Database: 459 - Release Date: 6/10/2004
Load Data Local Infile confusion
Hello, I have a client that can connect to either a local or remote MySQL server. LOAD DATA INFILE works fine on a local server, but obviously fails when a remote server is used. When I add LOCAL to the command, I get: The used command is not allowed with this MySQL version I am using 4.0.18. The client is written using Delphi. What do I need to do to get this command to work with either server? Regards Dan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.643 / Virus Database: 411 - Release Date: 3/25/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD DATA LOCAL INFILE confusion
Hello, I have a client that can connect to either a local or remote MySQL server. LOAD DATA INFILE works fine on a local server, but obviously fails when a remote server is used. When I add LOCAL to the command, I get: The used command is not allowed with this MySQL version I am using 4.0.18. The client is written using Delphi. What do I need to do to get this command to work with either server? Regards Dan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.643 / Virus Database: 411 - Release Date: 3/25/2004
Strange Error
Ive recently started getting an error: file '.\newsman\messages.MYD' not found (Errcode: 22) but when I check the database, the file is there and it is OK. Ive repaired and optimized it, but no change. What is the root cause of this error and what should I do to fix it? Thanks, Dan Cumpian --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 9/23/2003
Help with 4.0.12 on WinXP
Hello, I am having the following problem that I've been able to consistently replicate: I am using code written in Delphi with Zeos Database components and am having a problem with a query returning server connection error. I am inserting a row into a table and then immediately selecting a row from a table . This error occurs whether I select out of the table I inserted the new row into or from any other table. After inserting 3700-3900 rows, the select will be unable to connect. For at least 10-30 seconds, I cannot connect to MySQL, even with MySQL-Front (I get a Can't connect to server error). There are no errors being logged. After the 10-30 seconds passes, I can resume the program and it happens again after 3700-3900 rows. This does not happen on Windows 2000, only Windows XP (both Home and Pro). All connection are through Localhost. My configuration file is: [mysqld] set-variable=key_buffer_size=18M set-variable=myisam_sort_buffer_size=8M set-variable= max_allowed_packet=16M Table type is MyISAM. Machine is a P4-2.2Ghz with SCSI hard disks. Can anyone please suggest what I might be able to do to resolve this issue? Thank you, Dan Cumpian
RE: Help with 4.0.12 on WinXP (more info)
MySQL is installed as a service running locally. Also, this error occurs with version 3.23.53 onwards (I never tested on older versions than this). Thanks, Dan -Original Message- From: Dan Cumpian [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 10:27 PM To: [EMAIL PROTECTED] Subject: Help with 4.0.12 on WinXP Hello, I am having the following problem that I've been able to consistently replicate: I am using code written in Delphi with Zeos Database components and am having a problem with a query returning server connection error. I am inserting a row into a table and then immediately selecting a row from a table . This error occurs whether I select out of the table I inserted the new row into or from any other table. After inserting 3700-3900 rows, the select will be unable to connect. For at least 10-30 seconds, I cannot connect to MySQL, even with MySQL-Front (I get a Can't connect to server error). There are no errors being logged. After the 10-30 seconds passes, I can resume the program and it happens again after 3700-3900 rows. This does not happen on Windows 2000, only Windows XP (both Home and Pro). All connection are through Localhost. My configuration file is: [mysqld] set-variable=key_buffer_size=18M set-variable=myisam_sort_buffer_size=8M set-variable= max_allowed_packet=16M Table type is MyISAM. Machine is a P4-2.2Ghz with SCSI hard disks. Can anyone please suggest what I might be able to do to resolve this issue? Thank you, Dan Cumpian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and Dual Processors
Hello, Are there any known issues using MySQL on Localhost with WinXP Pro and a dual processor machine? The reason I ask is that I have a friend that is trying to run MySQL with this configuration and he seems to have a lot of problems keeping a connection to the database. Has anyone else seen this? Thanks, Dan Cumpian
mysqld-nt vs mysqld-max-nt
Hello, I've been running mysqld-nt on W2K and WinXP for awhile now (using MyISAM tables) and I'm a bit confused by what's in the max binary. Is the biggest difference InnoDB tables? Thank you, Dan Cumpian - 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 ZeosDBO - A newcomer question
I assume that you are using Delphi? I would recommend that you create a data module and drop a ZMySQLDatabase component on the data module, configure your connection to your MySQL database using this component. Add a ZMySQLTransact component and point the database property to the ZMySQLDatabase component you added earlier. Finally, drop a ZMySQLQuery component, set the database property, and then use the ZMySQLQuery as you would a normal TQuery. That's the basics... HTH, Dan Cumpian -Original Message- From: Crescendo Napitupulu [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:58 AM To: [EMAIL PROTECTED] Subject: MySQL ZeosDBO - A newcomer question Hi, I'm a newcomer and very interested to use MySQL with ZeosDBO. I would like to ask to anyone in this list who has experience in using ZeosDBO, what component(s) and settings should I make in order to use INSERT, DELETE and UPDATE ? I would also really appreciated for an example. Best Regards, Crescendo Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp 250.000 tunai - 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 and Windows XP (Pro)
I have an application that works just fine on a local MySQL database when it is running on W2K or Windows XP Home. However, on Windows XP Pro, the application has problems keeping its connection to the server. Has anyone else seen this and is there a known cause or fix? Weve tried this on more than one XP Pro setup and have seen the same results. MySQL versions: 3.23.52, 3.23.53, 3.23.54 Database connection is using Zeos Database Objects through a Delphi application. The application has five separate database connections each in individual threads. Thank you, Dan Cumpian - 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: Optimize Table usage
Well, I knew that, but I wondered if using an OPEN would solve the problem. Does anyone know of a workaround for the out of sync error? Thanks, Dan Cumpian -Original Message- From: Steve Yates [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 10:22 AM To: [EMAIL PROTECTED] Subject: Re: Optimize Table usage On Sat, 4 Jan 2003 21:25:03 -0500, Dan Cumpian wrote: 1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE TableName command? From Delphi help: Use ExecSQL to execute queries that do not return a cursor to data (such as INSERT, UPDATE, DELETE, and CREATE TABLE). 2) The queries are returning instantly and when the program tries to run OPTIMIZE TABLE on the next table, I am getting a commands out of sync I saw this when using optimize table via a GUI client, not sure where it comes from. In my case it wasn't a factor of using it on multiple tables. - Steve Yates - BUS STOP: Where the I/O gets off. ~ Taglines by Taglinator - www.srtware.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
Optimize Table usage
Hello, I am trying to write a process to optimize several tables in a database by using the OPTIMIZE TABLE command in a query. I have a couple of questions that I can't get an answer to in the documentation: 1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE TableName command? 2) The queries are returning instantly and when the program tries to run OPTIMIZE TABLE on the next table, I am getting a commands out of sync error. How can I tell when the optimization process is complete? (Please note that I am using Delphi and Query objects to interface with the tables). 3) Should I do a CHECK TABLE before I do an OPTIMIZE TABLE? Thanks, Dan Cumpian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Optimize Table usage
Hello, I am trying to write a process to optimize several tables in a database by using the OPTIMIZE TABLE command in a query. I have a couple of questions that I can't get an answer to in the documentation: 1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE TableName command? 2) The queries are returning instantly and when the program tries to run OPTIMIZE TABLE on the next table, I am getting a commands out of sync error. How can I tell when the optimization process is complete? (Please note that I am using Delphi and Query objects to interface with the tables). 3) Should I do a CHECK TABLE before I do an OPTIMIZE TABLE? Thanks, Dan Cumpian - 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: Suitability of mySQL for desktop use?
Frank, That doesn't sound like it will be a problem for MySQL. I am using the Zeos components. The only caveat that I have about these components is that they are very slow in loading large (more than 3-4 lines) SQL query statements. It is much, much faster to create a data module and create persistent, parameterized queries that you can call in your app. The app I am using with MySQL is an Usenet newsreader that downloads thousands of news headers and bodies a day. MySQL handles the data just fine. As far as an installer goes, I haven't released the application yet because I am still developing the full feature set and testing thoroughly as I go. There is a freeware install utility that allows you to create installation scripts that I will probably end up using. I've got it at my office, but I'm home now and can't remember the name of it. Do a web search for INSTALLERS DELPHI and you should turn it up. HTH, Dan Cumpian -Original Message- From: Frank Marousek [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 5:03 PM To: [EMAIL PROTECTED] Subject: Re: Suitability of mySQL for desktop use? Dan, I don't believe I will be placing stressful demands on the database/PC. I will be querying about a dozen tables varying in size from 100 records up to around 500,000 records each. Do you agree? What are you doing by comparison? Are you using the Zeos components to access mySQL from Delphi? If not, what -are- you using? And what do you use to do your installations? Frank - Original Message - From: Dan Cumpian [EMAIL PROTECTED] To: 'Frank Marousek' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 11:03 PM Subject: RE: Suitability of mySQL for desktop use? Frank, I am using MySQL for a PC desktop application. It runs fine, but you have to be careful how you structure your database because (depending on how much data you will be storing and processing) be putting a lot of stress on the PC the application and MySQL are running on. I am using Delphi 6, and MySQL 4.0.5 running as a service on WinXP and Win2000. The W2K is a generic (cheap) Dell with IDE disks. It bogs down occasionally, but recovers fairly quickly. The other system I am running it on is a 2.2Ghz machine with dual 15,000 RPM SCSI disks and 1GB RAM. On that machine, I can't even tell that MySQL is running. HTH, Dan Cumpian - 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: SELECT and UPDATE at the same time?
Actually, I think the behavior comes from the components used to connect to MySQL. Delphi doesn't really care one way or the other. Dan Cumpian -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:41 PM To: [EMAIL PROTECTED] Cc: Dan Cumpian; 'Jeff Snoxell'; [EMAIL PROTECTED] Subject: RE: SELECT and UPDATE at the same time? At 13:23 -0500 12/19/02, [EMAIL PROTECTED] wrote: Well, the only basis I have is personal experience from connecting to a local MySQL database. The components I use for connecting to MySQL with Delphi does cache the records as the server returns them. However, not all the records are returned at once. As I said, it depends on how one connects to the server. Okay. If that's what you observe, I won't dispute it. But then the behavior is probably something specific to the Delphi interface. The underlying behavior of the client/server protocol is somewhat different than what you observe, so people using other APIs will likely see something different happening. If I'm wrong, then I apologize for any incorrect information that I may have given. Just trying to help. Dan Cumpian On Thu, 19 Dec 2002 00:18:48 -0600 Paul DuBois [EMAIL PROTECTED] wrote: At 23:43 -0500 12/18/02, Dan Cumpian wrote: Jeff, Not if your outer loop is in a separate query. In that case, your query is essentially a cursor and is static once OPENed. As you move from record to record, what you are seeing is the records at the time the query was opened. Now, if you were to update records that you haven't processed yet, then they may show up as modified in your outer query Your basis for saying that? because (depending on how you are connecting to the database) the server only returns several hundred rows at a time and caches them as you go Your basis for saying that? through the record set. But that doesn't sound like it will impact you. HTH, Dan Cumpian -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:56 PM To: [EMAIL PROTECTED] Subject: SELECT and UPDATE at the same time? Hello again, I'm selecting a group of records from my database. I then loop through the selected records and do some work based on what I find. But what I also want to do as I interrogate each record is update some of its fields with new values... but won't that screw up the outer loop? I mean if I try to execute a query whilst looping around the result set of a former query will I not screw up my result set that I'm looping through? Also, is it possible to update specific fields of certain records within a SELECT query? ie can I do something like this: SELECT * FROM my_table WHERE Age 50 AND UPDATE Status = OLD Ta, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: SELECT and UPDATE at the same time?
Jeff, Not if your outer loop is in a separate query. In that case, your query is essentially a cursor and is static once OPENed. As you move from record to record, what you are seeing is the records at the time the query was opened. Now, if you were to update records that you haven't processed yet, then they may show up as modified in your outer query because (depending on how you are connecting to the database) the server only returns several hundred rows at a time and caches them as you go through the record set. But that doesn't sound like it will impact you. HTH, Dan Cumpian -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:56 PM To: [EMAIL PROTECTED] Subject: SELECT and UPDATE at the same time? Hello again, I'm selecting a group of records from my database. I then loop through the selected records and do some work based on what I find. But what I also want to do as I interrogate each record is update some of its fields with new values... but won't that screw up the outer loop? I mean if I try to execute a query whilst looping around the result set of a former query will I not screw up my result set that I'm looping through? Also, is it possible to update specific fields of certain records within a SELECT query? ie can I do something like this: SELECT * FROM my_table WHERE Age 50 AND UPDATE Status = OLD Ta, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Severe performace problem linking tables with mysql
Joseph, I've noticed this as well. MySQL seems to do most types of queries extremely well, but CERTAIN joins are very slow. I ended up having to denormalize my data structures somewhat in order to maintain good performance with MySQL. What I don't know, since I do not have access to a Linux box, is whether the problem is OS related. In any case, I found that I couldn't create data structures in the same way as on MSSQL. HTH, Dan Cumpian -Original Message- From: Joseph Dietz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:40 PM To: [EMAIL PROTECTED] Subject: Severe performace problem linking tables with mysql PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type) I have discovered a performace issue when joining several tables together. The performance is extremely poor when performing select queries using the WHERE clause and joining the tables with the pk_media_id = fk_media_id etc... I guess this is what people might think about when considering using mysql. With SQL 2000 Windows Server, and ACCESS, there was no loss in performace. 4 of my tables are cross reference tables as such: pk=primary key, fk= foreign key MediasMediaAuthorsAuthors pk_media_id fk_media_id, fk_author_id pk_author_id (Many authors for each media) _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus - 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: Suitability of mySQL for desktop use?
Frank, I am using MySQL for a PC desktop application. It runs fine, but you have to be careful how you structure your database because (depending on how much data you will be storing and processing) be putting a lot of stress on the PC the application and MySQL are running on. I am using Delphi 6, and MySQL 4.0.5 running as a service on WinXP and Win2000. The W2K is a generic (cheap) Dell with IDE disks. It bogs down occasionally, but recovers fairly quickly. The other system I am running it on is a 2.2Ghz machine with dual 15,000 RPM SCSI disks and 1GB RAM. On that machine, I can't even tell that MySQL is running. HTH, Dan Cumpian -Original Message- From: Frank Marousek [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:57 PM To: [EMAIL PROTECTED] Subject: Suitability of mySQL for desktop use? How suitable is mySQL for use in a desktop application i.e. one that would be installed completely by the user and run on a standalone PC? My application is written in Delphi and currently uses dBase files, but as Delphi support for accessing dBase files is being phased out, I am looking at possible alternatives. My application already makes heavy use of SQL, and moving to an SQL database would seem like a good fit otherwise. mySQL is also appealing as I may at some point port this application to the web, in which case mySQL seems like it would be a good platform. Comments? - 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 losing connection on WinXP
Hello, I have an application that reads and writes to a local MySQL database. On Wondows 2000, I have no problems, but on WinXP I am running into a situation where after executing 3000-4000 select queries, all of a sudden the application cannot connect to MySQL. I am using the ZeosLib components for Delphi. Does anyone know what could cause this to happen? Thanks, Dan Cumpian - 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: Record Lock?
Michael, If the database is twice the size, how will that affect performance? I don't use full-text searches, so that shouldn't be a problem. Thanks, Dan -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: Re: Record Lock? On Sun, Dec 08, 2002 at 12:06:53PM -0800, Richard Reina wrote: How do I switch from MYISAM to InnoDB? Are there any negative implication in swithing? ALTER table TYPE=InnoDB; It will take twice as much disk space or thereabouts and not support full text queries. SQL -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
MyISAM - InnoDB
Hello, I have a database that, I now realize, could use the benefits of row-locking and non-blocking SELECTs. So, I guess I need to change over to InnoDB tables. How do I convert my existing data structures (and the data they contain) into InnoDB tables? Also, Is there anything that MyISAM tables support (query-wise, like INSERT DELAYED), that is not supported by InnoDB that I might need to look out for in my application(s)? Thanks, Dan Cumpian - 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: Application threading and contention
Hello, I have a multi-threaded application written in Delphi and I am having a mysterious problem. There are 4 threads that write to several MySQL tables, but I am seeing what looks to be some type of deadly embrace that I dont know how to resolve. Each thread has a separate database connection (using ZeosLib) and when two of the threads attempt to read a table, and a third thread simultaneously tries to either read or write to the same table, all three threads are locking up. Does anyone know how to resolve these issues with MySQL (Ive never seen this kind of behavior with MS-SQL)? My current workaround is to only allow two threads to access the table simultaneously, but Im not happy with it. Also, the database is running on the local machine, and I am not issuing any file locks. All access to the tables are via SELECT, INSERT, DELETE or UPDATE queries. MySQL version is: 3.23.52-nt Thanks for any advice Dan Cumpian - 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 on windows
I've been running MySQL on Windows 2000 and Windows XP as local services on my DESKTOP, (I know, I know) without any problems. In fact, I hardly even know that the services are running except when I process a large chunk of data... Dan Cumpian -Original Message- From: John Ragan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Re: MySQL on windows my experience is rather limited since i use linux only as a file server. after installations of mysql on win2k and nt4.0 sp6, i can say that it came up without incident, and has been running for months in the corereader test environment. it was far far easier to install than oracle, and easier to install than mssql. when i reboot the windows box, mysql has always popped back up. my philosophy with tools is if it doesn't keep running after i install it, i don't need it. so far, mysql seems to be a keeper. TERRIBLE! at least with ver mysql-3.23.53 on Win98. It crashes my machine after a while and when I close it, it sends the hadr drive into an infinite loop doing who knows what. On 20 Nov 2002, at 11:02, Simon Windsor wrote: Hi I have been asked to support/bug-fix a Windows based web site using MySQL. I have used MySQL on Linux/FreeBSD for 3/4 years, but never on Windows. How does MySQL compare on Linux and Windows for stability and performance ? Simon -- Simon Windsor mail: [EMAIL PROTECTED] Regards Mike -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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
MySql Insert optimization
Hello, I am running MySql on a Windows 2000 PIII-1Ghz PC with 256MB of RAM. I have three table that need to get updates when a new record gets created. I have minimized the number of indexes on the tables and the insert process goes like this: (All three tables have a primary key to prevent duplicates) Try Insert into table1 Except // Record already exists End; Try Insert into table2 Except // Record already exists End; Try Insert into table3 Except // Record already exists End; Each table contains different data that is parsed from the data that is passed to the insert module. This module contains these three inserts. I am using CHAR fields rather than VARCHARS, because I read that MySQL handled these fields more efficiently (even though there is a cost in storage space). My question is: I am running the default NT version with the default settings, the table types are all MyISAM, however, I am only able to process approximately 7-10 transactions (into all three tables) per second. Is this a reasonable expectation of the performance I can expect? What server variables should I modify (if any) for better performance? Thanks for any advice, Dan Cumpian - 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