Re: The most elegant/efficient way to pull this SQL query

;>>> 2012/04/11 11:30 -0700, Haluk Karamete I've got this relational mySQL table that ties peopleIDs from the people table to the states IDs peopleID___stateID 1__1 2__4 3__5 people table is like this; ___peopleID_FNam

Re: The most elegant/efficient way to pull this SQL query

On 4/11/2012 1:30 PM, Haluk Karamete wrote: I've got this relational mySQL table that ties peopleIDs from the people table to the states IDs peopleID___stateID 1__1 2__4 3__5 people table is like this; ___peopleID_FName__

Re: Instance tuning

Hey Bruce, Much of the output is inaccurate and the tool is rather dated. A On Wed, Apr 11, 2012 at 10:23 PM, Bruce Ferrell wrote: > I've long used mysqltuner.pl and have recently heard that it may not be > the best tool for the job. what are others using? What experiences have > you had with

Instance tuning

I've long used mysqltuner.pl and have recently heard that it may not be the best tool for the job. what are others using? What experiences have you had with mysqltuner.pl Inquiring minds want to know -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

did you check permission of file /var/run/mysqld/mysqld.sock On Wed, Apr 11, 2012 at 9:48 AM, Larry Martell wrote: > On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar wrote: > > Hi Guys, > > > > I am using debian squeeze it's working good, I am trying to install > > mysql-server. mysql-server instal

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar wrote: > Hi Guys, > > I am using debian squeeze it's working good, I am trying to install > mysql-server. mysql-server installation successfully but didn't start > service > root@devel:/var/run# more /etc/mysql/my.cnf |grep socket > # Remember to edit

Re: Licensing question about mysql_com.h

You might not know about proxy services. I am in Canada and can watch hulu.com etc if I am proxied in. Currently I use HotSpot shield from anchorfree.com and they have a free version. Mike - Original Message - From: "Claudio Nanni" To: "Paul Vallee" Cc: "James Ots" ; Sent: We

Re: Licensing question about mysql_com.h

And in europe we cannot watch all the american TV Series online :( 2012/4/11 Paul Vallee > If you own the code, you can license it under multiple licenses. > > Kind of like if you own a TV Show, you can license it in the US under one > contract, and in other geographies under other more or less

Re: Licensing question about mysql_com.h

If you own the code, you can license it under multiple licenses. Kind of like if you own a TV Show, you can license it in the US under one contract, and in other geographies under other more or less restrictive contracts. This is a painful reality to those of us in Canada, as we can't watch South

Re: forcing mysql to use batched key access (BKA) optimization,for joins

Hi Stephen, 2012/04/10 15:58 -0400, Stephen Tu >| id | select_type | table| type | possible_keys | key >| key_len | ref | rows| >Extra | >++-+--++-

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Il 11/04/2012 10:51, Ganesh Kumar ha scritto: Hi Guys, I am using debian squeeze it's working good, I am trying to install mysql-server. mysql-server installation successfully but didn't start root@devel:~# /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL databa