Re: user last activity and log in

There is no such thing. Your application has to deal with such info. LS On Oct 4, 2012, at 11:28 AM, Aastha wrote: > Hello, > > I want to find the last time the given list of users logged in. > Is there any mysql table from where i can retrieve the data or anyt > specific sql > > > Aastha G

Re: Filesystem choice

Ext4 is faster to me. LS - Original Message - From: "rickytato rickytato" To: mysql@lists.mysql.com Sent: Tuesday, February 7, 2012 1:19:32 PM Subject: Filesystem choice Hi, I'm my new server I've to decided what filesystem to used. The server are dual amd six core 2.4GHz, 32GB ram,

mysqldumpslow error

I am using debian squeeze and mysql 5.1.45. I am trying to use mysqldumpslow -s c -t 10, but I keep getting the following error: Can't determine basedir from 'my_print_defaults mysqld' output: --general_log=on. Does anyone have any idea as to why? I am not getting anything from google. TIA,

Re: setting max_allowed_packet dynamically problem

Thanks for the explanation. LS On Nov 3, 2011, at 4:41 PM, Dan Nelson wrote: > In the last episode (Nov 03), List Man said: >> I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I >> attempted to change max packet with the following: SET GLOBAL >>

setting max_allowed_packet dynamically problem

I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configur