[GIG] $500 For Site Speed Improvement

2012-03-28 Thread Rich Jones
Hey folks! This gig just popped up on our system, thought it could be some easy money for anybody out there who knows Ruby/Rails and how to optimize queries! http://gun.io/contracts/67/improve-site-speed-for-startup Thanks! -- Rich Jones Director, Gun.io

Re: big character constant

2012-03-28 Thread Todd Lyons
On Wed, Mar 28, 2012 at 1:47 AM, Nuno Tavares wrote: > Halász, not sure if I understood correcly, but you "mysql" console/client > may have different charsets. This means you should set it accordingly. Check Good catch, I had not considered that. > mysql> set names utf8; > Query OK, 0 rows affe

Re: Mysqld remote dont stop

2012-03-28 Thread Johan De Meersman
- Original Message - > From: "AdmSA" > We have a problem when we try to stop the mysql service (mysql Ver > 14.14 Distrib 5.5.12, for Linux (x86_64) using readline 5.1) on a > remote server throught SSH. > The problem is that mysql_safe, start again mysqld before that mysql > kill all th

Mysqld remote dont stop

2012-03-28 Thread AdmSA
Hello: We have a problem when we try to stop the mysql service (mysql Ver 14.14 Distrib 5.5.12, for Linux (x86_64) using readline 5.1) on a remote server throught SSH. The problem is that mysql_safe, start again mysqld before that mysql kill all the connection and stop the process. So cannot s

Re: big character constant

2012-03-28 Thread Nuno Tavares
Halász, not sure if I understood correcly, but you "mysql" console/client may have different charsets. This means you should set it accordingly. Check this out: mysql> show global variables like '%character_set%'; +--++ | Variable_name

Re: big character constant

2012-03-28 Thread Hal�sz S�ndor
2012/03/27 11:20 -0700, Todd Lyons This seems backwards from what I expected: mysql> select convert(0xE29C94 using latin1), convert(0xE29C94 using utf8) \G *** 1. row *** convert(0xE29C94 using latin1): ✔ convert(0xE29C94 using utf8)