On Thu, Jul 22, 2010 at 8:42 PM, Kyong Kim wrote:
> Has anyone used this in production?
> We're looking at this as part of our sharding/scale strategy and
> wanted some insight into real world experience.
> Are there alternatives out there?
> Kyong
>
>
Lots of people are using MMM.
Alternatives
Thanks for the useful information. This is the answer I was. Looking
for.
Neil
On 22 Jul 2010, at 22:25, "Jerry Schwartz" wrote:
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, July 22, 2010 4:50 PM
To: Jerry Schwartz
Cc: Shawn Green (MySQL); mysql@lists.mysql.com
Now ur shouting ;) ;) ;) i was not. haha
U can say anything an escape with it without being brushed.go an take
poetry...where u can anything with any other thing...hehehe
Cheers,
Anirudh Sundar
On Fri, Jul 23, 2010 at 10:53 AM, Jan Steinman wrote:
>
> On 22 Jul 10, at 21:01, Anirudh S
On 22 Jul 10, at 21:01, Anirudh Sundar wrote:
SO ONE CANNOT COMPARE PHP WITH C.
I can compare anything I want to -- I took a poetry class in college!
("Her teeth were like the stars, 'cause they came out at night." :-)
If you STOP SHOUTING, people might take you more seriously.
-
Jay,
I am not incorrect.
PHP and C work on different domains.
SO ONE CANNOT COMPARE PHP WITH C. PHP IS A FULLY EVOLVED OBJECT ORIENTED
SERVER SIDE SCRIPTING LANGUAGE.
JUST BECAUSE PHP SYNTAX RESEMBLES C, DOES NOT MAKE IT LESS POWERFUL OR
INFERIOR OR LESS SCALABLE.
PHP IS INDEED A SELF SUFFICIE
Has anyone used this in production?
We're looking at this as part of our sharding/scale strategy and
wanted some insight into real world experience.
Are there alternatives out there?
Kyong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, July 22, 2010 4:50 PM
To: Jerry Schwartz
Cc: Shawn Green (MySQL); mysql@lists.mysql.com
Subject: Re: combined or single indexes?
Thanks for the information Jerry. Just to confirm, you mentioned "if you only
need one ke
Thanks for the information Jerry. Just to confirm, you mentioned "*if you
only need one key then you only need one key*". My question was that this
particular query was using SELECT against a primary key and other fields
which are NOT indexed. The EXPLAIN result was
table,type,possible_keys,key
>-Original Message-
>From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
>Sent: Thursday, July 22, 2010 3:39 PM
>To: Shawn Green (MySQL)
>Cc: mysql@lists.mysql.com
>Subject: Re: combined or single indexes?
>
>Thanks for your reply, and sorry for not verifying in the manual. Another
>
Running this query:
SELECT *
FROM `tbl_people`
WHERE name = 'Davé'
Returns results like:
'Dave'
I've checked my column, table and database and all are set to
utf8_general_ci collation
And I'm also runnig set names 'utf8' before my select statement.
Am I missing something obvious, I've had a
Thanks for your reply, and sorry for not verifying in the manual. Another
couple of questions I have :
If I run a EXPLAIN query and SELECT against a primary key and SELECT fields
which are not indexed, I assume that returned EXPLAIN statement as below,
means I don't need to index additional field
On 7/21/2010 1:02 PM, Tompkins Neil wrote:
Hi
So Just running a basic query I get returned the following :
table,type,possible_keys,key,key_len,ref,rows,Extra,
Products,ALL,9884,where used,
Therefore, I assume "*ALL*" is the worst possible type and should look at
adding a an index to this
On 22 Jul 10, at 01:25, Anirudh Sundar wrote:
Jay,
Actually, that was my comment.
Do not compare it with C. C is a middle -level System programming
language.
PHP's syntax is very much like C.
My point, which I guess wasn't clear, is that one of the reasons PHP
is popular (among the ma
On Thu, Jul 22, 2010 at 9:09 AM, John Daisley wrote:
> Sorry, my bad! Must learn to read the whole message!!
>
>
> This can be caused because when a foreign key is created mysql adds an
> index key to the column in addition to the foreign key. Why I'm not sure,
> but I'm guessing its for performan
On 7/21/2010 12:16 PM, Nunzio Daveri wrote:
database is around 150GB with over 5,000 tables. To make things worse, if I
shutdown MySQL, top-c still says all the memory is still used? Is this a bug,
why would it say all the memory is used when I turn off MySQL. The weird thing
is that when I rebo
Sorry, my bad! Must learn to read the whole message!!
This can be caused because when a foreign key is created mysql adds an index
key to the column in addition to the foreign key. Why I'm not sure, but
I'm guessing its for performance. To drop this foreign key
First do this to get the index nam
On Thu, Jul 22, 2010 at 8:47 AM, John Daisley wrote:
> Most likely a foreign key constraint would be violated if the table were
> dropped. Check those index definitions on `Store` and `User` columns.
>
But I don't want to drop the table, I want to drop the foreign key on Store.
How?
TIA,
V
>
> R
Most likely a foreign key constraint would be violated if the table were
dropped. Check those index definitions on `Store` and `User` columns.
Regards
John Daisley
Microsoft SQL Server 2005/2008 Database Administrator
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI
Hi;
mysql> alter table personalData drop foreign key Store;
ERROR 1025 (HY000): Error on rename of './test/personalData' to
'./test/#sql2-14ce-a61' (errno: 152)
mysql> describe personalData;
+---+--+--+-+++
| Field | T
On 7/21/2010 1:44 PM, Marc Guay wrote:
Hi everyone,
I have a question regarding database design, I hope that this is
appropriate for the list. Let's say that I have the following tables:
clients (id,name)
contacts (id, name, phone, client_id (FK))
companies (id, name)
employees (id, name, pho
[snip]
Jay,
PHP is a WEB based Server Side scripting Language.
Do not compare it with C. C is a middle -level System programming
language.
Please stop comparing.
[/snip]
The statements about C were not mine, it was just the way that the
thread was snipped together. Believe me when I say that I
Jay,
PHP is a WEB based Server Side scripting Language.
Do not compare it with C. C is a middle -level System programming language.
Please stop comparing.
On Sat, Jul 17, 2010 at 10:03 PM, Jan Steinman wrote:
> From: "Jay Blanchard"
>>
>>
>> You always have to use the right tool for the job
22 matches
Mail list logo
