-Original Message-
From: Mike Franon [mailto:kongfra...@gmail.com]
Sent: 18 March 2013 13:34
To: mysql@lists.mysql.com
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
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
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#: 2002
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
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 not
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
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
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
signature.asc
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:45
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 max
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:
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
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: mysql@lists.mysql.com
Subject:
13 matches
Mail list logo