Re: Commercial Licence
If those servers are yours, it sounds to me that you can run it GPL. Read this: http://www.mysql.com/doc/en/Using_the_MySQL_software_for_free_under_GPL.html Stephen - Original Message - From: Pierre Luguern [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 7:19 PM Subject: Commercial Licence I want to run a commercial product based on MySQL. I have one centralized server running MySQL in replication mode (master server). I have five clients running MySQL (each slave is running one MySQL daemon). Do I have to acquire only one commercial licence for my master server or do I have do get commercail licence for master and slave. Thanks in advance. mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Not receiving list emails
Hello, The MySQL list server sent me nothing for about 24 hours, until just recently. It followed my first attempt to use the support.mysql.com website and change my details there [that might have been just a coincidence]. I started getting messages again soon after I sent a new subscription message to [EMAIL PROTECTED] The posting today by Jim Winstead of MySQL AB indicates that SpamCop might be involved. The message is not clear to a non email techo like myself, so I expect to see more comments in that thread. Good luck, Stephen - Original Message - From: Freddie Sorensen [EMAIL PROTECTED] To: 'MySQL List' [EMAIL PROTECTED] Sent: Friday, January 16, 2004 11:27 AM Subject: Not receiving list emails I have not received any emails from this list since last Sunday - if this post comes through and anybody has an idea what is wrong please reply to me off list Thanks Freddie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: blacklist
Hello Jim, Would you please look at my comments under the thread Not receiving list emails, in case that puts further light on this matter. Thanks, Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using (hard?) links for tables
I agree with Dan. We looked into this years ago. We have MANY machines with many tables used this way. It is easy when you realise that one SQL command can access multiple databases, using db1.tablea ... db2.tableb syntax. Stephen - Original Message - From: Dan Greene [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:54 AM Subject: RE: using (hard?) links for tables What if you were to make a 3rd database, containing shared elements, such as your user table (I presume we're not talking the MySQL system user table) and then have necessary permissions granted between your other database users to read that table jointly, as you can query cross databases... -Original Message- From: Moritz von Schweinitz [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 9:26 AM To: [EMAIL PROTECTED] Subject: using (hard?) links for tables hi there! i have two databases on the same server, and one of the tables ('users') should be the same in both databases. since this is very specific to this one server, and other servers running similar databases don't need that functionality, i'm looking for the easiest way to do this, so i was wondering whether mysql is smart enough not to couse any mayor mess if i simply replace the users.* file in one of the datbase's directory with hardlinks to the other databses files for that table. anyone know whether this works, and if not, what would be the easiest way of keeping two tables in differnt databases synced? a cronjob, maybe (it's not THAT time-critiva). thanks, M. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to READ/WRITE directly on MyISAM data files ?
Hello Stephane, I use myisam for reading. I now use SQL for updating. When I used myisam for updating, tables sometimes corrupted, and I was unable to work out why. Currently I am changing programs to use HANDLER syntax not myisam for reading. This will: - Save the need for table locking. - Allow the use of InnoDB etc. - Allow mysqld to have full control. I recommend you just use SQL for everything. Regards, Stephen - Original Message - From: Stéphane Bischoff [EMAIL PROTECTED] To: MySQL (E-mail) [EMAIL PROTECTED] Sent: Friday, December 12, 2003 12:15 AM Subject: How to READ/WRITE directly on MyISAM data files ? Hello, I would like to know how to write directly to MyISAM files, without passing by SELECT or UPDATE queries. I believe this info can be found in the files myisam.h and myisammrg.h, but I am not shure if its safe and how to do it. I would very much like to have an example of this code (C code). thank you Stéphane. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replacing text using the Update command?
Hello Bob, - Original Message - From: Bob Loeffler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 10:01 AM Subject: Replacing text using the Update command? Hi all! I would like to update many records in a table called pictures where I find a string in the caption column. If the string (e.g. www.bob.com) is found, replace it with another string (e.g. www.bubba.com). Unfortunately, there is other text in the caption column of these records, so I can't just do a simple update. How can I replace a string of text within a column without destroying the other text in that column? For my example, here is a command to find all records with the text string that I'm looking for: select id from pictures where caption like '%www.bob.com%'; Now I want to replace the string www.bob.com in those records with www.bubba.com. One of the records has the following in the caption column: There is a party at www.bob.com Now I want it to be: There is a party at www.bubba.com I'm sure there is an easy way to do this. :-) update pictures set caption=REPLACE(caption,www.bob.com,www.bubba.com); MySQL's update optimisation should automatically save it from updating those rows that do not need to change. Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replacing text using the Update command?
Pat's version was better than mine. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.16 on SCO OpenServer 5.0.6
Hello Stefaan, Stefaan Van Dooren [EMAIL PROTECTED] wrote: I'm totally lost now.. As you can (could) see in my previous post, I managed to get MySQL working on SCO with --with-debug as a configure option. Whenever I remove --with-debug, I can compile and install it, but I can't connect to it. Can someone please explain what this --with-debug adds that makes it run on my system ? I have not tried the --with-debug option, so cannot advise on that. However ... I usually find that MySQL configuration problems can be explained by looking at the main mysql error file. This is called *.err and is normally in the data directory. Certainly, if the server will not start, you should find the reason there. You might also find clues to your connection problem. Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.16 on SCO OpenServer 5.0.6
Hello Stefaan, Stefaan Van Dooren wrote: Hi, I'm trying to install (compile, since there are no binaries for this system) MySQL on an SCO OPenServer 5.0.6 system. Prior to compiling MySQL, I installed the following packages for SCO : FSU Pthreads (ver 3.9) GNU Development Tools (ver 5.0.7Kj) Netscape Communicator (ver 4.7.0e) OSS631B - Supplemental Graphics, Web and X11 Libraries (ver 1.2.1) SCO OpenServer Enterprise System (ver 5.0.6j) SCO OpenServer Linker and Application Development Libraries (ver 5.1.2A) SCO SendMail (ver 8.11.0) OSS635A: Graphical Environment Supplement for OpenServer 5.0.6 (ver 1.0.0) OSS646B - Execution Environment Supplement (ver 1.1.0j) RS506A: Release Supplement for SCO OpenServer Release 5.0.6 (ver rs506a) RS506A: Software Manager Supplement (ver rs506a) USB Supplement (ver 1.0a) I asked our Unix technicians to comment about those. They said: Looks like he has all the patches loaded. Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.16 on SCO OpenServer 5.0.6
Hello Stefaan, We have around 80 servers running MySQL 4.0.15 on SCO OpenServer 5.0.5 through 5.0.7. Here is my make: CC=gcc CFLAGS=-O3 -mpentium LDFLAGS=-static CXX=gcc \ CXXFLAGS=-O3 -mpentium -felide-constructors \ ./configure --prefix=/usr/local/mysql \ --enable-thread-safe-client --enable-local-infile \ --disable-shared We do have a couple of issues with it, so we should compare notes. The issues are mostly due to SCO, not MySQL. Regards, Stephen - Original Message - From: Stefaan Van Dooren [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 21, 2003 11:36 PM Subject: RE: MySQL 4.0.16 on SCO OpenServer 5.0.6 Since I got no answers, I will put another question Is anybody using MySQL 4.x on SCO OpenServer 5.x ? Stefaan Stefaan Van Dooren wrote: Hi, I'm trying to install (compile, since there are no binaries for this system) MySQL on an SCO OPenServer 5.0.6 system. Prior to compiling MySQL, I installed the following packages for SCO : FSU Pthreads (ver 3.9) GNU Development Tools (ver 5.0.7Kj) Netscape Communicator (ver 4.7.0e) OSS631B - Supplemental Graphics, Web and X11 Libraries (ver 1.2.1) SCO OpenServer Enterprise System (ver 5.0.6j) SCO OpenServer Linker and Application Development Libraries (ver 5.1.2A) SCO SendMail (ver 8.11.0) OSS635A: Graphical Environment Supplement for OpenServer 5.0.6 (ver 1.0.0) OSS646B - Execution Environment Supplement (ver 1.1.0j) RS506A: Release Supplement for SCO OpenServer Release 5.0.6 (ver rs506a) RS506A: Software Manager Supplement (ver rs506a) USB Supplement (ver 1.0a) I followed the manual for compiling and installing MySQL. MySQL compiles just fine. I can use the compiled client to connect to databases running on W2K and linux servers. When I start the server (mysqld-safe --user=mysql --log ), it seems to start fine : Starting mysqld daemon with databases from /usr/local/mysql/var Err log : 031120 10:35:55 mysqld started Log : /var/opt/K/SCO/Unix/5.0.6Ga/usr/local/mysql/libexec/mysqld, Version: 4.0.16-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id CommandArgument The socket is there, but when I start mysql it just hangs there forever When I try msqladmin status it also hangs, but when I stop it, I get # mysqladmin status mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (4) ' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! It's there : # l /tmp/mysq* prwxrwxrwx 1 mysqlmysql 0 Nov 20 10:35 /tmp/mysql.sock # Any help would be appreciated, Stefaan Van Dooren .--. Technical Support |o_o | Kompas Automatisering |:_/ | // \ \ Tel : +32 3 2350084(| | ) Fax : +32 3 2359792 /'\_ _/`\ Email : [EMAIL PROTECTED] \___)=(___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Update optimization?
UPDATE some_table SET some_field=IF(id = some_id,1,0) Have fun, Stephen - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 21, 2003 11:41 AM Subject: Update optimization? Hello guys, Let say: UPDATE some_table SET some_field=1 WHERE id = some_id and UPDATE some_table SET some_field=0 WHERE id some_id what I can do to merge these queries? The first thing that came up in my mind was something like that: UPDATE some_table SET some_field=1 WHERE id = some_id; SET some_field=0 WHERE id some_id; so we can walk-through table only once... What do you think? Regards, July -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Column comment / metadata tables
Basically, what I would like to do is associate a human readable label with each column (in the comment field) so that I can automatically generate web-based forms for any given table. The script would look at the column's metadata, display the appropriate HTML element, and display the corresponding label read from the column field. MySQL could do something that would make MySQL more complete and more able to satisfy these Codd rules: 0. A relational database must be able to manage databases entirely through its relational capabilities. 1. The Information Rule. All information in a relational database (including table and column names) is represented explicitly as values in tables. The metadata would be loaded into tables (real, virtual, heap or temporary?). It would be refreshed as necessary by mysqld, when processing ALTER, DROP, CREATE, etc. Normal SELECTs would be used to efficiently view those metadata tables. Why should it be necessary for tools such as MySQLfront to use?: SHOW TABLE STATUS, SHOW FIELDS FROM table, SHOW KEYS FROM table. Thanks, Stephen - 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: speeding up simple SELECT statements with the C api?
Hello Gary, The MySQL server uses the myisam libraries to access MyISAM tables at the lower level. It works similarly to and just as quickly as C-ISAM, though the API is fairly different (IMHO). A myisam user manual is available, but is not complete (I know, since I wrote it). You could use that method for much faster navigation when your application reads just a row at a time. MySQL (4.0?) also provides a HANDLER syntax for doing row at a time IO but more at the SQL level. It is slower than myisam, but probably much faster than normal SQL for your purposes. I recommend you try (order of preference): - Rewrite the reports to be set based not row based. Or - See if HANDLER syntax is quick enough. I think it will be. Or - See if you can cope with the myisam libraries. Or - Beef up your hardware and tweak everything. Good luck, Stephen Brownlow, Sydney, Australia. - 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: C API Changes?
ggelu [EMAIL PROTECTED] wrote: --- Amy Joseph Kormann [EMAIL PROTECTED] wrote: Are there any (significant) changes in the C API between MySQL 3.X and 4.X? If so, where are they located. Yes. Are some changes between ver 3.x and 4.x.If i understand well i think you try to find where this changes are declared/prototype?...on h files. We should not need to read the source files to use the API. Are there any changes affecting the applications that use the API? Has the documentation changed? Stephen - 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: partitionong MyISAM tables??
Prasanth Krishna [EMAIL PROTECTED] wrote in message news:b1eg64$2rqn$[EMAIL PROTECTED]... Is there any way to partition MyISAM tables in mysql? i have a huge table and want to partition it. Do InnoDB tables support partitioning? thanks. The software RAID option for MyISAM sounds like what you need. I understand it is in the MySQL-MAX , not the standard MySQL binary. Here are a couple of extracts from the MySQL manual. RAID_TYPE= {1 | STRIPED | RAID0 } RAID_CHUNKS=# RAID_CHUNKSIZE=# The RAID_TYPE option will help you to break the 2G/4G limit for the MyISAM data file (not the index file) on operating systems that don't support big files. You can get also more speed from the I/O bottleneck by putting RAID directories on different physical disks. RAID_TYPE will work on any OS, as long as you have configured MySQL with --with-raid. For now the only allowed RAID_TYPE is STRIPED (1 and RAID0 are aliases for this). If you specify RAID_TYPE=STRIPED for a MyISAM table, MyISAM will create RAID_CHUNKS subdirectories named 00, 01, 02 in the database directory. In each of these directories MyISAM will create a table_name.MYD. When writing data to the data file, the RAID handler will map the first RAID_CHUNKSIZE *1024 bytes to the first file, the next RAID_CHUNKSIZE *1024 bytes to the next file and so on. See also the Changes History. Stephen - 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: take one database offline
Egor Egorov [EMAIL PROTECTED] wrote on December 05, 2002: What do you mean disable database? Ask the MySQL server to Flush it, then not access its tables until further notice. You can't turn off the database.. Can this please be written? It offers big benefits for little effort. You can make backup of the database and then drop the database.. Why do you want to do it? We have a similar need. We have a client with 16 branches. Each branch runs the same software, using the same server. Each branch has its own database. When maintenance is necessary, it would be far better to be able to: 1. turn off one database, 2. use myisamchk, Unix or other applications to adjust it in any way, 3. turn it back on. That way, the other 15 branches can continue normal operations while the maintenance occurs on the one. Thanks, Stephen - 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: take one database offline
Hello Paul, I am only lobbying, not demanding. Paul Dubois wrote: Mmm, how do you know how much effort it would be? Have you implemented it? Ok. IMHO it would be relatively easy for MySQL to implement, judging by my experience dealing with Monty and his source code (specifically, the myisam API). I await comments from MySQL AB. Write a client that flushes all the tables, then places a write lock on them all. That will keep anyone else from modifying them. Will it stop mysqld from reading them? Some maintenance processes such as myisamchk will actually move the files around, which could confuse mysqld. Run myisamchk. When it's done, flush the tables again and unlock them. While that might be workable, don't you think the proposal would be both safer and simpler? Thanks, Stephen - 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: Locking TABLES for myisamchk, please help!!
I understand all of the reasons given by Alexander. Yet I think that in 99% of cases, it would be best for myisamchk to do as Mark suggest, and not run when a MySQL server is active. Safety would be the default. There could be a special option (--no-safety) for myisamchk to override that check. - Original Message - From: Alexander Keremidarski [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, May 23, 2002 1:54 AM Subject: Re: Locking TABLES for myisamchk, please help!! Mark wrote: Wednesday, May 22, 2002, 9:23:02 AM, louie wrote: cut Personally, I find the behavior of myisasmchk to be a bit beta when it comes live tables. It would be real easy for myisasmchk to refuse to run when mysqld is running. That should be a built-in precaution. I can understand possible objections to myisasmchk globally locking tables out of the blue (it might disrupt what some clients are doing), but if myisamchk cannot run on a live table, it should not run on a live table. As simple as that. Hi, It is not that simple. You can run several mysqld simultaneously. So checking if mysqld is running is not enough. Or you might wish to use myisamchk knowing in advance that mysqld will not write to table. Typical case is to check 'offline' database or table. Backup copy for example. Another case: You want to check table which is read-only for all mysql users and for some reason (different priority, buffers used etc.) you don't want to do it with REPAIR TABLE. myisamchk uses tables as files so it is admin responcibility to avoid problems. It is dangerous to use it but it is possible. You can compare it to filesystem checks. It is admin to decide if he can handle it with live server or not. - 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: [7241] Indexes on columns that are declared differently?
I am hoping that a MySQL person will give a definite answer to my question. Thanks, Stephen - Original Message - From: Dan Nelson [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, May 20, 2002 3:18 PM Subject: Re: [7241] Indexes on columns that are declared differently? In the last episode (May 20), Stephen Brownlow said: The MySQL online manual says that MySQL cannot use indexes efficiently unless the columns have the same type and the same length. I can see no release notes that this problem has been fixed. My question: Is this still a problem? Probably. I doubt anyone's even trying to fix it, since a field-length mismatch between related fields means that one or the other fields has the wrong length. You'll never get a 20-character string to match if the other table's field definition is char(10); either make both 10, or both 20 :) - 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
[7241] Indexes on columns that are declared differently?
The MySQL online manual says that MySQL cannot use indexes efficiently unless the columns have the same type and the same length. I can see no release notes that this problem has been fixed. My question: Is this still a problem? Here is the extract from the latest manual: 7.29 EXPLAIN Syntax (Get Information About a SELECT) -- One problem here is that MySQL can't (yet) use indexes on columns efficiently if they are declared differently. In this context, VARCHAR and CHAR are the same unless they are declared as different lengths. Because tt.ActualPC is declared as CHAR(10) and et.EMPLOYID is declared as CHAR(15), there is a length mismatch. To fix this disparity between column lengths, use ALTER TABLE to lengthen ActualPC from 10 characters to 15 characters: mysql ALTER TABLE tt MODIFY ActualPC VARCHAR(15); - Thanks, Stephen - 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
7241 Indexes on columns that are declared differently?
The MySQL online manual says that MySQL cannot use indexes efficiently unless the columns have the same type and the same length. I can see no release notes that this problem has been fixed. My question: Is this still a problem? Here is the extract from the latest manual: 7.29 EXPLAIN Syntax (Get Information About a SELECT) -- One problem here is that MySQL can't (yet) use indexes on columns efficiently if they are declared differently. In this context, VARCHAR and CHAR are the same unless they are declared as different lengths. Because tt.ActualPC is declared as CHAR(10) and et.EMPLOYID is declared as CHAR(15), there is a length mismatch. To fix this disparity between column lengths, use ALTER TABLE to lengthen ActualPC from 10 characters to 15 characters: mysql ALTER TABLE tt MODIFY ActualPC VARCHAR(15); - Thanks, Stephen - 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: Problem installing 3.23.43 (@HOSTNAME@ command not found)
We have the same problem with MySQL (3.23.36) for SCO OpenServer, in script mysql.server. Here is the problem code, showing my workaround. ... if test -z $pid_file then # pid_file=$datadir/`@HOSTNAME@`.pid pid_file=$datadir/`hostname`.pid # changed @HOSTNAME@ to hostname else case $pid_file in ... I see no release notes to indicate that the problem is fixed. Thanks, Stephen I then got this error message: /etc/init.d/mysqld: @HOSTNAME@: command not found Starting mysqld daemon with databases from /usr/local/mysql/data 011029 12:23:02 mysqld ended Any ideas why this error is occurring? Thanks, Neil. - 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: Frequently corrupt tables
Hi Matthew, We had a similar problem that caused us to need to run myisamchk much more than we wanted to. It turned out that MySQL was not being shutdown when Unix was. Symptom: The MySQL server error log did NOT show normal shutdown messages. Cause 1: The normal method of shutting down MySQL uses kill to send a signal to the process. That was NOT working on SCO Open Server 5. Cause 2: We did not properly understand where to put the Unix shutdown scripts. Solution: Created a correct script: /etc/rc0.d/K95mysql AND changed it to use mysqladmin ... shutdown rather than kill. Result: MySQL now shuts down nicely in all cases except server power cuts. Normal shutdown messages on its log. More robust data. Stephen -Original Message- From: Matthew Bloch [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 3:34 AM To: [EMAIL PROTECTED] Cc: Peter Taphouse; Alec O'Donnell Subject: Frequently corrupt tables Hello all; I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with myisamchk. This is happening once every few days and it's becoming a pain. I have a multithreaded process which is constantly opening and closing connections to the database and trying to increase its concurrency until the load average reaches something comfortable like 15, and the network connection is saturated. I've had to throttle it back to stop it opening more than 32 simultaenous DB connections but otherwise it works fine. Until I start getting errors from the table handler, that is, and the whole thing grinds to a halt until I fix the table manually. Can anybody shed some light on this? I can't believe I'm putting it under more load than something like Slashdot would, and they don't (appear to) have half the troubles I've had. cheers, -- Matthewhttp://www.soup-kitchen.net/ - 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