Re: Help for very bad perf for MySQL
Le 26/11/2007 à 13:31:12+0100, Jan Catrysse a écrit I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). 6 seconds seem to be an awful lot. What kind of query are you running on what kind of database / contents? I don't really known it's some scientifical data. But the problem is on a basic linux pc (with SATA disk) the time is 0.6 sec with same request and same data. And it's for web applications. At 6 sec for one request it's become very long for the visitor because the application make many requests. Regards -- Albert SHIH Did you try pinpointing down the problem to make sure their is not another bottleneck? Is the system running in production environment for the moment or are you the sole user? No the server is empty (only root can logging) and no service running (other thant Mysql and apache). And when I try this test the load of the server is near zero. How did you install MySQL? I my experience (but I can be wrong) the default settings give the best performance on 5.x MySQL FreeBSD 6.2. So no Linux threads and stuff... Directly from the ports. Regards. JAS -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Mar 27 nov 2007 14:00:40 CET ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Help for very bad perf for MySQL
Le 26/11/2007 à 13:29:35+0100, Ivan Voras a écrit Albert Shih wrote: Hi all I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. For starts, if you didn't do it already, copy /usr/local/share/mysql/my-huge.cnf to /etc/my.cnf and try again. These are just some general settings, they might or might not help you. It's change nothing but thanks for you answer Regards. JAS -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Mar 27 nov 2007 14:02:06 CET ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Help for very bad perf for MySQL
Le 26/11/2007 à 07:20:43-0500, Philip M. Gollucci a écrit Albert Shih wrote: Hi all I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. Well -- we'll need more information, but as your say, if its not threading related what makes you think its FreeBSD. You'd probably have better luck over on [EMAIL PROTECTED] Thanks for this information. Also, your my.cnf is the next step. [client] port= 3306 socket = /tmp/mysql.sock [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8 log-bin=mysql-bin server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout Regards. JAS -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Mar 27 nov 2007 14:02:31 CET ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Help for very bad perf for MySQL
On Mon, 26 Nov 2007 13:03:19 +0100 Albert Shih [EMAIL PROTECTED] wrote: I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. I don't really known it's some scientifical data. But the problem is on a basic linux pc (with SATA disk) the time is 0.6 sec with same request and same data. And it's for web applications. At 6 sec for one request it's become very long for the visitor because the application make many requests. It may also be a simple database administration issue: If selects are taking so long, I'd strongly suspect that an INDEX table is either missing or damaged. Are you 100% sure that the database schema is *identical* on the Linux and FreeBSD machines? Perhaps dropping and rebuilding the index tables could speed things up? You could also try to listen to the disks while that slow select is performed: if the disks are thrashing, AND the swap activity is not really higher than else (vmstat -s, or top), it's a dead giveaway that mysqld is doing more disk i/o than necessary, i.e. check the index tables. If on the contrary the disks are quiet while the select runs, check if mysqld is accumulating CPU time (with top): if it is NOT, I'd guess it is some issue with the threading library, i.e. some threads are deadlocked and waiting. -cpghost. -- Cordula's Web. http://www.cordula.ws/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Help for very bad perf for MySQL
-Original Message- From: Albert Shih [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 5:00 AM To: Ted Mittelstaedt Cc: freebsd-questions@freebsd.org Subject: Re: Help for very bad perf for MySQL Le 26/11/2007 à 22:34:34-0800, Ted Mittelstaedt a écrit Sorry yeasterday I don't have time to answer you. I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. The server have two SAS 10 000 tr/m disks. Anyone have some advise to tunning FreeBSD or MySQL for increase the perf ? Start with the obvious stuff first. How big is the database? How big is system ram? If you have less ram than you have database then mysql will have to go to the hard disk for the select which will kill it's performance. Well : Database size ~ 180Mo Ram of server = 4 Go 2 processeurs. Nothing run on this server (charge is near zero). The disk I/O is running very fast. The make buildworld is fast too (I don't have measure but it's «fast» ;-)) Is Hyperthreading enabled (by default it is not under FreeBSD) mysql is heavily dependent on threading, if it is not built and linked into the freebsd threads package you will get poor performance. Some folks have installed the linux compat libs and linked mysql into the linux threads package and reported good results. Ted ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Help for very bad perf for MySQL
Is Hyperthreading enabled (by default it is not under FreeBSD) mysql is heavily dependent on threading, if it is not built and linked into the freebsd threads package you will get poor performance. Some folks have installed the linux compat libs and linked mysql into the linux threads package and reported good results. Actually, on 6.2, it's better to use libthr instead of libpthread. This can be done for MySQL only, but to test this without recompiling MySQL, he can: % echo libpthread.so.2 libthr.so.2 /etc/libmap.conf Then restart the mysql server and test again. I noticed a huge increase in performance on 6.2 with libthr instead of libpthread. It wasn't a 10x improvement, though, so there is definitely something else going on with his setup. Regards, Josh ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Help for very bad perf for MySQL
-Original Message- From: [EMAIL PROTECTED] [mailto:owner-freebsd- [EMAIL PROTECTED] On Behalf Of Josh Carroll Sent: Tuesday, November 27, 2007 8:12 AM To: Ted Mittelstaedt Cc: [EMAIL PROTECTED]; freebsd-questions@freebsd.org Subject: Re: Help for very bad perf for MySQL Is Hyperthreading enabled (by default it is not under FreeBSD) mysql is heavily dependent on threading, if it is not built and linked into the freebsd threads package you will get poor performance. Some folks have installed the linux compat libs and linked mysql into the linux threads package and reported good results. Actually, on 6.2, it's better to use libthr instead of libpthread. This can be done for MySQL only, but to test this without recompiling MySQL, he can: % echo libpthread.so.2 libthr.so.2 /etc/libmap.conf Then restart the mysql server and test again. I noticed a huge increase in performance on 6.2 with libthr instead of libpthread. It wasn't a 10x improvement, though, so there is definitely something else going on with his setup. Regards, Josh Here are some things that helped us on a high-volume MySQL server. -- /etc/sysctl.conf -- (these can be added dynamically from the command line) kern.threads.max_groups_per_proc=4 kern.threads.max_threads_per_proc=4 kern.maxfiles=65535 kern.maxfilesperproc=65535 -- /boot/loader.conf -- (You'll have to reboot for these to take effect) kern.maxdsiz=1073741824 # 1GB kern.dfldsiz=1073741824 # 1GB kern.maxssiz=134217728 # 128MB -- /etc/libmap.conf -- (as Josh said) [mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so Regards, Mike ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Help for very bad perf for MySQL
Hi all I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. The server have two SAS 10 000 tr/m disks. Anyone have some advise to tunning FreeBSD or MySQL for increase the perf ? Regards -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Lun 26 nov 2007 12:46:06 CET ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Help for very bad perf for MySQL
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Shih Sent: Monday, November 26, 2007 12:50 PM To: freebsd-questions@freebsd.org Subject: Help for very bad perf for MySQL Hi all I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. The server have two SAS 10 000 tr/m disks. Anyone have some advise to tunning FreeBSD or MySQL for increase the perf ? Regards -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Lun 26 nov 2007 12:46:06 CET 6 seconds seem to be an awful lot. What kind of query are you running on what kind of database / contents? Regs, Jan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Help for very bad perf for MySQL
Le 26/11/2007 à 13:01:47+0100, Jan Catrysse a écrit -Original Message- I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. The server have two SAS 10 000 tr/m disks. Anyone have some advise to tunning FreeBSD or MySQL for increase the perf ? Regards -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Lun 26 nov 2007 12:46:06 CET 6 seconds seem to be an awful lot. What kind of query are you running on what kind of database / contents? I don't really known it's some scientifical data. But the problem is on a basic linux pc (with SATA disk) the time is 0.6 sec with same request and same data. And it's for web applications. At 6 sec for one request it's become very long for the visitor because the application make many requests. Regards -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Lun 26 nov 2007 13:00:32 CET ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Help for very bad perf for MySQL
Albert Shih wrote: Hi all I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. Well -- we'll need more information, but as your say, if its not threading related what makes you think its FreeBSD. You'd probably have better luck over on [EMAIL PROTECTED] A good start would be the query itself, and the output of EXPLAIN for that query. Also, your my.cnf is the next step. -- Philip M. Gollucci ([EMAIL PROTECTED]) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/EC88A0BF 0DE5 C55C 6BF3 B235 2DAB B89E 1324 9B4F EC88 A0BF Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Help for very bad perf for MySQL
Albert Shih wrote: Hi all I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. For starts, if you didn't do it already, copy /usr/local/share/mysql/my-huge.cnf to /etc/my.cnf and try again. These are just some general settings, they might or might not help you. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Help for very bad perf for MySQL
I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). 6 seconds seem to be an awful lot. What kind of query are you running on what kind of database / contents? I don't really known it's some scientifical data. But the problem is on a basic linux pc (with SATA disk) the time is 0.6 sec with same request and same data. And it's for web applications. At 6 sec for one request it's become very long for the visitor because the application make many requests. Regards -- Albert SHIH Did you try pinpointing down the problem to make sure their is not another bottleneck? Is the system running in production environment for the moment or are you the sole user? How did you install MySQL? I my experience (but I can be wrong) the default settings give the best performance on 5.x MySQL FreeBSD 6.2. So no Linux threads and stuff... Regs, Jan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Help for very bad perf for MySQL
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Albert Shih Sent: Monday, November 26, 2007 3:50 AM To: freebsd-questions@freebsd.org Subject: Help for very bad perf for MySQL Hi all I've already send a message. But I don't receive any answer :-(. I try again and hope there more solution I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql 5.X on this server and the performance of MySQL is very bad. For some complexe select I've got ~6secondes (on some basic Linux it's take 0.6 sec). And I think this is nothing about thead (that's mean I don't think FreeBSD 7.0 can solve my problem) because it's just for one select. The server have two SAS 10 000 tr/m disks. Anyone have some advise to tunning FreeBSD or MySQL for increase the perf ? Start with the obvious stuff first. How big is the database? How big is system ram? If you have less ram than you have database then mysql will have to go to the hard disk for the select which will kill it's performance. Ted ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Whatever happend to the MySQL Administrator port?
MySQL has a handy graphical front-end called mysql-administrator. There used to be a port for it (databases/mysql-administrator). The port was marked broken in February and deleted in April. The last CVS entry reads: Remove databases/mysql-administrator. It's a part of MySQL Tools now and don't supported separately. Are the MySQL Tools part of another port? How do I get them? Cheers, -- Norbert. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql ports
On Thu, Nov 22, 2007 at 10:23:01AM -0800, jekillen wrote: Hello; I have installed mysql51-client, mysql51-server, and mysql51-scripts. I looked for pkg_message in mysql51-scripts but there is none. Where do I get info on what this port has and what it does? Take a look at the port's directory under /var/db/pkg. It should contain files called `+COMMENT', `+CONTENTS' and `+DESC', which will tell you what you want to know. HTH Dan -- Daniel Bye _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql ports
On Thu, Nov 22, 2007 at 10:23:01AM -0800, jekillen wrote: Hello; I have installed mysql51-client, mysql51-server, and mysql51-scripts. I looked for pkg_message in mysql51-scripts but there is none. Where do I get info on what this port has and what it does? Thank you for info pkg_info -Lx mysql-scripts|less -S From there you can use man(1) or Google. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Tunning Mysql
Hi all I've some question about MySQL on FreeBSD 6.x. I've running MySQL 5.x on FreeBSD 6.x on a dual Xeon 3.2Ghz (mono-core) with 2 SAS 1 rpm. And the perf is very...poor (x10 vs Linux) and it's nothing about thread because the performance is poor for a single select in mysql. I known you want to say when 7.0 come out everything go fine hummm Well, event it's true I cannont make the migration so fast. What's I want to known is how can tunning my FreeBSD and my Mysql for increase the performance. What's option I need to choose on mysql compilation. etc I forget to say the Mysql run into a jail but I think this don't have any impact. Regards. -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Ven 23 nov 2007 23:09:02 CET ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
lightly loaded php+mysql - high syscall/csw rates
We have a php+mysql web server. It serves 15-20 http requests per second, resulting in 100-200 sql qps. But according to vmstat(1), it all peaks at over 500k syscall/s and 100k cswitch/s. The peaks are quite frequent, even at this load. During the peaks top(1) shows 30-40k VCSW for mysql and around 1k vcsw for two php-cgi worker processes. IVCSW is relatively very low for all processes. This is a 4-core Opteron HP DL145 G2 server running 6.2/amd64 generic+quota. I'm considering a switch to 7.0. During peaks user/system/idle in top(1) is 20/30/50. The question is - is the syscall and csw rates normal or should I be trying to tune mysql and php more agressively? I'm not hungry for performance (haven't hit the limit yet), but a couple of days ago the server stopped responding until a cold reboot (which is another story) - and now I'm paying closer attention to its vitals. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: lightly loaded php+mysql - high syscall/csw rates
Andrew Pantyukhin wrote: We have a php+mysql web server. It serves 15-20 http requests per second, resulting in 100-200 sql qps. But according to vmstat(1), it all peaks at over 500k syscall/s and 100k cswitch/s. The peaks are quite frequent, even at this load. During the peaks top(1) shows 30-40k VCSW for mysql and around 1k vcsw for two php-cgi worker processes. IVCSW is relatively very low for all processes. This is a 4-core Opteron HP DL145 G2 server running 6.2/amd64 generic+quota. I'm considering a switch to 7.0. During peaks user/system/idle in top(1) is 20/30/50. The question is - is the syscall and csw rates normal or should I be trying to tune mysql and php more agressively? I'm not hungry for performance (haven't hit the limit yet), but a couple of days ago the server stopped responding until a cold reboot (which is another story) - and now I'm paying closer attention to its vitals. This sounds like it could be related to the issues being discussed on a thread on freebsd-stable titled 2 x quad-core system is slower that 2 x dual core on FreeBSD [http://docs.freebsd.org/cgi/mailindex.cgi?sort=subjectfile=current/freebsd-stable] Switching to 7 and SCHED_ULE may gain you perfromance for this kind of workload over 4 cores going by the benchmarks provided by Kris Kennaway, although they mainly deal with 8 core systems. Forcing MySQL to use libthr instead of libpthread in libmap.conf may also help also and going solely by one post in the thread mentioned above you could try reducing kern.hz in loader.conf to something like 100 as this could help reduce the context switches. Vince ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: lightly loaded php+mysql - high syscall/csw rates
On Thu, Nov 22, 2007 at 02:52:06PM +, Vince wrote: Andrew Pantyukhin wrote: We have a php+mysql web server. It serves 15-20 http requests per second, resulting in 100-200 sql qps. But according to vmstat(1), it all peaks at over 500k syscall/s and 100k cswitch/s. The peaks are quite frequent, even at this load. During the peaks top(1) shows 30-40k VCSW for mysql and around 1k vcsw for two php-cgi worker processes. IVCSW is relatively very low for all processes. This is a 4-core Opteron HP DL145 G2 server running 6.2/amd64 generic+quota. I'm considering a switch to 7.0. During peaks user/system/idle in top(1) is 20/30/50. The question is - is the syscall and csw rates normal or should I be trying to tune mysql and php more agressively? I'm not hungry for performance (haven't hit the limit yet), but a couple of days ago the server stopped responding until a cold reboot (which is another story) - and now I'm paying closer attention to its vitals. This sounds like it could be related to the issues being discussed on a thread on freebsd-stable titled 2 x quad-core system is slower that 2 x dual core on FreeBSD [http://docs.freebsd.org/cgi/mailindex.cgi?sort=subjectfile=current/freebsd-stable] Yeah, I'm following that thread, I just wanted to know if anyone else gets 500k+ syscalls per second on an php+mysql web server at 20 pages per second. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql ports
Hello; I have installed mysql51-client, mysql51-server, and mysql51-scripts. I looked for pkg_message in mysql51-scripts but there is none. Where do I get info on what this port has and what it does? Thank you for info Jeff K ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: lightly loaded php+mysql - high syscall/csw rates
On Thu, Nov 22, 2007 at 12:43:25PM +0300, Andrew Pantyukhin wrote: We have a php+mysql web server. It serves 15-20 http requests per second, resulting in 100-200 sql qps. But according to vmstat(1), it all peaks at over 500k syscall/s and 100k cswitch/s. The peaks are quite frequent, even at this load. During the peaks top(1) shows 30-40k VCSW for mysql and around 1k vcsw for two php-cgi worker processes. IVCSW is relatively very low for all processes. This is a 4-core Opteron HP DL145 G2 server running 6.2/amd64 generic+quota. I'm considering a switch to 7.0. During peaks user/system/idle in top(1) is 20/30/50. The question is - is the syscall and csw rates normal or should I be trying to tune mysql and php more agressively? I'm not hungry for performance (haven't hit the limit yet), but a couple of days ago the server stopped responding until a cold reboot (which is another story) - and now I'm paying closer attention to its vitals. Andrew, I don't know if you've been following stable@ but there is a long thread there about php performance (amongst other things). http://lists.freebsd.org/pipermail/freebsd-stable/2007-November/038371.html Titled: 2 x quad-core system is slower that 2 x dual core on FreeBSD[sic] Apologies, if it's not related to the problem you're seeing. (It's over my head). -- Frank Contact info: http://www.esperance-linux.co.uk/misc/contact.html ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql install Q
Hello; The following is what I get when I do mysql_install_db. /libexec/ld-elf.so.1: Shared object libcrypt.so.2 not found, required by my_print_defaults /libexec/ld-elf.so.1: Shared object libcrypt.so.2 not found, required by my_print_defaults (yes, the same message twice) I looked in ports for crypt but I do not know what exactly to look for to satisfy this complaint. In addition I got the following complaint: Neither host 'this_host.domain.tld' nor 'localhost' could be looked up with ./bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option This is strange because this is also secondary dns server for the domain. I looked in ports at what is available for mysql and there are a number of listings for various versions. For a particular version there appear to be three separate directories, client, server, and scripts. I am a little confused as to what all to build and install. Now that I have gotten a handle on using ports, I am doing it that way instead of my initial approach, get the tarballs unzip, configure, make and make install (and hope for the best). This happens to be one of those, accept it is a prebuilt binary package. mysql-max-5.0.18-freebsd5.3-i386 (hmmm...5.3?...) I will try to remove every thing it installed and got to ports if I can not solve the immediate problems. Any advice, suggestions, data appreciated. Thank you Jeff k ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql install Q
jekillen wrote: Hello; The following is what I get when I do mysql_install_db. /libexec/ld-elf.so.1: Shared object libcrypt.so.2 not found, required by my_print_defaults /libexec/ld-elf.so.1: Shared object libcrypt.so.2 not found, required by my_print_defaults (yes, the same message twice) I looked in ports for crypt but I do not know what exactly to look for to satisfy this complaint. In addition I got the following complaint: Neither host 'this_host.domain.tld' nor 'localhost' could be looked up with ./bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option This is strange because this is also secondary dns server for the domain. I looked in ports at what is available for mysql and there are a number of listings for various versions. For a particular version there appear to be three separate directories, client, server, and scripts. I am a little confused as to what all to build and install. Now that I have gotten a handle on using ports, I am doing it that way instead of my initial approach, get the tarballs unzip, configure, make and make install (and hope for the best). This happens to be one of those, accept it is a prebuilt binary package. mysql-max-5.0.18-freebsd5.3-i386 (hmmm...5.3?...) I will try to remove every thing it installed and got to ports if I can not solve the immediate problems. Sounds a good idea. If you have an up-to-date ports tree and then install /usr/ports/databases/mysql50-server, you should get a current version of MySQL 5.0 (although 5.1 is out now), and you you will also get the client as a dependency, so you can run your server and talk to it as well. As for the problem above, the current libcrypt.so is linked to libcrypt.so.3, so your tarball is too old for your current system. Use ports instead ;-) And, finally, what does `hostname` return on your system? Kevin Kinsey -- I refuse to consign the whole male sex to the nursery. I insist on believing that some men are my equals. -- Brigid Brophy ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Which knobs do I use to control BDB use in MySQL-server port?
Hi Dan, One last thing (It's way past my bedtime here ;-p) See that --with-berkeley-db in there? :-( A little digging in the mysql ditribution's source files dredged up the CONF_COMMAND variable. Do-ing, CONF_COMMAND=--without-berkeley-db; export $CONF_COMMAND perl -pi -e 's/^(CONFIGURE_ARGS.*)with-berkeley-db(.*)$/$1without-berkeley-db$2/g' Makefile Seems to do the trick as far as the build /process/ goes, grep berkeley-db ./work/mysql-5.0.45/config.log | grep $ ./configure $ ./configure --localstatedir=/var/db/mysql --without-debug --without-readline --without-libedit --without-bench --without-extra-tools --with-libwrap --with-mysqlfs --with-low-memory --with-comment=FreeBSD port: mysql-server-5.0.45 --enable-thread-safe-client --with-openssl=/usr/local --enable-assembler --without-berkeley-db --with-named-thread-libs=-pthread --prefix=/usr/local --mandir=/usr/local/man --infodir=/usr/local/info/ --build=i386-portbld-freebsd6.2 See the --without-berkeley-db is there, now. I'll check the build's output with ldd when the build finishes. For now, my pooch inists that it's lights out :-} Ali ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Which knobs do I use to control BDB use in MySQL-server port?
I'll check the build's output with ldd when the build finishes. Looks like the simple workaround works :-) ldd /usr/local/libexec/mysqld libz.so.3 = /lib/libz.so.3 (0x284a8000) libwrap.so.4 = /usr/lib/libwrap.so.4 (0x284b9000) libssl.so.5 = /usr/local/lib/libssl.so.5 (0x284c) libcrypto.so.5 = /usr/local/lib/libcrypto.so.5 (0x284fc000) libcrypt.so.3 = /lib/libcrypt.so.3 (0x28642000) libstdc++.so.5 = /usr/lib/libstdc++.so.5 (0x2865a000) libm.so.4 = /lib/libm.so.4 (0x28725000) libpthread.so.2 = /lib/libpthread.so.2 (0x2873b000) libc.so.6 = /lib/libc.so.6 (0x2876) Port install's done -- with No BDB. Great! Bye, Ali ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Which knobs do I use to control BDB use in MySQL-server port?
Hi everybody, I'm building my 1st FreeBSD-based box. Yay, I guess ;-p I've already installed Berkeley DB v46 from the Ports system. Now, I'ts on to MySQL server. I can easily build manually from source, configuring whatever I need. But, I'm trying to get the Ports system's knobs figured out :-/ Building the databases/mysql50-server Port, I see (they'er all in Makefile, yes?) my choices for knob-settings in make.conf are: WITH_OPENSSL=true WITH_PROC_SCOPE_PTH=yes BUILD_OPTIMIZED=yes WITH_INNODB=yes WITHOUT_ARCHIVE=true WITHOUT_CSV=true WITHOUT_FEDERATED=true WITHOUT_NDB=true Turning INNODB on/off is clear. But I haven't been able to grok how to (1) Turn OFF use of BDB completely. The build seems to default to the bundled BDB (2) Use the Port install of BDB v46 I mentioned above. Can somebody explaing the right knobs to turn to do both? Or, do I have to rely on manual configuration? THanks a lot! Ali ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Which knobs do I use to control BDB use in MySQL-server port?
In the last episode (Sep 18), Aliya Harbouri said: Building the databases/mysql50-server Port, I see (they'er all in Makefile, yes?) my choices for knob-settings in make.conf are: WITH_OPENSSL=true WITH_PROC_SCOPE_PTH=yes BUILD_OPTIMIZED=yes WITH_INNODB=yes WITHOUT_ARCHIVE=true WITHOUT_CSV=true WITHOUT_FEDERATED=true WITHOUT_NDB=true Turning INNODB on/off is clear. But I haven't been able to grok how to (1) Turn OFF use of BDB completely. The build seems to default to the bundled BDB Mysql 5.0's configure script doesn't seem to have a --without-bdb flag, so it always gets built. (2) Use the Port install of BDB v46 I mentioned above. It does have a --with-berkeley-db=DIR flag, so you could add that to CONFIGURE_ARGS to force an external bdb to be used instead of the one bundled with mysql. Note that the bdb engine has been removed from mysql 5.1, so you should think about moving any bdb tables you might already have to innodb. Development on the bdb engine pretty much stopped once innodb was available. -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Which knobs do I use to control BDB use in MySQL-server port?
Hi Dan!
(1) Turn OFF use of BDB completely. The build seems to default to the
bundled BDB
Mysql 5.0's configure script doesn't seem to have a --without-bdb flag,
so it always gets built.
(2) Use the Port install of BDB v46 I mentioned above.
It does have a --with-berkeley-db=DIR flag, so you could add that to
CONFIGURE_ARGS to force an external bdb to be used instead of the one
bundled with mysql. Note that the bdb engine has been removed from
mysql 5.1, so you should think about moving any bdb tables you might
already have to innodb. Development on the bdb engine pretty much
stopped once innodb was available.
Gotcha!
So, If I'm going to use the Port make changes anyway, since,
grep berkeley-db Makefile
CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
I suppose I might as well just do
vi Makefile
.if ${ARCH} == i386
- CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
+ CONFIGURE_ARGS+=--enable-assembler --without-berkeley-db
.endif
I know about the BDB-engine removal, too. Funny that this Port
doesn't give you that option.
Thanks a lot!
Ali
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Which knobs do I use to control BDB use in MySQL-server port?
In the last episode (Sep 19), Aliya Harbouri said:
(1) Turn OFF use of BDB completely. The build seems to default
to the bundled BDB
Mysql 5.0's configure script doesn't seem to have a --without-bdb
flag, so it always gets built.
(2) Use the Port install of BDB v46 I mentioned above.
It does have a --with-berkeley-db=DIR flag, so you could add that
to CONFIGURE_ARGS to force an external bdb to be used instead of
the one bundled with mysql. Note that the bdb engine has been
removed from mysql 5.1, so you should think about moving any bdb
tables you might already have to innodb. Development on the bdb
engine pretty much stopped once innodb was available.
Gotcha!
So, If I'm going to use the Port make changes anyway, since,
grep berkeley-db Makefile
CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
I suppose I might as well just do
vi Makefile
.if ${ARCH} == i386
- CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
+ CONFIGURE_ARGS+=--enable-assembler --without-berkeley-db
.endif
I just tried it and it looks like that does disable bdb. I never
noticed that line in the Makefile before :)
I know about the BDB-engine removal, too. Funny that this Port
doesn't give you that option.
Thanks a lot!
Ali
--
Dan Nelson
[EMAIL PROTECTED]
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Which knobs do I use to control BDB use in MySQL-server port?
Hi Dan! I just tried it and it looks like that does disable bdb. I never noticed that line in the Makefile before :) Well, you'd think it should. But even with, grep berkeley-db ./Makefile CONFIGURE_ARGS+=--enable-assembler --without-berkeley-db the build seems to /ignore/ the flag, grep berkeley-db ./work/mysql-5.0.45/config.log | grep $ ./configure $ ./configure --localstatedir=/var/db/mysql --without-debug --without-readline --without-libedit --without-bench --without-extra-tools --with-libwrap --with-mysqlfs --with-low-memory --with-comment=FreeBSD port: mysql-server-5.0.45 --enable-thread-safe-client --with-openssl=/usr/local --enable-assembler --with-berkeley-db --with-named-thread-libs=-pthread --prefix=/usr/local --mandir=/usr/local/man --infodir=/usr/local/info/ --build=i386-portbld-freebsd6.2 See that --with-berkeley-db in there? :-( Ali ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?
Philip M. Gollucci wrote: my.cnf innodb_thread_concurrency = 8 You want '0' or performance will suck. There's a basic architectural flaw in how mysql handles non-zero concurrency values here (innodb accesses are serialized by a global mutex that protects a counter to check if it should try to allow more innodb concurrency. Duh.) Anyway, assuming your disks can keep up you should see a big performance boost when you switch to 7.0. This is a fairly big if though: I don't know if it's even feasible for a write-heavy database to saturate 8 CPUs instead of being bottlenecked by disk speeds and leaving the CPUs mostly from /usr/local/share/my-innodb-heavy-4G.cnf # This permits the application to give the threads system a hint for the # desired number of threads that should be run at the same time. This # value only makes sense on systems that support the # thread_concurrency() # function call (Sun Solaris, for example). # You should try [number of CPUs]*(2..4) for thread_concurrency thread_concurrency = 8 # Number of IO threads to use for async IO operations. This value is # hardcoded to 4 on Unix, but on Windows disk I/O may benefit from a # larger number. innodb_file_io_threads = 4 # Number of threads allowed inside the InnoDB kernel. The optimal value # depends highly on the application, hardware as well as the OS # scheduler properties. A too high value may lead to thread thrashing. innodb_thread_concurrency = 16 Apparently its only set in this file. We should probably submit a bug to MySQL rather then add a patch to ports or do both and remove the ports when its released. -- Philip M. Gollucci ([EMAIL PROTECTED]) c:323.219.4708 o:703.749.9295x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/EC88A0BF 0DE5 C55C 6BF3 B235 2DAB B89E 1324 9B4F EC88 A0BF Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?
Kris Kennaway wrote: libthr has been around (and performing better than libkse) since the 5.x days and has been recommended for use since 6.0. Yeah I knew it had been around -- missed the recommend part. sysctl kern.timecounter.choice kern.timecounter.choice: TSC(-100) ACPI-fast(1000) i8254(0) dummy(-100) sysctl kern.timecounter.hardware kern.timecounter.hardware: TSC I meant to say that this made a rather large difference. 3) /tmp is a md0 malloc backed device Eh -- I'll switch it. Should be swap backed, but it won't make much difference on your workload. (I'm thinking of using tmpfs in 7.0 when I switch) tmpfs is not yet production-ready even though it performs better. Yeah that I knew, but I haven't had any issues with it on any of my desktops that run it. my.cnf innodb_thread_concurrency = 8 You want '0' or performance will suck. There's a basic architectural flaw in how mysql handles non-zero concurrency values here (innodb accesses are serialized by a global mutex that protects a counter to check if it should try to allow more innodb concurrency. Duh.) Anyway, assuming your disks can keep up you should see a big performance boost when you switch to 7.0. This is a fairly big if though: I don't know if it's even feasible for a write-heavy database to saturate 8 CPUs instead of being bottlenecked by disk speeds and leaving the CPUs mostly idle. Ah boo!!! I have DBs that are SELECT heavy and those that are WRITE heavy. I suppose I'll attached the my.cnf I'm using. Is it worth having the port remove that recommendation from the /usr/local/share/mysql/*.cnf files ? -- Philip M. Gollucci ([EMAIL PROTECTED]) c:323.219.4708 o:703.749.9295x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/EC88A0BF 0DE5 C55C 6BF3 B235 2DAB B89E 1324 9B4F EC88 A0BF Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?
Philip M. Gollucci wrote: Philip M. Gollucci wrote: my.cnf innodb_thread_concurrency = 8 You want '0' or performance will suck. There's a basic architectural flaw in how mysql handles non-zero concurrency values here (innodb accesses are serialized by a global mutex that protects a counter to check if it should try to allow more innodb concurrency. Duh.) Anyway, assuming your disks can keep up you should see a big performance boost when you switch to 7.0. This is a fairly big if though: I don't know if it's even feasible for a write-heavy database to saturate 8 CPUs instead of being bottlenecked by disk speeds and leaving the CPUs mostly from /usr/local/share/my-innodb-heavy-4G.cnf # This permits the application to give the threads system a hint for the # desired number of threads that should be run at the same time. This # value only makes sense on systems that support the # thread_concurrency() # function call (Sun Solaris, for example). # You should try [number of CPUs]*(2..4) for thread_concurrency thread_concurrency = 8 # Number of IO threads to use for async IO operations. This value is # hardcoded to 4 on Unix, but on Windows disk I/O may benefit from a # larger number. innodb_file_io_threads = 4 # Number of threads allowed inside the InnoDB kernel. The optimal value # depends highly on the application, hardware as well as the OS # scheduler properties. A too high value may lead to thread thrashing. innodb_thread_concurrency = 16 Apparently its only set in this file. We should probably submit a bug to MySQL rather then add a patch to ports or do both and remove the ports when its released. I believe the performance bug is well known actually, at least to the www.mysqlperformanceblog.com people which is where I got my test config from. I discovered the reason for it recently when I accidentally ran with a default config (innodb_thread_concurrency defaulted to 8 for me) and spent some time tracking down why performance was terrible until I set it back to 0. Kris ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?
Philip M. Gollucci wrote: Is it worth having the port remove that recommendation from the /usr/local/share/mysql/*.cnf files ? It probably is worth it, yeah. Kris ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql in a jail not starting
i have had many jails, and have never really had any problems with them until this one. for some reason, mysql wont start. nothing else is having any trouble starting, which is strange. is there a log file i can look in that might give me some clues as to whats going on? mysql_enable=YES is in my rc.conf, and when i start it i get: antares# /usr/local/etc/rc.d/mysql-server start Starting mysql. antares# /usr/local/etc/rc.d/mysql-server status mysql is not running. any tips for troubleshooting this would be apprciated. TIA, -- Jonathan Horne http://dfwlpiki.dfwlp.org [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql in a jail not starting
On Thursday 30 August 2007, Jonathan Horne said: i have had many jails, and have never really had any problems with them until this one. for some reason, mysql wont start. nothing else is having any trouble starting, which is strange. is there a log file i can look in that might give me some clues as to whats going on? mysql_enable=YES is in my rc.conf, and when i start it i get: antares# /usr/local/etc/rc.d/mysql-server start Starting mysql. antares# /usr/local/etc/rc.d/mysql-server status mysql is not running. any tips for troubleshooting this would be apprciated. TIA, Read the *.err files in /var/db/mysql. It should tell you why it's failing. Beech -- --- Beech Rintoul - FreeBSD Developer - [EMAIL PROTECTED] /\ ASCII Ribbon Campaign | FreeBSD Since 4.x \ / - NO HTML/RTF in e-mail | http://www.freebsd.org X - NO Word docs in e-mail | Latest Release: / \ - http://www.FreeBSD.org/releases/6.2R/announce.html --- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql in a jail not starting
On Thursday 30 August 2007 14:34:34 Beech Rintoul wrote: Read the *.err files in /var/db/mysql. It should tell you why it's failing. Beech thanks, that led me right to it! antares# /usr/local/etc/rc.d/mysql-server status mysql is running as pid 1738. cheers, -- Jonathan Horne http://dfwlpiki.dfwlp.org [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql in a jail not starting
trouble starting, which is strange. is there a log file i can look in that might give me some clues as to whats going on? mysql_enable=YES is in my rc.conf, and when i start it i get: antares# /usr/local/etc/rc.d/mysql-server start Starting mysql. antares# /usr/local/etc/rc.d/mysql-server status mysql is not running. any tips for troubleshooting this would be apprciated. TIA, any logs already read? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Installing mysql 4.0
Hi I have been trying to get mysql running for the past two days without luck. I added these two packages using sysinstall from FTP. mysql-client-4.0.26_1 Multithreaded SQL database (client) mysql-server-4.0.26_2 Multithreaded SQL database (server) I went to the folder /usr/ports/databases/mysql40-server/ and did a make clean install. Then I created the file /etc/my.cnf like fr# more my.cnf [mysqld] datadir=/usr/local/mysql/data socket=/tmp/mysql.sock [mysql.server] user=mysql basedir=/usr/local/bin/mysql I got stuck at this point. I have been reading online without luck. I do not even know how to start mysql. I hope you guys can point in the right directions. Thanks in advance. Fidel Garcia ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Installing mysql 4.0
Add mysql_enable=YES to your /etc/rc.conf file, and use the /usr/ local/etc/rc.d/mysql-server script to start the process as follows: % su root # /usr/local/etc/rc.d/mysql-server start HTH Eric Crist On Aug 17, 2007, at 9:01 AMAug 17, 2007, Fidel Garcia wrote: Hi I have been trying to get mysql running for the past two days without luck. I added these two packages using sysinstall from FTP. mysql-client-4.0.26_1 Multithreaded SQL database (client) mysql-server-4.0.26_2 Multithreaded SQL database (server) I went to the folder /usr/ports/databases/mysql40-server/ and did a make clean install. Then I created the file /etc/my.cnf like fr# more my.cnf [mysqld] datadir=/usr/local/mysql/data socket=/tmp/mysql.sock [mysql.server] user=mysql basedir=/usr/local/bin/mysql I got stuck at this point. I have been reading online without luck. I do not even know how to start mysql. I hope you guys can point in the right directions. Thanks in advance. Fidel Garcia ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions- [EMAIL PROTECTED] - Eric F Crist Secure Computing Networks ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
FW: Installing mysql 4.0
This is what I found inside this file: /var/db/mysql/fr.admin.err 070816 08:36:14 mysqld started 070816 8:36:14 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://dev.mysql.com/doc/mysql/en/InnoDB.html InnoDB: for installation help. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 070816 08:36:14 mysqld ended Fidel Garcia System Engineer SysTeam. 7205 NW 19th Street, Suite 302 Miami, Florida 33126 Email: [EMAIL PROTECTED] Tel: (305)-477-7303 Fax: (305)-477-0013 http://www.systeamusa.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Crist Sent: Friday, August 17, 2007 11:22 AM To: Fidel Garcia Cc: [EMAIL PROTECTED] Subject: Re: Installing mysql 4.0 Add mysql_enable=YES to your /etc/rc.conf file, and use the /usr/ local/etc/rc.d/mysql-server script to start the process as follows: % su root # /usr/local/etc/rc.d/mysql-server start HTH Eric Crist On Aug 17, 2007, at 9:01 AMAug 17, 2007, Fidel Garcia wrote: Hi I have been trying to get mysql running for the past two days without luck. I added these two packages using sysinstall from FTP. mysql-client-4.0.26_1 Multithreaded SQL database (client) mysql-server-4.0.26_2 Multithreaded SQL database (server) I went to the folder /usr/ports/databases/mysql40-server/ and did a make clean install. Then I created the file /etc/my.cnf like fr# more my.cnf [mysqld] datadir=/usr/local/mysql/data socket=/tmp/mysql.sock [mysql.server] user=mysql basedir=/usr/local/bin/mysql I got stuck at this point. I have been reading online without luck. I do not even know how to start mysql. I hope you guys can point in the right directions. Thanks in advance. Fidel Garcia ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions- [EMAIL PROTECTED] - Eric F Crist Secure Computing Networks ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
FW: Installing mysql 4.0
This is the error I get. I ran the command as root. fr# /usr/local/etc/rc.d/mysql-server start Starting mysql. fr# /usr/local/bin/mysqld_safe: cannot create /var/db/mysql/fr.admin.err: Permission denied Fidel Garcia System Engineer SysTeam. 7205 NW 19th Street, Suite 302 Miami, Florida 33126 Email: [EMAIL PROTECTED] Tel: (305)-477-7303 Fax: (305)-477-0013 http://www.systeamusa.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Crist Sent: Friday, August 17, 2007 11:22 AM To: Fidel Garcia Cc: [EMAIL PROTECTED] Subject: Re: Installing mysql 4.0 Add mysql_enable=YES to your /etc/rc.conf file, and use the /usr/ local/etc/rc.d/mysql-server script to start the process as follows: % su root # /usr/local/etc/rc.d/mysql-server start HTH Eric Crist On Aug 17, 2007, at 9:01 AMAug 17, 2007, Fidel Garcia wrote: Hi I have been trying to get mysql running for the past two days without luck. I added these two packages using sysinstall from FTP. mysql-client-4.0.26_1 Multithreaded SQL database (client) mysql-server-4.0.26_2 Multithreaded SQL database (server) I went to the folder /usr/ports/databases/mysql40-server/ and did a make clean install. Then I created the file /etc/my.cnf like fr# more my.cnf [mysqld] datadir=/usr/local/mysql/data socket=/tmp/mysql.sock [mysql.server] user=mysql basedir=/usr/local/bin/mysql I got stuck at this point. I have been reading online without luck. I do not even know how to start mysql. I hope you guys can point in the right directions. Thanks in advance. Fidel Garcia ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions- [EMAIL PROTECTED] - Eric F Crist Secure Computing Networks ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Problem: Apache chroots but MySQL doesn't
Hi all, I've got an unusual problem with my server. It just restarted after a power cut. Everything came back up apart from MySQL. The server refuses to chroot it. %sudo /uetc/rc.d/mysql-server start Password: [: chroot: unexpected operator Starting mysql. %chroot: /jail/mysql: Operation not permitted The first error is normal. It doesn't seem to cause a problem. It's the 'Operation not permitted' error that bothers me. I've tried a manual chroot: %sudo chroot /jail/mysql /bin/sash Stand-alone shell (version 3.7) exit % No problem there. The startup script is the one installed by the mysql51-server port, except for the 'command' line which now reads: command=chroot /jail/mysql mysqld_safe It looks as if the script isn't running as root. It must be though, because when I change the command variable to chroot /home/`whoami`, it throws an error because /home/root doesn't exist. I don't think the chroot binary itself is a problem as it started Apache just fine. So, I'm out of ideas. Help please? TiA, Adam J Richardson ps. I always forget this bit: %uname -a FreeBSD my.server.com 6.2-RELEASE FreeBSD 6.2-RELEASE #0: Fri Jan 12 10:40:27 UTC 2007 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC i386 % ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Best way to upgrade mysql-server?
Hi, I recently upgraded from 3.23 to 4.027. My steps were: 1. Stopped the mysql server 2. make deinstall in mysql-server 3.23 3. make deinstall in mysql-client 3.23 4. make install clean in mysql-server 4.0.27 5. Ran the mysql_fix_privilege_tables 6. Started the mysql server again (and ofcourse backups before step 1) Things seem to be working fine. In regards to the existing database files, are there more correct ways of doing an upgrade on a production server? Also, does anyone have some good advice on optimizing tables, correcting and speeding up things after an upgrade? Thanks and best regards, Andreas ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: problems with mysql database
In the last episode (Jul 29), David Banning said: I have recently converted from mysql 4.1 to 5.0 and some of my tables are not recogized. Using the mysql_upgrade utility is not effective as -it- does not recognize certain tables. On closer examination I see that the tables that are -not- recognize have the following extensions; -rw-rw 1 mysql mysql 147787 Jul 23 02:44 company.ISD -rw-rw 1 mysql mysql 13312 Jul 23 02:44 company.ISM -rw-rw 1 mysql mysql9064 Dec 8 2006 company.frm while the tables that have no problem have different extensions; -rw-rw 1 mysql mysql 3592 Jul 28 23:49 Employees.MYD -rw-rw 1 mysql mysql 1024 Jul 28 23:49 Employees.MYI -rw-rw 1 mysql mysql 9174 Dec 19 2006 Employees.frm Any idea whats going on here? You may have missed: http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html#id2794303 Incompatible change: Support for the ISAM storage engine has been removed in MySQL 5.0. If you have any ISAM tables, you should convert them before upgrading. For example, to convert an ISAM table to use the MyISAM storage engine, use this statement: ALTER TABLE tbl_name ENGINE = MyISAM; Use a similar statement for every ISAM table in each of your databases. ISAM tables were actually deprecated back in 3.23 and the manual predicted that support would be gone in 5.0. You'll need to temporarily drop down to 4.1, or copy those table files to a 4.1 server, convert to MyISAM, then copy them back. If you have made a mysqldump of your tables recently, you can also delete your existing database files and reload from the dump; 5.0 will ignore the ENGINE=ISAM option and create MyISAM tables. -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
problems with mysql database
I have recently converted from mysql 4.1 to 5.0 and some of my tables are not recogized. Using the mysql_upgrade utility is not effective as -it- does not recognize certain tables. On closer examination I see that the tables that are -not- recognize have the following extensions; -rw-rw 1 mysql mysql 147787 Jul 23 02:44 company.ISD -rw-rw 1 mysql mysql 13312 Jul 23 02:44 company.ISM -rw-rw 1 mysql mysql9064 Dec 8 2006 company.frm while the tables that have no problem have different extensions; -rw-rw 1 mysql mysql 3592 Jul 28 23:49 Employees.MYD -rw-rw 1 mysql mysql 1024 Jul 28 23:49 Employees.MYI -rw-rw 1 mysql mysql 9174 Dec 19 2006 Employees.frm Any idea whats going on here? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: problems with mysql database
David Banning wrote: I have recently converted from mysql 4.1 to 5.0 and some of my tables are not recogized. Using the mysql_upgrade utility is not effective as -it- does not recognize certain tables. On closer examination I see that the tables that are -not- recognize have the following extensions; -rw-rw 1 mysql mysql 147787 Jul 23 02:44 company.ISD -rw-rw 1 mysql mysql 13312 Jul 23 02:44 company.ISM -rw-rw 1 mysql mysql9064 Dec 8 2006 company.frm while the tables that have no problem have different extensions; -rw-rw 1 mysql mysql 3592 Jul 28 23:49 Employees.MYD -rw-rw 1 mysql mysql 1024 Jul 28 23:49 Employees.MYI -rw-rw 1 mysql mysql 9174 Dec 19 2006 Employees.frm Any idea whats going on here? ISM files are from the old (depreciated, removed) ISAM table engine. This was superseded by the MyISAM table engine. As detailed in the upgrade documentation for MySQL 5, you must change the database engine prior to upgrading, as MySQL 5 no longer has support for the old ISAM engine. This can be accomplished by logging in as a user with ALTER privileges on the tables in question, and issuing an ALTER TABLE table_name TYPE MyISAM; or ALTER TABLE table_name TYPE InnoDB; before upgrading to MySQL 5. If you've already upgraded, you must find a copy of 4.x recent enough to understand the tables, and use that to convert or dump them. -- Fuzzy love, -CyberLeo Technical Administrator CyberLeo.Net Webhosting http://www.CyberLeo.Net [EMAIL PROTECTED] Furry Peace! - http://.fur.com/peace/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql upgrade from 5.0.27 to 5.0.45
Hello, I currently have mysql Ver 14.12 Distrib 5.0.27. I can see that the most current ports version is 5.0.45. So I tried to portupgrade and it tells me: --- Session started at: Fri, 27 Jul 2007 09:17:39 +0200 ** No need to upgrade 'mysql-server-5.0.45' (= mysql-server-5.0.45). (specify -f to force) --- ** Upgrade tasks 1: 0 done, 1 ignored, 0 skipped and 0 failed --- Listing the results (+:done / -:ignored / *:skipped / !:failed) - databases/mysql50-server (mysql-server-5.0.45) --- Packages processed: 0 done, 1 ignored, 0 skipped and 0 failed --- Session ended at: Fri, 27 Jul 2007 09:17:44 +0200 (consumed 00:00:04) I know I can use -f to upgrade but why would it say that there is no need to upgrade when the versions differ so much? Thank you in advance! -- Zbigniew Szalbot ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql upgrade from 5.0.27 to 5.0.45
Zbigniew Szalbot wrote: Hello, I currently have mysql Ver 14.12 Distrib 5.0.27. I can see that the most current ports version is 5.0.45. So I tried to portupgrade and it tells me: --- Session started at: Fri, 27 Jul 2007 09:17:39 +0200 ** No need to upgrade 'mysql-server-5.0.45' (= mysql-server-5.0.45). (specify -f to force) --- ** Upgrade tasks 1: 0 done, 1 ignored, 0 skipped and 0 failed --- Listing the results (+:done / -:ignored / *:skipped / !:failed) - databases/mysql50-server (mysql-server-5.0.45) --- Packages processed: 0 done, 1 ignored, 0 skipped and 0 failed --- Session ended at: Fri, 27 Jul 2007 09:17:44 +0200 (consumed 00:00:04) I know I can use -f to upgrade but why would it say that there is no need to upgrade when the versions differ so much? Thank you in advance! According to your portupgrade messages, you ALREADY have mysql 5.0.45. Are you quite sure about the installed version? It might be an error of portupgrade or something wrong with your package database, but I surely haven't seen it before. Why don't you just confirm your installed version with something like: pkg_info | grep -i mysql-server In my system this actually shows 5.0.45, and I started with 5.0.2x something. I didn't even realise when it was upraded. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql upgrade from 5.0.27 to 5.0.45
Hello, On Fri, 27 Jul 2007 11:06:42 +0300, Manolis Kiagias [EMAIL PROTECTED] wrote: Zbigniew Szalbot wrote: Hello, I currently have mysql Ver 14.12 Distrib 5.0.27. I can see that the most current ports version is 5.0.45. So I tried to portupgrade and it tells me: --- Session started at: Fri, 27 Jul 2007 09:17:39 +0200 ** No need to upgrade 'mysql-server-5.0.45' (= mysql-server-5.0.45). (specify -f to force) --- ** Upgrade tasks 1: 0 done, 1 ignored, 0 skipped and 0 failed --- Listing the results (+:done / -:ignored / *:skipped / !:failed) - databases/mysql50-server (mysql-server-5.0.45) --- Packages processed: 0 done, 1 ignored, 0 skipped and 0 failed --- Session ended at: Fri, 27 Jul 2007 09:17:44 +0200 (consumed 00:00:04) I know I can use -f to upgrade but why would it say that there is no need to upgrade when the versions differ so much? Thank you in advance! According to your portupgrade messages, you ALREADY have mysql 5.0.45. Are you quite sure about the installed version? It might be an error of portupgrade or something wrong with your package database, but I surely haven't seen it before. Why don't you just confirm your installed version with something like: pkg_info | grep -i mysql-server In my system this actually shows 5.0.45, and I started with 5.0.2x something. I didn't even realise when it was upraded. Yes, indeed I now know what happened. The *-server version got upgraded and I was unaware that *-client stayed at 0.27. I was sure that upgrading *-server will upgrade *-client too. Apparently it did not happen: $ pkg_info -Ix mysql mysql-client-5.0.27 Multithreaded SQL database (client) mysql-server-5.0.45 Multithreaded SQL database (server) I guess this is something I can fix by setting appropriate option in pkgtools.conf? Thanks for your explanation! -- Zbigniew Szalbot ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql upgrade from 5.0.27 to 5.0.45
Zbigniew Szalbot wrote: Yes, indeed I now know what happened. The *-server version got upgraded and I was unaware that *-client stayed at 0.27. I was sure that upgrading *-server will upgrade *-client too. Apparently it did not happen: $ pkg_info -Ix mysql mysql-client-5.0.27 Multithreaded SQL database (client) mysql-server-5.0.45 Multithreaded SQL database (server) I guess this is something I can fix by setting appropriate option in pkgtools.conf? Thanks for your explanation! They don't seem to have a dependency on each other, so it is quite normal for one to stay at a previous version if you upgrade the other manually. I usually portupgrade -a my system so I never noticed it. As for pkgtools.conf quite a few settings are there, but I never really messed with it, can't really tell if it can make a difference ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
updating mysql database
David Banning writes: I installed mysql 5.1 on a new system and I want to run a 4.1 database. I notice that not all tables work. Is there a conversion to take the database from 4.1 to 5.1? It is my understanding that you will have to dump (using the appropriate MySQL utilities) the database, the import it to the new version. But you should check the documentation for the official policy. Robert Huff ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
updating mysql database
I installed mysql 5.1 on a new system and I want to run a 4.1 database. I notice that not all tables work. Is there a conversion to take the database from 4.1 to 5.1? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: stop portmanager from building mysql-client-4.1.22
Gerard wrote: On July 25, 2007 at 12:14PM Noah wrote: Even with the following IGNORE settings mysql-4.1.22 is still attempting to be built. # grep IGNORE /usr/local/etc/portmanager/pm-020.conf #IGNORE|editors/openoffice*| #IGNORE|java/jdk14| IGNORE|www/apache13| IGNORE|www/apache13*| IGNORE|www/mod_perl| IGNORE|net/openldap23-client| IGNORE|net/openldap23-client*| IGNORE|databases/mysql4*-client| IGNORE|databases/mysql4*-server*| IGNORE|databases/mysql3*-client| IGNORE|databases/postgresql*| Probably should be: IGNORE|databases/mysql41-server| See if that works. The '*' after server might be screwing thing up. Ypu might try this also: IGNORE|databases/mysql4*| That should prevent any version '4' of mysql being build. How about the HOLD_PKGS section in /usr/local/etc/pkgtools.conf? Does portmanager pay attention to pkgtools.conf? HtH, Adam J Richardson ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: updating mysql database
David Banning escribió: I installed mysql 5.1 on a new system and I want to run a 4.1 database. I notice that not all tables work. Is there a conversion to take the database from 4.1 to 5.1? I think you only have to run REPAIR TABLE or OPTIMIZE TABLE on the broken tables. IIRC, the indexing changed between 4.X and 5.X versions. Regards, -- Gabor Kovesdan FreeBSD Volunteer EMAIL: [EMAIL PROTECTED] .:|:. [EMAIL PROTECTED] WEB: http://people.FreeBSD.org/~gabor .:|:. http://kovesdan.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: updating mysql database
Although MySQL has worked very hard to ensure a high level of quality, protect your data by making a backup as you would for any other software beta release. MySQL generally recommends that you dump and reload your tables from any previous version to upgrade to 5.2. Troy http://primoris.com On 7/27/07, Robert Huff [EMAIL PROTECTED] wrote: David Banning writes: I installed mysql 5.1 on a new system and I want to run a 4.1 database. I notice that not all tables work. Is there a conversion to take the database from 4.1 to 5.1? It is my understanding that you will have to dump (using the appropriate MySQL utilities) the database, the import it to the new version. But you should check the documentation for the official policy. Robert Huff ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: updating mysql database
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Gabor Kovesdan wrote: David Banning escribió: I installed mysql 5.1 on a new system and I want to run a 4.1 database. I notice that not all tables work. Is there a conversion to take the database from 4.1 to 5.1? I think you only have to run REPAIR TABLE or OPTIMIZE TABLE on the broken tables. IIRC, the indexing changed between 4.X and 5.X versions. Recent versions of mysql come with a handy utility called 'mysql_upgrade' -- it basically does what you need in changing the internal format of the tables so that recent MySQL can use them. Plus it should update the mysql.* tables so they can grok all the new GRANTS and stuff. Cheers, Matthew - -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.4 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGqlpU8Mjk52CukIwRCFxYAJ9mG9sf0u1BJ6HcIcEKlSsVOeSqhgCeLpx9 5310RRJSEHyf9Pd5M4dLJ2w= =6fmY -END PGP SIGNATURE- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: stop portmanager from building mysql-client-4.1.22
Hi there Gerard, Even with the following IGNORE settings mysql-4.1.22 is still attempting to be built. # grep IGNORE /usr/local/etc/portmanager/pm-020.conf #IGNORE|editors/openoffice*| #IGNORE|java/jdk14| IGNORE|www/apache13| IGNORE|www/apache13*| IGNORE|www/mod_perl| IGNORE|net/openldap23-client| IGNORE|net/openldap23-client*| IGNORE|databases/mysql4*-client| IGNORE|databases/mysql4*-server*| IGNORE|databases/mysql3*-client| IGNORE|databases/postgresql*| Gerard wrote: On July 20, 2007 at 01:09PM Noah wrote: Hi there, I am attempting to stop portmanager from installing mysql-client-4.1.22 so I added the following lines to my portmanager config file. $ grep IGNORE /usr/local/etc/portmanager/pm-020.conf #IGNORE|editors/openoffice*| #IGNORE|java/jdk14| IGNORE|www/apache13| IGNORE|www/apache13*| IGNORE|www/mod_perl| IGNORE|net/openldap23-client| IGNORE|net/openldap23-client*| IGNORE|databases/mysql4*| IGNORE|databases/mysql3*| IGNORE|databases/postgresql*| but still mysql-client-4.1.22 is being installed. $ pkg_info | grep portmanager portmanager-0.4.1_9 FreeBSD installed ports status and safe update utility Try: IGNORE|databases/mysql4*-client| This should prevent any 4x version from being installed: IGNORE|databases/mysql4*-server*| ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re[2]: stop portmanager from building mysql-client-4.1.22
On July 25, 2007 at 12:14PM Noah wrote: Even with the following IGNORE settings mysql-4.1.22 is still attempting to be built. # grep IGNORE /usr/local/etc/portmanager/pm-020.conf #IGNORE|editors/openoffice*| #IGNORE|java/jdk14| IGNORE|www/apache13| IGNORE|www/apache13*| IGNORE|www/mod_perl| IGNORE|net/openldap23-client| IGNORE|net/openldap23-client*| IGNORE|databases/mysql4*-client| IGNORE|databases/mysql4*-server*| IGNORE|databases/mysql3*-client| IGNORE|databases/postgresql*| Probably should be: IGNORE|databases/mysql41-server| See if that works. The '*' after server might be screwing thing up. Ypu might try this also: IGNORE|databases/mysql4*| That should prevent any version '4' of mysql being build. -- Gerard ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Install pdo mysql
Hi, I've FreeBSD 6.1-RELEASE-p16 #3 and the php5-extensions 1.1 doesn't have anything related to pdo mysql. Can somebody tell me how do I install pdo mysql? Thanks in advance... Sé un Mejor Amante del Cine ¿Quieres saber cómo? ¡Deja que otras personas te ayuden! http://advision.webevents.yahoo.com/reto/entretenimiento.html ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Install pdo mysql
On July 24, 2007 at 09:46AM Efren Bravo wrote: I've FreeBSD 6.1-RELEASE-p16 #3 and the php5-extensions 1.1 doesn't have anything related to pdo mysql. Can somebody tell me how do I install pdo mysql? Perhaps you are looking for: php5-pdo_mysql-5.2.3, located in: /usr/ports/databases/php5-pdo_mysql HTH -- Gerard ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
stop portmanager from building mysql-client-4.1.22
Hi there, I am attempting to stop portmanager from installing mysql-client-4.1.22 so I added the following lines to my portmanager config file. $ grep IGNORE /usr/local/etc/portmanager/pm-020.conf #IGNORE|editors/openoffice*| #IGNORE|java/jdk14| IGNORE|www/apache13| IGNORE|www/apache13*| IGNORE|www/mod_perl| IGNORE|net/openldap23-client| IGNORE|net/openldap23-client*| IGNORE|databases/mysql4*| IGNORE|databases/mysql3*| IGNORE|databases/postgresql*| but still mysql-client-4.1.22 is being installed. $ pkg_info | grep portmanager portmanager-0.4.1_9 FreeBSD installed ports status and safe update utility ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: stop portmanager from building mysql-client-4.1.22
On July 20, 2007 at 01:09PM Noah wrote: Hi there, I am attempting to stop portmanager from installing mysql-client-4.1.22 so I added the following lines to my portmanager config file. $ grep IGNORE /usr/local/etc/portmanager/pm-020.conf #IGNORE|editors/openoffice*| #IGNORE|java/jdk14| IGNORE|www/apache13| IGNORE|www/apache13*| IGNORE|www/mod_perl| IGNORE|net/openldap23-client| IGNORE|net/openldap23-client*| IGNORE|databases/mysql4*| IGNORE|databases/mysql3*| IGNORE|databases/postgresql*| but still mysql-client-4.1.22 is being installed. $ pkg_info | grep portmanager portmanager-0.4.1_9 FreeBSD installed ports status and safe update utility Try: IGNORE|databases/mysql4*-client| This should prevent any 4x version from being installed: IGNORE|databases/mysql4*-server*| -- Gerard ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
ipnat + mysql replication
Hi, I have 4 FreeBSD servers in one location. A firewall/nat load balances between two web servers which hits a database server for content (also behind firewall/nat). The database server replicates from a remote location (outgoing connection), where the admin interface resides (different facility). The problem I'm having is that it's a fairly well-trafficked site. The ipnat entries table fills up quickly (30,000 I think is the max), and so I have to ipnat -F fairly often (every 5 minutes or so). The problem with this is that it kills any outgoing connections (like my mysql replication). Is there a way I can set the expiration for ipnat table entries, or setup mysql replication rules in ipnat.conf that will be ignored when ipnat -F is issued? Thanks, JJ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: ipnat + mysql replication
I have 4 FreeBSD servers in one location. A firewall/nat load balances between two web servers which hits a database server for content (also behind firewall/nat). The database server replicates from a remote location (outgoing connection), where the admin interface resides (different facility). The problem I'm having is that it's a fairly well-trafficked site. The ipnat entries table fills up quickly (30,000 I think is the max), and so I have to ipnat -F fairly often (every 5 minutes or so). The problem with this is that it kills any outgoing connections (like my mysql replication). Is there a way I can set the expiration for ipnat table entries, or setup mysql replication rules in ipnat.conf that will be ignored when ipnat -F is issued? rdr has and age option to define a different time out, the redirection for load ballencing could have a very short time out, causing your ipnat entries to exprire quickly. Just a guess, I never used it, but seen it from the manual. Another, more heavy solution, but maybe more robust, would be to have dual NIC in your mysql server and add a second firewall/nat. The mysql replication going through the second NIC and firewall. Bests, Olivier ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
PHP5/MySQL Problem
Been dealing with a very frustrating couple of days, and have hit a wall. I had a working gallery2 installation, then upgraded mysqli, and all hell broke loose. When I try to open a page (in this case gallery2) that connects to the database. It always says Too many open links. The thing is, it even says that if mysqld is not running. I'm running under freebsd 6.1. You can examine my server setup at http://geekfleet.tai-gear.com/server-info You can examine the php setup at http://geekfleet.tai-gear.com/phpinfo.php The problem I'm having now is that php5 won't connect to the mysql server. It's not a gallery thing, I've confirmed that I have the exact same problem with a simple script to just connect to the mysql server and read the database. And, in fact, the exact same error occurs if mysqld is not running at all. Apache shows -- [Mon Jul 16 02:07:10 2007] [error] [client 66.249.66.10] PHP Warning: mysql_connect() [a href='function.mysql-connect'function.mysql-connect/a]: Too many open links (0) in /usr/local/www/apache22/data/gallery2/lib/adodb/drivers/adodb-mysql.in c.php on line 366 Here is the info in php.ini -- [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = Off ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 ; Default port number for mysql_connect(). If unset, mysql_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysql.default_port = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysql.default_socket = ; Default host for mysql_connect() (doesn't apply in safe mode). mysql.default_host = ; Default user for mysql_connect() (doesn't apply in safe mode). mysql.default_user = ; Default password for mysql_connect() (doesn't apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run 'echo get_cfg_var(mysql.default_password) ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. mysql.default_password = ; Maximum time (in secondes) for connect timeout. -1 means no limit mysql.connect_timeout = 60 ; Trace mode. When trace_mode is active (=On), warnings for table/index scans an d ; SQL-Errors will be displayed. mysql.trace_mode = Off [MySQLi] ; Maximum number of links. -1 means no limit. mysqli.max_links = -1 ; Default port number for mysqli_connect(). If unset, mysqli_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysqli.default_port = 3306 ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysqli.default_socket = ; Default host for mysql_connect() (doesn't apply in safe mode). mysqli.default_host = ; Default user for mysql_connect() (doesn't apply in safe mode). mysqli.default_user = ; Default password for mysqli_connect() (doesn't apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run 'echo get_cfg_var(mysqli.default_pw) ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. mysqli.default_pw = ; Allow or prevent reconnect mysqli.reconnect = Off ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: PHP5/MySQL Problem
Please ignore if this problem has already been solved. --- Joseph Mays [EMAIL PROTECTED] wrote: Been dealing with a very frustrating couple of days, and have hit a wall. I had a working gallery2 installation, then upgraded mysqli, and all hell broke loose. When I try to open a page (in this case gallery2) that connects to the database. It always says Too many open links. The thing is, it even says that if mysqld is not running. I'm running under freebsd 6.1. You can examine my server setup at http://geekfleet.tai-gear.com/server-info You can examine the php setup at http://geekfleet.tai-gear.com/phpinfo.php The problem I'm having now is that php5 won't connect to the mysql server. It's not a gallery thing, I've confirmed that I have the exact same problem with a simple script to just connect to the mysql server and read the database. And, in fact, the exact same error occurs if mysqld is not running at all. Apache shows -- [Mon Jul 16 02:07:10 2007] [error] [client 66.249.66.10] PHP Warning: mysql_connect() [a href='function.mysql-connect'function.mysql-connect/a]: Too many open links (0) in /usr/local/www/apache22/data/gallery2/lib/adodb/drivers/adodb-mysql.in c.php on line 366 Note that it says 0 open links is too many. Note also that the file error was reported in is adodb-mysql.inc.php. I haven't used ado to connect to MySQL but perhaps it does not get the limit from the mysql.max_persistent setting in the MySQL section of php.ini. Check line 366 in adodb-mysql.inc.php and look for a call to get_ini( and see what variable it is specifying (or perhaps it's a hardcoded value?). Here is the info in php.ini -- [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = Off ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 ; Default port number for mysql_connect(). If unset, mysql_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysql.default_port = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysql.default_socket = ; Default host for mysql_connect() (doesn't apply in safe mode). mysql.default_host = ; Default user for mysql_connect() (doesn't apply in safe mode). mysql.default_user = ; Default password for mysql_connect() (doesn't apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run 'echo get_cfg_var(mysql.default_password) ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. mysql.default_password = ; Maximum time (in secondes) for connect timeout. -1 means no limit mysql.connect_timeout = 60 ; Trace mode. When trace_mode is active (=On), warnings for table/index scans an d ; SQL-Errors will be displayed. mysql.trace_mode = Off [MySQLi] ; Maximum number of links. -1 means no limit. mysqli.max_links = -1 ; Default port number for mysqli_connect(). If unset, mysqli_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysqli.default_port = 3306 ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysqli.default_socket = ; Default host for mysql_connect() (doesn't apply in safe mode). mysqli.default_host = ; Default user for mysql_connect() (doesn't apply in safe mode). mysqli.default_user = ; Default password for mysqli_connect() (doesn't apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run 'echo get_cfg_var(mysqli.default_pw) ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. mysqli.default_pw = ; Allow or prevent reconnect mysqli.reconnect = Off ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. http://sims.yahoo.com/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
accessing mysql server remotely
Just a general question about mysql remote access. Is it possible to login to my remote mysql server and create a new db table using a file on the local system which contains the definition statements? Thanks ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
accessing mysql server remotely
Just a general question about mysql remote access. Is it possible to login to my remote mysql server and create a new db table using a file on the local system which contains the definition statements? Thanks ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: accessing mysql server remotely
On Mon, Jul 09, 2007 at 11:40:07PM -0400, fbsd2 wrote: Just a general question about mysql remote access. Is it possible to login to my remote mysql server and create a new db table using a file on the local system which contains the definition statements? Thanks Of course, it's possible. It's the same as you would use it locally, with added hostname parameter: mysql -h hostname -u username -p dbname yourfile.sql (that's basic syntax, check mysql(1) manpage). HTH, Yuri pgpjBOBlWiJmy.pgp Description: PGP signature
Re: accessing mysql server remotely
On Mon, 9 Jul 2007 at 23:33 -0400, [EMAIL PROTECTED] confabulated: Just a general question about mysql remote access. Is it possible to login to my remote mysql server and create a new db table using a file on the local system which contains the definition statements? Sure. As long as the account name used to login to MySQL has login access from the remote location. mysql -host=ip_or_hostname -user=username -password=password dbname statements.sql - _|_ (_| | ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: accessing mysql server remotely
On Tue, 10 Jul 2007 at 12:01 -, [EMAIL PROTECTED] confabulated: On Mon, 9 Jul 2007 at 23:33 -0400, [EMAIL PROTECTED] confabulated: Just a general question about mysql remote access. Is it possible to login to my remote mysql server and create a new db table using a file on the local system which contains the definition statements? Sure. As long as the account name used to login to MySQL has login access from the remote location. mysql -host=ip_or_hostname -user=username -password=password dbname statements.sql My bad. The command line parameters should have two hyphens: mysql --host=ip_or_hostname --user=username --password=password dbname statements.sql - _|_ (_| | ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: accessing mysql server remotely
On Tue, 2007-07-10 at 12:15 +, Duane Hill wrote: On Tue, 10 Jul 2007 at 12:01 -, [EMAIL PROTECTED] confabulated: On Mon, 9 Jul 2007 at 23:33 -0400, [EMAIL PROTECTED] confabulated: Just a general question about mysql remote access. Is it possible to login to my remote mysql server and create a new db table using a file on the local system which contains the definition statements? Sure. As long as the account name used to login to MySQL has login access from the remote location. mysql -host=ip_or_hostname -user=username -password=password dbname statements.sql My bad. The command line parameters should have two hyphens: mysql --host=ip_or_hostname --user=username --password=password dbname statements.sql Whilst this syntax will work fine, it requires that the mysql server allow remote logins - well I already have a nice cryptographically secure way of allowing remote access, it's called SSH: cat statements.sql |\ ssh -C [EMAIL PROTECTED] 'mysql -uuser -ppass dbname' The main benefit of this is that my mysql server now only needs to run on localhost, and so cannot be touched by any external user. For an interactive mysql prompt, you'd need either to open up mysql, or forward a port: ssh -C -L13306:localhost:3306 [EMAIL PROTECTED] mysql -uuser -ppass -hlocalhost -P13306 dbname signature.asc Description: This is a digitally signed message part
RE: How does one start mysql after installing from ports
To autostart mysql at boot add this to /etc/rc.conf mysql_enable=YES Add this to /etc/rc.conf to direct to use location where there is a large enough free disk space to hold your databases mysql_dbdir=/usr/local/mysql To start or stop mysql server do this /usr/local/share/mysql/mysql.server start /usr/local/share/mysql/mysql.server stop Better is to use /usr/local/etc/rc.d/mysql start cq stop You have to tell mysql to create its internel control db by running this command one time first before trying to create databases. mysql_install_db --user=mysql If you did use /usr/local/etc/rc.d/mysql start, the above is not needed, it will do it automaticly if it does not find any database at startup. To verify mysql is operational issue these commands mysqladmin version mysqladmin variables To start command line session with mysql server to create a DB enter mysql -u root The online mysql manual is at http://dev.mysql.com/doc/refman/5.0/en/index.html No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.0/886 - Release Date: 4-7-2007 13:40 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
How does one start mysql after installing from ports
This is pretty pathetic but I'm batting a 1000 on this one. I installed mysql a few weeks ago on this web server I'm making for my church and didn't do anything with it at that point (that was the first mistake). I've not used mysql (I usually use PostgreSQL) but WebGUI wants mysql. So, being completely unfamiliar with it, I cannot figure out how to start this thing. I eventually figured out that the mysqld process starts by using mysqld_safe in /usr/local/bin. However, I can't get it to start. At first it was because the directory /var/db/mysql didn't exist. I created that and now I get this: whitbap# mysqld_safe Starting mysqld daemon with databases from /var/db/mysql STOPPING server from pid file /var/db/mysql/whitbap.pid 070704 16:09:42 mysqld ended (And the contents of /var/db/mysql/whitbap.err: whitbap# cat /var/db/mysql/whitbap.err 070704 16:02:41 mysqld started 070704 16:02:42 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 070704 16:02:42 mysqld ended 070704 16:09:42 mysqld started 070704 16:09:42 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 070704 16:09:42 mysqld ended I'm assuming that a process, perhaps similar to PostgreSQL, is applicable for MySQL too. For example, in PostgreSQL, one must first usr 'initdb' to initialize the data area. Is this true for MySQL too? Please tell me how to work MySQL (to anyone on this list that uses it). Thanks, Andy ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: How does one start mysql after installing from ports
On July 04, 2007 at 06:00PM Andrew Falanga wrote: This is pretty pathetic but I'm batting a 1000 on this one. I installed mysql a few weeks ago on this web server I'm making for my church and didn't do anything with it at that point (that was the first mistake). I've not used mysql (I usually use PostgreSQL) but WebGUI wants mysql. So, being completely unfamiliar with it, I cannot figure out how to start this thing. I eventually figured out that the mysqld process starts by using mysqld_safe in /usr/local/bin. However, I can't get it to start. At first it was because the directory /var/db/mysql didn't exist. I created that and now I get this: whitbap# mysqld_safe Starting mysqld daemon with databases from /var/db/mysql STOPPING server from pid file /var/db/mysql/whitbap.pid 070704 16:09:42 mysqld ended (And the contents of /var/db/mysql/whitbap.err: whitbap# cat /var/db/mysql/whitbap.err 070704 16:02:41 mysqld started 070704 16:02:42 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 070704 16:02:42 mysqld ended 070704 16:09:42 mysqld started 070704 16:09:42 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 070704 16:09:42 mysqld ended I'm assuming that a process, perhaps similar to PostgreSQL, is applicable for MySQL too. For example, in PostgreSQL, one must first usr 'initdb' to initialize the data area. Is this true for MySQL too? Please tell me how to work MySQL (to anyone on this list that uses it). Thanks, Andy Unless I am misreading this, the correct method is by inserting the following into the '/etc/rc.conf' file: mysql_enable=YES You can then either reboot the system to start the program, perhaps a good idea to make sure it does get initialized correctly, or else as root type: /usr/local/etc/rc.d/mysql-server start That should complete the process. If you receive error messages when mysql starts up, shut it down using the 'stop' flag in place of 'start' and then move the '/var/db/mysql' directory out of the way and restart mysql. -- Gerard ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: How does one start mysql after installing from ports
--On July 4, 2007 4:00:48 PM -0600 Andrew Falanga [EMAIL PROTECTED] wrote: This is pretty pathetic but I'm batting a 1000 on this one. I installed mysql a few weeks ago on this web server I'm making for my church and didn't do anything with it at that point (that was the first mistake). I've not used mysql (I usually use PostgreSQL) but WebGUI wants mysql. So, being completely unfamiliar with it, I cannot figure out how to start this thing. I eventually figured out that the mysqld process starts by using mysqld_safe in /usr/local/bin. However, I can't get it to start. At first it was because the directory /var/db/mysql didn't exist. I created that and now I get this: All ports that run daemons should put a startup script in /usr/local/etc/rc.d. Mysqld does. Look at that script and it will explain what you need to do to start mysql. The port maintainer has written the script so that it should start mysqld properly. Basically, you add mysqld_enable=YES to the /etc/rc.conf file, but look at the script and read the comments in it. Paul Schmehl ([EMAIL PROTECTED]) Senior Information Security Analyst The University of Texas at Dallas http://www.utdallas.edu/ir/security/
RE: How does one start mysql after installing from ports
To autostart mysql at boot add this to /etc/rc.conf mysql_enable=YES Add this to /etc/rc.conf to direct to use location where there is a large enough free disk space to hold your databases mysql_dbdir=/usr/local/mysql To start or stop mysql server do this /usr/local/share/mysql/mysql.server start /usr/local/share/mysql/mysql.server stop You have to tell mysql to create its internel control db by running this command one time first before trying to create databases. mysql_install_db --user=mysql To verify mysql is operational issue these commands mysqladmin version mysqladmin variables To start command line session with mysql server to create a DB enter mysql -u root The online mysql manual is at http://dev.mysql.com/doc/refman/5.0/en/index.html ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
MySQL Quotas
Hi, I am posting this here thinking this may be more of an OS thing than a mysql thing... Since all mysql databases and tables need to be owned by the mysql user, is there, er, has anyone figured out a way to impose disk quotas per database for mysql? -Grant ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL Quotas
Grant Peel wrote: I am posting this here thinking this may be more of an OS thing than a mysql thing... Since all mysql databases and tables need to be owned by the mysql user, is there, er, has anyone figured out a way to impose disk quotas per database for mysql? Databases tend to lose pending commits if they no longer can expand and use more space; most people do not attempt to use disk quotas with a database because new transactions are highly important. -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Spamassassin Bayes/mySQL + Amavisd-new
I've been getting some nasty spam and need to setup bayes. I'm running amavisd-new with spamassassin. I haven't been able to find any guides... so it's kind of hard. The only one I have been able to find is this one. http://www.maiamailguard.com/maia/wiki/SpamAssassin3SQLBayes but it pertains to maia-mailguard more then amavisd-new. This is my local.cf config: # Enable the Bayes system use_bayes 1 bayes_store_moduleMail::SpamAssassin::BayesStore::SQL bayes_sql_dsnDBI:mysql:bayes:localhost bayes_sql_usernamebayes bayes_sql_passwordbayes and I added the SQL that I found on that link; however, it doesn't seem to be connecting. It tried to connect as root, not sure why. Also, is bayasian per user or sitewide? I'm kind of confused as to where I should even start with this because of the lack of guides. I found this: http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes but it's pretty broad too so i'm not sure. Has anyone done it with amavisd-new? -- View this message in context: http://www.nabble.com/Spamassassin-Bayes-mySQL-%2B-Amavisd-new-tf3893449.html#a11037822 Sent from the freebsd-questions mailing list archive at Nabble.com. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Fwd: mysql start error...
-- Forwarded message -- From: Agus [EMAIL PROTECTED] Date: 18-may-2007 19:14 Subject: Re: mysql start error... To: Hanatsu Tori [EMAIL PROTECTED] 2007/5/17, Hanatsu Tori [EMAIL PROTECTED]: Hi! Please id ls -la /bin/csh ls -la /usr/local/etc/rc.d/mysql-server Dmitry 2007/5/17, Agus [EMAIL PROTECTED]: Hi, I am getting an error while trying to run mysql-server... Wired thing is that it was running ok for a month.suddenly i got this error.. su: /bin/csh: Permission denied thanks for any hints you could give see ya ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] Here it is Dimitry uid=0(root) gid=0(wheel) groups=0(wheel), 5(operator) -r-xr-xr-x 2 root wheel 293060 May 7 2006 /bin/csh -r-xr-xr-x 1 root wheel 1659 Jan 10 16:47 /usr/local/etc/rc.d/mysql-server thanks... ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql start error...
Hi! Please id ls -la /bin/csh ls -la /usr/local/etc/rc.d/mysql-server Dmitry 2007/5/17, Agus [EMAIL PROTECTED]: Hi, I am getting an error while trying to run mysql-server... Wired thing is that it was running ok for a month.suddenly i got this error.. su: /bin/csh: Permission denied thanks for any hints you could give see ya ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql start error...
Hi, I am getting an error while trying to run mysql-server... Wired thing is that it was running ok for a month.suddenly i got this error.. su: /bin/csh: Permission denied thanks for any hints you could give see ya ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
MySQL slowness in SMP
Hello, I have dual xeon server with 2 GB of ram. FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386 Which runs heavily MySQL with MyISAM, the problem I have it maxes out one cpu, and doesn't use the other one. Could someone tell me what shall I do to make MySQL runs faster? it already uses libthr, cache beside MySQL optimized, I would like to use the power of both cpus. last pid: 79040; load averages: 1.00, 1.01, 1.00 up 16+16:54:20 08:04:55 39 processes: 2 running, 37 sleeping CPU states: 26.9% user, 0.0% nice, 23.3% system, 0.0% interrupt, 49.8% idle Mem: 556M Active, 1154M Inact, 198M Wired, 93M Cache, 112M Buf, 3072K Free Swap: 5120M Total, 16K Used, 5120M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld Is upgrading to FreeBSD 7.0 current and using ULE would make MySQL runs in this dual xeon box? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
On 5/11/07, Martin Blapp [EMAIL PROTECTED] wrote: Hi, It depends on the threading library you use. Can you please show us the output of ldd /usr/local/libexec/mysqld ? You should use libthr instead of libpthread or libc_r in /etc/libmap.conf for mysqld. -- Martin Martin Blapp, [EMAIL PROTECTED] [EMAIL PROTECTED] -- ImproWare AG, UNIXSP ISP, Zurlindenstrasse 29, 4133 Pratteln, CH Phone: +41 61 826 93 00 Fax: +41 61 826 93 01 PGP: finger -l [EMAIL PROTECTED] PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E -- Here we go. ldd /usr/local/libexec/mysqld /usr/local/libexec/mysqld: libz.so.3 = /lib/libz.so.3 (0x28498000) libwrap.so.4 = /usr/lib/libwrap.so.4 (0x284a9000) libcrypt.so.3 = /lib/libcrypt.so.3 (0x284b) libstdc++.so.5 = /usr/lib/libstdc++.so.5 (0x284c9000) libm.so.4 = /lib/libm.so.4 (0x28598000) libpthread.so.2 = /usr/lib/libthr.so.2 (0x285ae000) libc.so.6 = /lib/libc.so.6 (0x285c1000) and here is the libmap.conf [/usr/local/libexec/mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
Hi, So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster or it's not optimized for dual cpu yet? Of course would upgrading to FreeBSD 7.0-CURRENT make it faster because some bottlenecks (unix domain sockets etc, old malloc) have been removed. -- Martin ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
Hi, Ohh, I overread that you already use libthr. But ... 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld It looks like you did not turn on 'showing threads' in top, else you would have seen that many mysqld's are running on cpu 0, other on cpu 1. -- Martin /usr/local/libexec/mysqld: libz.so.3 = /lib/libz.so.3 (0x28498000) libwrap.so.4 = /usr/lib/libwrap.so.4 (0x284a9000) libcrypt.so.3 = /lib/libcrypt.so.3 (0x284b) libstdc++.so.5 = /usr/lib/libstdc++.so.5 (0x284c9000) libm.so.4 = /lib/libm.so.4 (0x28598000) libpthread.so.2 = /usr/lib/libthr.so.2 (0x285ae000) libc.so.6 = /lib/libc.so.6 (0x285c1000) and here is the libmap.conf [/usr/local/libexec/mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
On 5/11/07, Martin Blapp [EMAIL PROTECTED] wrote: Hi, Ohh, I overread that you already use libthr. But ... 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld It looks like you did not turn on 'showing threads' in top, else you would have seen that many mysqld's are running on cpu 0, other on cpu 1. -- Martin So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster or it's not optimized for dual cpu yet? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
Hi, It depends on the threading library you use. Can you please show us the output of ldd /usr/local/libexec/mysqld ? You should use libthr instead of libpthread or libc_r in /etc/libmap.conf for mysqld. -- Martin Martin Blapp, [EMAIL PROTECTED] [EMAIL PROTECTED] -- ImproWare AG, UNIXSP ISP, Zurlindenstrasse 29, 4133 Pratteln, CH Phone: +41 61 826 93 00 Fax: +41 61 826 93 01 PGP: finger -l [EMAIL PROTECTED] PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E -- On Fri, 11 May 2007, Abdullah Ibn Hamad Al-Marri wrote: Hello, I have dual xeon server with 2 GB of ram. FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386 Which runs heavily MySQL with MyISAM, the problem I have it maxes out one cpu, and doesn't use the other one. Could someone tell me what shall I do to make MySQL runs faster? it already uses libthr, cache beside MySQL optimized, I would like to use the power of both cpus. last pid: 79040; load averages: 1.00, 1.01, 1.00 up 16+16:54:20 08:04:55 39 processes: 2 running, 37 sleeping CPU states: 26.9% user, 0.0% nice, 23.3% system, 0.0% interrupt, 49.8% idle Mem: 556M Active, 1154M Inact, 198M Wired, 93M Cache, 112M Buf, 3072K Free Swap: 5120M Total, 16K Used, 5120M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld Is upgrading to FreeBSD 7.0 current and using ULE would make MySQL runs in this dual xeon box? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-current To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
Martin Blapp wrote: So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster or it's not optimized for dual cpu yet? Of course would upgrading to FreeBSD 7.0-CURRENT make it faster because some bottlenecks (unix domain sockets etc, old malloc) have been removed. On the other hand, if it's an important database in production, you probably don't want to run -CURRENT on the machine. signature.asc Description: OpenPGP digital signature
Re: MySQL slowness in SMP
On Fri, 2007-05-11 at 11:07 +0300, Abdullah Ibn Hamad Al-Marri wrote: Hello, Hi! I had the same problem, but i found this blog entry from Jeremy Zawodny: http://jeremy.zawodny.com/blog/archives/000173.html After i adjusted the wait_timeout and thread_cache_size, the problem is gone. CPU utilization dropped significantly. HTH I have dual xeon server with 2 GB of ram. FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386 Which runs heavily MySQL with MyISAM, the problem I have it maxes out one cpu, and doesn't use the other one. Could someone tell me what shall I do to make MySQL runs faster? it already uses libthr, cache beside MySQL optimized, I would like to use the power of both cpus. last pid: 79040; load averages: 1.00, 1.01, 1.00 up 16+16:54:20 08:04:55 39 processes: 2 running, 37 sleeping CPU states: 26.9% user, 0.0% nice, 23.3% system, 0.0% interrupt, 49.8% idle Mem: 556M Active, 1154M Inact, 198M Wired, 93M Cache, 112M Buf, 3072K Free Swap: 5120M Total, 16K Used, 5120M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld -- Micskó Gábor HP APS, AIS, ASE Szintézis Zrt. H-9023 Győr, Tihanyi Á. u. 2. Tel: +36 96 502 216 Fax: +36 96 318 658 E-mail: [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Chrooting Apache 2, PHP 5 and MySQL 5
Hi, can anybody direct me to the subjected topic? I tried to google it out, but only chrooting of old versions is explained. Regards Lubos --- avast! Antivirus on Lubnet Server: Odchozi zprava cista. Virova databaze (VPS): 000734-2, 18.04.2007 Testovano: 18.4.2007 23:57:13 avast! (c) copyright 1988-2007 ALWIL Software. http://www.avast.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Chrooting Apache 2, PHP 5 and MySQL 5
Lubomir Matousek [EMAIL PROTECTED] wrote: Hi, can anybody direct me to the subjected topic? I tried to google it out, but only chrooting of old versions is explained. This isn't exactly the answer to your question, but as an alternative you could jail Apache and whatever else you wanted to install with it: http://people.collaborativefusion.com/~wmoran/howtos/sshdinjail.html -- Bill Moran http://www.potentialtech.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Mysql Hogging all system resources
In the last episode (Apr 13), Don O'Neil said: Nevermind on the badly formatted number... I specified the full path /usr/bin/nice and it worked ok this time :-) However, I still want to know if there is a way to specify a nice level for an entire users processes. If you create a login class in /etc/login.conf and set the priority capability, then assign a user to that class in /etc/master.passwd (the class field is the 5th one, it's usually empty), then their priority (aka niceness) should get set then they log in. Remember to use the 'vipw' command to edit the passwd file, and to run 'cap_mkdb /etc/login.conf' to rebuild login.conf.db. -- Dan Nelson [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Mysql Hogging all system resources
In response to Don O'Neil [EMAIL PROTECTED]: I did this: In my login.conf file (assuming that all you have to do is change whatever you don't want to be the default): nice:\ :priority=5: In the user entry I put 'nice' in field 5. When I rebuilt the login.conf db, nothing seems to have changed for th user... A 'top' still shows his processes (old and new) with a nice of 0. Is there something else I'm missing? Did you log the user out/restart all his processes? I expect the priority is applied at login time and isn't going to be re-evaluated on a continual basis. -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 2:57 PM To: Don O'Neil Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Mysql Hogging all system resources In the last episode (Apr 13), Don O'Neil said: Nevermind on the badly formatted number... I specified the full path /usr/bin/nice and it worked ok this time :-) However, I still want to know if there is a way to specify a nice level for an entire users processes. If you create a login class in /etc/login.conf and set the priority capability, then assign a user to that class in /etc/master.passwd (the class field is the 5th one, it's usually empty), then their priority (aka niceness) should get set then they log in. Remember to use the 'vipw' command to edit the passwd file, and to run 'cap_mkdb /etc/login.conf' to rebuild login.conf.db. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] -- Bill Moran http://www.potentialtech.com ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Mysql Hogging all system resources
On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote: [ ... ] Is there a way to prioritize or set the amount of resources that MySQL is allowed to have? Do I need to set it up as a jailed process maybe? I've never done that before, so I'm not sure if it's the right approach or not. Um, didn't you ask this question yesterday? Use nice/renice to change the process priority of the MySQL server so that you don't starve other processes of CPU -- -Chuck ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: Mysql Hogging all system resources
Is there a way to set a 'nice' priority for a particular user? Also, when I run this: nice -n 5 /usr/bin/spamd -d -c -m 5 I get: nice: Badly formed number. I ran a man page on it, and this is the right format, but its not working. -Original Message- From: Chuck Swiger [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 11:38 AM To: Don O'Neil Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Mysql Hogging all system resources On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote: [ ... ] Is there a way to prioritize or set the amount of resources that MySQL is allowed to have? Do I need to set it up as a jailed process maybe? I've never done that before, so I'm not sure if it's the right approach or not. Um, didn't you ask this question yesterday? Use nice/renice to change the process priority of the MySQL server so that you don't starve other processes of CPU -- -Chuck ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
