Re: rhel4 mysql max rpm question
Hi Yong, all, Yong Lee wrote: Hi All, I noticed that there are RPM downloads for RHEL4 but that these do not contain the ndb storage engine (ie: these are standard builds). As such, I've resolved to just use the generic x86 rpm bundles that are offered but I'm curious if the ndb storage engine will ever get included into a RHEL4 RPM bundle? First: When asking, please tell us what version you refer to. Very often, the correct answer depends on the MySQL version affected. Second: I won't make a prediction, but I am not aware of any plans to change that. In what way is it important for you to have a RPM geared specifically to RHEL 4, as opposed to a generic one ? Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rhel4 mysql max rpm question
Hi All, I noticed that there are RPM downloads for RHEL4 but that these do not contain the ndb storage engine (ie: these are standard builds). As such, I've resolved to just use the generic x86 rpm bundles that are offered but I'm curious if the ndb storage engine will ever get included into a RHEL4 RPM bundle? Thanks, Yong.
MySQL Max Build Policy
Dear MySQL users, Starting MySQL 5.1 (1), we’re simplifying life when it comes to the number of builds for each platform. We will be building only one binary package for each platform (2): the binary known in MySQL 5.0 as “max”. The assumption is that users prefer one binary with all options enabled, rather than having to choose the proper version at install time (or worse still, rely on others having made the proper choice on their behalf). And with only one version, there is no need to call it “max”. “The max version is dead. Long live the max version!“. Not to speak in riddles, the standard mysqld binary is intended to contain all mysqld-max features. While 5.1.11 e.g. in Linux (x86) package still has three binaries mysql-5.1.11-beta-linux-i686/bin/mysqld mysql-5.1.11-beta-linux-i686/bin/mysqld-debug mysql-5.1.11-beta-linux-i686/bin/mysqld-max the plan is to reduce this to two. Already now in 5.1, the only difference between mysqld and mysqld-max is the BDB table handler. The only real difference going forward is removing support of BDB, which is the first step towards removing it also from the source after 5.1. We think the majority of our users agree that the simplification is beneficial. This way, MySQL will by default contain MySQL Cluster, together with all other functionality we deem stable enough to provide our user base with. In MySQL 5.0 and earlier, the Standard/Max duality has proven problematic from the user’s perspective: - The question “Which package should I install?” is a very common one on the mailing list. - There is a limit to the number of flavours a user can decide between, more flavours is just overwhelming. - The risk of the user picking the wrong binary and then thinking “this is not supported” is high. - As we want customers to try new things, we should see to it that they already have them installed. I imagine the user asking himself or herself questions like - Has my DBA installed the version I want and need? - Are security functions (such as SSL) available in all binaries? - Does the Debug version have the extra debug information on top of Standard or on top of Max? - Is MySQL Max somehow related to MaxDB? (Footnote: No, it is not) I won’t hide the fact that our Build team also saves some time by not providing multiple binaries: We get a shorter turnaround time for builds, for tests and for uploads to mirrors. And it helps our commercial Support team, which now needs to ask users to separate between flavours for versions, and keep track of differences between flavours. However, our simplification is not as much about reducing our own build complexity, as about simplifying life for our user base. - Fewer choices means less time spent choosing, simpler lists on the Web. - The user/developer is less dependent on which particular version he has, when he uses/develops applications based on MySQL. - The developer does not need to convince his DBA or ISP to upgrade into a particular flavour of a release. ISPs and DBAs don’t have to make complex decisions on which flavours to support. - Distributors will hopefully pick up our choice of configuration, to further reduce the number of different MySQL configurations available (and thereby the confusion). Like with any decision, we don’t have all the facts at hand. So now is the time to let us know if we’re on track or not. This can be done on the forums at http://forums.mysql.com/list.php?3, or on the mailing lists at http://lists.mysql.com/mysql or as comments to my blog on http://www.planetmysql.org/kaj/?p=58 Footnotes: (1) The MySQL 5.1 download pages at http://dev.mysql.com/downloads/mysql/5.1.html say As we’re working on making some changes to how we will provide binary distributions of MySQL 5.1, this release currently only provides “Max” binaries for a few selected platforms as well as the source distributions. Compare this to the download pages for MySQL 5.0 Community Edition - Generally Available (GA) Release at http://dev.mysql.com/downloads/mysql/5.0.html where we say The Standard binaries are recommended for most users The Max version includes additional features that have not been exhaustively tested or are not required for general usage. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. The Max version also, for most platforms, contains MySQL Cluster storage node, management server and mysqld/ndb enabling programs. The Debug binaries have been compiled with extra debug information, and are not intended for production use, because the included debugging code may reduce performance. (2) A separate server binary with additional debugging support enabled continues to be included. Kaj -- Kaj Arnö [EMAIL PROTECTED] MySQL AB, VP Community Relations -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http
difference between mysql max version and non-max version
Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation of mysql on the clinet machine is to be done easily wihout any hassals and minimal human intervension regards, Ashwini - Yahoo! India Answers: Share what you know. Learn something new. Click here
difference between mysql max version and non-max version
Note: forwarded message attached. Yahoo! India Answers: Share what you know. Learn something new. Click here---BeginMessage--- Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation of mysql on the clinet machine is to be done easily wihout any hassals and minimal human intervensionregards,Ashwini Yahoo! India Answers: Share what you know. Learn something new. Click here---End Message--- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: difference between mysql max version and non-max version
Hi! ashwini c.v wrote: Can anybdoy please tell me the difference between mysql max version andthe non-max version? I answered this here on April 26. Also, please use exact terminology: A version is a two- or three-level numeric designator, like 4.1 or 5.0.21. max is a package, or (coming with 5.1) a server variant. Also lemme know how the max version is helpful if the installation of mysql on the clinet machine is to be done easily wihout any hassals and minimal human intervension No difference between a max and a standard package in this respect. Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: difference between mysql max version and non-max version
On 5/2/06, ashwini c.v [EMAIL PROTECTED] wrote: Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation of mysql on the clinet machine is to be done easily wihout any hassals and minimal human intervension This is well covered in the documentation: http://dev.mysql.com/doc/refman/5.0/en/mysqld-max.html Also, mysqld-max has the d on its name because its a daemon, a server, so, no use for it on a machine suppose to be a client. Its just a version of the server with different options (more features) at compile time. Joerg, accourding to the page above, he used the correct terminology, a version has different meanings, one for apps (as you stated) and another for executables (builds), that is the way Ashwini mentioned it. -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld vs. mysql-max
Hi Payne, Payne wrote: Hey, I got a box that is dying, it is currently running MySQL-Max, I want to move the DB from it to a box that is running just plain jane MySQL, what will happen and will it work. I know, strange but I am not sure what the Max does. we cannot tell either, as you do not list the versions involved. Basically, max is standard with some more advanced stuff added, typically the cluster table handler (aka NDB) and some options considered experimental (like big tables, big joins etc.). The exact feature difference varies from version to version, as some of the experimental features are later considered stable and well-tested and then get included in the standard server. The main difference that will remain is the issue of the cluster handler; and as long as you do not use it, its inclusion in Max does not make a difference to you. In short: Most likely, the difference will not matter for you (for otherwise you would know about it). Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld vs. mysql-max
Hey, I got a box that is dying, it is currently running MySQL-Max, I want to move the DB from it to a box that is running just plain jane MySQL, what will happen and will it work. I know, strange but I am not sure what the Max does. Payne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory
Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server Is it possible to give more memory to the client when running on the command line? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory
Hi Tom, Use -q option on mysqldump ;) -q Won't buffer query, It will dump directly to stdout. --Praj On Tue, 14 Mar 2006 11:56:42 + Tom Brown [EMAIL PROTECTED] wrote: Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server Is it possible to give more memory to the client when running on the command line? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory
Hi Tom, Are you using the --quick option? --quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out. From the manual at page http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Tom Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, 14 March 2006 10:27 PM To: mysql@lists.mysql.com Subject: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server Is it possible to give more memory to the client when running on the command line? thanks -- 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: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory
Are you using the --quick option? --quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out. thanks both - that did the trick cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
some myisam tables turned read only (MySQL Max 4.1.12)
Very odd problem. I do have a larger database, with many myisam tables. A couple days ago, some of them turned 'read only'. Symptom: delete from day_48392 where id=28398776259; ERROR 1036 (HY000): Table 'day_48392' is read only I checked: - table file permissions are right ('660 mysql:daemon'). They are the same for all tables - directory permissions are 700 mysql:daemon - tables are not packed. To track this down, I tried: - copy data from old table to a new table: create table x like day_48392; insert into x select * day_48392; table 'x' is now writable and works fine drop table day_48392; alter table x rename day_48392; and 'day_49392' is once again read only :-( - compress/uncompress the table: no luck - repair the table from within mysql fails (read only) - repair table from shell with myisamchk works, but doesn't fix the problem - I flushed tables (several times) - I restarted mysql - I rebooted the system So what else ??? Hint: before this started, I backed up a number of older tables. In order to back them up, I copied them to a different partition, marked them '444'. Next, I dropped the tables, and added a symlink to the backups. Looks like tables are affected if they existed at the time of the backup. Tables created after that are fine. The tables that have the problem where not touched during the backup :-( The tables are part of a merge table. but dropping the merge table doesn't help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SOLUTION] some myisam tables turned read only (MySQL Max 4.1.12)
Well, I found the reason for these table becoming 'read only': These tables where part of a merge table, which included some read only tables (read only set in file system). Now even after the merge table was dropped, all member tables stayed 'read only' regardless of their individual file system permissions. very odd.. a bug? to recover, you will have to: - drop the merge table. - create new tables - insert the data from the old tables into the new tables - drop the old tables - rename the new tables to match the names of the old tables. - change file system permissions on ALL the tables of the merge tables - recreate the merge tables... signature.asc Description: OpenPGP digital signature
Re: 'Autoextend' datafile - Mysql-Max-4.1.14 - Linux
Tom Brown wrote: hmm i'm not entirely sure i fancy adding another data file on the fly - Can you give me a brief run down about how you would go about this? My collegue the sysadmin usually takes care of keeping the databases happy. But AFAIK it's a matter of modifying the setting in the .cnf file and restarting MySQL. I wouldn't let a process do the editing in the .cnf though, but you may trigger alerts automagically. another option would be for me to create the 100gig as 2 25 gig files from the off - Do you know how well these would compress? Do you know what they are 'filled' with so when it comes to backup they will compress down to virtually nothing? I wouldn't use the InnoDB datafiles in a backup. They are use server wide for storing InnoDB data. You can use a MySQL dump or the InnoDB hot backup tool to backup the data easily. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 'Autoextend' datafile - Mysql-Max-4.1.14 - Linux
The short answer: no. http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states: The autoextend attribute and those following can be used only for the last data file in the innodb_data_file_path line. autoextend is available starting from MySQL 3.23.50 and 4.0.2. You could use two methods to manage the increasing need for space in your situation: 1) Use fixed sizes and keep track of the free space. Use SHOW TABLE STATUS LIKE 'tablename'; and use the `Comment` column which shows you something like InnoDB free: 5278720 kB. If this number gets too low, modify your config file and add an extra datafile. 2) Use an autoextend file and make it fixed size if it gets too large. http://dev.mysql.com/doc/refman/4.1/en/adding-and-removing.html tells you that you can change an autoextend datafile to a fixed size file by getting the size, rounding it to the closest multiple of 1024 x 1024 bytes (1MB), changing the settings in the configuration file in such a way that the autoextend file is now fixed to the size you calculated and that you added a new autoextend file. hmm i'm not entirely sure i fancy adding another data file on the fly - Can you give me a brief run down about how you would go about this? another option would be for me to create the 100gig as 2 25 gig files from the off - Do you know how well these would compress? Do you know what they are 'filled' with so when it comes to backup they will compress down to virtually nothing? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
'Autoextend' datafile - Mysql-Max-4.1.14 - Linux
Hi I need to have a single db that will have in excess of 100gb of data in it - For this i will need to create more that 1 datafile as the max file size of linux would be exceeded in this scenerio. On Oracle you can say that a datafile is x mb in size and it can autoextend to be x mb - Is this possible in MySQL 4.1.x ? I see that you can say that each datafile is x mb but that this filesize is created when the server is started eg if i want 100GB of space available then i can create 4x25GB files but they have to start at 25GB rather than all starting at say 1GB and then 'extending' to 25GB. So is it possible for all datafiles, rather than just the last one, be 'autoextending' Hope this makes sense -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 'Autoextend' datafile - Mysql-Max-4.1.14 - Linux
From: Tom Brown [EMAIL PROTECTED] (...) starting at say 1GB and then 'extending' to 25GB. So is it possible for all datafiles, rather than just the last one, be 'autoextending' The short answer: no. http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states: The autoextend attribute and those following can be used only for the last data file in the innodb_data_file_path line. autoextend is available starting from MySQL 3.23.50 and 4.0.2. You could use two methods to manage the increasing need for space in your situation: 1) Use fixed sizes and keep track of the free space. Use SHOW TABLE STATUS LIKE 'tablename'; and use the `Comment` column which shows you something like InnoDB free: 5278720 kB. If this number gets too low, modify your config file and add an extra datafile. 2) Use an autoextend file and make it fixed size if it gets too large. http://dev.mysql.com/doc/refman/4.1/en/adding-and-removing.html tells you that you can change an autoextend datafile to a fixed size file by getting the size, rounding it to the closest multiple of 1024 x 1024 bytes (1MB), changing the settings in the configuration file in such a way that the autoextend file is now fixed to the size you calculated and that you added a new autoextend file. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL-Max Mandriva
I have MySQL 4.1.12 that came on the Mandriva Linux 2006 RC1 CDs. I think it is probably the Standard rather than the Max version. How can I tell for sure? The reason I am asking is because I have the MySQL Tutorial book, published by MySQL Press and it says that I need the Max version to do all the lessons in the book. Installing MySQL version from Mandriva was a no-brainer because it was already adapted and included in the Mandriva package manager. How complex would it be to get the Max version from the MySQL web site and get it going on my machine with Apache and PHP? If I go that route should I go ahead and get MySQL 5 while I'm at it? Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does the kernel options MAXSSIZ affect the MySQL max connections on FreeBSD
hi,everyone, I just did a test to find out the MySQL4.1.12 max connections on FreeBSD 5.4 Release and FreeBSD 4.11 Release. The first test, the MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because I have 1GB memory. The second test, I setted the MAXSSIZ=1GB, and the MAXDSIZ is also 1GB. The two test show that the MySQL max connections is the same. The max connections is about 1000. Have anyone kown how to tune the FreeBSD and MySQL to increase the max connections? Best regards, leo huang [EMAIL PROTECTED] 2005-06-17 _ MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Does the kernel options MAXSSIZ affect the MySQL max connections on FreeBSD
huang leo : hi,everyone, I just did a test to find out the MySQL4.1.12 max connections on FreeBSD 5.4 Release and FreeBSD 4.11 Release. The first test, the MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because I have 1GB memory. The second test, I setted the MAXSSIZ=1GB, and the MAXDSIZ is also 1GB. The two test show that the MySQL max connections is the same. The max connections is about 1000. Have anyone kown how to tune the FreeBSD and MySQL to increase the max connections? Best regards, leo huang [EMAIL PROTECTED] 2005-06-17 _ MSN Messenger: http://messenger.msn.com/cn mysql show variables like '%max%'; +-+--+ | Variable_name | Value | +-+--+ | bdb_max_lock | 1 | | ft_max_word_len | 84 | | group_concat_max_len | 1024 | | innodb_max_dirty_pages_pct | 90 | | innodb_max_purge_lag | 0 | | max_allowed_packet | 1048576 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connect_errors | 10 | | max_connections | 100 | | max_delayed_threads | 20 | | max_error_count | 64 | | max_heap_table_size | 16777216 | | max_insert_delayed_threads | 20 | | max_join_size | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_relay_log_size | 0 | | max_seeks_for_key | 4294967295 | | max_sort_length | 1024 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 4294967295 | | myisam_max_extra_sort_file_size | 2147483648 | | myisam_max_sort_file_size | 2147483647 | +-+--+ 24 rows in set (0.00 sec) You can see max_connections=100. Change that variable to get max connections you want. Regards, Gu Lei -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error in the binaries installation of mysql-max-4.1.10a-pc-linux-gnu-i686
Hello. You have links in MySQL message which you should follow. Resolve the stack trace. I suggest you to switch to 4.1.11. If you are able to make a repeatable test case you may report a bug. Does the problem remain with a debug package? Hi, We tried to install mysql-max-4.1.10a-pc-linux-gnu-i686 on linux 2.4.30 with redhat es 3.0 When I executed the mysql_install_db script , I have these errors: [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql Installing all prepared tables mysqld got signal 11; 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=8388600 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x40a4c77c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8136a43 0x40054e58 (nil) New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Can someone help me ? David M. Marois, David [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error in the binaries installation of mysql-max-4.1.10a-pc-linux-gnu-i686
Hi, We tried to install mysql-max-4.1.10a-pc-linux-gnu-i686 on linux 2.4.30 with redhat es 3.0 When I executed the mysql_install_db script , I have these errors: [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql Installing all prepared tables mysqld got signal 11; 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=8388600 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x40a4c77c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8136a43 0x40054e58 (nil) New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Can someone help me ? David M.
re: problem with mysql-max-5.0.3 for Solaris 8 32 bit
It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file from http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-max-5.0.3-beta-sun-solaris2 .8-sparc.pkg.gz/from/http://mysql.mirrors.pair.com/ James, Sorry about this. Somehow the 64bit tarball was used for this package. I've fixed it now and uploaded a new 32bit Solaris 2.8 PKG. Note that it will take a bit to propagate out to the mirrors (probably 8-10 hrs). Thanks for notifying us about this. Matt -- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: problem with mysql-max-5.0.3 for Solaris 8 32 bit
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file from http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-max-5.0.3-beta-sun-solaris2.8-sparc.pkg.gz/from/http://mysql.mirrors.pair.com/ - -- Love is mutual self-giving that ends in self-recovery. Fulton Sheen James Black[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCSGQkikQgpVn8xrARAqr1AJsFslyPkjRck+5uNTPbU3gxoLx9fwCeJEEn fdly9uy3J0L38pkizClQNzY= =hmti -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrading from MySQL Max 3.23 to 4.1.x
Greetings all, I am currently running mysql-max-3.23.54a-sun-solaris2.9 and would like to upgrade to a 4.1 sparc 64 equivalent. As I'm also running 'depot' on the same machine that has MySQL, I wonder what the easiest way to do this upgrade would be. I presume that it would be to do a seperate install and then let depot do the migration. However, if MySQL provides a simple 'upgrade' I would love to hear of it. Thanks! Lee __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem Installing MySQL Max
Trying to install MySQL 4.1.1 Max binary using MySQL-Max-4.1.1-0.i386.rpm onto Linux Fedora version. When I do, I get the following failed dependencies: libcrypto.so.0.9.6 is needed by MySQL-Max-4.1.1-0 libssl.so.0.9.6 is needed by MySQL-Max-4.1.1-0 libstdc++-libc6.2-2.so.3 is needed by MySQL-Max-4.1.1-0 But on my system I DOhave: /lib/libcrypto.so.0.9.7a /libssl.so.0.9.7a I haven't figured out where to get the libstdc++ one yet, but shouldn't the other two be fine seeing how they are later versions? Lou
Re: Problem Installing MySQL Max
Lou Olsten wrote: I haven't figured out where to get the libstdc++ That's part of gcc usually found in /usr/local/lib or in the lib dir under the gcc installation dir. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL, mySQL Max and stored procedure support (version problem?)
I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? but this fail create procedure pippo begin select 1 end as well as create procedure 'pippo' begin select 1 end and many other combination Is my syntax wrong? am I using the wrong version of mySQL to have SP support? Should I configure anything to have SP support? If I'm using the wrong version of mySQL which one has SP support and is considered the most stable? thx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
Hi, I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
On Tue, 9 Mar 2004 10:52:38 +0100 Martijn Tonies [EMAIL PROTECTED] wrote: I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. But what about Max version? Docs are not crystal clear. While it is clearly stated that mySQL started to support SP from version 5, nothing is said about Max where docs just say it supports them but it is not clear from which version. It is even not that clear from which source package should I start from to have Max or plain mySQL. I gave a look to SUSE source package of release 4 and it seems that Max and plain are built from the same tarball. Since I'm not sure if I have a version that support SP it is difficult to see if my syntax is wrong or it is a problem of version. Could anyone post a correct 5 line example of working stored procedure to test? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote: On Tue, 9 Mar 2004 10:52:38 +0100 Martijn Tonies [EMAIL PROTECTED] wrote: I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. But what about Max version? Docs are not crystal clear. While it is clearly stated that mySQL started to support SP from version 5, nothing is said about Max where docs just say it supports them but it is not clear from which version. 5 is a number of version. MySQL-Max is a name of MySQL server, where Max means that this MySQL server supports InnoDB and BDB storage engines. It is even not that clear from which source package should I start from to have Max or plain mySQL. I gave a look to SUSE source package of release 4 and it seems that Max and plain are built from the same tarball. Since I'm not sure if I have a version that support SP it is difficult to see if my syntax is wrong or it is a problem of version. Could anyone post a correct 5 line example of working stored procedure to test? For example: mysql delimiter | mysql create procedure pippo () - begin - select 1; - end | Query OK, 0 rows affected (0.07 sec) Syntax of stored procedures is described at: http://www.mysql.com/doc/en/CREATE_PROCEDURE.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
On Tue, 09 Mar 2004 12:36:30 +0200 Victoria Reznichenko [EMAIL PROTECTED] wrote: 5 is a number of version. MySQL-Max is a name of MySQL server, where Max means that this MySQL server supports InnoDB and BDB storage engines. So this make MaxDB another product Could anyone post a correct 5 line example of working stored procedure to test? For example: mysql delimiter | mysql create procedure pippo () - begin - select 1; - end | Query OK, 0 rows affected (0.07 sec) Syntax of stored procedures is described at: http://www.mysql.com/doc/en/CREATE_PROCEDURE.html Yep but without being sure you've the right software you're always in doubt if you missed something. Anyway result was the same. So I've to upgrade. Any suggestion about which is the way to go to have stored procedure on mySQL. I was compiling 5.0 right now and I had trouble with relayrotate test. First passed, second didn't. Installation script suggest to use --force... Google doesn't offer any page for relayrotate mysql. spasiba -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: guru needed - large configuration MySQL-Max InnoDB - 4.0.16
You don't mention CPU type but do mention RedHat 9. Is this on 32-bit x86 hardware or something 64-bit? How do you set innodb_buffer_pool_size to anything 2GB on a 32-bit box if it is? I've got it set to 7GB on a dual Opteron box with 8GB RAM with great results so far (in testing, go live next week probably). Hi, innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_buffer_pool_size = 6G it looks like your InnoDB tablespace is less than 2G. If it is true then IMHO it doesn't make any sense to allocate 6G for innodb_buffer_pool. InnoDB won't use it. Best regards, Mikhail. - Original Message - From: nm [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 30, 2003 10:17 AM Subject: guru needed - large configuration MySQL-Max InnoDB - 4.0.16 Hi there I was wondering I you can send your comments and remarks for this my.cnf file o.s. redhat9 tables 20Mb mem: 8gb server dedicated to mysql max_connections=2000/3000 uses only innodb tables my.cnf [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 max_connections=2000 #max_connections=3000 innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 6G innodb_additional_mem_pool_size = 20M innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
guru needed - large configuration MySQL-Max InnoDB - 4.0.16
Hi there I was wondering I you can send your comments and remarks for this my.cnf file o.s. redhat9 tables 20Mb mem: 8gb server dedicated to mysql max_connections=2000/3000 uses only innodb tables my.cnf [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 max_connections=2000 #max_connections=3000 innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 6G innodb_additional_mem_pool_size = 20M innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 -- I found few documents on mysql tuning. Do you have any suggestions? Experience? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: guru needed - large configuration MySQL-Max InnoDB - 4.0.16
I'd up your buffer sizes - the mysql manual has some clues as to setting these values? You might want to increase the query cache size. I'd then run it and watch the stats. Greg snipped -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: guru needed - large configuration MySQL-Max InnoDB - 4.0.16
Hi, innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_buffer_pool_size = 6G it looks like your InnoDB tablespace is less than 2G. If it is true then IMHO it doesn't make any sense to allocate 6G for innodb_buffer_pool. InnoDB won't use it. Best regards, Mikhail. - Original Message - From: nm [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 30, 2003 10:17 AM Subject: guru needed - large configuration MySQL-Max InnoDB - 4.0.16 Hi there I was wondering I you can send your comments and remarks for this my.cnf file o.s. redhat9 tables 20Mb mem: 8gb server dedicated to mysql max_connections=2000/3000 uses only innodb tables my.cnf [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 max_connections=2000 #max_connections=3000 innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 6G innodb_additional_mem_pool_size = 20M innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 -- I found few documents on mysql tuning. Do you have any suggestions? Experience? Thanks. -- 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]
mysqld-nt vs. mysql-max-nt
Hi All, I can't seem to find any documentation or opinions that would help me decide if it is better to run mysqld-max-nt over the non-max server. Opinions and pointers to supporting docs would be very welcome (especially pointer to docs). Thanks to All in advance. Allen
Re: mysqld-nt vs. mysql-max-nt
Allen Weeks [EMAIL PROTECTED] wrote: I can't seem to find any documentation or opinions that would help me decide if it is better to run mysqld-max-nt over the non-max server. Opinions and pointers to supporting docs would be very welcome (especially pointer to docs). All MySQL servers with description are listed at: http://www.mysql.com/doc/en/Windows_prepare_environment.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql max
Hi do you mean that InnoDB have no table-size limit? Thanks. |-Original Message- |From: Tobias Asplund [mailto:[EMAIL PROTECTED] |Sent: Friday, October 17, 2003 6:04 PM |To: nm |Cc: [EMAIL PROTECTED] |Subject: Re: mysql max | | | |It depends on your filesystem's and OS's max-size of a file in its |filesystem. | |HOWEVER, there are a few ways you can get around this. | |You can use InnoDB tables, or read about RAID types here: |http://www.mysql.com/doc/en/CREATE_TABLE.html (almost at the bottom of the |page). |You can also use MERGE tables: |http://www.mysql.com/doc/en/MERGE.html | |On Fri, 17 Oct 2003, nm wrote: | | Hi | | what's the max table size we can use with mysql-max version? | | Suggestions? | | Thanks. | | | | | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql max
do you mean that InnoDB have no table-size limit? if size is that important to you get an 64-Bit system an should be able to go for Terrabytes without Raid an MERGE. Greetings Stephan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql max
At 8:25 +0200 10/18/03, nm wrote: Hi do you mean that InnoDB have no table-size limit? Thanks. The InnoDB tablespace size limit is 64 TB. All InnoDB tables are stored within the tablespace, so this is also the individual table size limit. http://www.innodb.com/ibman.html#InnoDB_restrictions -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql max
Hi what's the max table size we can use with mysql-max version? Suggestions? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql max
It depends on your filesystem's and OS's max-size of a file in its filesystem. HOWEVER, there are a few ways you can get around this. You can use InnoDB tables, or read about RAID types here: http://www.mysql.com/doc/en/CREATE_TABLE.html (almost at the bottom of the page). You can also use MERGE tables: http://www.mysql.com/doc/en/MERGE.html On Fri, 17 Oct 2003, nm wrote: Hi what's the max table size we can use with mysql-max version? Suggestions? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication and LOAD DATA INFILE MySQL Max 3.23.56-1
Hello, After recently replicating using the stop databases and copy innodb and mysql files method, things were fine... Until the slave thread stopped complaining about duplicate rows after one of our developers did a LOAD DATA INFILE operation on the master. Unfortunately the insert's are into a table using AUTO_INCREMENT as well and this may be compounding the problem. I have read the docs, but it's sort of unclear, does LOAD DATA INFILE work in a replicated 3.23.56-1 setup, only under certain circumstances, or not at all? Your help is greatly appreciated. Thanks. -- Richard F. Rebel [EMAIL PROTECTED] t. 212.239. signature.asc Description: This is a digitally signed message part
Anyone experiencing replication problems with mysql-max-3.23.57-pc-linux-i686
mysql-max-3.23.57-pc-linux-i686 I notice that slaves which never went out of sync are now doing so regularly with the same traffic pattern. Since upgrading to 3.23.57 I've notice a large increase in CPU utilization with the same configuration as the previous version in production 3.23.54. Anyone else experiencing the same issue? -- Dathan
MySQL-Max
I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking that I use MySQL-Max. Does this have to be installed along with the regular MySQL version or is it a single product on it's own? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL-Max
Jon Miller wrote: I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking that I use MySQL-Max. Does this have to be installed along with the regular MySQL version or is it a single product on it's own? From the MySQL/downloads page for 4.0: The Standard binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not required for general usage, such as user-defined functions (UDFs), and BIG_TABLE support. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. http://www.mysql.com/downloads/mysql-4.0.html --V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL-Max
Since we are on the subject Why is mysql-max(16meg) mysql(25meg) (for x86 v4.1)? No docs or something? -Original Message- From: V. M. Brasseur [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 1:00 PM To: Jon Miller Cc: [EMAIL PROTECTED] Subject: Re: MySQL-Max Jon Miller wrote: I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking that I use MySQL-Max. Does this have to be installed along with the regular MySQL version or is it a single product on it's own? From the MySQL/downloads page for 4.0: The Standard binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not required for general usage, such as user-defined functions (UDFs), and BIG_TABLE support. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. http://www.mysql.com/downloads/mysql-4.0.html --V -- 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-Max
I'm running a recently up2dated RH 7.2 machine. I just downloaded all the My SQL 4x. RPMS from the MYSQL site: MySQL-4.0.1-2.i386.rpm MySQL-embedded-4.0.12-0.i386.rpm MySQL-bench-4.0.12-0.i386.rpm MySQL-Max-4.0.12-0.i386.rpm MySQL-client-4.0.12-0.i386.rpm MySQL-shared-4.0.12-0.i386.rpm MySQL-devel-4.0.12-0.i386.rpm Mysql starts up fine and runs except when I install the MySQL-Max rpm. When install the rpm I get the following error message: Preparing...### [100%] 1:MySQL-Max ### [100%] Restarting mysqld. error: execution of %post scriptlet from MySQL-Max-4.0.12-0 failed, exit status 1 Then when I try to start Mysql I get the following error message: [EMAIL PROTECTED] root]# service mysql start [EMAIL PROTECTED] root]# Starting mysqld-max daemon with databases from /var/lib/mysql 030329 15:38:10 mysqld ended I wanted the MySQL-Max so I use SSL connections to the server. Anyone have any ideas what I am doing wrong? :) Dave -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql-max 4.0.12 missing GLIBC 2.2
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 19 Mar 2003, Natalino Picone wrote: can anyone tell me why the mysql-max 4.0.12 is not statically linked against Glibc 2.2 ? (the standard one is ok)... This is done intentionally, to enable the use of User Defined Functions (UDFs) - you need a dynamically linked binary for this to work (it uses the dlopen() system call). Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD4DBQE+eClGSVDhKrJykfIRAoAcAJY7mHU0cX2D7erCG6jzUfBmNWhTAJ9v8tfT pR/MrSUGJkHvCIeTkkbRxw== =SB8J -END PGP SIGNATURE- - 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-max 4.0.12 missing GLIBC 2.2
can anyone tell me why the mysql-max 4.0.12 is not statically linked against Glibc 2.2 ? (the standard one is ok)... Regards Nat -- Natalino Picone - [EMAIL PROTECTED] -- It's a horrible thing to be on top of the world and then to lose it and try to get it back. It's a whole lot harder the second 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
Memory usage of MySQL-Max on Rh 8.0 with InnnoDB
Hello, I am running MySQL-Max on RH8.0 on a Dell 1650, 2 proc with 512MB ram. I am only using InnoDB for databases (40gb) other than the mysql.*. I have the following relevant memory settings: set-variable= sort_buffer=2M set-variable= record_buffer=2M ## For redhat 8.0 set-variable= thread_stack=192k set-variable= myisam_sort_buffer_size=2M ... set-variable = innodb_log_buffer_size=30M set-variable = innodb_buffer_pool_size=396M set-variable = innodb_additional_mem_pool_size=2M I don't have anything other than the basic daemons running on this machine. Top reports: 71 processes: 69 sleeping, 2 running, 0 zombie, 0 stopped CPU0 states: 6.0% user, 1.0% system, 0.0% nice, 91.0% idle CPU1 states: 55.1% user, 11.1% system, 0.0% nice, 32.0% idle Mem: 513296K av, 506796K used,6500K free, 0K shrd,7468K buff Swap: 1048568K av, 241628K used, 806940K free 159928K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 2772 mysql.pr 15 0 480M 302M 53104 S63.8 60.3 1:15 mysqld-max Vmstat reports: [EMAIL PROTECTED] prod]# vmstat 1 procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 1 0 0 376168 6580 3176 105724 2 31025 25910 0 0 99 0 1 0 376168 7160 3212 104216 1064 0 1064 5823 846 631 30 3 67 1 0 0 376168 6592 3192 101156 1688 0 1700 5820 988 929 30 4 67 1 0 0 376168 6516 2680 102644 848 16 2924 6312 769 627 29 8 63 This doesn't seem right. Why so much swap usage? Why am I swapping? The other processes on the box don't even come close to accounting for the swap usage, let alone the swapping. Any help here is greatly appreciated. Thanks Richard - 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-Max dies when remote connection opened
Version: 4.0.8, installed from the RPMs downloaded from the mysql.com webpages. The server runs RedHat 8.0, all updates installed. The hardware is a Dell 2650. Problem: Any connection, using the command line client for example, from any other node fails even though the access should be allowed. The error message is: ERROR 2013: Lost connection to MySQL server during query On the server side this is logged on the console: # /usr/bin/mysqld_safe: line 312: 30764 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 The error log contains: mysqld-max process hanging, pid 30774 - killed A simple fix is to uninstall the Max rpm: rpm -e MySQL-Max-4.0.8-0 After restarting the problem goes away and the remote access is allowed. Something about the Max package seems to be incompatible with RedHat 8.0 ? -psi - 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
Is innodb still beta in MySQL-Max-3.23.54a?
Is Innodb still beta in MySQL-Max-3.23.54a? If not, I am thinking of making the move. :) Thanks! - Mark - 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 MAX client
Dear All, Where can i find mysql client and devel .rpm files compatible for MySQL-Max-3.23.53a-1.i386.rpm Thanks in advance. Regards, Muruganandam g - 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 MAX client
On Tuesday 17 December 2002 22:04, Muruganandam wrote: Dear All, Where can i find mysql client and devel .rpm files compatible for MySQL-Max-3.23.53a-1.i386.rpm You can use any recent 3.23.x version of client. -devel.rpm should be the same as -shared.rpm if it's used. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
mysql-max-3.23.54a binary DOES NOT WORK! GLIBC MISSING!
I tried to use mysql-max-3.23.54a but it isn't statically linked against GBLIB 2.2 Please also note the file size: mysql-3.23.54a-pc-linux-i686.tar.gz is 9831919 mysql-max-3.23.54a-pc-linux-i686.tar.gz is 6097043 At the startup it prints out: /lib/libc.so.6: version `GLIBC_2.2' not found Bye Nat -- Natalino Picone - [EMAIL PROTECTED] -- It's a horrible thing to be on top of the world and then to lose it and try to get it back. It's a whole lot harder the second 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
mysql-max-3.23.54-pc-linux-i686 doesn't work!
I downloaded the new binary version (3.23.54) mysql-max from the website but the safe_mysqld seems buggy .. Moreover when I try to start it up i got these errors: /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld: /lib/libpthread.so.0: version `GLIBC_2.2' not found (required by /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld) /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld: /lib/libc.so.6: version `GLIBC_2.2' not found (required by /usr/local/mysql-max-3.23.54-pc-linux-i686/bin/mysqld) Running on debian 2.2 Nat -- Natalino Picone - [EMAIL PROTECTED] -- It's a horrible thing to be on top of the world and then to lose it and try to get it back. It's a whole lot harder the second 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
MySQL max memory usage on linux/intel
Apologies if this is off topic ... please let me know what a more appropriate forum is if so. Quick question: since there is normally a per-process limit of 4GB on 32-bit linux/intel platforms is there any point to installing more than 4gb in an sql server that is only running running 1 instance of the DB daemon? The total size of the DB is 30 GB and several tables are 4GB. -- -Chris Beck - Coradiant, Inc - Research Development - +1.514.908.6314- -- http://www.coradiant.com - Leaders in Web Performance Optimization -- --- This email represents my opinion, not that of Coradiant. --- We do not inherit the Earth from our Ancestors, we borrow it from our Children. -- Indian Proverb - 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 max memory usage on linux/intel
You can expect that your operating system will use the remaining memory as a file cache that will speed up your databases accesses. We don't have that much memory our dedicated database server, it has only 2 Gb. mysqld itself is using around 600Mb the rest is used by the OS mainly for file caching. Since the total size of all databases is around 1.5 Gb they almost fit in memory and the server is happily serving around 300 queries/s with 200 concurrent connections and almost no disk I/O (no reads, just a few write every 5 seconds). Hope this helps -- Joseph Bueno [EMAIL PROTECTED] wrote: Apologies if this is off topic ... please let me know what a more appropriate forum is if so. Quick question: since there is normally a per-process limit of 4GB on 32-bit linux/intel platforms is there any point to installing more than 4gb in an sql server that is only running running 1 instance of the DB daemon? The total size of the DB is 30 GB and several tables are 4GB. -- -Chris Beck - Coradiant, Inc - Research Development - +1.514.908.6314- -- http://www.coradiant.com - Leaders in Web Performance Optimization -- --- This email represents my opinion, not that of Coradiant. --- We do not inherit the Earth from our Ancestors, we borrow it from our Children. -- Indian Proverb - 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 max memory usage on linux/intel
How do I set the cache limit? Any suggestions on optimizing mySQL? At 07:05 PM 11/21/2002 +0100, Joseph Bueno wrote: You can expect that your operating system will use the remaining memory as a file cache that will speed up your databases accesses. We don't have that much memory our dedicated database server, it has only 2 Gb. mysqld itself is using around 600Mb the rest is used by the OS mainly for file caching. Since the total size of all databases is around 1.5 Gb they almost fit in memory and the server is happily serving around 300 queries/s with 200 concurrent connections and almost no disk I/O (no reads, just a few write every 5 seconds). Hope this helps -- Joseph Bueno [EMAIL PROTECTED] wrote: Apologies if this is off topic ... please let me know what a more appropriate forum is if so. Quick question: since there is normally a per-process limit of 4GB on 32-bit linux/intel platforms is there any point to installing more than 4gb in an sql server that is only running running 1 instance of the DB daemon? The total size of the DB is 30 GB and several tables are 4GB. -- -Chris Beck - Coradiant, Inc - Research Development - +1.514.908.6314- -- http://www.coradiant.com - Leaders in Web Performance Optimization -- --- This email represents my opinion, not that of Coradiant. --- We do not inherit the Earth from our Ancestors, we borrow it from our Children. -- Indian Proverb - 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
Problems installing mysql-max-3.23.53a linux binaries
Hi all. I've downloaded mysql-max-3.23.53a-pc-linux-gnu-i686.tar from www.mysql.com and tried to install it on a linux box. I followed the steps provided at http://www.mysql.com/doc/en/Installing_binary.html shell groupadd mysql (Not really, I have a mysql group) shell useradd -g mysql mysql (Not really, I have a mysql user) shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/safe_mysqld --user=mysql When I execute bin/safe_mysqld --user=mysql prototipo mysql # bin/safe_mysqld --user=mysql [1] 948 prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data 021120 12:49:15 mysqld ended If I look at mysql log: 021120 11:51:26 mysqld started 021120 11:51:26 Can't start server : Bind on unix socket: Permission denied 021120 11:51:26 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 021120 11:51:26 Aborting 021120 11:51:26 /usr/local/mysql/bin/mysqld: Shutdown Complete Also after copying a my.cnf configuration file from support-files to /etc/my.cnf and mysql.server to /etc/init.d/ if I execute /etc/init.d/mysql.server start I also get an error for variable @HOSTNAME and print-defaults: prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data 021120 12:52:05 mysqld ended Iago Sineiro. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problems installing mysql-max-3.23.53a linux binaries
Hi all. I resolved the problem of starting mysql server changing permissions of /tmp directory to permit user mysql write /tmp/mysql.sock. But when I start mysql server with /etc/init.d/mysql server start I get error @HOSTNAME@. prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data Iago Sineiro. -Mensaje original- De: Iago Sineiro [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 20 de noviembre de 2002 10:37 Para: MySql Mail List Asunto: Problems installing mysql-max-3.23.53a linux binaries Hi all. I've downloaded mysql-max-3.23.53a-pc-linux-gnu-i686.tar from www.mysql.com and tried to install it on a linux box. I followed the steps provided at http://www.mysql.com/doc/en/Installing_binary.html shell groupadd mysql (Not really, I have a mysql group) shell useradd -g mysql mysql (Not really, I have a mysql user) shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/safe_mysqld --user=mysql When I execute bin/safe_mysqld --user=mysql prototipo mysql # bin/safe_mysqld --user=mysql [1] 948 prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data 021120 12:49:15 mysqld ended If I look at mysql log: 021120 11:51:26 mysqld started 021120 11:51:26 Can't start server : Bind on unix socket: Permission denied 021120 11:51:26 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 021120 11:51:26 Aborting 021120 11:51:26 /usr/local/mysql/bin/mysqld: Shutdown Complete Also after copying a my.cnf configuration file from support-files to /etc/my.cnf and mysql.server to /etc/init.d/ if I execute /etc/init.d/mysql.server start I also get an error for variable @HOSTNAME and print-defaults: prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data 021120 12:52:05 mysqld ended Iago Sineiro. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems installing mysql-max-3.23.53a linux binaries
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 20 November 2002 11:41, Iago Sineiro wrote: I resolved the problem of starting mysql server changing permissions of /tmp directory to permit user mysql write /tmp/mysql.sock. But when I start mysql server with /etc/init.d/mysql server start I get error @HOSTNAME@. prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data Hmm, that's interesting. Seems like the build script did not replace this variable with the correct path to the hostname binary. For the time being, please replace @HOSTNAME@ with /bin/hostname. [SNIP] then - - pid_file=$datadir/`@HOSTNAME@`.pid + pid_file=$datadir/`/bin/hostname`.pid else [SNIP] Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE923GZSVDhKrJykfIRAh+SAJ9RbPIJUZucM55fa6L9TdRBI2wAqwCdEofI hW/WYU3k48feRG3MyO7VbjU= =GCQu -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problems installing mysql-max-3.23.53a linux binaries
Thanks Lenz. Now, after modifying the init script, I don't get the advise. Iago Sineiro. -Mensaje original- De: Lenz Grimmer [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 20 de noviembre de 2002 12:27 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: Problems installing mysql-max-3.23.53a linux binaries -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 20 November 2002 11:41, Iago Sineiro wrote: I resolved the problem of starting mysql server changing permissions of /tmp directory to permit user mysql write /tmp/mysql.sock. But when I start mysql server with /etc/init.d/mysql server start I get error @HOSTNAME@. prototipo mysql # /etc/init.d/mysql.server start /etc/init.d/mysql.server: @HOSTNAME@: command not found prototipo mysql # Starting mysqld daemon with databases from /usr/local/mysql/data Hmm, that's interesting. Seems like the build script did not replace this variable with the correct path to the hostname binary. For the time being, please replace @HOSTNAME@ with /bin/hostname. [SNIP] then - - pid_file=$datadir/`@HOSTNAME@`.pid + pid_file=$datadir/`/bin/hostname`.pid else [SNIP] Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE923GZSVDhKrJykfIRAh+SAJ9RbPIJUZucM55fa6L9TdRBI2wAqwCdEofI hW/WYU3k48feRG3MyO7VbjU= =GCQu -END PGP SIGNATURE- - 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
weird characters inserted into mysql max 4
Hi, Can someone help on this question? I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I checked the information I stored via insert statements, I noticed weird characters placed in the positions of letter that have accents. I am storing information in portuguese and the content stored is not exactly what I am putting in my sql statement. Any Ideas? Thanks Siomara _ MSN 8 with e-mail virus protection service: 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
MySQL-max-3.23.52-win
I installed MySQL-max-3.23.52-win in the Win98 with the following configuration #This File was made using the WinMySQLAdmin 1.4 Tool #16/10/2002 14:37:55 #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [WinMySQLadmin] Server=C:/MYSQL/bin/mysqld-max.exe user=root [mysqld] basedir=C:/MYSQL datadir=C:/MYSQL/data innodb_data_home_dir=C:/MYSQL/data innodb_data_file_path=data_d1:50M:autoextend innodb_log_group_home_dir=c:/mysql/data innodb_log_arch_dir=c:/mysql/data set-variable=key_buffer=32M set-variable=innodb_buffer_pool_size=32M but the startup is very slower. Is it normal? What's the problem? Should I use another stableer version? I want to use Innodb with autoextend. - 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-max-3.23.52-win
Dobrý den, quarta-feira, 16 de outubro de 2002, 17:33:00, napsal jste: S I installed MySQL-max-3.23.52-win in the Win98 with the following S configuration S #This File was made using the WinMySQLAdmin 1.4 Tool S #16/10/2002 14:37:55 S #Uncomment or Add only the keys that you know how works. S #Read the MySQL Manual for instructions S [WinMySQLadmin] S Server=C:/MYSQL/bin/mysqld-max.exe S user=root S [mysqld] S basedir=C:/MYSQL S datadir=C:/MYSQL/data S innodb_data_home_dir=C:/MYSQL/data S innodb_data_file_path=data_d1:50M:autoextend S innodb_log_group_home_dir=c:/mysql/data S innodb_log_arch_dir=c:/mysql/data S set-variable=key_buffer=32M S set-variable=innodb_buffer_pool_size=32M S but the startup is very slower. S Is it normal? S What's the problem? S Should I use another stableer version? S I want to use Innodb with autoextend. Yes, in = .52 is normal... use the 3.23.53 version. http://www.mysql.com - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes look: cannot open my eyes - Reply: [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: How to start Mysql-max to create tables
Perumal, Saturday, October 12, 2002, 11:27:44 AM, you wrote: P Please anybody could tell me how to start mysql-max to work with DB. P What i did : start mysqld like P ./configure --prefix P =/usr/local/mysqlit starts like P Starting mysqld daemon with databases from P /usr/local/mysql-max-3.23.51-pc-linux-gnu-i686/data P 021012 12:37:18 mysqld ended P But i don't know that what command i should enter to start work with DB. safe_mysqld Look in the error logs to see why MySQL server didn't start. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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 to start Mysql-max to create tables
Dear sir, Please anybody could tell me how to start mysql-max to work with DB. What i did : start mysqld like ./configure --prefix =/usr/local/mysqlit starts like Starting mysqld daemon with databases from /usr/local/mysql-max-3.23.51-pc-linux-gnu-i686/data 021012 12:37:18 mysqld ended But i don't know that what command i should enter to start work with DB. Perumal. - 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-max-3.23.51-pc-linux-gnu-i686 Installation
Hi, Since I need to install mysql-max , please give me an idea on my.cnf in linux environment and tell me also other configurations in the files to install mysql-max. Thanx, Perumal. - 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-max-3.23.51-pc-linux-gnu-i686 Installation
Perumal, Thursday, October 10, 2002, 3:01:21 PM, you wrote: P Since I need to install mysql-max , please give me an idea on P my.cnf in linux environment and tell me also other configurations in the P files to install mysql-max. If you want to use InnoDB, please read the following chapter of the manual: http://www.mysql.com/doc/en/InnoDB_start.html Read info about my.cnf here: http://www.mysql.com/doc/en/Option_files.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
MySQL-Max-3.23.52-1.i386.rpm is missing many files.
Description: I'm trying to install MySQL MAX 3.23.52 (MySQL, with transactions enabled). My rpm attempts goes like this... 1. Check for installed MySQL... [root@Zeke mysql]# rpm -q -a | fgrep -i mysql [root@Zeke mysql]# 2. Nothing, so I attempt an install... [root@Zeke mysql]# rpm -i MySQL-Max-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.34280: /etc/rc.d/init.d/mysql: No such file or directory QUESTIONS 1. Why is the mysql start/stop script missing? 2. In addition, OTHER FILES are missing, as compared to the tar/gzip binary: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz Thanks in advance. /AL How-To-Repeat: 1. Download the Intel Linux RPM file: MySQL-Max-3.23.52-1.i386.rpm 2. su as root 3. rpm -i MySQL-Max-3.23.52-1.i386.rpm 4. See the error /etc/rc.d/init.d/mysql: No such file or directory Fix: BETTER FIX: 1. Re-build the rpm file for MySQL-Max-3.23.52 2. While you guys are at it, provide the rpm for the other modules (ask RedHat for help on this, if necessary). If you want me to do some of the work, I'll volunteer the time. ... Just give me some RH linux box to login to. ... I have only 1 box at home, which I use to support my consulting clients, so I can't fool around with the box too much. WORKAROUND: 1. Install the RPM file, in spite of its problems: MySQL-Max-3.23.52-1.i386.rpm 2. Install tar/gzip file: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz ...This way, other rpm files that depend on MySQL-Max-3.23.52-1 won't have problems (assuming that they are properly installed). Submitter-Id: [EMAIL PROTECTED] Originator:alg Organization: Al G, WowSignal.Com MySQL support: none Synopsis: MySQL-Max-3.23.52-1.i386.rpm is missing many files. Severity: serious Priority: medium Category: mysql Class: change-request Release: mysql-3.23.52-max (Official MySQL-max binary) Environment: uname -a output: Linux Zeke 2.2.16-22 #1 Tue Aug 22 16:16:55 EDT 2000 i586 unknown rpm -q -a output: sed-3.02-8 which-2.11-4 awesfx-0.4.3a-7 zlib-1.1.3-12 control-center-devel-1.2.1-5 dialog-0.9a-3 esound-0.2.19-3 gcc-objc-2.96-54 glade-0.5.9-3 gnome-media-1.2.0-7 gpm-1.19.3-4 ImageMagick-5.2.2-5 kdebase-1.1.2-48 kgcc-1.1.2-40 libpng-1.0.8-1 losetup-2.10m-5 metamail-2.7-25 multimedia-2.1-20 njamd-0.7.0-3 pciutils-devel-2.1.8-8 procmail-3.14-5 quota-2.00pre3-7 rp3-1.1.4-4 SDL-1.1.4-1 strace-4.2-9 tetex-dvilj-1.0.7-7 trn-3.6-25 xboard-4.0.7-3 xloadimage-4.1-16 bash-doc-2.04-11 imap-devel-4.7c2-12 mod_php-4.0.1pl2-9 php-ldap-4.0.1pl2-9 python-tools-1.5.2-27 w3c-libwww-devel-5.2.8-6 bind-devel-8.2.3-1 termcap-11.0.1-3 fileutils-4.0x-3 apmd-3.0final-18 psmisc-19-4 aspell-0.32.5-1 autorun-2.61-5 bzip2-devel-1.0.1-3 XFree86-xfs-4.0.1-1 SysVinit-2.78-10 control-panel-3.18-2 db1-devel-1.85-4 diffstat-1.27-5 ee-0.3.12-1 esound-devel-0.2.19-3 flex-2.5.4a-11 gd-1.8.3-4 gedit-0.9.0-3 glib-devel-1.2.8-4 gnome-core-1.2.1-33 gnome-objc-1.0.2-9 gnome-utils-1.2.0-7 gpm-devel-1.19.3-4 readline-4.1-5 imlib-1.9.8.1-2 iptables-1.1.1-2 kdegames-1.1.2-6 kdeutils-1.1.2-6 less-358-7 libjpeg-devel-6b-13 libtiff-devel-3.5.5-7 lilo-21.4.4-10 lsof-4.47-5 man-pages-1.30-4 mkbootdisk-1.2.8-2 mount-2.10m-5 ncompress-4.2.4-20 netscape-common-4.75-2 openjade-1.3-6 ORBit-0.5.3-2 pilot-link-devel-0.9.3-10 postgresql-7.0.2-17 pump-0.8.3-2 pythonlib-1.27-1 rdate-1.0-6 rhn_register-gnome-1.0-7 rpm-devel-4.0-4 samba-common-2.0.7-21ssl sendmail-8.11.0-8 slocate-2.2-5 stunnel-3.8-4 tcl-8.3.1-46 tetex-dvips-1.0.7-7 tin-1.4.4-2 trojka-1.1-17 vim-common-5.7-6 xcdroast-0.98-1 XFree86-tools-4.0.1-1 xmailbox-2.5-12 xscreensaver-3.25-4 cxhextris-1.0-22 giftrans-1.12.2-7 itcl-3.1.0-46 libpcap-0.4-29 octave-2.0.16-1 php-imap-4.0.1pl2-9 postgresql-python-7.0.2-17 python-docs-1.5.2-27 sysreport-1.0-4.3 w3c-libwww-5.2.8-6 xsysinfo-1.7-3 filesystem-2.0.7-1 grep-2.4.2-4 modutils-2.3.14-3 bdflush-1.5-14 cracklib-2.7-8 cpio-2.4.2-20 diffutils-2.7-21 exmh-2.2-8 gd-devel-1.8.3-4 kernel-headers-2.4.0-0.26 gnome-objc
in mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz dist: init/mysqld.server has incompatibility problems with RH Linux
Description: File: support-files/mysqld.server This file has problems when run under RH Linux 7.0, and I suppose in other Linux versions. How-To-Repeat: 1. Download: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz 2. Install as per instructions in INSTALL-BINARY . 3. Problems apparent when invoking: mysqld.server start Fix: I made the following fixes in my own copy of mysqld.server, which I checked into RCS. I successfully tested under RH7.0. (Note: the success only relates to start/stop of mysqld). RCS file: RCS/mysql.server,v retrieving revision 1.1 retrieving revision 1.2 diff -r1.1 -r1.2 36,37c36,38 datadir=/usr/local/mysql/data basedir= --- basedir=/usr/local/mysql datadir=$basedir/data bindir=$basedir/bin 39,45d39 if test -z $basedir then basedir=/usr/local/mysql bindir=./bin else bindir=$basedir/bin fi 48c42 pid_file=$datadir/`@HOSTNAME@`.pid --- pid_file=$datadir/`hostname`.pid Submitter-Id: [EMAIL PROTECTED] Originator:[EMAIL PROTECTED] Organization: [EMAIL PROTECTED] MySQL support: none Synopsis: in mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz dist: init/mysqld.server has incompatibility problems with RH Linux Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.52-max (Official MySQL-max binary) Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 3.23.52, 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 3.23.52-max Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 12 min 38 sec Threads: 1 Questions: 9 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.012 Environment: uname -a output: Linux Zeke 2.2.16-22 #1 Tue Aug 22 16:16:55 EDT 2000 i586 unknown rpm -q -a output: sed-3.02-8 which-2.11-4 awesfx-0.4.3a-7 zlib-1.1.3-12 control-center-devel-1.2.1-5 dialog-0.9a-3 esound-0.2.19-3 gcc-objc-2.96-54 glade-0.5.9-3 gnome-media-1.2.0-7 gpm-1.19.3-4 ImageMagick-5.2.2-5 kdebase-1.1.2-48 kgcc-1.1.2-40 libpng-1.0.8-1 losetup-2.10m-5 metamail-2.7-25 multimedia-2.1-20 njamd-0.7.0-3 pciutils-devel-2.1.8-8 procmail-3.14-5 quota-2.00pre3-7 rp3-1.1.4-4 SDL-1.1.4-1 strace-4.2-9 tetex-dvilj-1.0.7-7 trn-3.6-25 xboard-4.0.7-3 xloadimage-4.1-16 bash-doc-2.04-11 imap-devel-4.7c2-12 mod_php-4.0.1pl2-9 php-ldap-4.0.1pl2-9 python-tools-1.5.2-27 w3c-libwww-devel-5.2.8-6 bind-devel-8.2.3-1 termcap-11.0.1-3 fileutils-4.0x-3 apmd-3.0final-18 psmisc-19-4 aspell-0.32.5-1 autorun-2.61-5 bzip2-devel-1.0.1-3 XFree86-xfs-4.0.1-1 SysVinit-2.78-10 control-panel-3.18-2 db1-devel-1.85-4 diffstat-1.27-5 ee-0.3.12-1 esound-devel-0.2.19-3 flex-2.5.4a-11 gd-1.8.3-4 gedit-0.9.0-3 glib-devel-1.2.8-4 gnome-core-1.2.1-33 gnome-objc-1.0.2-9 gnome-utils-1.2.0-7 gpm-devel-1.19.3-4 readline-4.1-5 imlib-1.9.8.1-2 iptables-1.1.1-2 kdegames-1.1.2-6 kdeutils-1.1.2-6 less-358-7 libjpeg-devel-6b-13 libtiff-devel-3.5.5-7 lilo-21.4.4-10 lsof-4.47-5 man-pages-1.30-4 mkbootdisk-1.2.8-2 mount-2.10m-5 ncompress-4.2.4-20 netscape-common-4.75-2 openjade-1.3-6 ORBit-0.5.3-2 pilot-link-devel-0.9.3-10 postgresql-7.0.2-17 pump-0.8.3-2 pythonlib-1.27-1 rdate-1.0-6 rhn_register-gnome-1.0-7 rpm-devel-4.0-4 samba-common-2.0.7-21ssl sendmail-8.11.0-8 slocate-2.2-5 stunnel-3.8-4 tcl-8.3.1-46 tetex-dvips-1.0.7-7 tin-1.4.4-2 trojka-1.1-17 vim-common-5.7-6 xcdroast-0.98-1 XFree86-tools-4.0.1-1 xmailbox-2.5-12 xscreensaver-3.25-4 cxhextris-1.0-22 giftrans-1.12.2-7 itcl-3.1.0-46 libpcap-0.4-29 octave-2.0.16-1 php-imap-4.0.1pl2-9 postgresql-python-7.0.2-17 python-docs-1.5.2-27 sysreport-1.0-4.3 w3c-libwww-5.2.8-6 xsysinfo-1.7-3 filesystem-2.0.7-1 grep-2.4.2-4 modutils-2.3.14-3 bdflush-1.5-14 cracklib-2.7-8 cpio-2.4.2-20 diffutils-2.7-21 exmh-2.2-8 gd
Re: MySQL-Max-3.23.52-1.i386.rpm is missing many files.
At 20:17 -0400 9/21/02, alg wrote: Description: I'm trying to install MySQL MAX 3.23.52 (MySQL, with transactions enabled). My rpm attempts goes like this... 1. Check for installed MySQL... [root@Zeke mysql]# rpm -q -a | fgrep -i mysql [root@Zeke mysql]# 2. Nothing, so I attempt an install... [root@Zeke mysql]# rpm -i MySQL-Max-3.23.52-1.i386.rpm You're supposed to install the non-max rpm first, then install the max rpm. That's why you're seeing so many files missing. - 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 max
I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - 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 max
Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them, but those sites work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 max
So is there really any benefit to using MySql Max? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Thursday, September 05, 2002 3:53 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: mysql max Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them, but those sites work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 max
Hello, Yes, there might be very strong reasons to use the Max version. Most people are using Max because it has InnoDB support. I'm not sure about your specific needs, but see this URL for more guidance on which version to choose: http://www.mysql.com/doc/en/mysqld-max.html Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: So is there really any benefit to using MySql Max? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Thursday, September 05, 2002 3:53 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: mysql max Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them, but those sites work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 max
Mysql-Max binaries are the binaries complied with InnodB support and InnoDB tables support transactions. So if you do something that has to be transaction-based, then you'd use mysql-max. Gurhan On Thu, 2002-09-05 at 16:17, Edward Peloke wrote: So is there really any benefit to using MySql Max? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Thursday, September 05, 2002 3:53 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: mysql max Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them, but those sites work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql max
If you're using MySQL 4.0.x, mysql max is included. -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 2:43 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: RE: mysql max Mysql-Max binaries are the binaries complied with InnodB support and InnoDB tables support transactions. So if you do something that has to be transaction-based, then you'd use mysql-max. Gurhan On Thu, 2002-09-05 at 16:17, Edward Peloke wrote: So is there really any benefit to using MySql Max? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Thursday, September 05, 2002 3:53 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: mysql max Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them, but those sites work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
Difference between MySQL 4 and MySQL Max 4
Hi, Could anyone tell me what are the differences between MySQL 4 and MySQL Max 4, now that MySQL 4 has InnoDB built in as standard? I couldn't find the answer in the manual or the download section. I'd like to download MySQL and definitely want InnoDB, but I don't know whether i should go with MySQL 4 or MySQL Max 4. hence my question. Thanks a lot. Andy - 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: Difference between MySQL 4 and MySQL Max 4
On Sun, Aug 25, 2002 at 01:11:16PM -0400, Andy Leung wrote: Hi, Could anyone tell me what are the differences between MySQL 4 and MySQL Max 4, now that MySQL 4 has InnoDB built in as standard? I couldn't find the answer in the manual or the download section. I'd like to download MySQL and definitely want InnoDB, but I don't know whether i should go with MySQL 4 or MySQL Max 4. hence my question. 4.0-max contains BDB tables, MyISAM RAID support, and a few other odditites. You probably don't need it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 19 days, processed 391,026,547 queries (232/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
mySQL max connections
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I have a mySQL database thats taking a bit of a hammering - enough so that the number of connections spirals up and out of control. max_connections was originally at the default of 100 - but rising above 50 or so meant actual throughput dropped so the db never got a chance to keep up (meaning manually restarting the db). I've lowered max_connections to 40 which at least keeps the db alive. But, the number of connections keeps rising to and bouncing off this limit - and for the users that hit it a 'Too many connections' error is given. Now, I've optimised all the tables and queries as much as is humanely possible - - and the only way out I can see so far is to have some kind of connection queue to keep people waiting for the 1/2 second or so until the load spike drops off (I'd rather have a few slow pages than errors any day). Is there any way of doing this - I've looked at back_log (the listen() backlog), but that doesnt really apply. Short of writing a 'hide-warning-wait-a-bit-and-try-again' chunk in PHP (sucky!) I'm stuck! Using persistent connections doesn't stunningly help either - it only gives a small performance increase. If it makes any odds, the SQL only talks to 3 tables, all are properly indexed and there's enough RAM to keep it all from swapping. Any help appreciated, thanks. - -- Shane http://www.shanewright.co.uk/ Public key: http://www.shanewright.co.uk/files/public_key.asc -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9Rosv5DXg6dCMBrQRAkMXAKCvGx8mYNEJoUPobtI093amT6RHAACcD3za xMUz0AP1fcMxJoZZdO0BixY= =zBoX -END PGP SIGNATURE- - 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
HP-UX 11, mysql-max
I tried the HP-UX mysql depot from the HP Software Porting Center, but it doesn't have innodb support. The mysql-max capability page says that innodb is supported on HP-UX, though... so presumably somebody, somewhere, has done this already. When I'm trying to compile with gcc 2.95.3 or with gcc 3.0.1, I get a missing library (-ldl) when building mysqld, despite configuring with --disable-shared and --enable-static. So... I'm game for just about any advice at this point. A depot with mysqld-max would be ideal, advice on what's going wrong on the link would be a close second. Thanks in advance, 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
Re: HP-UX 11, mysql-max
Jason, - Original Message - From: Jason Baker [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, July 18, 2002 11:48 PM Subject: HP-UX 11, mysql-max I tried the HP-UX mysql depot from the HP Software Porting Center, but it doesn't have innodb support. The mysql-max capability page says that innodb is supported on HP-UX, though... so presumably somebody, somewhere, has done this already. When I'm trying to compile with gcc 2.95.3 or with gcc 3.0.1, I get a missing library (-ldl) when building mysqld, despite configuring with --disable-shared and --enable-static. So... I'm game for just about any advice at this point. A depot with mysqld-max would be ideal, advice on what's going wrong on the link would be a close second. please try HP-UX downloads Binary packages (tar.gz) MySQL 4.0.1-alpha HP-UX 10.20 (6.5M) Download at http://www.mysql.com/downloads/mysql-4.0.html Some people also compile Max-3.23 on their own HP-UX computer. Thanks in advance, Jason 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
Error in Windows download of MySQL-Max-4.0.2; download MySQL-4.0.2 instead
Hi! There is an error in the Windows download of MySQL-Max-4.0.2. It is a wrong file, the same as MySQL-Max-4.0.1. If you do not need BDB tables, please download the Windows version of MySQL-4.0.2 (without the 'Max') instead. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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
rpm of plain MySQL-4.0.2 does not contain InnoDB; download rpm of MySQL-Max-4.0.2 instead
Hi! Due to an error in the build process, the rpm of plain MySQL-4.0.2 does not contain InnoDB. Please download the rpm of MySQL-Max-4.0.2 instead. The error in the build of the plain MySQL-4.0.2 rpm will be fixed in the coming days. Best regards, Heikki Tuuri Innobase Oy - 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: high level: enabling transactions in mysql-max with WebLogic TX datasource?
Hi again, I really think you should walk yourself through the InnoDB user manual at http://www.innodb.com/ibman.html There's a lot of usefull and explanory information in there. For your question: ib_arch and ib_logfileX are the logs that InnoDB uses to track committed transactions and perform recovery in case of an DataBase crash. Having all these files in the same directory is kinde messy, maybe you wanne use a config file like the one at the bottom of my reply. The kind of logging you need is the one indicated by the log parameter in the config file. The binary logging that we use is only usefull if you want to be able to do recovery for certain time spans. Also you can start your server manually at the command prompt with c:\yourmysqldir\bin\mysqld-max-nt --console This way you will be able to see any (error) messages directly in the console ... Have fun, I know I did ;) CB. = # The MySQL server [mysqld] # Activate binary logging for MySQL log-bin=C:/mysql/binlogs/localhost-bin # Only binary log queries for table TW binlog-do-db=tw # Prevent those stupid lower case table names when importing/exporting dumps set-variable = lower_case_table_names=0 # InnoDB logging file # log=log.txt # Default table type for new tables default-table-type=InnoDB # BDB home - mysqld-max will not start without this parameter # and the directory must exist bdb-home=../bdbhome # Data home dir of your InnoDB tables innodb_data_home_dir = c:\mysql\ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:500M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=15M # Logging innodb_log_group_home_dir = c:\mysql\iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:\mysql\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=25M set-variable = innodb_log_buffer_size=10M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 == -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 23:14 To: [EMAIL PROTECTED] Subject: Re: high level: enabling transactions in mysql-max with WebLogic TX datasource? Bert == Bert VdB [EMAIL PROTECTED] writes: Bert Hi, Bert all you have to do use a transaction enabled data-source and use the Bert Mm-MysqlDriver Bert for your JDBC connections. (http://mmmysql.sourceforge.net/) Bert Best is to read the InnoDB documentation carefully (http://www.innodb.com), Bert as you cannot choose from a wide Bert variety of transaction-levels ... in my experience, most of the detailed Bert transaction-handling Bert can only be done at mysql-query level. Bert To test wether your datasource supports the transactions, do a test and look Bert at the InnoDB-logfiles, it should Bert indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Ok, I determined that innodb wasn't being initialized because I didn't have innodb_data_file_path set in my.ini. I added the following line to my.ini in mysqladmin: innodb_data_file_path = ibdata1:30M:autoextend After I restarted the service and created some tables (not adding any rows yet), I noticed the following files in the data subdirectory: --- total 41004 drwxr-xr-x2 dmkarr None 8192 Jul 1 15:01 mysql/ -rw-r--r--1 dmkarr None 2461 Jul 1 14:59 mysql.err -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile0 -rw-r--r--1 dmkarr None 31457280 Jul 1 14:59 ibdata1 drwxr-xr-x4 dmkarr None 4096 Jul 1 14:59 ./ -rw-r--r--1 dmkarr None25088 Jul 1 14:59 ib_arch_log_00 -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile1 drwxr-xr-x 11 dmkarr None 4096 Jun 29 11:30 ../ drwxr-xr-x2 dmkarr None0 Jun 29 11:07 test/ --- However, I don't know how to check the log files for those strings, as they appear to be binary. A simple grep didn't find anything. Is there a special viewer for mysql log files
Mysql vs MySQL max
Hi Probably a stupid question, but which is best to have on ones server, the old mysql, or max. I.O.W, if you install MAX and never use innodb or berkeley tables, will it be equivalent to a normal mysql installation wrt performance and stability? I'm asking from an ISP's point of view, if that makes any difference ( obviously if from developer it will depend on the needs of the app..) Thanks sql, mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: high level: enabling transactions in mysql-max with WebLogic TX datasource?
Hi, all you have to do use a transaction enabled data-source and use the Mm-MysqlDriver for your JDBC connections. (http://mmmysql.sourceforge.net/) Best is to read the InnoDB documentation carefully (http://www.innodb.com), as you cannot choose from a wide variety of transaction-levels ... in my experience, most of the detailed transaction-handling can only be done at mysql-query level. To test wether your datasource supports the transactions, do a test and look at the InnoDB-logfiles, it should indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Greetz, CB. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 22:33 To: [EMAIL PROTECTED] Subject: high level: enabling transactions in mysql-max with WebLogic TX datasource? One thing that I find a little confusing is the notion of transactional behavior in mySQL. I read that it's possible to enable transactions in mySQL-max, however, it's never really been clear to me exactly what I'm supposed to do, or whether I have to do anything. If I'm using a transactional datasource in WebLogic, on top of mySQL, I need to make sure mySQL supports that transactional behavior. Is there a section of the mySQL documentation, or some other documentation, which explains these issues clearly? -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [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 - 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: high level: enabling transactions in mysql-max with WebLogic TX datasource?
Bert == Bert VdB [EMAIL PROTECTED] writes: Bert Hi, Bert all you have to do use a transaction enabled data-source and use the Bert Mm-MysqlDriver Bert for your JDBC connections. (http://mmmysql.sourceforge.net/) Bert Best is to read the InnoDB documentation carefully (http://www.innodb.com), Bert as you cannot choose from a wide Bert variety of transaction-levels ... in my experience, most of the detailed Bert transaction-handling Bert can only be done at mysql-query level. Bert To test wether your datasource supports the transactions, do a test and look Bert at the InnoDB-logfiles, it should Bert indicate some thing like SET AUTOCOMMIT=0 and COMMIT. Ok, I determined that innodb wasn't being initialized because I didn't have innodb_data_file_path set in my.ini. I added the following line to my.ini in mysqladmin: innodb_data_file_path = ibdata1:30M:autoextend After I restarted the service and created some tables (not adding any rows yet), I noticed the following files in the data subdirectory: --- total 41004 drwxr-xr-x2 dmkarr None 8192 Jul 1 15:01 mysql/ -rw-r--r--1 dmkarr None 2461 Jul 1 14:59 mysql.err -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile0 -rw-r--r--1 dmkarr None 31457280 Jul 1 14:59 ibdata1 drwxr-xr-x4 dmkarr None 4096 Jul 1 14:59 ./ -rw-r--r--1 dmkarr None25088 Jul 1 14:59 ib_arch_log_00 -rw-r--r--1 dmkarr None 5242880 Jul 1 14:59 ib_logfile1 drwxr-xr-x 11 dmkarr None 4096 Jun 29 11:30 ../ drwxr-xr-x2 dmkarr None0 Jun 29 11:07 test/ --- However, I don't know how to check the log files for those strings, as they appear to be binary. A simple grep didn't find anything. Is there a special viewer for mysql log files? -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [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
high level: enabling transactions in mysql-max with WebLogic TX datasource?
One thing that I find a little confusing is the notion of transactional behavior in mySQL. I read that it's possible to enable transactions in mySQL-max, however, it's never really been clear to me exactly what I'm supposed to do, or whether I have to do anything. If I'm using a transactional datasource in WebLogic, on top of mySQL, I need to make sure mySQL supports that transactional behavior. Is there a section of the mySQL documentation, or some other documentation, which explains these issues clearly? -- === David M. Karr ; Java/J2EE/XML/Unix/C++ [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
increase mysql max connections over 1024
Hello list, I'd like to increase the number of max connections above 1024 in Linux. I think I have to increase PTHREAD_THREADS_MAX in /usr/include/bits/local_lim.h /* The number of threads per process. */ #define _POSIX_THREAD_THREADS_MAX 64 /* This is the value this implementation supports. */ #define PTHREAD_THREADS_MAX 1024 My question is, what should I do after modify this file. Should I rebuild mysql-server .deb package again? Or I just set mysql max connections and restart mysql server? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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
foreign keys in MySQL-Max-4.0.1
Hi, I use MySQL-Max-4.0.1 and i am wantering if is true that the information about the foreign keys are stored at comment properties of table with maximum length 60 characters? I need to use innodb tables with many f.keys.What I have to do? Thank you. - 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
foreign keys in MySQL-Max-4.0.1
Hi, I use MySQL-Max-4.0.1 and i am wantering if the information about the foreign keys are stored at comment properties of table with maximum length 60 characters? I need to use innodb tables with many f.keys.What I have to do? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: foreign keys in MySQL-Max-4.0.1
-Original Message- From: victoria papazoi [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 11:58 AM To: [EMAIL PROTECTED] Subject: foreign keys in MySQL-Max-4.0.1 Hi, I use MySQL-Max-4.0.1 and i am wantering if the information about the foreign keys are stored at comment properties of table with maximum length 60 characters? I need to use innodb tables with many f.keys.What I have to do? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help - foreign keys in MySQL-Max-4.0.1
Hi, I use MySQL-Max-4.0.1 and i am wantering if the information about the foreign keys are stored at comment properties of table with maximum length 60 characters? I need to use innodb tables with many f.keys.What I have to do? Thank you. - 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