Caution!! If any one of them dies and cannot be recovered, you will have a
mess to fix.
From: Prabhat Kumar [mailto:aim.prab...@gmail.com]
Sent: Wednesday, May 30, 2012 1:43 PM
To: Rick James
Cc: Anupam Karmarkar; Nigel Wood; mysql@lists.mysql.com
Subject: Re: Architectural Help
Hi Anupam,
You
"a" and "A" are identical, according to utf8_unicode_ci and utf8_general_ci,
but not utf8_bin.
That is, I would not expect "[" to slip in between them.
About 80% of the way down this page, there is a list of some of the
'equivalences' in selected collations:
http://mysql.rjweb.org/doc.php/charc
In phpMyAdmin it says the database collation is utf8_unicode_ci and each of
the columns is utf8_unicode_ci except the ID primary key column.
If you create a simple table with ID and TITLE and put the data below (each
row in a record) and run 'select * from table order by title' what do you
get?
C
I'll double check and get back.
Thanks,
-wes
On Wed, May 30, 2012 at 3:43 PM, Carlos Proal wrote:
>
> Hi Wes, have you double checked you character set and collation ??
>
> http://dev.mysql.com/doc/refman//5.5/en/charset-charsets.html
>
> The collation is which determines the sorting order.
>
>
Hi Wes, have you double checked you character set and collation ??
http://dev.mysql.com/doc/refman//5.5/en/charset-charsets.html
The collation is which determines the sorting order.
Carlos Proal
On Wed, May 30, 2012 at 4:02 PM, Wes James wrote:
> I have mysql 5.1.62-0ubuntu0.11.10.1 installe
I have mysql 5.1.62-0ubuntu0.11.10.1 installed, but the sort order for
utf8-unicode doesn't seem to be right. It is sorting some text like this
(order by title):
!
! *`-=[];',./~@#$%^&()_+{}|:"<>?\
!"
![
!@
!a
!A
!t
!test
'Coal age'
[
\--\
100 years
when it should be (shouldn't it?):
!
! *`-=[]
Hi Anupam,
You can achive this by circular replication, Circular replication between 4
nodes works fine. but not sure with 50 node server how practical it was.
Each database node will be a data center,
*Node 1 - data center 1* *->* *Node 2 - Data center 2* *->* *Node 3 - Data
Center 3* *->* *Nod
Check performance with script :
http://mysqltuner.pl/mysqltuner.pl - Variable tunning
http://hackmysql.com/mysqlidxchk - Unused Index
Thanks,
Prabhat
On Thu, May 24, 2012 at 4:32 PM, Rick James wrote:
> Thanks. I got tired of answering the same questions about buffer_pool and
> key_buffer ove
Dear MySQL users,
MySQL 5.5.25 is a new version of the 5.5 production release of the
world's most popular open source database. MySQL 5.5.25 is recommended
for use on production systems.
MySQL 5.5 includes several high-impact enhancements to improve the
performance and scalability of the MySQL D
Pesebe-san,
I'm sorry to i'm not clear what do you want to do.
do you mean like this? (exampled by Perl)
#---
use DBI;
$cn = DBI->connect("DBI:mysql:test","root","");
$st = $cn->prepare("SELECT t1.name AS cat,GROUP_CONCAT(t2.name) AS
subcat FROM `table` AS t1 LEFT JOIN `table` AS t2 ON t1.id =
t
On 05/07/2012 12:30 PM, Zhangzhigang wrote:
Thanks, i thought about this answer in the past, and i appreciate your reply.
How about the omelet?
What's your method?
--
RMA.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/m
Welcome to Hopper!
Claudio
Thank you Claudio, we hope it will serve it's purpose and we get lots of
feedback on it.
2012/5/25 Martijn Tonies
Dear ladies and gentlemen,
Upscene Productions is happy to announce the launch of a new
database-developer tool:
"Hopper" (public beta 1)
Hop
Hello everyone,
There's only a few days left to get a massive discount of 70%
on all database development products at Upscene Productions.
www.upscene.com
Database tools for:
- Firebird
- MySQL
- Microsoft SQL Server
- Oracle
- InterBase
- NexusDB
- Advantage Database
- ADO & ODBC
--
With re
and also id (either cat or subcat) can be called
- Original Message -
From: "HaidarPesebe"
To: "MySQL Lists"
Sent: Wednesday, May 30, 2012 2:31 PM
Subject: Re: category with parentid
Hello ts. Tanaka,
I've tried your way and succeed. Thank you.
But I want to ask your help again wh
Hello ts. Tanaka,
I've tried your way and succeed. Thank you.
But I want to ask your help again what if the result will be like this:
A. Cat A
- Subcat A
- Subcat A
2. CatB
- Subcat B
possible by using or
which the previous result is
Cat A - SubcatA, SubcatA
Cat B - SubcatB
15 matches
Mail list logo
