rpm packages for 4.0.20 (compat-libs)
Hey folks, just wanted to upgrade from 4.0.18 to 4.0.20 but found the following. The Dynamic client libraries (including 3.23.x libraries) are still 4.0.18 ... does that mean that they don't NEED to be changed or were they just forgotten? TIA, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem with mysql-crashes
Hi Lenz, thanks a lot for your reply! Is that a self-compiled binary or one of ours? It are the MySQL-4.0.13-MAX-RPMs from your site. Not very helpful. Does this occur under high load only? Yeah I know, otherwise I would have tried to generate a reproducible testcase with a given query or such. Any way to have valid pointers there? Nope, the load on that system is mostly around 0.5 with peaks up to 1.5, not something I would call a high load for a dual-system. Also the crashes are at many different times (even in the deep night) so I don't think its related to load :-(. What version of glibc is this system running on? Is it 2.2.3 by chance? Nope, sorry. Its glibc-2.2.4-32. What version of glibc is being used on that system? I noticed that you use the Max binary, which is dynamically linked - so it will use the locally installed libc.so. Is there any special reason for using Max? Or could you try to use our statically linked Standard binary instead? Yeah I could try that instead, maybe I should try with 4.0.13 to see if its a problem of that version. Or should I better try 4.0.14 already? I was hosting a couple of bdb-tables for some time, but no longer now. Currently only myisam and innodb-tables so I could try the standard-built too. The problem above looks very similar to the problems we had when we linked against glibc 2.2.3 instead of 2.2.5: under high load, a mysqld thread starts eating up all CPU resources on an SMP system. Unfortunately we never found the reason for that - it did not seem to happen when using glibc 2.2.5... Hmm, maybe 2.2.4 has the same problem? The problem is that the init-process is taking all the cpu, didn't see a mysql-process doing the same before. Thanks, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stalled mysqld-processes?
Hi folks, running mysql-4.0.x since the early versions without any problems, I had a problem 3 days ago. I'm not sure if its mysql-4.0.x-related but maybe anyone may shed a light on it. MySQL is running with the query-cache enabled (16 MB cache for it, 33% cache-hits). That day mysql got pretty unresponsive, connects where just hanging, the shutdown-script didn't shut down mysql because it didn't quit on the TERM-signal, only KILL really helped to shut it down by force. It was MySQL-4.0.9, in the meantime I've upgraded to 4.0.11. Any problems which could have caused it? Or how could I trace it any further, in case it happens again TIA, Thomas - 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: fatal error
compile php with mysql-support, i.e. configure --with-mysql and so on. If you are on a redhat system and using the installed apache-webserver, then there should be a package php-mysql*.rpm or similar which needs to be installed. Thats not a real mysql-problem. ;-) Thomas On Sun, 1 Dec 2002 07:34:19 +1000 Brendan Mansell [EMAIL PROTECTED] wrote: Hi all, I'm not really sure if I'm posting this to the right list or not, but I've recently installed mysql on a Linux machine in order to learn some mysql/php stuff. However, I've obviously configured something wrongly and can't work out what. The output i get when I try to do anything mysql-ish from my php code is: Fatal error: Call to undefined function: mysql_connect() in /var/www/testphp.php on line 7 To me this says 'mysql isn't installed as far as I can tell' since the connect function is the first thing it does.. but I've looked through documentation and configuration files and I'm stumped. Any help would be appreciated. Thanks, Brendan. - 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?
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
Re: table_cache too high?
thanks a lot for both replies. I just asked as this question was brought up with the post before mine. I will ask further off-list :-). Thomas On Wed, 20 Nov 2002 15:25:32 +0100 Thomas Seifert [EMAIL PROTECTED] wrote: 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: why is this slow?
On Tue, 12 Nov 2002 10:24:34 +0800 Jaime Teng [EMAIL PROTECTED] wrote: At 04:47 PM 11/11/2002 +0800, Thomas Seifert wrote: Are you using MySQL-3.23.x? AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does). Maybe thats the cause? Hi, Yes. Im using 3.23.52(nt). I just upgraded it from 3.23.27. You mean, if I have ORDER BY as part of the query statement, MySQL doesnot use index/keys? Does this mean, that there is absolutely no way to improve my query? Not sure, I'm no pro on all the ways to optimize queries, maybe someone other on the list has some more ideas? Hmm.. I read lots of good stuffs with MySQL 4.x; is this already safe to use? I'm using it in production on myphorum.de for some months already, works without a hitch so far. Thomas regards, jaime Thomas On Mon, 11 Nov 2002 16:41:50 +0800 Jaime Teng [EMAIL PROTECTED] wrote: Hi, I have a mysql table: mysql describe eventlog; +-+--+ | Field | Type | +-+--+ | id | int(10) unsigned | | time| datetime | | source | varchar(10) | | description | varchar(255) | +-+--+ id is a unique auto_increment key. the way data is entered, this key is always sorted. and most importantly, it is a KEY index too. Currently, this table has about 400,000 entries occupying about 30MB of hard disk space. Whenever I try to perform: SELECT * FROM eventlog where id number ORDER BY id DESC limit 20; The result is very slow, taking 5~10 seconds WHEN number is almost at the very top of the list: example, if max(id) is 300, then doing the above search with number being 290, will be very slow. the performance ONLY increases when number is very low OR when select count(*) from eventlog where id number; would give a small number. Is there a way to increase the performance of my table/search? jaime - 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: [reidbryn@doctor.nl2k.ab.ca: Re: help]
create the users again or whatever you had before. Thomas On Sat, 9 Nov 2002 09:38:32 -0700 System Administrator a.k.a. The Root of the Problem [EMAIL PROTECTED] wrote: since my of my customers are reporting that they are getting: Search Results for 'T5Y1M4' Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)No results were found for 'T5Y1M4'. Searching again for the two-digit postal code 'T5'. WHAT must I do to correct his?? On Sat, Nov 09, 2002 at 08:04:45AM -0700, System Administrator a.k.a. The Root of the Problem wrote: Looks as if security got tightened and now next to no databases with Web/php are geting accessed. What needs to be fixed? Customers are yelling. Rectification needed ASAP! forwarded message -- Hi , I corrected the core mysql tables (there was nothing in them) Your root password for mysql is '@!#@$#%' Because there was no user information stored, you'll need to restore their details so they'll be able to access their databases again. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED]http://www.nl2k.ab.ca 990-3244 - 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
4.0.5 estimate?
Hi folks, as I am building a new db-server right now and would like to know if I should wait ... when is 4.0.5 due to arrive? ;-) Thanks, Thomas filter-fodder: sql, query -- +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - 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: phpmyadmin (OT)
I don't want to start a flame but where do take this from? Every security-hole in php has been fixed shortly after it was known. Its as secure as any other server-side scripting-language in the web. Thomas On Fri, 25 Oct 2002 10:40:32 -0500 Ed Carp [EMAIL PROTECTED] wrote: PHP itself is not secure unless special steps are taken to secure it, and even then it's no guarantee. There have been several exploits published against PHP, and a few of them have been root exploits. I avoid PHP when I can, especially on shared servers. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need urgent help recovering after renistall (pleeeease !)
Maybe you didn't specify the correct data-dir in my.cnf? Thomas sql,query On Sun, 6 Oct 2002 09:23:51 +0200 jeroen [EMAIL PROTECTED] wrote: hello, I'm kindof a newbie with MySQL, and recently did something fairly stupid : I installed a new system (I'm running on MacOSX, was 10.1.5.1, now after upgrading it is 10.2.1) and I did not properly do it I'm afraid : I backed up my /usr/local/var directory which contained all my mysql 3.23.28 files. Then I wiped the disk (it needed repartitioning) and installed jaguar. Then I installled mysql from www.entropy.ch packages, which is 3.23.52. then I copied the backups to /usr/local/mysql/data now it doesn't work anymore : mysql select * from reeksen; ERROR 1017: Can't find file: './ETL/reeksen.frm' (errno: 13) even though the file is there : [juturnas-Computer:mysql/data/ETL] jeroen% ls -l total 200 -rwxrwxrwx 1 mysql wheel 476 Jul 8 16:27 auteurs.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 8 16:27 auteurs.MYI -rwxrwxrwx 1 mysql wheel 8650 Jul 2 15:20 auteurs.frm -rwxrwxrwx 1 mysql wheel 1160 Jul 29 15:48 main.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 29 15:48 main.MYI -rwxrwxrwx 1 mysql wheel 9896 Jul 24 21:28 main.frm -rwxrwxrwx 1 mysql wheel88 Jul 24 21:38 reeksen.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 24 21:38 reeksen.MYI -rwxrwxrwx 1 mysql wheel 8664 Jul 9 00:09 reeksen.frm -rwxrwxrwx 1 mysql wheel40 Jul 11 13:44 tijdschriften.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 11 13:44 tijdschriften.MYI -rwxrwxrwx 1 mysql wheel 8676 Jul 11 13:10 tijdschriften.frm -rwxrwxrwx 1 mysql wheel 116 Jul 10 15:20 uitgevers.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 10 15:20 uitgevers.MYI -rwxrwxrwx 1 mysql wheel 8718 Jul 8 21:45 uitgevers.frm what can I do to get this thing working again ? Please ? Any help would be VERY MUCH appreciated ! I need this server to be back up by sunday evening ! thanks ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql Error
if I remember right, there is a php-mysql*rpm package for redhat which corrects this problem. Thomas On Wed, 25 Sep 2002 23:23:07 +1000 Peter Goggin [EMAIL PROTECTED] wrote: The php is as installed from the redhat distribution for 7.3 from the Next handbooks. Do I need to down load a later version of PHP or cn I modify what is already installed? Regards Peter Goggin - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Peter Goggin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 10:30 PM Subject: Re: Mysql Error Hello, Your Apache is OK, but you've got a PHP version that's not configured with the --with-mysql option. You need to recompile PHP if you've installed from the source. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: I have got apache and mysql running on my linux server. When connecting to my web site I get the following error: Fatal error: Call to undefined function: mysql_close() in /usr/local/www/vantweststamps/databaselogin.php on line 15 Does this mena the apache server has not been linked to the mysql functions? Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Documentation question
if you run more than one binary it will NOT use the same physical memory, even if it is the same binary. every programm you run uses its own memory for most parts. Thomas sql, query On Tue, 24 Sep 2002 16:35:21 +0200 Magnus Sundberg [EMAIL PROTECTED] wrote: Dear sirs, I have a small question about the documentation that I do not understand. In your documentation you have a small section regarding running multiple data base servers on the same machine. You are supposed to run the databases on different sockets, communication ports etc. I do understand that, but you do recommend that you have different versions compiled for this issue, even though you can run the database servers with just different switches. From a performance issue, I believe that you should run with just one binary, that will be occupy the same physical memory for the two multithreaded processes, even though they have different command line switches. With two different binarys will the physical memory requirement be twice as much. But it might be easier to get a system working when you have two different binarys. But I believe that users that can recompile your software with some different settings also have the competence to adjust runtime switches. What is wrong with the argumentaion above? /Magnus - 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: transactions...
On Mon, 23 Sep 2002 08:40:59 +0300 (EEST) Iikka Meriläinen [EMAIL PROTECTED] wrote: On Mon, 23 Sep 2002, Daniel Kiss wrote: Hi! At 00:56 2002.09.23._ -0300, you wrote: Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? The real quiestion is: Why do you want to use InnoDB tables when you don't want to use its transaction safe features? The reason for prefering InnoDB over MyISAM? Performance. Most benchmarks show InnoDB is slightly faster than MyISAM, and not to mention its some other benefits. But the performance could be a reason on its own to use InnoDB. I don't mean that MyISAM is bad, not at all. It's simpler to use, after all. But what I mean is that InnoDB can be used in all tasks MyISAM is suitable for, and some tasks will be done faster using InnoDB. But some tasks are really bad in InnoDB, at most selects and worst if it comes to table-scans. Thomas mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sum column in mysql
SELECT *,sum(Duration) as durationsum from table1 WHERE condition should work, Thomas On Wed, 18 Sep 2002 10:32:07 +0300 adi [EMAIL PROTECTED] wrote: Hi, I have a table table1, with a column Duration time type(ex 00:12:30) I want to make a sql selection: SELECT * from table1 WHERE condition, and after that, to make sum of values of column Duration and display it. Any Help? tx - 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: start safe_mysqld
as far as I know you have to start safe_mysqld as root! Thomas On Fri, 13 Sep 2002 12:29:30 +0200 hans schneidhofer [EMAIL PROTECTED] wrote: hi, have a simple question of about starting mysql : staring with a book of mysql I should start mysql as the loggedin-user, which is my case papabaer as follows : safe_mysqld but trying that, I get : [papabaer@hanna papabaer]$ safe_mysqld Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/hanna.develop.business-conzept.at.err: Keine Berechtigung /usr/bin/safe_mysqld: /var/lib/mysql/hanna.develop.business-conzept.at.err: Keine Berechtigung tee: /var/lib/mysql/hanna.develop.business-conzept.at.err: Keine Berechtigung 020913 12:18:57 mysqld ended tee: /var/lib/mysql/hanna.develop.business-conzept.at.err: Keine Berechtigung (Keine Berechtechtigung = no rights) have done a look for all accesses and found that : -rwxr-xr-x1 root root 8173 Apr 9 2001 /usr/bin/safe_mysqld* so - as I can see, it has an executable access. what can I do there ? hope anyone has a glue ? thanks and bye hans - 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
index_priv and creating indexes
Hi folks, just wanting some headsup on the following question. How does the index_priv catch in at all? Does a missing index_priv also block me to create a table with indexes in the create-statement? Or does it only affect the later creating of indexes? Thanks in advance, Thomas sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Gui admin clients - security concern?
for a gui running on your local system the ISP has to open a remote connection which is already security problem. Also the data-flow between your client and the server is not encrypted. Tools like phpMyAdmin run on the ISPs webserver with a local connection and so there is no problem with a remote connection at all. Thomas On Thu, 5 Sep 2002 14:03:02 -0700 neal [EMAIL PROTECTED] wrote: I had a conversation with my ISP wherein I was told that using a GUI admin tool such as MySQLGUi or MySQL Front is a security concern, but that a tool like phpAdminSQL (??) is better becaise they can lock it down. Is this true? Wouldn't they have the same security issues unless phpAdmin was on an SSL or something? Thanks. Neal - 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
where is replication logged?
Hi folks, I was just wondering, where I can see, which queries are used from the bin-log. I am using a setup with ...do-table so I restricted it but I am not sure if all the queries are taken to update the tables. is there a log where I can see, what was done? I looked at the relay-log but mysqlbinlog (from 3.x.) didn't show all the lines in there!? And for the records, 3.23.49 as master and 4.0.2 as slave, both on the same machine with different ports and sockets. Any ideas? Thomas PS: for the filter sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL over NFS
Isn't that what the MySQL-Replication is for? Thomas On Tue, 20 Aug 2002 08:07:24 -0500 Brian Moon [EMAIL PROTECTED] wrote: This is an interesting idea. I would be a happy man if it would actually work. My experiences with NFS would lead me to believe that this would not help and could hurt the performance of existing MySQL server even more. My use has been limited to a file server for our web nodes, so, this is a bit different. Let us know if you try it and how it turns out. - Original Message - From: Luis Calero [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 5:39 AM Subject: MySQL over NFS | | Hi... I've got the folowing question, our servers are running pretty | busy these days and our main DB server is taking high load peaks (memory | is OK but the cpu has almost no idle time). We have another spare server | and I'm thinking about mounting the database over NFS (100mb LAN) to the | spare server and using both as frontends to the DB. Both servers are | supposed to do reads and updates to the DB, but i'm concerned with the | updates of the server using NFS. | | Are NFS locks safe enough to run this kind of setup? Is this going to be | an advantage or will suffer from other kinds of problems? Both boxes are | PIII dual 1Ghz / 1Gb ram, Linux 2.4.16, MySQL 3.23.52 | | Thanx | | -- | L | | | - | 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: Persisten Connections
it will reduce the load for sure! MySQL is very fast in opening and closing connections at least if the database-server and webserver are on the same machine. I don't know how it will perform on different machines. Thomas On Wed, 14 Aug 2002 14:40:31 +0100 John Wards [EMAIL PROTECTED] wrote: I am running a website which generates around 100,000 pageviews a day and I am wondering if I stop using persistent conections to the MySQL database and use normal open and close conections this would reduce the load onto my server? Most conections are either made through my main file or the phorum message board system. Thanks in advance John Wards - 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: Persisten Connections
And I disagree with this view. If you've got a server with 512 MB RAM and running the webserver and the db-server on the same machine, 100 idling mysql-processes are a HUGE overhead. At most if not every http-request requires a mysql-connection. I did many benchmarks and I got a huge decrease of the server-load as I disallowed persistent connections through the php.ini. I am serving around 180K pageviews/day with this config and on the described server. AFAIK it is MUCH more than 100K per mysql-process and a large process table is also of no gain. I may have to agree to your view but only if you have different servers for webserver and database, but I never tested such a config. Thomas On Wed, 14 Aug 2002 11:14:33 -0400 Tod Harter [EMAIL PROTECTED] wrote: On Wednesday 14 August 2002 09:54 am, Thomas Seifert wrote: I disagree entirely Persistent connections have little or nothing to do with increasing load! Given that you mention you are using PHP I'll assume you have mod_php running in Apache. Each Apache child process in this configuration will maintain ONE open database handle, so 100k pageviews per day I would expect you might max at like 30k in one hour, or around 10/second, so you might top out at roughly 100 Apache child processes at any one time, thus 100 database connections. Each DB connection is not a huge overhead, but creating and destroying 10 database handles PER SECOND is a large overhead!!! Remember, every time mysql creates a connection it has to do internal queries on the grant tables. I don't know exactly what the overhead of that is going to be, but ANYTHING that creates 10 queries per second is putting some strain on your database server! One of the main goals of using Apache modules for scripting was to allow persistent database connections. There is really NO reason to give up that advantage. Remember, MySQL is multi-threaded, with one thread per connection, so the resources for a database connection are on the order of under 100k of memory per connection. it will reduce the load for sure! MySQL is very fast in opening and closing connections at least if the database-server and webserver are on the same machine. I don't know how it will perform on different machines. Thomas On Wed, 14 Aug 2002 14:40:31 +0100 John Wards [EMAIL PROTECTED] wrote: I am running a website which generates around 100,000 pageviews a day and I am wondering if I stop using persistent conections to the MySQL database and use normal open and close conections this would reduce the load onto my server? Most conections are either made through my main file or the phorum message board system. Thanks in advance John Wards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL eating all memory
maybe too high sort-buffers and so on (in my.cnf) ? Thomas On Tue, 13 Aug 2002 22:02:42 +0200 [EMAIL PROTECTED] wrote: Hi, mysql 3.23.51 is running on a Linux 2.4.18 box (4cpu, 2GB) with Apache 1.3.39. The server is under load (~160 mysqld processes; 80-120 queries/second shown by mysqladmin status). The problem is that mysqld´s memory usage is growing all the time from 17MB after start up to 500MB 5 hours later. System load grows from 0.4 to 3. We have the same problem for earlier versions of mysql (ex. 3.23.49). Does anyone know this problem? Any solutions? Sincerely, Matt - 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
How stable is v4? (was: Re: InnoDB vs. MyISAM on large number of tables?)
On Thu, 8 Aug 2002 03:02:40 -0700 Jeremy Zawodny [EMAIL PROTECTED] wrote: btw: I did a quick benchmark with mysql4 and its query caching running with innodb. Quite impressive, the app run with double the number of pages per second as before. Excellent. MySQL 4.0.{2,3} is working well for us too. Is there 4.0.3 already somewhere to download? At all, how stable is 4.0.x already? afaik its labelled alpha on the website but I heard some talking about beta-quality. Is there an official bug-list for v4? I would like to give it a shot on a production-system 'cause of that fantastic speed increase. Thomas - 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
many tables in one database, impact on performance?
Hi folks, just another question. I have a lot of tables in one mysql-database (around 3200 for now) because I am running Phorum with a lot of boards. (yes I am working on it to split it in different databases but it can take a while). So my question is ... does that mass of tables in one database have some impact on the performance of mysql? Could it be, that it creates higher load on the server it is running? Thanks in advance, Thomas -- Thomas Seifert mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-bin.001 --- files?
Hi Folks, I am running a webserver with around 100.000 hits per day running mostly on PHP / MySQL. In the mysql-data-directory (for my home /var/lib/mysql) I find a some files named: ./server-bin.009 ./server-bin.010 ./server-bin.011 ./server-bin.012 ./server-bin.013 ./server-bin.014 and so on (001 - 014). Some of them are really HUGE (300 MB i.e.) ... which is bigger than my whole database. Could someone tell me what this files are for? Thanks in advance and sorry for my bad english Thomas -- Thomas Seifert mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: -bin.001 --- files?
Wow 300 MB logs ;-). Thanks a lot! Thomas At 11:35 09.06.2001, you wrote: They are mysql binary logs of updates to your databases, and are usually only needed for replication across multiple servers. If you don't need this, remove or comment out the log-bin line from /etc/my.cnf and restart mysqld, then you can delete them. Hi Folks, I am running a webserver with around 100.000 hits per day running mostly on PHP / MySQL. In the mysql-data-directory (for my home /var/lib/mysql) I find a some files named: ./server-bin.009 ./server-bin.010 ./server-bin.011 ./server-bin.012 ./server-bin.013 ./server-bin.014 and so on (001 - 014). Some of them are really HUGE (300 MB i.e.) ... which is bigger than my whole database. Could someone tell me what this files are for? Thanks in advance and sorry for my bad english Thomas - 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 -- Thomas Seifert mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How many Mysql PIDs ?
Hi Bob, thas just a difference in the apache-config from caldera. That has nothing to do with mysql! Thomas - Original Message - Jeremy, Yeah I follow you and as a LInux user of 5 years I am accustomed to seeing multiple processes launched for the same executable but I installed the same version of Mysql on a 2nd machine on my LAN. The difference being the 2nd installation was on Caldera 2.4 edesktop and was the rpm install.. My process question was vs. regarding the compiled from source same version on Caldera 2.3..Same version of Mysql should Launch the same processes, No? The rpm package shows these associated processes only when I command #prompt ps x 679S 0:00 sh /usr/bin/safe_mysql --user=mysql --pid-file=/var/ 774S 0:01 httpd -f /etc/httpd/conf/httpd.conf -D AUTH_MYSQL -D The src package shows these associated processes only when I command #prompt ps x 754 ?S 0:00 httpd -f /etc/httpd/apache/conf/httpd.conf 790 ?S 0:00 sh /usr/local/mysql/bin/safe_mysqld --user=root --pid 858 ?SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ 875 ?SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ 876 ?SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ Notice the difference in the apache server conf between versions... The compiled source did not produce a mod auth_mysql.conf Which is named in a IfDefine AUTH)_MYSQL in a Apache.conf It appears to use a mod_dav.conf a mod_perl.conf, a mod_php.conf and a mod_roaming.conf ONLY on Caldera 2.4 rpm install of MYSQL or perhaps, is this some module coding stuck in there by CALDERA with 2.4 ver.? Please Shine a light over here .. :^) .. Bob T - 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