Monthly Archive: Aralık 2012

Using XFS File System for MySQL 0

Using XFS File System for MySQL

MySQL is preferred to be run on XFS file system due to its performance on direct IO. Even though many benchmarks have already come out with the latest Linux default file system Ext4 versus...

Linux: /tmp: Read-only file system Error 0

Linux: /tmp: Read-only file system Error

One of the server that I manage has problem as below when I want to edit some files in crontab: $ crontab -e /tmp/crontab.XXXX1ibTLU: Read-only file system It shows that the /tmp partition is...

jos_session 0

jos_session

DROP TABLE IF EXISTS `jos_session`; CREATE TABLE IF NOT EXISTS `jos_session` ( `username` varchar(150) default ”, `time` varchar(14) default ”, `session_id` varchar(200) NOT NULL default ‘0’, `guest` tinyint(4) default ‘1’, `userid` int(11) default ‘0’,...

SQL ile Mükerrer Kayıtları Bulmak 1

SQL ile Mükerrer Kayıtları Bulmak

1 den fazla olan yani mükerrer kayıtları göstermek isterseniz SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 ) ifadesini Tekil (Unique) kayıtları göstermek isterseniz SELECT email FROM...