MemSQL學習筆記-類似MySQL的數據庫

wget?http://www.php.cn/  tar?xvfz?memsqlbin_amd64.tar.gzcd?memsqlbin./check_systemWarning:?The?version?of?CentOS?that?you're?using?(5.5)?is?too?low.MemSQL?supports?versions?6.0?and?up.  /home/manchun/memsqlbin/objdir/usr/local/bin/memsql-g++:?/lib64/libc.so.6:?version?GLIBC_2.11'?not  ?found?(required?by?/home/manchun/memsqlbin/objdir/usr/local/bin/memsql-g++)

[root@banggo?~]#?  wget?http://www.php.cn/  tar?zxvf?glibc-2.11.tar.gz  cd?glibc-2.11  mkdir?glibc-2.11-build  退出去在別的目錄執行如下編譯  /usr/src/glibc-2.11/configure?--prefix=/usr/src/glibc-2.11/glibc-2.11-build/  error:  checking?for?.cfi_personality?and?.cfi_lsda?pseudo-ops...?no?  configure:?error:?assembler?too?old,?.cfi_personality?support?missing

I?couldn't?overcome?that?problem,?and?I'm?wondering?how?I?can,?but?I?  said,?"hey?cuda?only?requires?glibc-2.7,?so?lets?compile?that".?I?went?  ahead,?and?installed?it?into?/share/apps/glibc-2.7.?So?here?comes?the?  main?question:?how?can?I?link?CUDA?C?to?the?glibc-2.7?installed?in?  /share/apps???Years?ago,?Tim?Carlson?has?said?"It?is?really?not?  practical?to?try?and?upgrade?glibc?to?2.5.?You?might?want?to?try?  installing?a?glibc?2.5?from?source?in?/share/apps/glibc-2.5?and?then?  use?LD_PRELOAD?to?load?that?library?in?for?you?CMAQ?binary.",?but?I?  don't?know?how?to?use?LD_PRELOAD,?and?I?would?appreciate?any?  guideline.

[root@banggo?~]#?  wget?http://www.php.cn/  tar?zxvf?glibc-2.8.tar.gz  cd?glibc-2.8  mkdir?glibc-2.8-build

/usr/src/glibc-2.8/configure?--prefix=/usr/src/glibc-2.8/glibc-2.8-build/  make  make?install

[root@banggo?memsqlbin]#?./check_system  Warning:?The?version?of?CentOS?that?you're?using?(5.5)?is?too?low.  MemSQL?supports?versions?6.0?and?up.  /home/manchun/memsqlbin/objdir/usr/local/bin/memsql-g++:?/lib64/libc.so.6:?version?'GLIBC_2.11'?not  ?found?(required?by?/home/manchun/memsqlbin/objdir/usr/local/bin/memsql-g++)

wget?http://www.php.cn/  tar?xvfz?memsqlbin_amd64.tar.gz  cd?memsqlbin  ?./check_system

Warning:?The?recommended?configuration?for?MemSQL?is?at?least?8?GB?of?RAM

?let?"mem_mb=$(free?-m?|?sed??-n?-e?'/^Mem:/s/^[^0-9]*([0-9]*)?.*/1/p')";  if?[?$mem_mb?-lt?1000?];?then  ????echo?"Warning:?The?recommended?configuration?for?MemSQL?is?at?least?1?GB?of?RAM"?1>&2  ????invalid='1'  fi  [root@memdb?memsqlbin]#??./check_system?  System?check?successful

[root@memdb?memsqlbin]#??./memsqld?--port?3308  299691?2012-06-27?13:26:26?WARNING:?SSE4.2?is?not?supported.?Resorting?to?software?CRC32C.  497378?2012-06-27?13:26:27?INFO:?Log?level?changed?to?0  120627?13:26:27?[ERROR]?Fatal?error:?Please?run?MemSQL?as?a?non-root?user?or?specify?-u?root?on?the?command?line.  120627?13:26:27?[ERROR]?Aborting  120627?13:26:27?[Note]?./memsqld:?Shutdown?complete  [root@memdb?memsqlbin]#??./memsqld?-u?root??--port?3308  292356?2012-06-27?13:26:54?WARNING:?SSE4.2?is?not?supported.?Resorting?to?software?CRC32C.  480363?2012-06-27?13:26:55?INFO:?Log?level?changed?to?0  120627?13:26:55?[Note]?./memsqld:?ready?for?connections.  Version:?'1b'??socket:?'/tmp/memsql.sock'??port:?3308

