Re: Problem With Join Syntax
Keith, I agree that would be a good option to change the table. Unfortunately, that's not an option at this point. I don't control the schema. Thanks for the suggestion anyway. Albert Padley On Jun 14, 2006, at 3:59 PM, Keith Roberts wrote: Hi Chris. I cannot see how it can be done with the current table schema. Maybe you need to redeclare your table so the values in the value column are more distinct? What is value supposed to contain anyway? First name, last name and email address? What about a structure like: id | userid | ipf_1 | ipf_2 | ipf_3 1 2 JohnSmith email_addy Which will allow you to retrieve all the values you want from the table as one row without having to repeat the userid column? HTH Keith Roberts In theory, theory and practice are the same; in practice they are not. On Wed, 14 Jun 2006, Chris White wrote: To: mysql@lists.mysql.com From: Chris White [EMAIL PROTECTED] Subject: Re: Problem With Join Syntax On Wednesday 14 June 2006 10:55 am, Albert Padley wrote: A typical set of data looks like this: id | inputfieldid | userid | value 1 1 2 John 2 2 2 Smith 3 3 2 [EMAIL PROTECTED] I am trying to come up with a query to return all the `values` of a single userid in a single row. I've checked my books, the manual and tried every type of join I can think of without success. I'd appreciate some direction. This sounds like somewhat of a strange requirement. Why do they need to be in a single row? There MIGHT be a way to do it with stored procedures, I'm just not sure how.. Thanks. Albert Padley -- Chris White PHP Programmer/DB Fighter Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stored procedure TYPE
*Disclaimer - this will be kind of vague mainly because I only vaguely recall the material. I am trying to create a stored procedure. Now I vaguely recall reading something that says I have to match a column type if I am messing with one. Something like I want to match a table column type... even if I don't know what it is. I think it was something like TYPE table.column... I'm not sure if it was only in a DECLARE or if I can set one of the INOUT vars to the column type as well. Hell I can't even remember if it was MySQL or something I read about while researching stored procedures in general and it dealt with a different database system Anyone have any ideas what the heck I am talking about or if it is even supported in MySQL? If it is - any help pointing me in the right general direction to get some information on it would be helpful. If it isn't - I will just make the datatype fixed. I have been looking over the MySQL manual pages on stored procedures, the articles on the MySQL developer zone and google (of course) and can't find it anywhere. -- life is a game... so have fun. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Aborted clients status variable seems increasing -how to tune the server to reduce the same
Hi, The aborted clients seems to be increasing than the connections made. Any solution Aborted_clients 67529 where as the connection made is 60462 . Here is my server details, Server : Red Hat Enterprise Linux AS release 4 (Nahant) Mysql Server version : 4.1.15-log *my.cnf variables:* key_buffer=350M max_allowed_packet=32M table_cache=1024 thread_cache_size=400 sort_buffer=64K net_buffer_length=64K read_buffer_size = 64K thread_stack=96K query_cache_size=64M max_connections=1000 max_connect_errors=100 max_user_connections=900 wait_timeout=5 record_buffer=5M thread_concurrency=8 myisam_sort_buffer_size=64M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 *Status Variables: *Aborted_clients 67529 Aborted_connects0 Connections 60462 Key_blocks_unused 275836 Key_blocks_used 42002 Key_read_requests 1836872 Key_reads 42002 Key_write_requests 3704 Key_writes 3701 Max_used_connections205 Open_tables 84 Opened_tables 90 Qcache_free_blocks 4451 Qcache_free_memory 54838840 Qcache_hits 18034 Qcache_inserts 66383 Qcache_lowmem_prunes0 Qcache_not_cached 11320 Qcache_queries_in_cache 11792 Questions 269605 Threads_cached 81 Threads_connected 124 Threads_created 205 Threads_running 4* -Lakshmi.M.P. MYSQL DBA, Sify Limited. ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
BBEdit tip (was: Differences between MySQL 4 and 5 for scripts)
At 23:00 +0100 14/6/06, Graham Reeds wrote: 1) You may have a bogus hidden character in your SQL file. If you look at it with a text editor (BBEdit, TextWrangler, etc), with the show invivisbles feature on, do you see unusual stuff? Sounds strange but I've seen stranger. Took a brief look over it but didn't see anything that I thought looked untoward. Nor did side by side comparison show up anything. I know your problem is now solved, but a quick tip for users of BBEdit when searching for 'rogue' characters: Sometimes you can't see them at all in the normal display, but if you go to the page preferences menu - the third little square from the left inside the message window - and select Show Invisibles, this can reveal various oddities. You may find, eg, control characters appearing as inverted red ?s, or non-breaking spaces (I /think/ that's what they are) appearing as grey bullets where you expect normal spaces. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Empty warhead found in White House -- Sign carried on New York peace rally, April 2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: stored procedure TYPE
*Disclaimer - this will be kind of vague mainly because I only vaguely recall the material. I am trying to create a stored procedure. Now I vaguely recall reading something that says I have to match a column type if I am messing with one. Something like I want to match a table column type... even if I don't know what it is. I think it was something like TYPE table.column... I'm not sure if it was only in a DECLARE or if I can set one of the INOUT vars to the column type as well. Oracle does that. MySQL, as far as I know, doesn't. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql and Aix 5.3
Hello I'm looking for mysql 4.1 for Aix 5.3. I found mysql for aix 5.2 but no where 5.3 package. Is there anyway to provide this version ? Other things : the final user use 4.1.10a with Linux and want the same version for Aix. Why this version of Mysql doesn't exists anymore ? Thanks, -- Sébastien -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
order field of a table
Hi I' m a newbie and I'm sure this question has been answered many times, but I can't find the appropriate thread. Example: I have a table of people's data including a field called say importance like: NAME; AGE; FUNCTION; IMPORTANCE Peter; 24years, some job, 0 Anna; 22years, better job, 1 Frank; 40 years, chief, 2 Now, there is a new employee John with a job better than Peter's His importance is one more than peter's, and all other move up +1; So the list should look like this after inserting John: Peter; 24years, some job, 0 John; 28years, somewhat better job, 1 Anna; 22years, better job, 2 Frank; 40 years, chief, 3 Which is the most effiicient way (SQL Statements) to insert or delete John in this example? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: order field of a table
theo schrieb: Hi I' m a newbie and I'm sure this question has been answered many times, but I can't find the appropriate thread. Example: I have a table of people's data including a field called say importance like: NAME; AGE; FUNCTION; IMPORTANCE Peter; 24years, some job, 0 Anna; 22years, better job, 1 Frank; 40 years, chief, 2 Now, there is a new employee John with a job better than Peter's His importance is one more than peter's, and all other move up +1; So the list should look like this after inserting John: Peter; 24years, some job, 0 John; 28years, somewhat better job, 1 Anna; 22years, better job, 2 Frank; 40 years, chief, 3 Which is the most effiicient way (SQL Statements) to insert or delete John in this example? Thank you Well one solution would be updating the table first UPDATE workers SET impartance = importance + 1 WHERE importance 1 This would raise every importance by one where the importance is bigger than 1. Now you could insert john with the importance of 1. Is it that what you have been looking for? Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: order field of a table
On 6/15/06, theo [EMAIL PROTECTED] wrote: Now, there is a new employee John with a job better than Peter's His importance is one more than peter's, and all other move up +1; So the list should look like this after inserting John: Peter; 24years, some job, 0 John; 28years, somewhat better job, 1 Anna; 22years, better job, 2 Frank; 40 years, chief, 3 Which is the most effiicient way (SQL Statements) to insert or delete John in this example? Barrys solution works fine, but you might want a little more details (no offence Bar!) :-) Before inserting a new employee: UPDATE workers SET importance = importance + 1 WHERE importance X Where X is the position that the new employee should have. This makes every person under the new employee raise the importance value by one. Just reverse the method before removing an employee: UPDATE workers SET importance = importance - 1 WHERE importance X importance 0 Which would move all the employees which were under the given employee (with importance X) up a step, as long as they're not on top (importance 0). ...just realize this might get you more confused than clearing it out for you, but what the hey. Best regards -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
suggestions
Hi All, I'm still kind of new to this, so I'm looking for suggestions on how to do this one. I need to recode this site that was designed using the old WebCatalog program which we will be phasing out soon. Here's the link to a page I need help on: http://die-broke.com/books.tpl What's the simplest way to code this? Much thanks. Kay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: suggestions
I'm still kind of new to this, so I'm looking for suggestions on how to do this one. I need to recode this site that was designed using the old WebCatalog program which we will be phasing out soon. Here's the link to a page I need help on: http://die-broke.com/books.tpl What's the simplest way to code this? How long is the piece of string? --Rob __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same
You have your wait_timeout set to 5 seconds. Which means a client connection will be aborted after 5 seconds of inactivity. Since your aborted connects is 0, you don't seem to having a problem connecting, just staying connected. 5 seconds is kind of low (default is 28800 I think), but is fine if you have a reason for setting it so low. Your threads_created number is fairly low, so you're not having a problem of constantly creating threads to handle connections, which can really hurt. I don't know what your front end is written in. But you may want to increase the wait_timeout or call mysql_close when you are done with your database connection. I'm guessing that since your aborted clients number is higher than the number of connections, you're using persistant connections. Which means connections are reused if still available. - Original Message - From: Lakshmi [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Thursday, June 15, 2006 3:42 AM Subject: Aborted clients status variable seems increasing -how to tune the server to reduce the same Hi, The aborted clients seems to be increasing than the connections made. Any solution Aborted_clients 67529 where as the connection made is 60462 . Here is my server details, Server : Red Hat Enterprise Linux AS release 4 (Nahant) Mysql Server version : 4.1.15-log *my.cnf variables:* key_buffer=350M max_allowed_packet=32M table_cache=1024 thread_cache_size=400 sort_buffer=64K net_buffer_length=64K read_buffer_size = 64K thread_stack=96K query_cache_size=64M max_connections=1000 max_connect_errors=100 max_user_connections=900 wait_timeout=5 record_buffer=5M thread_concurrency=8 myisam_sort_buffer_size=64M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 *Status Variables: *Aborted_clients 67529 Aborted_connects0 Connections 60462 Key_blocks_unused 275836 Key_blocks_used 42002 Key_read_requests 1836872 Key_reads 42002 Key_write_requests 3704 Key_writes 3701 Max_used_connections205 Open_tables 84 Opened_tables 90 Qcache_free_blocks 4451 Qcache_free_memory 54838840 Qcache_hits 18034 Qcache_inserts 66383 Qcache_lowmem_prunes0 Qcache_not_cached 11320 Qcache_queries_in_cache 11792 Questions 269605 Threads_cached 81 Threads_connected 124 Threads_created 205 Threads_running 4* -Lakshmi.M.P. MYSQL DBA, Sify Limited. ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in -- 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: suggestions
At 02:16 PM 6/15/2006 Thursday, Rob Desbois wrote: I'm still kind of new to this, so I'm looking for suggestions on how to do this one. I need to recode this site that was designed using the old WebCatalog program which we will be phasing out soon. Here's the link to a page I need help on: http://die-broke.com/books.tpl What's the simplest way to code this? How long is the piece of string? --Rob Rob, I think it's listed by the corresponding SKU numbers - 17 digits. Is this what you're asking? Kay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: suggestions
I'm still kind of new to this, so I'm looking for suggestions on how to do this one. I need to recode this site that was designed using the old WebCatalog program which we will be phasing out soon. Here's the link to a page I need help on: http://die-broke.com/books.tpl What's the simplest way to code this? Hire someone to do it for you. Now, seriously... If I would be asking you: What's the easiest way to build a house, just like that one, but different. What kind of answer would I be expecting? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re[2]: suggestions
I think it's listed by the corresponding SKU numbers - 17 digits. Is this what you're asking? Err...no, I meant pretty much what Martijn said in his reply - the question is very vague. There are many ways of achieving...whatever it is you want to achieve. If you need help with it you need to be more specific - if you need help with the overall design / logic then you'd be best hiring someon as he suggests. --Rob __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same
On 6/15/06, Lakshmi [EMAIL PROTECTED] wrote: Hi, The aborted clients seems to be increasing than the connections made. Any solution Aborted_clients 67529 where as the connection made is 60462 . A client is aborted after wait_timeout seconds of inactivity, but as your app seem to be working OK, the aborted_clients is increasing because you are not closing the connection properly after dealing with data with that connection. The low number of seconds explains why you have no trouble at all, because MySQL simply kills that connection after you use it and leave it there hanging. Try closing your connections after you've used them in a proper way (that depends on the language you're using for your frontend) and that number should not increase anymore. -- 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: confirm subscribe to mysql@lists.mysql.com
On Friday 16 June 2006 00:28, [EMAIL PROTECTED] wrote: To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please click on the following link: http://lists.mysql.com/s/mysql/44916ea4caaa5c4f/markc=renta.net This confirmation serves two purposes. First, it verifies that we are able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: For help and a description of available commands, send a message to: [EMAIL PROTECTED] To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, just send a message to the address in the ``List-Unsubscribe'' header of any list message. If you haven't changed addresses since subscribing, you can also send a message to: [EMAIL PROTECTED] or for the digest to: [EMAIL PROTECTED] For addition or removal of addresses, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete the transaction. If you need to get in touch with the human owner of this list, please send a message to: [EMAIL PROTECTED] Please include a FORWARDED list message with ALL HEADERS intact to make it easier to help you. --- Enclosed is a copy of the request I received. Received: (qmail 2946 invoked by uid 48); 15 Jun 2006 14:28:52 - Date: 15 Jun 2006 14:28:52 - Message-ID: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Unsubscribe request From: [EMAIL PROTECTED] This message was generated because of a request from 203.213.7.131. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Extending mysql.user.User to 64 chars
Howdy. For years I have manually altered mysql.user.User to 64 chars to accommodate email length user IDs but now, after upgrading to v5.0.21, the normal alter table routine I use seems to ruin the table altogether. I can't use mysqlcheck to fix it because the root user can't log in. On a fresh install I usually do this, but get the following error... # mysql -e ALTER TABLE user CHANGE User User CHAR(64) mysql # mysqladmin -u root password 'abc' mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' I know what I am doing is non-standard but being limited to 16 char usernames is unacceptable. Would anyone know of a workaround other than using postgresql ? Are there any table fixing programs that don't require a running mysql server ? --markc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MS access query in mysql
Thank you very much for the tips and for the links. I think I have it working now with a subquery. cheers, Andrew Zahn Peter Brawley wrote: Andrew Zahn wrote: I am using MS Access to read from a MySQL database. The query generated through access listed below returns incorrect data when executed in Access and doesn't work at all in MySQL. I believe it has to Last() and with the # symbols around the date. Any insight into this problem would be greatly appreciated. SELECT ReturnTbl.ComponentID, ReturnTbl.PartDescription, Sum(ReturnTbl.Quantity) AS SumOfQuantity, Last(CompVendorListTbl.Cost) AS LastOfCost FROM ReturnTbl LEFT JOIN CompVendorListTbl ON ReturnTbl.ComponentID = CompVendorListTbl.ComponentID WHERE (((ReturnTbl.Date)#2/1/2006#)) GROUP BY ReturnTbl.ComponentID, ReturnTbl.PartDescription, ReturnTbl.USL, ReturnTbl.RtnMfgr HAVING (((Sum(ReturnTbl.Quantity))0) AND ((ReturnTbl.USL)=0) AND ((ReturnTbl.RtnMfgr)=0)) ORDER BY ReturnTbl.PartDescription; MySQL has no Last() function. You need a subquery (eg SELECT MAX(cost) FROM CompVendorListTbl WHERE componentid=returntbl.componentid), or one of the tricks described at http://dev.mysql.com/doc/refman/5.1/en/example-maximum-column-group-row.html, or one of the tricks described under 'Within-Group Aggregates' at http://www.artfulsoftware.com/queries.php. Surround date literals with '', not ##. MySQL will not expect a US date format unless you apply explicit formatting. PB - Thanks, Andrew Zahn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to split output from SHOW SLAVE STATUS?
Not natively in 5.0, but MySQL 5.1 has introduced an event schedule feature embedded into it, but i am not really sure if even that can do what you have described, but the best way to do this is in Perl with the DBI or the DBIx::DWIW or the DBD::MySQL modules, if you want some reference then look at this script from my website, and it should help you to get started right away . http://kjalleda.googlepages.com/checkingmysqlslavestatus Kishore Jalleda On 6/14/06, Jacek Becla [EMAIL PROTECTED] wrote: Hi, I'm trying to find how to split the output from SHOW SLAVE STATUS into individual fields. Specifically, I would like to be able to do in a stored function: 1) determine what the status of slave is, and if it is Waiting for master to send event, do some action, like stop the slave 2) extract value of Master_Log_File and Read_Master_Log_Pos and return it from the function. Is that possible with existing tools (mysql 5.0.x)? Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
innodb buffer pool size
Здравствуйте, . Hi all. I try to increaseinnodb_buffer_pool_size There is log file: mysqld_safe[23845]: started mysqld[23848]: 060615 19:14:52 InnoDB: Error: cannot allocate 2147500032 bytes of mysqld[23848]: InnoDB: memory with malloc! Total allocated memory mysqld[23848]: InnoDB: by InnoDB 58027104 bytes. Operating system errno: 12 mysqld[23848]: InnoDB: Check if you should increase the swap file or mysqld[23848]: InnoDB: ulimits of your operating system. mysqld[23848]: InnoDB: On FreeBSD check you have compiled the OS with mysqld[23848]: InnoDB: a big enough maximum process size. mysqld[23848]: InnoDB: Note that in most 32-bit computers the process mysqld[23848]: InnoDB: memory space is limited to 2 GB or 4 GB. mysqld[23848]: InnoDB: We keep retrying the allocation for 60 seconds... core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size(512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 53248 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited OS Debian 3.1 About 6 Gb of memory. How i can allocate about 2-3Gb? -- С уважением, Vitaliy mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb buffer pool size
Look at this previous thread http://forums.mysql.com/read.php?22,42721,42721 Kishore Jalleda http://kjalleda.googlepages.com On 6/15/06, Vitaliy Okulov [EMAIL PROTECTED] wrote: Здравствуйте, . Hi all. I try to increaseinnodb_buffer_pool_size There is log file: mysqld_safe[23845]: started mysqld[23848]: 060615 19:14:52 InnoDB: Error: cannot allocate 2147500032 bytes of mysqld[23848]: InnoDB: memory with malloc! Total allocated memory mysqld[23848]: InnoDB: by InnoDB 58027104 bytes. Operating system errno: 12 mysqld[23848]: InnoDB: Check if you should increase the swap file or mysqld[23848]: InnoDB: ulimits of your operating system. mysqld[23848]: InnoDB: On FreeBSD check you have compiled the OS with mysqld[23848]: InnoDB: a big enough maximum process size. mysqld[23848]: InnoDB: Note that in most 32-bit computers the process mysqld[23848]: InnoDB: memory space is limited to 2 GB or 4 GB. mysqld[23848]: InnoDB: We keep retrying the allocation for 60 seconds... core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size(512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 53248 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited OS Debian 3.1 About 6 Gb of memory. How i can allocate about 2-3Gb? -- С уважением, Vitaliy mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Warnings while trying to restore database
I'm trying to restore a MySQL database in v5.0 (that minor number is in the teens, I don't have it at hand). I get a bunch of warnings like: Warning: Do not know how to handle this statement at line 28: CREATE TEMPORARY TABLE `CHARACTER_SETS` ( `CHARACTER_SET_NAME` varchar(64) NOT NULL default '', `DEFAULT_COLLATE_NAME` varchar(64) NOT NULL default '', `DESCRIPTION` varchar(60) NOT NULL default '', `MAXLEN` bigint(3) NOT NULL default '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized. Warning: Do not know how to handle this statement at line 86: CREATE TEMPORARY TABLE `COLLATIONS` ( `COLLATION_NAME` varchar(64) NOT NULL default '', `CHARACTER_SET_NAME` varchar(64) NOT NULL default '', `ID` bigint(11) NOT NULL default '0', `IS_DEFAULT` varchar(3) NOT NULL default '', `IS_COMPILED` varchar(3) NOT NULL default '', `SORTLEN` bigint(3) NOT NULL default '0' ) ENGINE=MEMORY DEFAULT CHARSET=utf8; Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized. I've searched the list archive and the bug database without finding a clue. What's this about? How do I work around it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Extending mysql.user.User to 64 chars
The same limitation is also in 4.1.x versions. You have to edit the source of the client library and recompile. Mark Constable wrote: Howdy. For years I have manually altered mysql.user.User to 64 chars to accommodate email length user IDs but now, after upgrading to v5.0.21, the normal alter table routine I use seems to ruin the table altogether. I can't use mysqlcheck to fix it because the root user can't log in. On a fresh install I usually do this, but get the following error... # mysql -e ALTER TABLE user CHANGE User User CHAR(64) mysql # mysqladmin -u root password 'abc' mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' I know what I am doing is non-standard but being limited to 16 char usernames is unacceptable. Would anyone know of a workaround other than using postgresql ? Are there any table fixing programs that don't require a running mysql server ? --markc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Extending mysql.user.User to 64 chars
On Friday 16 June 2006 02:40, Ghaffar wrote: The same limitation is also in 4.1.x versions. You have to edit the source of the client library and recompile. I thought so too but fortunately for me we are both wrong... version: 4.1.15-Debian_1ubuntu5-log mysql SHOW FULL FIELDS FROM `user`; +---+--- | Field | Type +---+--- | Host | varchar(60) | User | varchar(64) | Password | varchar(41) Would anyone know why there is such a lame and arbitrary limitation for username length ? I distribute a system solution so I can't just do a one-off recompile of source for a single installation. # mysql -e ALTER TABLE user CHANGE User User CHAR(64) mysql # mysqladmin -u root password 'abc' mysqladmin: unable to change password; error: 'Can't find any matching row in the user table' I know what I am doing is non-standard but being limited to 16 char usernames is unacceptable. Would anyone know of a workaround other than using postgresql ? Are there any table fixing programs that don't require a running mysql server ? --markc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compile Problems -- Solaris 10 -- mysql-5.0.22
Hello, I'm trying to compile mysql-5.0.22 on Solaris 10 using the Forte Compiler (cc: Sun C 5.8 2005/10/13). I'm doing this so I can build the DBI driver for mysql (DBD::mysql). The .pkg versions are missing libmysqlclient.so required to build DBD::mysql (http://bugs.mysql.com/bug.php?id=17205). PATH: /usr/bin:/opt/SUNWspro/bin:/opt/SUNWspro/prod/bin:/usr/ucb:/etc:/usr/ccs/bin Configure: CC=cc CFLAGS=-Xa -fast -native -xstrconst -mt \ CXX=CC CXXFLAGS=-noex -mt \ ./configure --prefix=/usr/local/mysql-5.0.22 --enable-assembler make (yields error): Making all in strings /opt/SUNWspro/prod/bin/as -o strings-x86.o strings-x86.s Assembler: strings-x86.s, line 1 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 2 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 3 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 4 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 5 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 6 : Syntax error strings-x86.s, line 7 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 8 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 9 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 10 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 11 : Syntax error strings-x86.s, line 12 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 13 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 14 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 16 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 19 : Inappropriate assembler version: have 02.01 expect 1.00 or greater strings-x86.s, line 23 : Syntax error strings-x86.s, line 24 : Syntax error strings-x86.s, line 31 : Syntax error strings-x86.s, line 32 : Syntax error strings-x86.s, line 33 : Syntax error strings-x86.s, line 34 : Syntax error strings-x86.s, line 37 : Illegal mnemonic strings-x86.s, line 37 : Syntax error strings-x86.s, line 50 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 51 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 56 : Syntax error strings-x86.s, line 58 : Syntax error strings-x86.s, line 59 : Syntax error strings-x86.s, line 60 : Syntax error strings-x86.s, line 63 : Syntax error strings-x86.s, line 66 : Illegal mnemonic strings-x86.s, line 66 : Syntax error strings-x86.s, line 78 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 79 : Warning: Error in the # lineno from preprocessor strings-x86.s, line 85 : Syntax error strings-x86.s, line 86 : Syntax error strings-x86.s, line 87 : Syntax error strings-x86.s, line 88 : Illegal mnemonic strings-x86.s, line 88 : Syntax error strings-x86.s, line 88 : Illegal mnemonic strings-x86.s, line 88 : Syntax error strings-x86.s, line 90 : Syntax error strings-x86.s, line 91 : Illegal mnemonic strings-x86.s, line 91 : Syntax error strings-x86.s, line 92 : Syntax error strings-x86.s, line 93 : Syntax error strings-x86.s, line 95 : Syntax error strings-x86.s, line 96 : Syntax error strings-x86.s, line 97 : Syntax error Too many errors - Goodbye *** Error code 127 make: Fatal error: Command failed for target `strings-x86.o' Current working directory /home/andy/mysql-4.1.20/strings *** Error code 1 Does anyone have any idea how this error can be fixed? //andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sort-index on geometry always fails
Hi, I have a table that stores geometry information in one column in point type. After freshly uploading the table, myisamcheck --sort-index reports an error: - Sorting index for MyISAM-table 'TEST_I14_GEOM' myisamchk: Unknown error 126 myisamchk: error: Can't read key block from filepos: 71995659058108416 MyISAM-table 'TEST_I14_GEOM' is not fixed because of errors === OK, so I go ahead, and fix it: myisamchk --analyze Checking MyISAM file: TEST_I14_GEOM Data records: 37852738 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links MyISAM-table 'TEST_I14_GEOM' is usable but should be fixed myisamchk --verbose --recover - recovering (with keycache) MyISAM-table 'TEST_I14_GEOM' Data records: 37852738 The recovery exists with 0, and is seemingly successful. Then I go back to myisamcheck --sort-index, and I get the same error; myisamchk: Unknown error 126 myisamchk: error: Can't read key block from filepos: 71995659058108416 MyISAM-table 'TEST_I14_GEOM' is not fixed because of errors Seems like myisamcheck --sort-index does not work with spatial indexing? All this is under FC3 on x86_64 AMD opteron, MySQL 5.0.22. Any ideas? Gaspar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]