On Thu, Aug 26, 2010 at 6:04 AM, Norman Khine wrote:
> hello,
> i have a working master-slave replication, the problem i find is that
> if i restart the MASTER there is a difference in the MASTER_LOG_FILE
> and MASTER_LOG_POS on the SLAVE.
>
> what is the correct way to keep the two slaves in sync
Hi
I've a soccer application consisting of managers, teams players and
fixtures/results. Basically each manager will get points for each game
which will depend on the result.
What would be the best table design bearing in mind that a manager can
move to a different club.
My thought was
My apologies. With your example; SELECT MOD( X, 2 ), it will do exactly as you
say it will do.
-Original Message-
From: Christoph Boget [mailto:christoph.bo...@gmail.com]
Sent: Tuesday, August 31, 2010 2:26 PM
To: Coll-Barth, Michael
Cc: mysql@lists.mysql.com
Subject: Re: FW: Even or O
>> where X is your number (or column name). If 0, it's even if
>> 1 it's odd.
> I think you mean, if it is non-zero, then it is odd.
If you're MODding using 2 as the second argument, it's always going to
be 0 or 1. 2 either divides in to the number evenly, having a
remainder of 0, or it'll have
Not sure what you're trying to do, but if all you want to do is toggle
between two things (as in row color zebra stripes or something) then I
would suggest you not use some MOD() routine and instead just flip a
boolean.
For example in PHP just do:
just sayin'.
> -Original Message
- Original Message -
From: "Christoph Boget"
To: "Mike Blezien"
Cc: "MySQL List"
Sent: Tuesday, August 31, 2010 1:06 PM
Subject: Re: Even or Odds numbers
is there a function, using MySQL 5.0v, that can detect if a numerical value
is either an Even or Odd number
MOD()
http://dev.m
> -Original Message-
> From: Christoph Boget [mailto:christoph.bo...@gmail.com]
> http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.
html#function_mod
>
> SELECT MOD( X, 2 )
>
> where X is your number (or column name). If 0, it's even if
> 1 it's odd.
I think you mean,
> is there a function, using MySQL 5.0v, that can detect if a numerical value
> is either an Even or Odd number
MOD()
http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_mod
SELECT MOD( X, 2 )
where X is your number (or column name). If 0, it's even if 1 it's odd.
thnx
[snip]
is there a function, using MySQL 5.0v, that can detect if a numerical
value is
either an Even or Odd number
[/snip]
You can use modulus
http://www.roseindia.net/sql/mysql-example/mysql-modulus.shtml
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Hello,
is there a function, using MySQL 5.0v, that can detect if a numerical value is
either an Even or Odd number
Thanks,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
http://www.thunder-rai
This is a good place to start:
https://launchpad.net/mysql-tuning-primer
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Tuesday, August 31, 2010 5:38 AM
To: Johan De Meersman
Cc: kranthi kiran; mysql@lists.mysql.com
Subject: Re: Performance Tunning
So, it's n
In the last episode (Aug 30), Kyong Kim said:
> I've been going through the 5.1 manual and exploring the new features.
>
> To add a secondary index to an existing table, InnoDB scans the table, and
> sorts the rows using memory buffers and temporary files in order by the
> value(s) of the secondar
Hi Ananda
that worked fine:
mysql> alter table suomi_contacts2 modify history longtext character set
utf8 collate utf8_bin;
Query OK, 6327 rows affected (0.34 sec)
Records: 6327 Duplicates: 0 Warnings: 0
mysql>
mysql> update suomi_contacts2 set history = concat(now(), ' ', ''
,'concerne: u
Hi Ananda
not sofar. But if you recommend it, i will give it a try.
thanks so much.
suomi
On 2010-08-31 15:41, Ananda Kumar wrote:
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql mailto:my...@ayni.com>>
On 2010-08-31 15:17, Ananda Kumar wro
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql
> On 2010-08-31 15:17, Ananda Kumar wrote:
> > desc suomi_contacts2;
>
> mysql> desc suomi_contacts2;
>
> +--+--+--+-+---+
On 2010-08-31 15:17, Ananda Kumar wrote:
> desc suomi_contacts2;
mysql> desc suomi_contacts2;
+--+--+--+-+---+-+
| Field| Type | Null | Key | Default |
Extra
can u please give the output of
desc suomi_contacts2;
2010/8/31 mysql
> Hi Ananda
>
> table structure is:
>
> mysql> show full columns from suomi_contacts2;
>
> +--+--+---+--+-+---+-+-
Hi Ananda
table structure is:
mysql> show full columns from suomi_contacts2;
+--+--+---+--+-+---+-+-+-+
| Field| Type | Collation
can u please list out the table structure...as collation can also be set at
column level
regards
anandkl
On Tue, Aug 31, 2010 at 6:00 PM, mysql wrote:
> Hi listers
> mysql server here is
>
> mysql-server-5.1.48-2.fc13.x86_64
>
> this morning i created a message with a literal string in chinese
So, it's not just me that is stuck in this infinite loop? I thought I had
gone mad!
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
On Tue, Aug 31, 2010 at 5:23 AM, Johan De Meersman wrote:
> 1. Find out what is slow
> 2. Fix it
> 3. GOTO 1
>
> On Tue, Aug 31,
Hi listers
mysql server here is
mysql-server-5.1.48-2.fc13.x86_64
this morning i created a message with a literal string in chinese in it.
the messages in the application i used are stored in a mysql database,
when you submit them, like in a "sent" folder.
With this chinese literal in it, i,
Hi,
I also wondered, if there is any way to LIMIT the products.rating for each
language to say the top 25 ?
Cheers
Neil
On Tue, Aug 31, 2010 at 12:11 PM, Tompkins Neil <
neil.tompk...@googlemail.com> wrote:
> Perfect. Exactly what I was looking for.
>
> Cheers John.
>
> Regards,
> Neil
>
> On
On 31/08/2010 12:23 p, Johan De Meersman wrote:
1. Find out what is slow
2. Fix it
3. GOTO 1
Good one Johan, Performance tuning depends alot on your table types,
your server, the version of MySQL, how you client applications access
your database, the size of your data, type of queries, indexes
Perfect. Exactly what I was looking for.
Cheers John.
Regards,
Neil
On Tue, Aug 31, 2010 at 12:06 PM, John Daisley
wrote:
> SELECT products_sales.language, SUM(products.rating) AS products_rating
>
> FROM products_sales
> INNER JOIN products ON products_sales.products_id = products.products_id
SELECT products_sales.language, SUM(products.rating) AS products_rating
FROM products_sales
INNER JOIN products ON products_sales.products_id = products.products_id
WHERE products.enabled = 1
AND products_sales.language IN ('EN','ES')
GROUP BY products_sales.language
Will give the sum for each la
Sorry I don't want to SUM the varchar columns. This is the parameter passed
that defines the two different queries.
On Tue, Aug 31, 2010 at 11:48 AM, misiaQ wrote:
> I don't think that SUM will work for varchar columns.
> If I got your point right - you need to use WITH ROLLUP grouping
> http
I don't think that SUM will work for varchar columns.
If I got your point right - you need to use WITH ROLLUP grouping
http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
see second example on that page.
regards,
m
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@
Hi,
I've the following basic SUM for our products based on a rating.
SELECT SUM(products.rating) AS products_rating
FROM products_sales
INNER JOIN products ON products_sales.products_id = products.products_id
WHERE products.enabled = 1
AND products_sales.language = 'EN'
This works fine, however
1. Find out what is slow
2. Fix it
3. GOTO 1
On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran
wrote:
> Hi All,
> In performance tunning what are the steps can follow,please help
> me
>
> Thanks & Regards,
> Kranthi kiran
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt
---
kranthi kiran wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-7b9f42b217-2ea453372e-yAnBROFNjKN29DW37cRa_kmftE8
You'll
---
kranthi kiran wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-7b9f42b217-34446b6de3-Dp2zHVPU5AhNWkYs9pgMnHMgaM0
You'll
Hi All,
In performance tunning what are the steps can follow,please help
me
Thanks & Regards,
Kranthi kiran
32 matches
Mail list logo