[root@memdb?~]#?mysql?-uroot?-p?-h?127.0.0.1?-P3308?--prompt="MemSQL>?"  Enter?password:?  Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?g.  Your?MySQL?connection?id?is?253  Server?version:?5.5.8?MemSQL?source?distribution  Copyright?(c)?2000,?2010,?Oracle?and/or?its?affiliates.?All?rights?reserved.  This?software?comes?with?ABSOLUTELY?NO?WARRANTY.?This?is?free?software,  and?you?are?welcome?to?modify?and?redistribute?it?under?the?GPL?v2?license  Type?'help;'?or?'h'?for?help.?Type?'c'?to?clear?the?current?input?statement.  MemSQL>?  MemSQL>?show?databases;  +--------------------+  |?Database???????????|  +--------------------+  |?information_schema?|  |?memsql?????????????|  +--------------------+  2?rows?in?set?(0.00?sec)  MemSQL>?use?memsql;  Database?changed  MemSQL>?show?tables;  Empty?set?(0.00?sec)  MemSQL>?use?information_schema;  Reading?table?information?for?completion?of?table?and?column?names  You?can?turn?off?this?feature?to?get?a?quicker?startup?with?-A  Database?changed  MemSQL>?show?tables;  +---------------------------------------+  |?Tables_in_information_schema??????????|  +---------------------------------------+  |?CHARACTER_SETS????????????????????????|  |?COLLATIONS????????????????????????????|  |?COLLATION_CHARACTER_SET_APPLICABILITY?|  |?COLUMNS???????????????????????????????|  |?COLUMN_PRIVILEGES?????????????????????|  |?ENGINES???????????????????????????????|  |?EVENTS????????????????????????????????|  |?FILES?????????????????????????????????|  |?GLOBAL_STATUS?????????????????????????|  |?GLOBAL_VARIABLES??????????????????????|  |?KEY_COLUMN_USAGE??????????????????????|  |?PARAMETERS????????????????????????????|  |?PARTITIONS????????????????????????????|  |?PLUGINS???????????????????????????????|  |?PROCESSLIST???????????????????????????|  |?PROFILING?????????????????????????????|  |?REFERENTIAL_CONSTRAINTS???????????????|  |?ROUTINES??????????????????????????????|  |?SCHEMATA??????????????????????????????|  |?SCHEMA_PRIVILEGES?????????????????????|  |?STATISTICS????????????????????????????|  |?TABLES????????????????????????????????|  |?TABLESPACES???????????????????????????|  |?TABLE_CONSTRAINTS?????????????????????|  |?TABLE_PRIVILEGES??????????????????????|  |?TRIGGERS??????????????????????????????|  |?USER_PRIVILEGES???????????????????????|  |?VIEWS?????????????????????????????????|  +---------------------------------------+  28?rows?in?set?(0.00?sec)  MemSQL>

[root@memdb?memsqlbin]#?ll?/root/memsqlbin/memsql.cnf?  -rw-r--r--.?1?1001?1001?1026??6月?18?20:07?/root/memsqlbin/memsql.cnf

MemSQL>?grant?all?on?*.*?to?tim@'%'?identified?by?"tim"??with?grant?option;  Query?OK,?1?row?affected?(0.01?sec)  MemSQL>?exit  Bye

[root@memdb?memsqlbin]#?mysql?-utim?-ptim?-h?127.0.0.1?-P3308?--prompt="MemSQL>?"????  ERROR?1045?(28000):?Access?denied?for?user?'tim'@'localhost'?(using?password:?YES)  [root@memdb?memsqlbin]#?mysql?-utim?-p?-h?127.0.0.1?-P3308?--prompt="MemSQL>?"???  Enter?password:?  Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?g.  Your?MySQL?connection?id?is?253  Server?version:?5.5.8?MemSQL?source?distribution  Copyright?(c)?2000,?2010,?Oracle?and/or?its?affiliates.?All?rights?reserved.  This?software?comes?with?ABSOLUTELY?NO?WARRANTY.?This?is?free?software,  and?you?are?welcome?to?modify?and?redistribute?it?under?the?GPL?v2?license  Type?'help;'?or?'h'?for?help.?Type?'c'?to?clear?the?current?input?statement.  MemSQL>?  CREATE?TABLE?test?(  ?id?int(11)?NOT?NULL?AUTO_INCREMENT,  ?excel_id?varchar(100)?NOT?NULL,  ?rpt_id?int(10)?unsigned?NOT?NULL,  ?acc_std?tinyint(3)?unsigned?NOT?NULL,  ?prd_year?int(10)?unsigned?NOT?NULL,  ?prd_qtr?tinyint(3)?unsigned?NOT?NULL,  ?accumulate?char(3)?NOT?NULL,  ?biz_cd?tinyint(3)?unsigned?NOT?NULL,  ?acc_cd?tinyint(3)?unsigned?NOT?NULL,  ?row_num?int(10)?unsigned?NOT?NULL,  ?col_num?int(10)?unsigned?NOT?NULL,  ?data_id?int(10)?unsigned?NOT?NULL,  ?data_trace?mediumtext?NOT?NULL?COMMENT?'trace信息',  ?trace_edit?tinyint(1)?NOT?NULL,  ?upd_stmp?timestamp?NOT?NULL?DEFAULT?'0000-00-00?00:00:00',  ?PRIMARY?KEY?(id)  )?;