RE: Multitable selection

2005-07-19 Thread PMilanese
You have not tried merge? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 19, 2005 5:46 AM To: Peter J Milanese; mysql@lists.mysql.com Subject: Re: Multitable selection Hello Now I use temporary table, but I can`t use SQL_CACHE in queries, which

RE: error in mysql

2005-07-19 Thread PMilanese
I do hope that you understand that this is not a productive post (question?) "Very slow" is a bit vague. What is it that you are trying to do? -Original Message- From: Manish [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 19, 2005 3:20 AM To: mysql@lists.mysql.com Subject: error in mysql

MySQL 5.0.19, fails to start, no log entries!

2006-04-10 Thread PMilanese
Greetings- I have a fresh install of 5.0.19, and when I go to start the database (using the init script), it fails to start. Odd enough, it only logs the start and end lines in the .err log. Is anyone familiar with this? The only thing different about the box is that it has dell's openmanag

Re: MySQL 5.0.19, fails to start, no log entries!

2006-04-10 Thread PMilanese
FYI- I am a moron, and SELinux was enforced, although I thought I had disabled it. Thanks- Peter J. Milanese, System Administrator Information Technology Group The New York Public Library [EMAIL PROTECTED] - 212.621.0203

RE: recovering a 17G dump

2005-05-20 Thread PMilanese
I doubt there is much to do. Your hardware is the bottleneck I would think. You will completely kill the server regenerating the indexes afterwards as well, so if the idea is to get is up and running fast, it may not be so fast once you get it up. -Original Message- From: Mikel - [mailto:[

RE: Hashmysql.org 0wn3d?

2005-05-20 Thread PMilanese
Whatever it was, looks like they recovered. -Original Message- From: Rahul S. Johari [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 1:38 PM To: [EMAIL PROTECTED]; 'mysql@lists.mysql.com ' Subject: Re: Hashmysql.org 0wn3d? Ave, I was wondering the same. Looks like hacked to me. Som

RE: max_connections

2005-06-07 Thread PMilanese
Where are you getting this error from? Sounds like something on top of mysql that is doing the connection pooling perhaps. -Original Message- From: James Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 12:28 PM To: mysql@lists.mysql.com Subject: max_connections Hello,

RE: max_connections

2005-06-07 Thread PMilanese
I would then gather to say that the limit (hence the error) is being generate by Torque, which does the connection pooling, and has nothing to do directly with max_conn. Is there a config file or something that you can look for in torque? -Original Message- From: James Sherwood [mailto:[E

RE: Seriously.. When are we going to get subqueries?!

2005-06-08 Thread PMilanese
Although it was nice to hear a few versions ago that they were thinking about adding this, I did not think it was absolutely necessary. There are many other ways to handle embedded queries. You can also offload some of the server side work by doing so. Depends on how you use it I suppose. As far a

RE: Which users eat cpu on Mysql

2005-06-10 Thread PMilanese
Haven't used it in a while, but mytop is handy (think that was the name) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 10, 2005 12:09 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Which users eat cpu on Mysql Hi, SHOW PROCESSLI