26- Original Message
From: Tommy Nordgren <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, March 2, 2007 7:32:16 PM
Subject: Re: Can't Bind to Port
server312# netstat -nlap tcp | grep 3306
tcp4 0 0 *.3306
*.*
On 3 mar 2007, at 00.21, Drew Jenkins wrote:
Oops. Forgot to add I passed it tcp as the protocol and it returned
blank:
# netstat -nlp tcp| grep 3306
#
I presume that means nothing's listening on that port? If so, then
why did nmap return mysql on that port? At any rate, what do?
TIA,
Dr
Drew Jenkins wrote:
- Original Message
From: Borokov Smith <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, March 2, 2007 6:21:59 PM
Subject: Re: Can't Bind to Port
netstat -nlp | grep 3306
Option p requires a protocol. What pro
Oops. Forgot to add I passed it tcp as the protocol and it returned blank:
# netstat -nlp tcp| grep 3306
#
I presume that means nothing's listening on that port? If so, then why did nmap
return mysql on that port? At any rate, what do?
TIA,
Drew
- Original Message
From: Borokov Smith <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, March 2, 2007 6:21:59 PM
Subject: Re: Can't Bind to Port
>netstat -nlp | grep 3306
Option p requires a protocol. What protocol should I give it?
Drew
g
netstat -nlp | grep 3306
greetz,
boro
Drew Jenkins wrote:
Hi;
I just installed MySQL from FreeBSD port. I specified using openssl. Outside of
that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the
innodb stuff commented out. In preparing to install my database, I got this
Jay Pipes wrote:
Other variables you may want to look at is ensuring that your
table_cache (or table_open_cache if 5.1+) has enough room to deal
with 600 connections * the number of average tables in a typical SQL
expression executed against the server. If this variable value is
really low, y
Chris Boot wrote:
Jay Pipes wrote:
Chris Boot wrote:
Rolando Edwards wrote:
Also consider
wait_timeout in my.ini
This is set to 28800. I don't consider this a problem since I've
hardly ever got anywhere near my connection limit.
- Original Message -
From: "Rolando Edwards" <[EMA
Hi;
I just installed MySQL from FreeBSD port. I specified using openssl. Outside of
that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the
innodb stuff commented out. In preparing to install my database, I got this
error:
server312# mkdir /usr/local/localhost
server312# chown
Jay Pipes wrote:
Chris Boot wrote:
Rolando Edwards wrote:
Also consider
wait_timeout in my.ini
This is set to 28800. I don't consider this a problem since I've
hardly ever got anywhere near my connection limit.
- Original Message -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To:
Chris Boot wrote:
Rolando Edwards wrote:
Also consider
wait_timeout in my.ini
This is set to 28800. I don't consider this a problem since I've hardly
ever got anywhere near my connection limit.
- Original Message -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Chris Boot" <[EMA
Rolando Edwards wrote:
Also consider
wait_timeout in my.ini
This is set to 28800. I don't consider this a problem since I've hardly ever got
anywhere near my connection limit.
- Original Message -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Chris Boot" <[EMAIL PROTECTED]>
Cc:
Also consider
wait_timeout in my.ini
- Original Message -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Chris Boot" <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, March 2, 2007 2:19:38 PM (GMT-0500) Auto-Detected
Subject: Re: Heavily-loaded MySQL: Resource temporarily unav
I hope I am not asking dumb questions
but please consider the following:
1) Do you mysql_close every connection when rendering a page ?
2) Have you ever tried mysql_pconnect (which does not require doing a
mysql_close to any persistent connection) ?
3) Do you have interactive_timeout set (in seco
All,
I'm running a loaded MySQL server and every so often MySQL seems to refuse
connections in batches, which manifests itself as the following errors in PHP:
mysql_connect() [function.mysql-connect]:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
(11) [path to
> You SELECT statrment
> SELECT
> (s.server_disk_space * s.server_load * s.server_ram),
> s.server_fqdn,
> s.server_url,
> s.server_id
> INTO
> L_server_load,
> L_server_fqdn,
> L_server_url,
> L_server_id
> FROM clientdev.servers s
> WHERE s.active = 1
>
Mike,
Below is an message written a few months back tailing a discussion on
why MyISAM is and is not faster than InnoDB. Basically my understanding
is that if you have multiple simultaneous updates/inserts, stay away
from MyISAM.
We switched from MyISAM to InnoDB because of the concurrency is
I will have an application that will have 1000 20 row selects executed
every second. The application will also be updating individual rows from
this table at a rate of 100 rows/second. I prefer to use MyISAM instead of
InnoDb because eventually the table will exceed the amount of memory on the
You SELECT statrment
SELECT
(s.server_disk_space * s.server_load * s.server_ram) INTO
l_server_load,
s.server_fqdn INTO L_server_fqdn,
s.server_url INTO L_server_url,
s.server_id INTO L_server_id
FROM clientdev.servers s
WHERE s.active = 1
AND s.available = 1
ORDER BY
> Inserts are of the form (updates are analogous):
>
> insert into dns_records (zone, host, data, ... )
> values ('domain.com', 'www', '1.2.3.4', ... );
>
> Queries are of the form:
>
> select ttl, type, mx_priority, case
> when lower(type)='txt' then
> concat('\"', dat
20 matches
Mail list logo
