Re: How to change max simultaneous connection parameter in mysql.

Am 02.04.2013 23:14, schrieb Rick James: > (Thanks for the comment, spameden.) > Well, I was going to drop the thread, but he baited me. I _do_ know > something about web serving... maybe > Should I recount the number of times I have traced a database meltdown back > to MaxClients being too

Re: All client commands to syslog?

2013/3/28 Rafał Radecki > Hi All. > > I have a production setup of four databases connected with > replication. I would like to log every command that clients execute > for auditing. > Take a look at general query log it's exactly what you need. http://dev.mysql.com/doc/refman/5.5/en/query-log

Re: How to change max simultaneous connection parameter in mysql.

2013/4/3 Rick James > SELECT is not performed in the same thread as nginx; it is performed in > another process, or even (in big web setups) in a different host. > Therefore, nginx would be in some form of "wait" state, thereby not really > using the CPU. > ofc select is not performed in nginx

RE: How to change max simultaneous connection parameter in mysql.

I hear that nginx is very fast for a certain class of web serving. But what happens if a web page needs to do a SELECT? Is nginx single-threaded, thereby sitting "idle" waiting for the SELECT? And, should you run 8 nginx web servers on an 8-core box? > -Original Message- > From: spam

RE: How to change max simultaneous connection parameter in mysql.

SELECT is not performed in the same thread as nginx; it is performed in another process, or even (in big web setups) in a different host. Therefore, nginx would be in some form of "wait" state, thereby not really using the CPU. > -Original Message- > From: Reindl Harald [mailto:h.rei...

Re: How to change max simultaneous connection parameter in mysql.

Am 02.04.2013 23:15, schrieb Rick James: > SELECT is not performed in the same thread as nginx; it is performed in > another process, or even (in big web setups) in a different host. Therefore, > nginx would be in some form of "wait" state, thereby not really using the CPU. tell me something

RE: How to change max simultaneous connection parameter in mysql.

(Thanks for the comment, spameden.) Well, I was going to drop the thread, but he baited me. I _do_ know something about web serving... Should I recount the number of times I have traced a database meltdown back to MaxClients being too big? They are _ugly_ meltdowns -- hundreds of point-querie

Re: How to change max simultaneous connection parameter in mysql.

Am 02.04.2013 22:56, schrieb Rick James: > I hear that nginx is very fast for a certain class of web serving. yes > But what happens if a web page needs to do a SELECT? what should happen? > Is nginx single-threaded, thereby sitting "idle" waiting for the SELECT? why should it do that?

Re: Please Help. selectcol_arrayref problem

Nope. That's just granting replication privileges so it can read updates on all tables on all databases. It cannot select anything. Why are you trying to connect with a replication slave user? On 4/2/13 1:47 PM, "Richard Reina" wrote: >I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'19

Re: Please Help. selectcol_arrayref problem

On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina wrote: > use DBI; > my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, { > RaiseError => 3 } ); > my $dbs = $dbh->selectcol_arrayref("show databases"); > > #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306"; > #my $dbh =

Re: Please Help. selectcol_arrayref problem

I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'192.168.0.23' IDENTIFIED BY 'psswd'; on the master. Doesn't *.* mean everything? Why would it just show me to databases? 2013/4/2 Larry Martell > On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina > wrote: > > use DBI; > > my $dbh = DBI->conn

Please Help. selectcol_arrayref problem

use DBI; my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, { RaiseError => 3 } ); my $dbs = $dbh->selectcol_arrayref("show databases"); #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306"; #my $dbh = DBI->connect($dsn, $usrr, $passw); my $dbs = $dbh->selectcol_arrayr

Re: How to change max simultaneous connection parameter in mysql.

Am 02.04.2013 16:09, schrieb spameden: > 2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James >: > >>> you never have hosted a large site > >> Check my email address before sayin

Re: How to change max simultaneous connection parameter in mysql.

2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > I do not judge only on 1 parameter, Rick has