Re: Where is mysql-workbench SCM?
Found it (after some days of searching): https://code.launchpad.net/ubuntu/+source/mysql-workbench must be the official repository according to https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html. -Kalle Am 15.10.2015 um 22:11 schrieb Karl-Philipp Richter: > Hi, > The only list of mysql-related SCM repositories I found was > https://github.com/mysql which didn't contain a repository for > `mysql-workbench`. I only found the source tarball at > http://dev.mysql.com/downloads/workbench/. The development section at > http://dev.mysql.com/downloads/workbench/ doesn't explain the > development of `mysql-workbench`. > > Any help or pointers are appreciated. > > -Kalle > signature.asc Description: OpenPGP digital signature
Where is mysql-workbench SCM?
Hi, The only list of mysql-related SCM repositories I found was https://github.com/mysql which didn't contain a repository for `mysql-workbench`. I only found the source tarball at http://dev.mysql.com/downloads/workbench/. The development section at http://dev.mysql.com/downloads/workbench/ doesn't explain the development of `mysql-workbench`. Any help or pointers are appreciated. -Kalle signature.asc Description: OpenPGP digital signature
Event feature already working in Server 5.1.37
Hi, I just wanted to remark, that the Event feature is already working in server version 5.1.37 (installed on Debian). In tech resources is mentioned that this feature would be available since version 5.1.6 (see http://dev.mysql.com/tech-resources/articles/event-feature.html). So I wanted to give up using it- but fortunately I tried it on my 5.1.37 server and it works fine.. So I you have a MySQL server version prior 5.1.6 an need the Event feature - I suggest just give it a try . Friendly Philipp Maske Software Developer Dipl.-Oec. Philipp Maske Location Bretagne Maske Maske GbR Ferienhausvermittlung Am Wasserturm 13 31303 Burgdorf b. Hannover Deutschland / Allemagne Email: mailto:i...@location-bretagne.de i...@location-bretagne.de WWW: http://www.location-bretagne.de www.location-bretagne.de Mobile: +49 (0)172 4523977 OpenBC: http://www.openbc.com/hp/Philipp_Maske http://www.openbc.com/hp/Philipp_Maske
fulltext substringsearches?
Hi, can somebody tell me, if it`s possible to search for substrings with a fulltext search? We are using a fulltextsearch in boolean mode. I tried a lot but the search doesn`t find any substrings. The mysql reference just hast got an example like this: apple* that finds everything that begins with apple. Is it possible to seachr for *ppl* and find entries that contain apple or something like this without a like-search and and a full table scan? Thanks for any help Philipp -- View this message in context: http://www.nabble.com/fulltext-substringsearches--tf3433702.html#a9572461 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't connect to local MySQL server through socket
Hi according to Dr Google I'm not the first one to encounter this error below. SpamAssassin: invoked with 'spamd -D -q -u filter' failed to load user (filter) scores from SQL database: SQL Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Thus, I cannot read SpamAssassin preferences from the database. I checked for the sticky bit on mysql.sock. No change. I added all in /var/lib/mysql/ to the 'daemon' group. No change. I hope somebody here can help me. I'm pretty much lost with this. Thanks Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: referencial integrity problem
Hi Hello. What output does the following statement produce: show variables like 'have_innodb'; mysql show variables like 'have_innodb'; +---+---+ | Variable_name | Value | +---+---+ | have_innodb | YES | +---+---+ 1 row in set (0.00 sec) Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: referencial integrity problem
Hi thanks for your help and your answers, it works now. foreign key (ownerdomain) references domains(domain) on delete cascade ^^ was missing. Philipp -Original Message- From: Philipp Snizek [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 23. Februar 2005 11:22 To: mysql@lists.mysql.com Subject: RE: referencial integrity problem Hi Hello. What output does the following statement produce: show variables like 'have_innodb'; mysql show variables like 'have_innodb'; +---+---+ | Variable_name | Value | +---+---+ | have_innodb | YES | +---+---+ 1 row in set (0.00 sec) Philipp -- 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]
referencial integrity problem
Hi I run a Postfix MTA attached to a mysql DB with various domains on it. A domain consists of email addresses. When I want to delete the domain the referenced email addresses should be deleted, too. But that doesn't work and I don't know why. here are the two tables domains and users: CREATE TABLE domains ( ID_DOMAINS int(11) auto_increment, active int(1) not null, domain varchar(50) NOT NULL, PRIMARY KEY (ID_DOMAINS) ) TYPE=MyISAM; create table users ( email varchar (80) primary key unique not null, belongs_to integer not null, foreign key (belongs_to) references domains on delete cascade ); if I use the delete command like delete from domains where id_domains='1' the dataset that belongs to id 1 in domains is deleted while the email addresses belonging to this domain are left untouched. What am I missing? thanks Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: referencial integrity problem
Foreign keys are only supported within InnoDB tables (on both sides).. so using a table 'users' like create table users ( email varchar (80) primary key unique not null, belongs_to integer not null references domains on delete cascade ); without foreign keys could help? I couldn't make it work that way either. Philipp Hi I run a Postfix MTA attached to a mysql DB with various domains on it. A domain consists of email addresses. When I want to delete the domain the referenced email addresses should be deleted, too. But that doesn't work and I don't know why. here are the two tables domains and users: CREATE TABLE domains ( ID_DOMAINS int(11) auto_increment, active int(1) not null, domain varchar(50) NOT NULL, PRIMARY KEY (ID_DOMAINS) ) TYPE=MyISAM; create table users ( email varchar (80) primary key unique not null, belongs_to integer not null, foreign key (belongs_to) references domains on delete cascade ); if I use the delete command like delete from domains where id_domains='1' the dataset that belongs to id 1 in domains is deleted while the email addresses belonging to this domain are left untouched. What am I missing? thanks Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 -- 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: referencial integrity problem
You need to make *both* of your table definitions include Type=InnoDB; *then*, the cascading delete should work fine. This is what I have done upon Keith's suggestion. I have changed all my tables to Type=innodb. Still nothing. Maybe mysqlcc or mysql administrator deliver wrong information? Deleteting the record in Table domains leaves the record in Table users referencing domains untouched. Or is my sql script bad? I'm already spending hours on that. CREATE TABLE domains ( ID_DOMAINS int(11) auto_increment, active int(1) not null, domain varchar(50) NOT NULL, PRIMARY KEY (ID_DOMAINS) ) type=innodb; Either this 'users' Table: create table users ( email varchar (80) primary key unique not null, belongs_to integer not null references domains on delete cascade ) type=innodb; or this 'users' Table: create table users ( email varchar (80) primary key unique not null, belongs_to integer not null, foreign key (belongs_to) references domains on delete cascade ) type=innodb; Philipp Rhino - Original Message - From: Philipp Snizek [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Mysql List (E-mail) mysql@lists.mysql.com Sent: Tuesday, February 22, 2005 7:49 AM Subject: RE: referencial integrity problem Foreign keys are only supported within InnoDB tables (on both sides).. so using a table 'users' like create table users ( email varchar (80) primary key unique not null, belongs_to integer not null references domains on delete cascade ); without foreign keys could help? I couldn't make it work that way either. Philipp Hi I run a Postfix MTA attached to a mysql DB with various domains on it. A domain consists of email addresses. When I want to delete the domain the referenced email addresses should be deleted, too. But that doesn't work and I don't know why. here are the two tables domains and users: CREATE TABLE domains ( ID_DOMAINS int(11) auto_increment, active int(1) not null, domain varchar(50) NOT NULL, PRIMARY KEY (ID_DOMAINS) ) TYPE=MyISAM; create table users ( email varchar (80) primary key unique not null, belongs_to integer not null, foreign key (belongs_to) references domains on delete cascade ); if I use the delete command like delete from domains where id_domains='1' the dataset that belongs to id 1 in domains is deleted while the email addresses belonging to this domain are left untouched. What am I missing? thanks Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 -- 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] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.2.0 - Release Date: 21/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.2.0 - Release Date: 21/02/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: InnoDB Row Lock test (A query maybe?)
Hi I must be blind. Please help a DB-Newbie. What's wrong here: create table users ( email varchar (80) unique not null, ownerdomain int not null, foreign key (ownerdomain) references domains on delete cascade ) type=innodb; MySQL sais: ERROR 1005: Can't create table './postfix/users.frm' (errno: 150) Where can I lookup up error codes? Thanks Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 4.0.18 crashed6384512
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. 040316 16:27:10 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 3044349028 InnoDB: Doing recovery: scanned up to log sequence number 0 3044402982 040316 16:27:10 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed Regards, Philipp
memory leaks
Hello, I am using the mysqlclient library 4.0.14 on win2k. It works fine but there are memory leaks I have no solutions for. I have tried this: int _tmain(int argc, TCHAR* argv[], TCHAR* envp[]) { MYSQL MySQL; mysql_init(MySQL); mysql_close(MySQL); mysql_thread_end(); return 0; } ... but in the debug mode I get results like this: Detected memory leaks! Dumping objects - {52} normal block at 0x00974088, 556 bytes long. Data: 00 00 00 00 C8 00 00 00 00 00 00 00 00 00 00 00 Object dump complete. Do you know how to avoid this problem? Thank you very much Philipp Grohs PS: I am working with MS Visual C++ 6.0 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Selected items delete
Hi! Pag wrote: If i was too confusing, maybe this helps: How can i delete the records whose num field is 4,78,34 and 23, all in one command? Something along delete * in 'table' where num=1 and num=13 and num=34 etc. DELETE FROM table WHERE num=1 OR num=13 OR num=34 or better: http://www.mysql.com/doc/en/index.html -- search for delete :o) Bye, phly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Process Limit on Linux ?
Hi Joseph, thank you for your answer. While i was reading about clustering some weeks ago i read the openmosix FAQ claiming that openmosix would not work with apache, because apache was using shared memory to communicate with its threads, and i always thought mysql is designed the same way. Please someone correct me if i am wrong. Regards, Philipp On Wed, 19 Mar 2003 10:41:21 +0100 Joseph Bueno [EMAIL PROTECTED] wrote: Hi, Since shm (shared memory) in Unix/Linux is only used to share memory between independent processes and mysql server is a single process (multi-threaded), I am convinced that shmmax value has no consequence on mysql. (OTOH Oracle has a multiprocess architecture and uses shared memory). Hope this helps, Joseph Bueno Philipp wrote: Dear Walt, dear List, thank you for your reply. Finally a suggestions at all. I checked both /proc/sys/kernel/threads-max /proc/sys/kernel/shmmax I dont think threads-max will be a problem, because the value is 14336, and i dont think my system will ever have to handle this number of threads. But researching shmmax at google i got several hits. Most are dealing with postgres but perhaps its the same with mysql. shmmax ist 32 MB. on one page the author suggest to raise this value to 128 MB. What are your suggestions for the values: shmall shmmax shmmni ? Thank you very much, Yours Philipp - Original Message - From: walt [EMAIL PROTECTED] To: Philipp [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:48 PM Subject: Re: Process Limit on Linux ? Philipp wrote: Hi there, i wrote several times to the list asking for help with a problem regarding process limits on linux, but never got an answer. today i found this story: http://www.mysql.com/press/user_stories/handy.de.html here are the relevant sentences: We had some process limit problems on our Linux Systems, but thanks to your support we where able to patch the linux boxes and move the limit to a size that meets our needs (we've got an average of about 1600 concurrent threads per server). These people use 2.2 Kernels so i dont know if the mentioned kernel and glibc patching is also relevant for me, as i am using 2.4 kernels only. Here is my problem in detail: i am using mysql-3.23.55 binary packages on linux 2.4.20 and i raised ulimit values and configuration in my.conf to allow more then 1500 threads. but when there are around 750 threads a new client connecting is told something like that (dont have the errno at the moment, i think its 11): cant create new thread, perhaps you are out of memory or there is a os-depended bug. The machine only runs apache and mysql and is a Xeon 2x2 2.4 Gz with 2 GB of RAM. cat /proc/meminfo sais that more then 1 Gig is used for caching, so memory should be no problem . Please, if you have any ideas, let me know. If it is a kernel issue, tell me to go to linux mailing lists or if its some kind of secret issue only the support will be able to answer let me know that. Thanks in advance, Philipp - 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 Philipp, Did you check /proc/sys/kernel/threads-max? I know with oracle 8i, you are supposed to increase /proc/sys/kernel/shmmax as well as some other values. You might check into that and see if changing those values will help. Does your syslog say anything when these problems occur? walt walt -- - Philipp Steinkrueger Oberberg Online Informationssysteme GmbH Technik http://www.oberberg.net PGPkeyID: 690A9504 Key Fingerprint: 35CE 467E C813 06B0 B8E3 0275 2B1E E84A 690A 9504 - 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: Process Limit on Linux ?
Hi Dan, i just talked about openmosix because i read about shared memory segments. my only desire is to make mysql able to spawn 1000-1500 connections and *not* to tell my client cant create new thread, perhaps out of memory while 1.5 GB of RAM is only used for caching. Is that really possible that mysql is not able to handle this amount of connections ? My best Regards, Philipp On Wed, 19 Mar 2003 10:01:38 -0600 Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Mar 19), Philipp said: thank you for your answer. While i was reading about clustering some weeks ago i read the openmosix FAQ claiming that openmosix would not work with apache, because apache was using shared memory to communicate with its threads, and i always thought mysql is designed the same way. Please someone correct me if i am wrong. SYSV shared memory (shm*) is a block of memory that one process creates, and depending on the access flags, multiple processes can attach to and see each other's changes. Threads use shared memory by definition, because a threaded application is still one process. No SYSV shm tricks are needed. Openmosix won't be able to balance mysql threads, because even if it were possible to synchronize shared memory between machines with Mosix, synching thread mutexes would be horrendously slow. Better to just get a multi-CPU box. -- Dan Nelson [EMAIL PROTECTED] -- - Philipp Steinkrueger Oberberg Online Informationssysteme GmbH Technik http://www.oberberg.net PGPkeyID: 690A9504 Key Fingerprint: 35CE 467E C813 06B0 B8E3 0275 2B1E E84A 690A 9504 - 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: Process Limit on Linux ?
Dear Walt, dear List, thank you for your reply. Finally a suggestions at all. I checked both /proc/sys/kernel/threads-max /proc/sys/kernel/shmmax I dont think threads-max will be a problem, because the value is 14336, and i dont think my system will ever have to handle this number of threads. But researching shmmax at google i got several hits. Most are dealing with postgres but perhaps its the same with mysql. shmmax ist 32 MB. on one page the author suggest to raise this value to 128 MB. What are your suggestions for the values: shmall shmmax shmmni ? Thank you very much, Yours Philipp - Original Message - From: walt [EMAIL PROTECTED] To: Philipp [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:48 PM Subject: Re: Process Limit on Linux ? Philipp wrote: Hi there, i wrote several times to the list asking for help with a problem regarding process limits on linux, but never got an answer. today i found this story: http://www.mysql.com/press/user_stories/handy.de.html here are the relevant sentences: We had some process limit problems on our Linux Systems, but thanks to your support we where able to patch the linux boxes and move the limit to a size that meets our needs (we've got an average of about 1600 concurrent threads per server). These people use 2.2 Kernels so i dont know if the mentioned kernel and glibc patching is also relevant for me, as i am using 2.4 kernels only. Here is my problem in detail: i am using mysql-3.23.55 binary packages on linux 2.4.20 and i raised ulimit values and configuration in my.conf to allow more then 1500 threads. but when there are around 750 threads a new client connecting is told something like that (dont have the errno at the moment, i think its 11): cant create new thread, perhaps you are out of memory or there is a os-depended bug. The machine only runs apache and mysql and is a Xeon 2x2 2.4 Gz with 2 GB of RAM. cat /proc/meminfo sais that more then 1 Gig is used for caching, so memory should be no problem . Please, if you have any ideas, let me know. If it is a kernel issue, tell me to go to linux mailing lists or if its some kind of secret issue only the support will be able to answer let me know that. Thanks in advance, Philipp - 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 Philipp, Did you check /proc/sys/kernel/threads-max? I know with oracle 8i, you are supposed to increase /proc/sys/kernel/shmmax as well as some other values. You might check into that and see if changing those values will help. Does your syslog say anything when these problems occur? walt walt - 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: Process Limit on Linux ?
Hi Walt, i am using PHP to generate the connections. The maximum was around 750 Connections. I am sure it never was more then 800. At the moment i have queries per second avg: 548.286 Regards, Philipp - Original Message - From: walt [EMAIL PROTECTED] To: Philipp [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 7:11 PM Subject: Re: Process Limit on Linux ? On Tuesday 18 March 2003 01:01 pm, you wrote: Dear Walt, dear List, thank you for your reply. Finally a suggestions at all. I checked both /proc/sys/kernel/threads-max /proc/sys/kernel/shmmax I dont think threads-max will be a problem, because the value is 14336, and i dont think my system will ever have to handle this number of threads. But researching shmmax at google i got several hits. Most are dealing with postgres but perhaps its the same with mysql. shmmax ist 32 MB. on one page the author suggest to raise this value to 128 MB. What are your suggestions for the values: shmall shmmax shmmni ? I really couldn't give you good values for these. I just remember Oracle suggested changes to them. What are you using to generate the connections (perl, c/c++, php, etc.)? -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 If it's not broketweak it - 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
Process Limit on Linux ?
Hi there, i wrote several times to the list asking for help with a problem regarding process limits on linux, but never got an answer. today i found this story: http://www.mysql.com/press/user_stories/handy.de.html here are the relevant sentences: We had some process limit problems on our Linux Systems, but thanks to your support we where able to patch the linux boxes and move the limit to a size that meets our needs (we've got an average of about 1600 concurrent threads per server). These people use 2.2 Kernels so i dont know if the mentioned kernel and glibc patching is also relevant for me, as i am using 2.4 kernels only. Here is my problem in detail: i am using mysql-3.23.55 binary packages on linux 2.4.20 and i raised ulimit values and configuration in my.conf to allow more then 1500 threads. but when there are around 750 threads a new client connecting is told something like that (dont have the errno at the moment, i think its 11): cant create new thread, perhaps you are out of memory or there is a os-depended bug. The machine only runs apache and mysql and is a Xeon 2x2 2.4 Gz with 2 GB of RAM. cat /proc/meminfo sais that more then 1 Gig is used for caching, so memory should be no problem . Please, if you have any ideas, let me know. If it is a kernel issue, tell me to go to linux mailing lists or if its some kind of secret issue only the support will be able to answer let me know that. Thanks in advance, Philipp - 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
Problem: mysql can't create new thread.
Hi there, this problem was asked in this list before and i thought i solved it but i was wrong. Heres the description: I am running mysql 3.23.54 on Debian Linux with 2.4.20 Final System has 2 GB Ram. I compiled from source. Here are relevant passages from my.cnf port= 3306 socket = /var/run/mysql/mysql.sock set-variable= max_connections=1000 skip-locking set-variable= open_files_limit=8129 set-variable= max_tmp_tables=300 set-variable= key_buffer=512M set-variable= max_allowed_packet=5M set-variable= table_cache=3000 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=50 set-variable= myisam_sort_buffer_size=96M set-variable= thread_concurrency=512 set-variable= wait_timeout=60 Ulimits are raised to unlimted for user msql. I am executing this in safe_mysqld: ulimit -n $open_files ulimit -u unlimited ulimit -a /tmp/mysql.ulmit mysql.ulimit looks like this: core file size(blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files(-n) 8129 pipe size (512 bytes, -p) 8 stack size(kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes(-u) unlimited virtual memory(kbytes, -v) unlimited The System never runs out of Ram. There is lots of it available, but when Mysql created 750 threads it stops creating more. It then tells me something like in the Subject: Can't create thread, perhaps out of memoy, OS-depended bug, blah... Now finally, a question: Can someone please give me a hint what to do to make mysql create more threads ? Regards, Philipp - 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: CREATE TABLE, NOT NULL fields, and empty strings
Doug Beyer wrote: create table t1 ( id varchar(5) not null, name varchar(5) not null ); insert into t1 ( id ) values ( 1234 ); select count(*) from t1 where name is null; -- Result = 0 select count(*) from t1 where name = ; -- Result = 1 Questions: 1) Why did the insert succeed since the name field is not null and I didn't provide a value? MySQL uses the default value of this column if you don't provide a value and the column is defined not null. 2) Why does MySql think it's correct to substitute an empty string for a non-provided value? http://www.mysql.com/doc/en/CREATE_TABLE.html : If no DEFAULT value is specified for a column, MySQL automatically assigns one. If the column may take NULL as a value, the default value is NULL. If the column is declared as NOT NULL, the default value depends on the column type: * For string types other than ENUM, the default value is the empty string. For ENUM, the default is the first enumeration value (if you haven't explicitly specified another default value with the DEFAULT directive). Good night, Philipp - 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: 3.23 thread error - help/advice please
Hi, i had a problem like this, too. in my case it wasnt mysql restricting the number of threads but my OS (Linux/Debian). Usually mysql does not run as root, but as user mysql or something else. Debian restricts normal users to a number of running processes to prevent an overloaded. i solved my problem by raising this value, in my case with the tool ulimit. i call it with the appopriate paramter in safe_mysqld. there is already a ulimit call in safe_mysqld to raise thie number of allowed open files. i added my ulimit right after that line... hope that helps... regards, philipp - Original Message - From: my5ql _ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 3:04 PM Subject: 3.23 thread error - help/advice please I tweaked my.cnf on a server. Changed wait_timeout from 80 to 75 and increased key_buffer to 1280M from 1024M max_connections is set to 500 Max_used_connections was reported at 370 (from 'mysqladmin variables') thread_cache is set to 48 I ran 'mysqladmin flush-hosts' as the mysql root user and got the following output: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug' Problem seems to have disappeared once I reverted back to my old settings (and I don't get the regular [every 10min] php pconnect errors). Max_used_connections is now at 439. System is MySQL 3.23.51 built from source, Rh 7.3, custom 2.4.19 kernel. What I'm unsure about is the errors from php pconnect and the inability to flush hosts when I hadn't hit any connection limits. I have over 2GB RAM free (as reported by 'top') Any ideas/suggestions? _ Chat online in real time with MSN Messenger http://messenger.msn.co.uk - 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: 3.23 thread error - help/advice please
Hi, yes, thats where i added the line. i used ulimit -u. ulimit is a build-in bash command. man bash says: -u The maximum number of processes available to a single user My section looks like this: if test -n $open_files then ulimit -n $open_files ulimit -u 1505# - That limits to 1505 processes. fi if test -n $core_file_size then ulimit -c $core_file_size fi fi If you want a connection limit of 500 set it to something more than 500, because the main process, which will not handle a connection, has to be counted. You can also add something like this before and after the above section to verify: ulimit -a /tmp/mysql-ulimit.txt That will print all ulimit restrictions to /tmp/mysql-ulimit.txt. Regards, Philipp - Original Message - From: my5ql _ [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 6:05 PM Subject: Re: 3.23 thread error - help/advice please What kind of limit did you set? I think I've found the area in safe_mysqld you referred to. Is this correct? -- # If we are root, change the err log to the right user. touch $err_log; chown $user $err_log if test -n $open_files then ulimit -n $open_files fi if test -n $core_file_size then ulimit -c $core_file_size fi fi - From: Philipp [EMAIL PROTECTED] To: my5ql _ [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: 3.23 thread error - help/advice please Date: Tue, 28 Jan 2003 17:15:06 +0100 Hi, i had a problem like this, too. in my case it wasnt mysql restricting the number of threads but my OS (Linux/Debian). Usually mysql does not run as root, but as user mysql or something else. Debian restricts normal users to a number of running processes to prevent an overloaded. i solved my problem by raising this value, in my case with the tool ulimit. i call it with the appopriate paramter in safe_mysqld. there is already a ulimit call in safe_mysqld to raise thie number of allowed open files. i added my ulimit right after that line... hope that helps... regards, philipp - Original Message - From: my5ql _ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 3:04 PM Subject: 3.23 thread error - help/advice please I tweaked my.cnf on a server. Changed wait_timeout from 80 to 75 and increased key_buffer to 1280M from 1024M max_connections is set to 500 Max_used_connections was reported at 370 (from 'mysqladmin variables') thread_cache is set to 48 I ran 'mysqladmin flush-hosts' as the mysql root user and got the following output: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug' Problem seems to have disappeared once I reverted back to my old settings (and I don't get the regular [every 10min] php pconnect errors). Max_used_connections is now at 439. System is MySQL 3.23.51 built from source, Rh 7.3, custom 2.4.19 kernel. What I'm unsure about is the errors from php pconnect and the inability to flush hosts when I hadn't hit any connection limits. I have over 2GB RAM free (as reported by 'top') Any ideas/suggestions? _ Chat online in real time with MSN Messenger http://messenger.msn.co.uk - 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 _ Use MSN Messenger to send music and pics to your friends http://messenger.msn.co.uk - 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
Rollback problem
Hi! I've got the following problem with Version 4.0.9 of Mysql: The page http://www.mysql.com/doc/en/COMMIT.html says: 'If you do a ROLLBACK when you have updated a non-transactional table you will get an error (ER_WARNING_NOT_COMPLETE_ROLLBACK) as a warning. All transactional safe tables will be restored but any non-transactional table will not change.' When I change both, an InnoDB table and a MyISAM table there is no table restored; not even the InnoDB table. Maybe there is an obvious error in my testing, maybe an error in Mysql. Please tell me. :o) You can find a detailed log at http://www.phlybye.de/sql.txt . Thanks, bye, Philipp - 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: field type of double without scientific notation
I have a Mysql-table with a field of type double. when i retrieve very small numbers from this table I get them allways in a scientific notation: i.e. 8.34e-05. what i have to do, that i get the same number in normal notation: 0.834? thank you for any hints in advance! philipp - 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: field type of double without scientific notation
Roger Baklund: * Philipp Sutter I have a Mysql-table with a field of type double. when i retrieve very small numbers from this table I get them allways in a scientific notation: i.e. 8.34e-05. what i have to do, that i get the same number in normal notation: 0.834? See the FORMAT() function: URL: http://www.mysql.com/doc/en/Miscellaneous_functions.html -- Roger format() has two disadvantages: 1) format will round the number. i can't round the numbers. 2) format(number,13) will get i.e. 0.83400. i do not want the ending zeros. is there an other way to get only the number i.e. 0.834. philipp - 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 Server Crashes under heavy load
Hi Chavvon, we are running a high volume site with currenty 1.3 Million Page Views daily. mysql query average is at 300. We are using the latest stable versions of mysql, apache and php. the server has 2 GB of RAM and 4 XEON 2.4 GZ processors and the load varies between 1 and 2 at peek times. although this box is serving blazing fast even at peak times i think you should cluster if you expect that the hits increase... best regards, philipp - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Chavvon Smith [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 17, 2003 6:45 PM Subject: Re: MySQL Server Crashes under heavy load We have a site with a similar architecture: - 6 load balanced front-ends - 1 dedicated database server (Dual P3 1.4GHz, 2GbRAM, RH7.2) we serve around 3 million pages/day (all pages are dynamiquely generated, each page needs an average of 15 SQL queries). What we have done: - audit ALL SQL queries and make sure that they are optimised (all selects use indexes,...) - optimise mysqld configuration (tune key_buffer_size, ..) - setup replication : each front-end is a mysql slave server and replicate most used tables. - modify the site so that heaviest SELECT queries are run by each front-end on local slave. Result: - on main database server: 300queries/s average (~700q/s peak) load : 0.2 average, ~0.7 peak - on each front-end : 30q/s average (60q/s peak) We could run more requests on the slaves but since the master server load is so low, we have postponed those optimisations. I think you really should audit your queries first. From my experience and what other users have reported on this list, you should expect to be able to run several hundred queries/s with the kind of hardware you are using. Hope this helps -- Joseph Bueno Chavvon Smith wrote: We are hosting a high volume site that gets about 1 million page views a day on RedHat 7.3. We currently have 3 load balanced servers on the front end accessing a MySQL server on the back end. The MySQL servers is dual P3 1ghz with 1 GB of RAM and when the MySQL queries hit about 50 per second, the DB crashes and the servers is useless unless you reset the DB. Memory is only at about 50% usage, but the CPU skyrockets to 100%. The only solution we can think of is to throw a huge server at the backend (i.e. 4-8 processor Compaq 8500) and keep RH 7.3 or switch to Windows 2000 Advanced Server and cluster a few dual P3 servers together. Any other solutions to make MySQL handle a high volume site? CS - 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: Loading a database into RAM
Hi, if your system suddenly crashs all changes to the database are lost. be aware of this ! regards, philipp p - Original Message - From: Shamit Verma [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 11:01 AM Subject: Re: Loading a database into RAM You may try using a Ramdisk as storage for mysql data folder. Regards, Shamit http://www.vshamit.com - Original Message - From: Steve Quezadas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 2:53 PM Subject: Loading a database into RAM I have a mySQL database that is about 240 megabytes. I am loading it on a Linux server with 2 gigs of RAM. I would like to have the whole table reside in memory to save time from disk access. Is there any way to load the tables into RAM on startup? I am thinking about creating a heap table, but I need the heap table to be lodaed when mysql gets loaded. Is there anyway to do this? Or perhaps it is best to put the table in a RAM disk or something? Anyone know a generally recommended solution? -Steve - 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
Re: table_cache too high?
If you with Linux, you can use the 'sysctl' programm. sysctl -h gives you the parameters (i.e -u is for the maximum number of processes created by a user). I use the sysctl command in the safe_mysqld script to increase this number. if you want to set a parameter systemwide you may also use /etc/sysctl.conf. Regards, Philipp - Original Message - From: Thomas Seifert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 3:25 PM Subject: Re: table_cache too high? and how on-the-fly? Thomas On Wed, 20 Nov 2002 09:18:15 -0500 Ken Menzel [EMAIL PROTECTED] wrote: Yes, you are correct and it can be worse because you have not considered that there are some descriptors required by other processes running. I suggest you increase your file limit to at least 2048. Good luck Ken - Original Message - From: Lance Lovette [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 12:12 AM Subject: table_cache too high? My database has many hundreds of tables. Originally I set my table_cache to 512. Today I realize this might not be a good idea. By default open_files_limit is 0. According to my understanding of the manual this means each MySQL process will open at most 1124 file handles: max_connections + (table_cache * 2) = 100 + (512 * 2) = 1124 ulimit -n says the process file handle limit is 1024. Am I correct in assuming this configuration could potentially put the server in an unstable situation? Thanks! Lance - 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 - 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 MySQL Works?
Hi, if you dont understand the language mysql is written in you are probably not interested in how it works, technically. this perspective can only be explained by using terms from the programming language. i guess you are interested in learning more about the user-level, like how to set it up and how to do a query and this stuff. just go read the documentation at www.mysql.com. good luck, philipp - Original Message - From: Unidux (S) - Han Lin [EMAIL PROTECTED] To: Michael T. Babcock [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 3:06 PM Subject: Re: How MySQL Works? Hi Michael, Thanks for your suggestion, but I didn't read C code, and I don't think so someone in this list will:) Maybe short explanation from you also can:) Regards, Han Lin - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Unidux (S) - Han Lin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 9:45 PM Subject: Re: How MySQL Works? Unidux (S) - Han Lin wrote: I wanna know what the steps MySQL perform when we do INSERT in Database? Anyone can explain? Or anyone here have some reference about how MySQL works? The source code is freely available from the website; download it and take a read -- if you don't read C code, grab someone who does :). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
thread creation problem
Hello, i have a problem with the mysql database. mysql seems not able to created ne threads sometimes. the system is running several deamons, like a webserver and a ftpserver. RAM was short so i added more. now there are 2 GB RAM available. first, here is the error message: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug here is my system configuration: debian 3.0 kernel 2.4.19 (high memory enabled) mysql 3.23.52 (compiled from source) here is what mysql looks like in the ps-tree (top 3): root 27041 0.0 0.0 2056 976 pts/5S 17:43 0:00 /bin/sh /usr/local/mysql/bin/safe_mysqld --core --err-log=/var/log/mysql/mysql.err - -datadir=/www/mysql/data --pid-file=/www/mysql/data/www4.pid mysql27073 0.0 0.3 401804 7268 pts/5 S 17:43 0:00 \_ /usr/local/mysql-3.23.52-src/libexec/mysqld --basedir=/usr/local/mysql-3.23. 52-src --datadir=/www/mysql/data --user=mysql --pid-file=/www/mysql/data/www 4.pid --skip-locking --core mysql27075 0.0 0.3 401804 7268 pts/5 S 17:43 0:00 \_ /usr/local/mysql-3.23.52-src/libexec/mysqld --basedir=/usr/local/mysql-3.23. 52-src --datadir=/www/mysql/data --user=mysql --pid-file=/www/mysql/data/www 4.pid --skip-locking --core here is the output of `cat /proc/meminfo`: MemTotal: 2069560 kB MemFree: 19072 kB MemShared: 0 kB Buffers: 74828 kB Cached:1334320 kB SwapCached: 1900 kB Active: 756716 kB Inactive: 850452 kB HighTotal: 1179584 kB HighFree: 3220 kB LowTotal: 889976 kB LowFree: 15852 kB SwapTotal: 384476 kB SwapFree: 379276 kB i see that the cached-value is high, but i think this is to be considered as free if needed. i am not sure at this, could someone correct me please if i am worng here. here is my /etc/my.conf (parts): skip-locking port= 3306 socket = /var/run/mysql/mysql.sock set-variable= max_connections=400 set-variable= open_files_limit=8129 set-variable= key_buffer=384M set-variable= max_allowed_packet=5M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= myisam_sort_buffer_size=64M server-id = 1 [isamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M finally, here is the outout of 'sysctl -a | grep file-max': fs/file-max = 65536 Do you need anything else ? Sorry if the mail got to long, but i dont know what you need to help me... Best Regards and thank you, Philipp - 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 on OS X PROBLEM!
hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.51-entropy.ch Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 4 hours 15 min 17 sec php 4.2.1 also by entropy.ch my problem is the following: let's say i want to add the following user (just as a test): mysql grant all - on * - to test - with grant option; i do that and then i do a mysql use mysql; mysql SELECT * FROM user; the thing is, that all the permissions are still set to 'N'!! it won't accept the grant arguments. also after a mysqladmin reload! i also have phpMyAdmin 2.3.0 installed and if i change the user's permissions in there, it accepts them. then also the terminal will list them properly. why is this happening? please advise, phil - 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 on OS X PROBLEM!
hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.51-entropy.ch Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 4 hours 15 min 17 sec php 4.2.1 also by entropy.ch my problem is the following: let's say i want to add the following user (just as a test): mysql grant all - on * - to test - with grant option; i do that and then i do a mysql use mysql; mysql SELECT * FROM user; the thing is, that all the permissions are still set to 'N'!! it won't accept the grant arguments. i also have phpMyAdmin 2.3.0 installed and if i change the user's permissions in there it accepts them. also the terminal will list them properly. why is this happening? please advise, phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on OS X PROBLEM!
hi rene, thanks for your reply. yes, i do it being root: mysql -u root -p and in phpMyAdmin i see that the grant option for root is enabled. and i am loged into phpMyAdmin as root also. i really wonder what's going on... i mean, am i missing the point in some way or another? cheers, phil Hmm, nothing springs out off the top of my head. You're logged into MySQL as a user that has the GRANT priv. before you issue the grant command, right? If MySQL silently ignores unpriv'd grant requests, that might cause the error you're seeing. Rene - 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