Clustrix now has a software version of their auto-sharding system. (It used to
be that they only sold an 'appliance'.)
> -Original Message-
> From: Andrew Morgan [mailto:andrew.mor...@oracle.com]
> Sent: Monday, March 18, 2013 6:51 AM
> To: Mike Franon
> Cc:
> Subject: RE: mysql cluster
Possibly related:
http://ronaldbradford.com/blog/why-sql_mode-is-important-2011-06-01/
http://rpbouman.blogspot.com/2009/01/mysqls-sqlmode-my-suggestions.html
http://gabrito.com/post/when-installing-mysql-always-set-the-sql-mode
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs
The Surge 2013 CFP is open. For details or to submit a paper, please visit
http://surge.omniti.com/2013
--
Katherine Jeschke
Director of Marketing and Creative Services
OmniTI Computer Consulting, Inc.
11830 West Market Place, Suite F
Fulton, MD 20759
O: 240-646-0770, 222
F: 301-497-2001
C: 443/6
> you never have hosted a large site
Check my email address before saying that.
20 may be low, but 100 is rather high.
> -Original Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Monday, March 18, 2013 1:36 PM
> To: mysql@lists.mysql.com
> Subject: Re: How to change
If you are running Apache with MaxClients set too high, that can cause the
problem. That Apache setting should be something like 20. (Other web servers
have similar settings.)
> -Original Message-
> From: Igor Shevtsov [mailto:nixofort...@gmail.com]
> Sent: Saturday, March 16, 2013 1:4
On Mon, 2013-03-18 at 21:35 +0100, Reindl Harald wrote:
>
> Am 18.03.2013 21:01, schrieb Rick James:
> > 20 is plenty if your pages run fast enough
>
> if your server can not serve more than 20 simultaionous
> requests you are not doing any serious things
>
or he's using a 286
signatu
Am 18.03.2013 21:01, schrieb Rick James:
> 20 is plenty if your pages run fast enough
it is not
you never have hosted a large site
> Excess clients after MaxClients are queued in Apache
so what - it doe snot help you
been there, done that
if you have some hundret USERS at the same time
any ev
20 is plenty if your pages run fast enough.
Excess clients after MaxClients are queued in Apache. If the 20 are consuming
resources (eg cpu/disk) it is better to queue the excess than to have everybody
stumbling over each other.
In MySQL, the excess clients beyond max_connections are give an err
Am 18.03.2013 19:26, schrieb Rick James:
> If you are running Apache with MaxClients set too high, that can cause the
> problem.
"too high" is relative
> That Apache setting should be something like 20. (Other web servers have
> similar settings.)
20 is a laughable value as long you are n
I have about 60 websites based on mysql and php. Suddenly they have all gone
blank, just white pages. The files are still on the server and I can see the
tables in all the databases via myphpadmin interfact. I'm not getting any
response from hosting gods yet. When I try to connect to server via
Check directory permissions, and check out the 'answers' in here:
http://forums.mysql.com/read.php?10,284776,284936
> -Original Message-
> From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
> Sent: Monday, March 18, 2013 12:05 PM
> To: mysql@lists.mysql.com
> Subject: MySQL Error#: 20
select * from tab where anwer_timestamp in (select max(anwer_timestamp) from
tab where q_id in (select distinct q_id from tab) group by q_id);
That query will be extremely slow if you have lots of data. This is because
the construct "in (select...)" is not optimized (until version 5.6).
select
> -Original Message-
> From: Mike Franon [mailto:kongfra...@gmail.com]
> Sent: 18 March 2013 13:34
> To:
> Subject: mysql cluster and auto shard
>
> I am looking at the best way to scale writes.
>
> Either using sharding with our existing infrastructure, or moving to
> mysql cluster.
13 matches
Mail list logo
