Mnesia user manual 4.4.10
Contents
1. ADTRAN Mnesia Mnesia Mnesia Mnesia2. 6 9 3 EI Fallbacks mnesia install_fallback Opaque Mod Mod ok error Reason db nodes Mnesia Mnesia Mnesia
3. Mnesia ACID
4. 43 5 3 RNA 5 3 1 Mnesia local content snmp Mnesia mnesia frag mnesia access
5. error_logger inconsistent_database Context Node Mnesia mnesia system info db nodes MasterNode mnesia set master node MasterNode e error logger o mnesia fatal Format Args BinaryCore Mnesia Format Args io format 2 BinaryCore Mnesia RAM Core mnesia_info Format Args Mnesia
6. Mnesia Mnesia Mnesia Erlang disc copies disc only copies Mnesia
7. 71 7 Mnsia 5 SNMP 7 1 Mnesia 5 SNMP SNMP Mnesio SNMP Mnesia SNMP Mnesia Mnesia SNMP Mnesia 72 8 A Mnesia 3 Mnesia mnesia transaction Fun mnesia create_table N L aborted Reason Reason
8. Wildpattern mnesia table_info employee wild_pattern Or use Wildpattern employee _ _ employee Pat employee sex female _ _ F fun gt mnesia match_object Pat end Females mnesia transaction F i eee ene Pat employee emp_no 1 room no 1 _ F fun gt mnesia match_object Pat end Odd mnesia transaction F mnesia match_object 3 mnesia select 3 mnesia match_object 3 MatchHead employee name 1 sex male room_no 2 _ _ _ Guard gt 2 220 lt 2 230 Result 1 mnesia select employee MatchHead Guard Result Select
9. permanent change of nodes db_node EME size memory threshold temporary node down WEA overload threshold
10. raise 2 2 SBM insert_emp 3 employee at dept in_proj Mnesia 4 1 2 Enang Mnesia Mnesia 4 1 3 raise 2 lost update problem
11. Mnesia dirty operations 1 2 2 QLC Mnesia Session Mnesia Mnesia Mnesia Session QLC OTP Mnesia Session QLC Mnesia QLC Mnesia DBMS QLC Mnesia list comprehensions Mnesia Session Mnesia Mnesia Session Erlang Mnesia DBMS 1 2 2 1
12. 69 1 e mnesia backup checkpoint Name Opaque Mod e mnesia backup Opaque Mod e mnesia traverse backup Source SourceMod Target TargetMod Fun Acc mnesia backup mnesia_backup disc_log mnesia_backup Mnesia Mnesia Erlang mnesia backup_module lt module gt mnesia backup checkpoint Name Opaque Mod ok error Reason Name mnesia activate_checkpoint ArgList
13. Mnesia ann Mnesia mnesia_qown ram copies Mnesia Mnesia mnesia change table load order Tab LoadOrdenD load order 64 LoadOrder 0 load_order 0 6 7 Mnesia
14. fatomic Val Mnesia 36 add_subscriber S gt mnesia transaction fun gt case mnesia read add subscriber 1 ES add subscriber 1 UET TREER AT EEREMEATAELERETX MRE TRSA AA FH Ea async_dirty sync_dirty ets add_subscriber S gt mnesia transaction fun gt Transaction context mnesia read some_tab some_data mnesia sync dirty fun gt Still in a transaction context case mnesia read end end add subscriber2 S gt mnesia sync dirty fun gt 2596 In dirty context mnesia read some tab some data mnesia transaction fun gt In a transaction co
15. Mnesia Mnesia max wait for decision Mnesia 66 Mnesia inconsistent database bad deci
16. 60 mnesia deactivate_checkpoint Name Name Ac MR AURE ok error Reason Mnesia min max mnesia activate_checkpoint Args Ares e name Name Name
17. Mnesia disc_copie Mnesia ram_copies opt_disc schema location opt_disc BY eB mnesia change_table_copy_type 3 1 gt mnesia start ok 50 2 gt mnesia change_table_copy_type schema node disc_copies atomic ok mnesia start Mnesia 5 6 Mnesia mnesia add_table_copy 3 mnesia del_table_copy 2 Mnesia
18. Mnesia Attr foreign_key undefineq hash module Atom mnesia frag hash mnesia_frag_hash e mnesia frag old hash mnesia frag old hash erlang hash 1 WA hash_state Term undefinedo Eshell V4 7 3 3 abort with G a sam 1 gt mnesia start ok a sam 2 gt PrimProps n_fragments 7 node_pool node l n fragments 7 node pool a sam a s
19. set bag f0 gt F fun gt mnesia write foo 1 2 mnesia write foo 1 3 mnesia read foo 1 end mnesia transaction F 23 24 LOR foo set foo 1 3 bag foo 1 2 1 3 bag set Mnesia disc copies NodeList 1X8 NodeList le Xj disc copies disc_copies l 2 Xj disc copies ram copies NodeList iX NodeList
20. Fun mnesia transaction 1 Fun Fun bad_raise Eno Raise gt F fun gt E mnesia read employee Eno Salary E employee salary Raise New E employee salary Salary io format Trying to write n mnesia write New end mnesia transaction F Trying to write Mnesia Mnesia Mnesia Mnesia DBMS Mnesia Mnesia receive
21. 42 e mnesia match_object Pattern gt transaction abort RecordList 4 5 2 Mnesia Erlang Mnesia index type RAM mnesia create_table foo
22. true flase RAM_copies disc copies Mnesia ets FEUX ets mnesia ets Fun Args RAM_copies ets etc mnesia activity 2 3 4 access module Mnesia
23. Mnesia Mnesia Mnesia field Mnesia record employee emp_no name salary sex phone room no dept projects manager record dept id name record project name nu
24. e mnesia error_description Error 8 1 Mnesia Mnesia badarg e no_transaction combine_error bad_index e already_exists index exists no_exists e system limits e mnesia down e not_a_db_node bad type e node not running e truncated_binary_file active illegal mnesia create_table bar
25. extra_db_nodes Mnesia mnesia extra db nodes NodeList Mnesia Mnesia mnesia change_config 2 extra_db_nodes mnesia change_config extra_db_nodes NodeList Sschema location Mnesia Disc Mnesia Mneia Ram extra db nodes extra db nodes opt_disc
26. mnesia start0 ok e mnesia wait_for_tables TabList Timeout Tablist Mnesia mnesia wait for tables 2 22 e mnesia force load table Tab a b case mnesia wait_
27. Mnesia Mnesia Mnesia e mnesia transaction Fun gt aborted Reason atomic Value iX Fun e mnesia read Tab Key gt transaction abort RecordList MR Tab Key bag read Tab Key set e mnesia wread Tab Key gt transaction abort RecordList read 1
28. Mnesia mnesia uninstall_fallback Erlang Mnesia 6 9 4 UNIX fsck Mnesia Mnesia mnesia auto repair lt bool gt Mnesia lt bool gt ttue Mnesia lt bool gt false Mnesia DAT
29. e max MaxTabs MaxTabs RARE cine mnesia add table_copy 3 ee e min MinTabs MinTabs e allow_remote Bool False t rue trueo e ram overrides dump Bool ram copies Bool True false DAT
30. auto_repair 63 X E Mnesia Mnesia disc_copies DCL DCD 6 6 Mnesia Mnesia Mnesia Mnesia Mnesia Mnesia Mnesia Mnesia mnesia_down mnesia down
31. local content Mnesia attributes AtomList AtomList ER key val record_info fields record_name record_info fields record_name Erlang record foo x y z record_info fields foo x y z record_info 2 record_info 2 o record name Atom 4 record funky x y
32. 123 Pl P2 5 Pl 2 Pl P2 P2 3 8 Pl 7 P2 P2 4 1 4 27 Mnesia
33. 4 55 5 10 Mnesia estem Mnesia FM REDE e mnesia load_textfile Filename Mnesiq Mnesia anaes E e mnesia dump_to_textfile Filename Mnesia Mnesia tables Typename Options Typename2 HN Typename Attributel Atrrib
34. mnesia create_schema 1 3 Mnesia klacke gin 3 gt mnesia start ok Mnesia rw rw r 1 klacke staff 86 May 26 19 03 LATEST LOG rw rw r 1 klacke staff 34507 May 26 19 03 schema DAT FALLBACK BUP schema DAT FALLBACK BUP Mnesia 4 klacke gin 4 gt mnesia create_table foo disc_copies node atomic ok Mnesia ls l ldisc scratch klacke rw rw r 1 klacke staff 86 May 26 19 07 LATEST LOG rw rw r 1 klacke staff 94 May 26 19 07 foo DCD rw rw r klacke staff 6679 May 26 19 07 schema DAT 62 foo DCD foo 6 5 2 Mnesia LATEST LOG
35. Mnesia disc copies disc_only_copies Mnesia Mnesia disc_log Mnesia DAT DCD DCL foo 4 elvis 6 Mnesia foo DCL Mnesia DCL DCD Mesia 100 3 Mnesia El mnesia dump log write threshold WriteOperations mnesia dump_log_time_threshold MilliSecs
36. y bag mnesia create_table funky disc_copies N1 N2 index VI type bag attributes record_info fields funky mnesia create_table stuff key val 25 4 Mnesia Mnesia table lock FAR sticky lock dirty operation nested transaction e Activity KREBS 4 1 Mnesia
37. Mnesia Erlang Mnesia Schema Mnesia 2 1 Mnesia Mnesia Erlang shell unix erl mnesia dir tmp funky Erlang BEAM emulator version 4 9 Eshell V4 9 abort with G 1 1 gt mnesia create_schema node ok 2 gt mnesia start ok 3 gt mnesia create_table funky atomic ok 4 gt mnesia info gt Processes holding locks lt gt Processes waiting for locks lt gt Pending remote transactions lt gt Active local transactions lt gt Uncertain transactions lt gt Active tables lt funky with O records occupying 269 words of mem schema with 2 records occupying 353 words of mem gt System info in version 1 0 debug level none lt opt_disc Directory tmp funky is used use fall back at restart false running db nodes nonode nohost stopped db nodes remote ram_copies funky disc_copies schema disc_only_copies nonode nohost disc_copies schema nonode nohost ram_copies funky 1 transactions committed 0
38. mnesia create_table subscriber subscriben my subscriber your_subscriber subscriber TabDef record_name subscriber mnesia create_table my_subscriber TabDef mnesia create_table your_subscriber TabDef subscriber ic mnesia write 3 mnesia write 1 mnesia s_write 1 mnesia write subscriber subscriber write mnesia write my subscriber subscriber sticky_write mnesia write your subscriber subscriber write mnesia dirty_write Record gt Tab element 1 Record mnesia dirty_write Tab Record mnesia dirty_delete Tab Key gt mnesia dirty_delete Tab Key mnesia dirty_delete_object Record gt Tab element 1 Record mnesia dirty_delete_object Tab Record mnesia dirty_update_counter Tab Key Incr gt mnesia dirty_update_counter Tab Key Incr 33 34 mnesia dirty_r
39. Fun Mnesia Fun raise Eno Raise gt F fun gt E mnesia read employee Eno write Salary E employee salary Raise New E employee salary Salary mnesia write New end mnesia transaction F raise Eno Raise gt Eun Fun mnesia transaction F Mnesia Fun 26 Mnesia A C D D 55 ACID 4 1 1
40. C mnesia frag erl mnesia table_info 2 QLC HE QLC QLC QLC transaction sync transaction async_dirty sync dirty and ets ets mnesia dirty_ async_dirty 4 6 HR ESS SSALMESRE PFSSUORMARRSSBHTEM THEE Fh FES aborted Reason
41. Mnesia e mnesia read_lock_table Tab Tab e mnesia write lock table Tab EX Tab mnesia lock table Tab read mnesia lock table Tab write Mnesia 488 Rey 30 4 2 3 RARES i mnesia lock 2 m mnesia lock global GlobalKey Nodes LockKind LockKind read write Lockltem 4 3
42. Mnesia Ail TabName Key Integer AN L 2 HBA dirty update counter 2 dirty_update_counter 2 HM WR BK mnesia dirty match object Pat mnesia match _ object 1 mnesia dirty_select Tab Pat EKA AF mnesia select 2 mnesia dirty index match object Pat Pos KKA ESAF mnesia index_match_object 2 e mnesia dirty_index_read Tab SecondaryKey Pos mnesia index_read 3 e mnesia dirty all keys Tab KKA ESRB mnesia all keys 1 4 4 ft Mnesia TAR PIAS PA iG Sif ice SO record name elt
43. mnesia change_table_frag 2 mnesia add_table_copy 3 mnesia del_table_copy 2 mnesia change_table_copy_type 2 5 4 So ee eee 49 local_content true 5 5 Mnesia disc copie Bk disc only copies schema Mnesia disc copies ram copies disc only copies Mnesia
44. nodeO ram copies mnesia dump_tables TabList disc only copies NodeList index AttributeNameList AttributeNameList Mnesio Mnesia 2 snmp SnmpStruct SnmpStruct SNMP mnesia create_table 2 ArgList SNMP SNMP Mnesia SNMP Mnesia local content true
45. Erlang OTP 1 1 Mnesia DBMS Mnesia Mnesia 5 Erlang Erlang Mnesia Erlang Mnesia Erlang Mnesia 1 key value 2 3
46. ArsgList 3 company init 0 manager in_proj bag at_dep set set bag mnesia info0 7 6 6 6 at dep in proj insert_emp Emp Deptld ProjNames gt Ename Emp employee name Fun fun gt mnesia write Emp AtDep at_dep emp Ename dept id Deptld mnesia write AtDep mk_projs Ename ProjNames end 12 mnesia transaction Fun mk_projs Ename ProjNamelTail gt mnesia write in_proj emp Ename proj name ProjName mk_projs Ename Tail mk_projs _ gt ok e insert emp Emp DeptId P
47. exit aborted Reason e mnesia dirty_read Tab Key Mnesia e mnesia dirty_write Record Record e mnesia dirty_delete Tab Key Key e mnesia dirty delete object Record JER delete _object 1 e mnesia dqirty first Tab Tab set bag FER LAY Yol o dirty_next 2 31 32 Sendq_of_ table o mnesia dirty_next Tab Key Tab Send of table dirty next 2
48. Fun NewAcc XR 45 PR De MM EE TargetMod read_only SourceMod TargetMod BackupItems schema Tab e schema Tab CreateList mnesia create table 2 CreateList Tab Rey Record Tab record_name db node mnesia traverse_backup
49. Mnesia 1 gin gin erl sname a mnesia dir ldisc scratch Mnesia company 2 skeppet skeppet erl sname b mnesia dir ldisc scratch Mnesia company 3 a ginl gt mnesia create_schema a gin b skeppet 4 mnesia start 5 CES EI m mnesia create table employee ram copies a gin b skeppet attributes record info fields employee mnesia create table dept ram copies a gin b skeppet attributes record info fields dept mnesia create table project ram copies a gin b skeppet attributes record_info fields project mnesia create_table manager type bag ram copies a gin b skeppet attributes record_info fields manager 21 mnesia create table at dep ram copies a gin b skeppet attributes record info fields at dep mnesia create table in proj type bag ram copies a gin b skeppet attributes record info fields in_proj ldisc scratch
50. Es Erlang mnesia start Mnesia Mnesia mnesia stopO Mnesia start O stop 0 Mnesia 3 3 2 Mnesia mnesia start DBMS 1 Mnesia 2 Mnesia 3
51. e mnesia add_table_copy Tab Node Type Node Tab RAY Type ram copies disc copies disc_only_copies schema Mnesia Mnesia mnesia del table copy Tab Node Node Tab e mnesia transform_table Tab Fun NewAttributeList NewRecordName Tab Fun Key ecorme ele isey UNS record new Rey val extra Transformer fun X when record X old gt new key X old key val X old val extra 42 end atomic ok mnesia transform_table foo Transformer record_info fields new new Fun ignore meta AA
52. mnesia dump log update in place lt bool gt mnesia dump_log0 Mnesia DAT DAT false Mnesia DAT DAT 70 disc only copies disc_only_copies disc_only_copies DAT Mnesia
53. Opaque Mnesia Mnesia mnesia backup Mod 67 mnesia backup Opaque Mod Mnesia local_contents Ee ok LastAcc mnesia traverse_backup Source SourceMod Target TargeMod Fun Acc SourceMod open_read Source TargetMod open_write Target e SourceMod TargetMod e Source Al Targe SourceMod TargetMod Acc e Fun Backupltems Acc e valGoodqBackupItems NewAcc ValidBackupItems Newacc TargetMod write 2 ValidBacRupItems e LastAcc
54. 2 F fun gt mnesia s_write foo a kalle end mnesia transaction F s_write 1 write l s write 1 NI N1 N1 Mnesia NI1 stuck N2 unstuck N2 5 s_write 1 unsticking 4 2 2 Mnesia
55. cookie Mnesia cookie cookie e cookie disc_copies cookie cookie ram_copies 1 ram copies schema change table copy type 3o 2 mynode host mnesia 51 cookie ram copies Bk disc copies cookie cookie EA RAM mnesia system info schema location fA mnesia system_info extra_db_nodes schema location extra db nodes mnesia system_info use_dir Mnesia Mnesia use_dir Mnesia mnesia info 0
56. LATEST LOG PREVIOUS LOG LATEST LOG PREVIOUS LOG 6 5 3 DAT schema DAT DAT DAT disc only copies Ro Mnesia dets dets Mnesia dets dets traverse 2 Mnesia Mnesia ok N dets open_file schema file schema DAT repair false keypos 2 jy Gebel au RO Mat Majo ICS continuen ene dets traverse N F dets close N staq_lip aets repair false Mnesio
57. Mnesia Mnesia Mnesia disc copies lla 5 7 Mnesia Mnesia Mnesia mnesia subscribe Event Category Event Category mnesia unsubscribe Event Category Event Category Event Category system table Tab simple table Tab detailed table Tab table Tab simple mnesia subscribe l mnesia_system_event
58. mnesia read 1 mnesia write 1 e mnesia write Record gt transaction abort ok Record ok B er mnesia delete Tab Key gt transaction abort ok Key e mnesia delete oe eee transaction abort ok Record bag 4 2 1 Sticky Mnesia i ds Mnesia a 29 F fun gt mnesia write foo a kalle end mnesia transaction F foo N1 N2
59. db node change_node_name Mod From To Source Target gt Switch fun Node when Node From gt To Node when Node To gt throw error already_exists Node gt Node end 68 Convert fun schema db_nodes Nodes Acc gt schema db nodes lists map Switch Nodes Acc schema version Version Acc gt schema version Version Acc schema cookie Cookie Acc gt schema cookie Cookie Acc schema Tab CreateList Acc gt Keys ram copies disc copies disc only copies OptSwitch fun Key Val gt case lists member Key Keys of true gt Key lists map Switch Val false gt Key Val end end schema Tab lists map OptSwitch CreateList Acc Other Acc gt Other Acc end mnesia traverse_backup Source Mod Target Mod Convert switched view Source Mod gt View fun Item Acc gt io format p n Item tem Acc 1 end mnesia traverse_backup Source Mod dummy read_only View 0 6 9 2 Mnesia mnesia restore Opaque Args Args module Mod Mod e skip tables TableList i
60. mnesia set_master_nodes Nodes Nodes TabNodes mnesia set master nodes Tab TabNodes BN TabNodes Nodes mnesia system_info master_node_tables mnesia table info Tab master_nodes mnesia force_load_table Tab 6 8 Mnesia Mnesia Mnesia 65 Mnesia
61. Mnesia Enlang Mnesia Mnesia Mnesia mnesia down Mnesia inconsistent_database running_partitioned_network Node Mnesia Mnesia mnesia_down inconsistent_database starting_partitioned_network Node mnesia set_master_nodes Tab Nodes Mnesia moster nodes mnesia down KH Nodes
62. bug Mnesia core dump 6 3 ram_copies mnesia dump_tables TabList RAM ram_copies DCD Mnesia DCD RAM Ro 6 4 Mnesia
63. mnesia del_table_copy schema mynode host Mnesia mynode host Mnesia mynode host Mnesia mynode host mnesia H mnesia delete schema 1 mnesia mynode host mnesia ram_copies Mnesia disc_copies mnesia create_schema 1 Mnesia cookie mnesia create_table 2 Mnesia Mnesia sanity test
64. 4 5 6 Mnesia Mnesia Mnesia Erlang Erlang 1 2 Mnesia DBMS 1 2 1 Mnesia schema a eee location replication persistence BI
65. del_frag 47 add_node Node node_pool mnesia table_info Tab frag_dist del_node Node node pool mnesia table_info Tab frag_dist 5 3 4 mnesia create_table 2 frag properties mnesia delete_table 1 mnesia table_info 2 frag_properties mnesia_frag mnesia table_info 2 EH ms base_table n_fragments node_pool n_ram_copies n_disc_copies n_disc_only_copies ram c
66. e change table copy type Tab Node ToType Node Tab 3 2 Mnesia oid o Da demie dS 104732 klacke 7 male 98108 221 015 Oid BIA employee 104732 record key Oid Key 4 S Mnesia Erlang term oids DBMS 20 3 3 Mnesia
67. manager 2 at dep 3 in_proj 2 2 2 record company hrl ss no record dept ide record project AUAWREr record managera x record at dep fu record in proj BR ame p OS TE Mnesia E ER 2X mnesia create table Name ArgList FH Name Mnesia FRERE table record 4 Record Names Versus Table Names o mnesia create_table employee attributes record_info fields employee l employee K K emplpyee ArgList Erlang record_info fields RecordName 2 2 3 shell Mnesia schemas erl mnesia dir Idisc scratch Mnesia Company Erlang BEAM emulator version 4 9 Eshell V4 9 abort with G 1 gt mnesia create sc
68. Mnesia 2 Mnesia Mnesia 4 Mnesia 5 Mnesia Mnesia 6 Mnesia Mnesia 7 Mnesia SNMP Mnesia SNMP A Mnesia Mnesia MRE C 2 FF Mnesia Mnesia
69. Mnesia DELFT Mnesia erl mnesia debug verbose 5 9 Mnesia Erlang Mnesia
70. mnesia activity 4 mnesia_frag mnesia_access mnesia_frag hash ordered set select math_object Mnesia Eshell V4 7 3 3 abort with G a sam 1 gt mnesia start ok a sam 2 gt mnesia system info running db nodes b sam c sam a sam a sam 3 gt Tab dictionary dictionary a sam 4 gt mnesia create table Tab ram_copies a 9 sam b sam atomic ok a sam 5 gt Write fun Keys gt mnesia write Tab K K I K lt Keys ok end Fun lt erl_eval gt a sam 6 gt mnesia activity sync_dirty Write lists seq 1 256 mnesia_frag ok a sam 7 gt mnesia change_table_frag Tab activate atomic ok a sam 8 gt mnesia table_info Tab frag_properties base_table dictionary foreign_key undefined 44
71. Format Args io format 2 io format 2 mnesia_error Format Args 53 Mnesia Format Margs io format 2 mnesia_user Event mnesia report_event Event Event Erlang amp Mnesia Mnesia Mnesia mnesia report_event 1 5 7 2 Oper Record ActivityId Oper Record ActivityId
72. Mnesia Mnesia 5 1 Mnesia e mnesia add table index Tab AttributeName gt aborted R atomic ok mnesia del_table_index Tab AttributeName gt aborted R atomic ok AttributeName employee emp no name salary sex phone room_no salary 1 mnesia add_table_index employee salary Mnesia 3 e mnesia index_read Tab SecondaryKey AttributeName gt transaction abort RecordList SecondaryKey e mnesia index_match_object Pattern AttributeName gt transaction abort RecordList Pattern AY AttributeName
73. mnesia match_object 3 Select MatchSpecificatio MatchFunctions MatchHead MatchCondition MatchBody MatchHead mnesia match_object 3 MatchCondition MatchBody 38 Erts Erlang ets gets select 4 select 1 Continuation Mnesia NObjects NObjects mnesia select 1 2 3 4 mnesia select mnesia write 1 El mnesia delete lo
74. Mnesia Mnesia Mnesia dets ets disc log 1 2 3 OTP Mnesia Mnesia OTP Mnesia 1 2 4 Erlang 1 2 5 2 Mnesia Mnesia Erlang Mnesia Mnesia 3
75. Erlang shell 11 3 gt company init atomic ok 4 gt mnesia info gt Processes holding locks lt gt Processes waiting for locks lt gt Pending remote transactions lt gt Active local transactions lt gt Uncertain transactions lt gt Active tables lt in_proj with 0 records occuping 269 words of mem at_dep with 0 records occuping 269 words of mem manager with O records occuping 269 words of mem project with O records occuping 269 words of mem dept with 0 records occuping 269 words of mem employee with O records occuping 269 words of mem schema with 7 records occuping 571 words of mem gt System info in version 1 0 debug level none lt opt disc Directory Idisc scratch Mnesia Company is used use fall back at restart false running db nodes nonode nohost stopped db nodes remote ram_copies at_dep dept employee in_proj manager project disc_copies schema disc_only_copies nonode nohost disc_copies schema nonode nohost ram_copies employee dept project manager at_dep in_proj 6 transactions committed 0 aborted 0 restarted 6 logged to disc 0 held locks 0 in queue 0 local transactions 0 remote 0 transactions waits for other nodes ok e Imnesia create_table Name ArgLisb
76. Mnesia mnesia wait_for_tables TabList Timeout mnesia force_load_table Tab Mnesia Hmnesia force load table Tab read_only Rix Bkread write 1x5 AccessMode 3FE H AM mnesia change_table_access_mode Tab AccessMode read_only local_content
77. 1 mnesia match object QLC Mnesia mnesia table 112 E 73 E QLC Mnesia Mnesia mnesia table 1I2 lock Lock n_objects lnteger traverse SelMethod lock Mnesia Di n objects chunk QLC traverse mnesia selecto EX mnesia table 2 traverse select MatchSpecification 100 select mnesia table Tab gt mnesia table Tab n_objects 100 lock read traverse select mnesia all_keys Tab Mnesia mnesia foldl Fun Acc0 Tab gt NewAcc transaction abort mnesia foldr Fun Acc0 Tab gt NewAcc transaction a
78. Mnesia Erlang disc create_schema NodeList mnesia start o HAA Z4E S HRA SLIME mnesia start mnesia start Erlang shell 3 3 1 Mnesia a gin b skeppet 2 Mnesia Mnesia Mnesia EX Jaz Erlang shell Mnesia erl mnesia dir Idisc scratch Mnesia Company flag Mnesia Erlang shell
79. record name write NewRecord ActivityId NewRecord delete object OldRecord ActivityId mnesia delete_object 1 OldRecord bag delete Tab Key ActivityId Tab HHA Key Oper Table Data OldRecs ActivityId Oper Table Data oid OldRecs ActivityId write Table NewRecord OldRecords ActivityId NewRecord OldRecords delete Table What OldRecords ActivityId What Table Key RecordName Rey 5 8
80. false mnesia activate_checkpoint Args e ok Name Nodes e error Reason Name Nodes e mnesia system_info checkpoints e mnesia table_info Tab checkpoints ee 6 5 Mnesia 6 5 1 3 Mnesia 3 Mnesia Erlang Mnesia mnesia create_schema 1 l erl sname klacke mnesia dir ldisc scratch klacke 2 Erlang BEAM emulator version 4 9 Eshell V4 9 abort with G klacke gin 1 gt mnesia create_schema node ok klacke gin 2 gt Z Suspended Mnesia ls l ldisc scratch klacke rw rw r 1 klacke staff 247 Aug 12 15 06 FALLBACK BUP FALLBACK BUP
81. 4 2 Mnesia two phase locking Mnesia 5 Mnesia h Sticky Mnesia mnesia read 1 Mnesia Mnesia wait die Mnesia
82. Mnesia Mnesia BAAR Mnesia e mnesia set_debug_level Level 54 Level none verbose mnesia_info Format Args mnesia subscribe 1 Mnesia debug verbose mnesia_info Format Args mnesia subscribe 1 Mnesia Mnesia trace Mnesia Mnesia false none true debug Erlang
83. Frag Item end first ActivityId Opaque Tab gt case catch_val Tab frag_hash of EXIT _ gt 81 mnesia first ActivityId Opaque Tab FH gt FirstFrag Tab case mnesia first ActivityId Opaque FirstFrag of Send of table gt search first ActivityId Opaque Tab 1 FH Next gt Next end end search first ActivityId Opaque Tab N FH when N lt FH frag_state n_fragments gt NextN N 1 NextFrag n_to_frag_name Tab NextN case mnesia first ActivityId Opaque NextFrag of Send of table gt search first ActivityId Opaque Tab NextN FH Next gt Next end search_first _ActivityId Opaque Tab N _FH gt Send of table last ActivityId Opaque Tab gt case catch val Tab frag hash of EXIT _ gt mnesia last ActivityId Opaque Tab FH gt LastN FH frag_state n_fragments search_last ActivityId Opaque Tab LastN FH end search_last ActivityId Opaque Tab N FH when N gt 1 gt Frag n_to_frag_name Tab N case mnesia last ActivityId Opaque Frag of Send of table gt PrevN N 1 search_last ActivityId Opaque Tab PrevN FH Prev gt Prev end search_last _ActivityId Opaque Tab N FH gt Send of table prev ActivityId Opaque Tab Key gt case catch_val Tab frag_hash of EXIT _ gt mnesia prev ActivityId Opaque Tab Rey FH gt N key_to_n FH Key Frag n_to_frag_nam
84. Mnesia jg HER 8 mnesia dirty last Tab ILS mnesia dirty_first 1 ordered_set Erang mnesia dirty_first 1 mesia dirty_last 1 mnesia dirty prev Tab Key mnesia dirty_next 2 ordered_set Erlang mnesia dirty_next 2 mesia dirty_prev 2 mnesia dirty_slot Tab Slot Slot dirty_next 2 0 slots dirty slot 2 Send_of table o mnesia read_lock_table Tab HR Ste TAN HT mnesia dirty update counter Tab Key Val 0 Val Val
85. e QLC 2 2 7 1 Mnesia mnesia select employee employee sex female name 1 _ _ 1 select shell all_females gt F fun gt Female employee sex female name 1 _ mnesia select employee Female 1 end mnesia transaction F select employee sex A female shell 1 gt company all_females klacke gin 1 gt company all_females atomic Carlsson Tuula Fedoriw Anna 4 7 Pattern Matching select 2 2 7 2 QLC QLC QLC QLC Mnesia Q qlc q E employee name ll E lt mnesia table employee E employee sex female qlc e Q QLC Mnesia females gt F fun gt Q qlc q
86. frag names Tab foldr ActivityId Opaque Fun Acc Tab LockKind gt Fun2 fun Frag A gt mnesia foldr ActivityId Opaque Fun A Frag LockKind 80 end lists foldr Fun2 Acc frag_names Tab table_info ActivityId Opaque Tab Key Item gt Frag key_to_frag_name Tab Key table_info2 ActivityId Opaque Tab Frag Item table_info ActivityId Opaque Tab Item gt table info2 ActivityId Opaque Tab Tab Item table_info2 ActivityId Opaque Tab Frag Item gt case Item of size gt SumFun fun _ Size Acc gt Acc Size end lists foldi SumFun 0 frag size ActivityId Opaque Tab memory gt SumFun fun _ Size Acc gt Acc Size end lists foldi SumFun 0 frag memory ActivityId Opaque Tab base_table gt lookup_prop Tab base_table node_pool gt lookup_prop Tab node_pool n_fragments gt FH lookup_frag_hash Tab FH frag_state n_fragments foreign_key gt FH lookup_frag_hash Tab FH frag_state foreign_key foreigners gt lookup_foreigners Tab n_ram_copies gt length val Tab ram copies n disc copies gt length val Tab disc copies n disc only copies gt length val Tab disc only copies frag names gt frag names Tab frag dist gt frag dist Tab frag size gt frag size ActivityId Opaque Tab frag memory gt frag memory ActivityId Opaque Tab gt mnesia table_info ActivityId Opaque
87. n_doubles 0 n_fragments next_n_to_split 1 node_pool a sam b sam c sam a sam 9 gt Info fun Item gt mnesia table_info Tab Item end Fun lt erl_eval gt a sam 10 gt Dist mnesia activity sync_dirty Info frag_dist mnesia_frag c sam 0 a sam 1 b sam 1 a sam 11 gt mnesia change_table_frag Tab add_frag Dist atomic ok a sam 12 gt Dist2 mnesia activity sync_dirty Info frag_dist mnesia_frag b sam 1 c sam 1 a sam 2 a sam 13 gt mnesia change_table_frag Tab add_frag Dist2 atomic ok a sam 14 gt Dist3 mnesia activity sync_dirty Info frag_dist mnesia_frag a sam 2 b sam 2 c sam 2 a sam 15 gt mnesia change_table_frag Tab add_frag Dist3 atomic ok a sam 16 gt Read fun Key gt mnesia read Tab Key end Fun lt erl_eval gt a sam 17 gt mnesia activity transaction Read 12 mnesia_frag dictionary 12 12 a sam 18 gt mnesia activity sync_dirty Info frag_size mnesia_frag dictionary 64 dictionary_frag2 64 dictionary_frag3 64 dictionary frag4 64 a sam 19 gt 5 3 2 up epee mnesia table_info Tab frag_properties Mnesia n_fragments Int n fragmen
88. ok e aborted Reason 3 1 1 e mnesia create schema NodeList Mnesia Mnesia Mnesia NodeList NodeList Mnesia e mnesia delete schema DiscNodeList DiscNodeList db nodes Mnesia e mnesia delete_table Tab Tab e mnesia clear table Tab Tab e mnesia move_table_copy Tab FErom To Tab From To type RAM RAM
89. ram_copies N1 N2 attributes record_info fields foo Erlang e Lam_copies RAM Erlang 1 mnesia dump tables 1 2 e disc_copies Erlang is e disc_only_copies Erlan je tog eee RUNDE 3
90. ActivityId Opaque Frag Rec LockKind read ActivityId Opaque Tab Key LockKind gt Frag key to frag name Tab Key mnesia read ActivityId Opaque Frag Key LockKind match object ActivityId Opaque Tab HeadPat LockKind gt MatchSpec HeadPat _ select ActivityId Opaque Tab MatchSpec LockKind select ActivityId Opaque Tab MatchSpec LockKind gt do_select ActivityId Opaque Tab MatchSpec LockKind select ActivityId Opaque Tab MatchSpec Limit LockKind gt init select ActivityId Opaque Tab MatchSpec Limit LockKind all keys ActivityId Opaque Tab LockKind gt Match mnesia all keys ActivityId Opaque Frag LockKind ll Frag lt frag names Tab lists append Match clear table ActivityId Opaque Tab Obj gt mnesia clear table ActivityId Opaque Frag Obj ll Frag lt frag_names Tab ok index match object ActivityId Opaque Tab Pat Attr LockKind gt Match mnesia index_match_object ActivityId Opaque Frag Pat Attr LockKind ll Frag lt frag_names Tab lists append Match index_read ActivityId Opaque Tab Key Attr LockKind gt Match mnesia index read ActivityId Opaque Frag Key Attr LockKind ll Frag lt frag_names Tab lists append Match foldi ActivityId Opaque Fun Acc Tab LockKind gt Fun2 fun Frag A gt mnesia foldl ActivityId Opaque Fun A Frag LockKind end lists foldi Fun2 Acc
91. Event mnesia_table_event Event Mnesia gen event handler mnesia_event event_module STDLIB gen event mnesia system_info subscribers mnesia table_info Tab subscribers 5 7 1 mnesia_up Node 52 Mnesia Node mnesia_down Node Mnesia Node mnesia_checkpoint_activated Checkpoint Checkpoint mnesia activate checkpoint 1 mnesia_checkpoint_deactivated Checkpoint T4A Checkpoin
92. aborted 0 restarted 1 logged to disc 0 held locks 0 in queue 0 local transactions 0 remote 0 transactions waits for other nodes ok e Erlang mnesia dir tmp funky Mnesia e mnesia create_schema nodeO Schema e DBMS mnesia startO mnesia create table funky DR EK funky mnesia info0 2 2 Mnesia Erlang location persistence Erlang schema e Mnesia Zk E 2 2 1 Company ALUKA employee project department o 1
93. attributes 3 14 aborted Reason Reason bad type bar 3 14000 mnesia error_description Reason i amp El Jii H Bad type on some provided arguments bar 3 14000 73 9 B 9 1 Mnesia o Fo 90 Fo To Vo Yo Fo Yo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Yo Fo Vo Fo Fo Vo Fo Fo Yo Fo Fo Vo Fo Fo Vo Fo Fo Yo Fo Fo Vo Fo Fo Yo Fo Yo Fo Yo Vo Yo Fo Yo Fo Yo Fo Yo Fo Yo Po 90 Fo 90 90 To Fo Yo 99 99 90 99 0090 9090 This module contains one implementation of callback functions YW used by Mnesia at backup and restore The user may however 9696 write an own module the same interface as mnesia backup and 2696 configure Mnesia so the alternate module performs the actual 9696 accesses to the backup media This means that the user may put 9696 the backup on medias that Mnesia does not know about possibly 9090 on hosts where Erlang is not running 0696 2696 The OpaqueData argument is never interpreted by other parts of 2696 Mnesia It is the property of this module Alternate implementations 2696 of this module may have different interpretations of OpaqueData 2696 The OpaqueData argument given to open write 1 and open read 1 9696 are forwarded directly from the user o All functions must return ok NewOpaqueData or error Reason P The NewOpaqueData arguments returned by backup cal
94. ti ram copies fruit vegetable disc copies schema disc only copies nonode nohost disc_copies schema nonode nohost ram_copies fruit vegetable 3 transactions committed 0 aborted 0 restarted 2 logged to disc 0 held locks 0 in queue 0 local transactions 0 remote 0 transactions waits for other nodes ok 3 gt 5 11 Mnesia 2 employee dept project oe at dep in_proj project remove_proj ProjName gt F fun gt Ip glc e gle q X Il X lt mnesia table in proj Xilin proj proj name ProjName mnesia delete project ProjName del_in_projs Ip 57 end mnesia transaction F del in projs IplTail gt mnesia delete object Ip del in projs Tail del in projs gt done
95. E employee name ll E lt mnesia table employee E employee sex female qlc e Q end mnesia transaction F shell klacke gin 1 gt company females atomic Carlsson Tuula Fedoriw Anna selection MRH projection o 1 list 2 I lt Efemployee name RJ E MAF employee sex atom female qlc q 1 HAH Mnesia raise_females Amount gt F fun S Q glc q E Il E lt mnesia table employee E employee sex female Fs qlc e Q over_write Fs Amount end mnesia transaction F over write ElTail Amount gt Salary E employee salary Amount New E employee salary Salary mnesia write New 1 over_write Tail Amount over_write _ gt 0 raise females 1 1 El JC Z
96. H atomic Number XF Number aborted Reason Mnesia 33 gt company raise_females 33 atomic 2 18 3 HJ Mnesia Mnesia e Mnesia 3 1 Mnesia schema RAM Mnesia tuple e atomic
97. Mnesia P ft 4 4 10 Mnesia DBMS Erlang mnesia 4 4 10 Copyright 1991 2009 Ericsson H 3 e a E TE Eee EO PO IN 4 wii 4 1 2 Mnesia DBMS eee 4 De 7 3 1 Minesla 000 7 es eT OE EO mR eee eT te 8 EESTE Ei 22 eee o 4 ERERTTEHENE 22 fol a ae ee TMYMY s 23 Se A E E E A EE ee AEA E E EE E E ET E 23 pote ee Ne as 26 RE 29 RE eg 29 a Re ie de nu 30 DK cen Rees 33 DIM Coe aud E er 34 4 5 Activity HS AIS E FI 37 5 2 45 pe A Ee Le eRe eee Te eee ee eer en e 46 C ul cct TT mr 53 54 EP 54 UE deli esd LL Tec 55 CON ULIS Lig 55 V E GAST don M X 57 5 9 Mnesia ee 58 AL 58 5 11 Mnesia 61 ie 64 GM t In M xo Rea ee 64 6 2 Core Dumps tenerent nennen 64 C a ro RR D NN 64 8 MIRA Mne 8 1 M Mnesia Mnesia DBMS
98. X TableList e clear tables TableList iX TableList e keep tables TableList TableList i 69 e recreate_tables TableList TableList e default_op Operation Operation skip_tables clear_tables keep_tables recreate_tables clear_tableso Opaque atomic TabList aborted Reason
99. am 3 gt mnesia create table prim dict frag properties PrimProps attributes prim_key prim_val atomic ok a sam 4 gt SecProps foreign_key prim dict sec_val foreign_key prim_dict sec_val a sam 5 gt mnesia create table sec dict frag_ properties SecProps aQ sam 5 attributes sec key sec val atomie ok adsam 6 gt Write fun Rec gt mnesia write Rec end Fun lt erl_eval gt a sam 7 gt PrimKey 11 Li a sam 8 gt SecKey 42 42 a sam 9 gt mnesia activity sync_dirty Write prim_dict PrimKey 11 mnesia_frag ok 46 a sam 10 gt mnesia activity sync_dirty Write sec_dict SecKey PrimKey mnesia_frag ok a sam 11 gt mnesia change_table_frag prim_dict add_frag node atomic ok a sam 12 gt SecRead fun PrimRey SecKey gt mnesia read sec_dict PrimKey SecKey read end Fun lt erl_eval gt a sam 13 gt mnesia activity transaction SecRead PrimKey SecKey mnesia frag sec_dict 42 11 a sam 14 gt Info fun Tab Item gt mnesia table_info Tab Item end Fun lt erl_eval gt a sam 15 gt mnesia activity sync_dirty Info prim dict frag size mnesia frag oca cle Oh pPrimedice trac2 ON primediicrmirace 0 prim_dict_frag4 1 primidiictuftrago n 0 7 jou elec icreagio OI primediicr frraot 0 primedicrftrac on a sam 16 gt mnesia activity sync dirty Info sec
100. bort mnesia foldi Fun Acc0 Tab LockType gt NewAcc transaction abort mnesia foldr Fun Acc0 Tab LockType gt NewAcc transaction abort Fun Mnesia Tab Fun Fun Fun Acc0 Fun Fun fold lr 39 Foldl 5 foldr ordered set LockType mnesia match_object3 10 find_low_salaries gt Constraint fun Emp Acc when Emp employee salary lt 10 gt Emp Acc _ Acc gt Acc end Find fun gt mnesia foldi Constraint employ
101. dict frag size mnesia frag sec_dict 0 sec_dict_frag2 0 sec_dict_frag3 0 sec_dict_frag4 1 sec_dict_frag5 0 sec_dict_frag6 0 sec dict frag7 0 sec_dict_frag8 0 a sam 17 gt 5 3 3 mnesia change table frag Tab Change Change activate FragProps FragProps node_pool Nodes NEF deactivate 1 add_frag NodesOrDist NodesOrDist mnesia table info Tab frag_dist HAMAR NodesOrDist n ram copies n disc copies Mn disc only copies NodesOrDist
102. e Tab N 82 case mnesia prev ActivityId Opaque Frag Key of Send of table gt search prev ActivityId Opaque Tab N Prev gt Prev end end search prev ActivityId Opaque Tab N when N gt 1 gt PrevN N 1 PrevFrag n_to_frag_name Tab PrevN case mnesia last ActivityId Opaque PrevFrag of Send of table gt search prev ActivityId Opaque Tab PrevN Prey S Prev end search prev ActivityId Opaque Tab _N gt Send of table next ActivityId Opaque Tab Rey gt case catch_val Tab frag_hash of EXIT _ gt mnesia next ActivityId Opaque Tab Key FH gt N key to n FH Key Frag n to frag name Tab N case mnesia next ActivityId Opaque Frag Key of Send of table gt search next ActivityId Opaque Tab N FH Prev gt Prev end end search next ActivityId Opaque Tab N FH when N lt FH frag_state n_fragments gt NextN N 1 NextFrag n_to_frag_name Tab NextN case mnesia first ActivityId Opaque NextFrag of Send of table gt search next ActivityId Opaque Tab NextN FH Next gt Next end search next ActivityId Opaque Tab N FH gt Send of table 83 11 D 11 1 mnesia_frag_hash module mnesia_frag_hash 9696 Fragmented Table Hashing callback functions export init_state 2 add_frag 1 del_frag 1 key_to_frag_number 2 match_spec_to_frag_numb
103. ead Tab Key gt Tab element 1 Record mnesia dirty_read Tab Key mnesia dirty match object Pattern gt Tab element 1 Pattern mnesia dirty_match_object Tab Pattern mnesia dirty_index_match_object Pattern Attr Tab element 1 Pattern mnesia dirty_index_match_object Tab Pattern Attr mnesia write Record gt Tab element 1 Record mnesia write Tab Record write mnesia s_write Record gt Tab element 1 Record mnesia write Tab Record sticky_write mnesia delete Tab Key gt mnesia delete Tab Key write mnesia s_delete Tab Key gt mnesia delete Tab Key sticky_write mnesia delete_object Record gt Tab element 1 Record mnesia delete object Tab Record write mnesia s_delete_object Record gt Tab element 1 Record mnesia delete object Tab Record sticky_write mnesia read Tab Key gt mnesia read Tab Key read mnesia wread Tab Key gt mnesia read Tab Key write mnesia match_object Pattern gt Tab element 1 Pattern mnesia match_object Tab Pattern read mnesia index_match_object Pattern Attr gt Tab element 1 Pattern mnesia index_match_object Tab Pattern Attr read 45 Activity FEum mnesia transaction 1 2 3 HT XI fr BU ERI A e mnesia wri
104. eads Mnesia fun mnesia async_dirty Fun Args dirty Checkpointretainers fun mnesia sync_dirty Fun Args mnesia async_dirty Fun L Args sync dirty Mnesia 35 mnesia is transaction O
105. ee end mnesia transaction Find 10 10 increase_low_salaries gt Increase fun Emp Acc when Emp employee salary lt 10 gt OldS Emp employee salary ok mnesia write Emp employee salary 10 Acc 10 OIdS _ Acc gt Acc end IncLow fun gt mnesia foldi Increase 0 employee write end mnesia transaction IncLow PRE BRIA Fun Mnesia ordered_set mnesia first Tab gt Key transaction abort mnesia last Tab gt Key transaction abort mnesia next Tab Key gt Key transaction abort 40 mnesia prev Tab Rey gt Key transaction abort mnesia snmp_get_next_index Tab Index gt ok NextIndex endOfTable first last next prev ordered set end_o
106. ers 2 D record hash_state n_fragments next_n_to_split n_doubles function o Fo 90 Fo To Yo Yo Fo Vo Fo Fo Vo Fo Fo Fo Fo Fo Vo Fo Fo Fo Fo Lo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Yo Fo Fo Fo Fo Fo Yo Fo Yo Fo Yo Vo Yo Fo Yo Fo Yo Fo Yo Fo Yo Po 90 Fo 90 To To 90 Yo Po init_state _Tab State when State undefined gt hash_state n_fragments ll next n to split 1 n doubles function phash2 convert_old_state hash_state N P L gt hash_state n_fragments N next_n_to_split P n_doubles L function phash D Fo Fo Fo Fo Fo 99 To Fo Fo Fo Yo Yo Yo Fo Fo Fo Fo Fo Fo Fo Fo Fo Fo Fo Fo Fo Fo Yo Fo Fo Fo Fo Yo Yo Fo Fo Fo Fo Fo Vo Fo Fo Fo Fo Fo Fo Fo Fo Fo Fo Yo Yo Fo Fo Fo Yo To Fo Yo Fo Fo 90 90 Fo Yo add_frag hash_state next_n_to_split SplitN n_doubles L n_fragments N State gt 84 P SplitN 1 NewN N 1 State2 case power2 L 1 of P2 when P2 P gt State hash_state n_fragments NewN n_doubles eee next_n_to_split 1 _ gt State hash_state n_fragments NewN next_n_to_split P end State2 SplitN NewN add_frag OldState gt State convert_old_state OldState add_frag State Jo Fo 90 Fo Yo Vo Yo Fo Yo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Yo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Yo Vo Fo Fo Yo Fo Yo Fo Yo Vo Fo Fo Yo Fo Yo Fo Yo Fo Yo Po 90 Fo 90 90 To 90 Yo Po del_frag hash_state next_n_to_split SplitN n_do
107. f table o mnesia fold lrl 4 first next mnesia write_lock_table 1 o Mnesia sync_dirty async_dirty th RARER ES EBAY AR FS NT mnesia first 1 mnesia next 2 fp amp EI dirty first dirty next 41 5 HE Mnesia Mnesia Mnesia Mnesia ol RAF Mnesia
108. for_tables a b 20000 of timeout RemainingTabs gt panic RemainingTabs Ok gt synced end W Jm m ride AM mnesia startO cryptic error shutdown mnesia_sup start normal erl boot start_sasl 3 4 Mnesia mnesia create_table Name ArgList e atomic ok e aborted Reason Name atomic BE record name e ArgList Key Value o type Type Type set ordered set bag set ordered_set disc_only_copies set BK ordered set bag
109. hema node ok 2 mnesia start ok include lib stdlib include glc hrl include company hrl init gt mnesia create table employee attributes record info fields employee mnesia create table dept attributes record info fields dept mnesia create table project attributes record info fields project mnesia create table manager type bag attributes record info fields manager mnesia create table at dep attributes record info fields at dep mnesia create table in proj type bag attributes record info fields in_proj 2 2 4 Company e erl mnesia dir ldisc scratch Mnesia Company Erlang UNIX mnesia dir Dir 1 gt e mnesia create_schema node mnesia create_schema DiscNodeList schema 3 e mnesia start Mnesia 3 Mnesia
110. la 2 female 94556 242 056 employee 114872 Dacker Bjarne 3 male 99415 221 035 employee 104531 Nilsson Hans 3 male 99495 222 026 employee 104659 Tornkvist Torbjorn 2 male 99514 222 022 employee 104732 Wikstrom Claes 2 male 99586 221 015 employee 117716 Fedoriw Anna 1 female 99143 221 031 employee 115018 Mattsson Hakan 3 male 99251 203 348 dept dept B SF Open Telecom Platform dept B SFP OTP Product Development dept B SFR Computer Science Laboratory project project erlang 1 project otp 2 project beam 3 project mnesia 5 project wolf 6 project documentation 7 project www 8 employees dept projects manager at dep in_proj manager project erlang 1 project otp 2 project beam 3 project mnesia 5 project wolf 6 project documentation 7 project www 8 at_dep at dep 104465 B SF at_dep 107912 B SF at dep 114872 B SFR at dep 104531 B SFR at dep 104659 B SFR at dep 104732 B SFR at dep 117716 B SFP at dep 115018 B SFP in proj fin proj 104465 otp fin proj 107912 otp in proj 114872 otp in proj 104531 ot
111. lback functions will 9696 be given as input when the next backup callback function is invoked 2696 If any return value does not match ok _ the backup will be aborted 0090 2696 The NewOpaqueData arguments returned by restore callback functions will 9696 be given as input when the next restore callback function is invoked If any return value does not match ok _ the restore will be aborted o Jo Fo 90 Fo Yo Vo Yo Fo Yo Fo Fo Vo Fo Fo Yo Fo Fo Vo Fo Fo Fo Fo Vo Fo Fo Vo Fo Fo Lo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Yo Fo Yo Fo Yo Vo Yo Fo Yo Fo Yo Fo Yo Fo Yo Po 90 90 90 90 To Fo Yo To 99 99 o module mnesia_backup include lib kernel include file hrl export Write access open write 1 74 write 2 commit_write 1 abort_write 1 Read access open_read 1 read 1 close_read 1 D Fo Fo To Fo Fo Vo Fo Fo Vo Fo To Fo Fo Yo Fo Vo Fo Fo Vo Fo Yo Fo Fo Vo Fo Fo Fo Fo Vo Fo Fo Fo Fo Yo Fo Fo Vo Yo Fo Fo Fo Fo Fo Fo Fo Fo Vo Fo Fo Fo Fo To To Fo Fo To o Po 90 90 Fo 90 Fo To o To To Po Po 9696 Backup callback interface record backup tmp_file file file_desc Opens backup media for write 9090 Returns fol OpaqueData or ferror Reason open_write OpaqueData gt File OpaqueData Tmp lists concat File BUPTMP file delete Tmp file delete File case disk_log open name make_ref file Tmp repair false linkto self of ok Fd gt ok backup tmp_fi
112. le Tmp file File file_desc Fd error Reason gt error Reason end Writes Backupltems to the backup media o Returns fol OpaqueData or ferror Reason write OpaqueData Backupltems gt B OpaqueData case disk log log terms B backup file desc Backupltems of ok gt ok B error Reason gt abort write B error Reason end 75 2696 Closes the backup media after a successful backup 066 Returns ok ReturnValueToUser or error Reason commit write OpaqueData gt B OpaqueData case disk log sync B backup file desc of ok gt case disk log close B bbackup file desc of ok gt case file xrename B backup tmp file B backup file of ok gt ok B backup file error Reason gt error Reason end error Reason gt error Reason end error Reason gt error Reason end 2696 Closes the backup media after an interrupted backup o Returns ok ReturnValueToUser or error Reason abort_write BackupRef gt Res disk_log close BackupRef backup file_desc file delete BackupRef backup tmp_file case Res of ok gt ok BackupRef backup file error Reason gt error Reason end o Fo 90 Fo Fo Yo Fo Fo Yo Fo Fo Vo Fo Fo Fo Fo Fo Vo Fo Fo Fo Fo Yo Fo Fo Vo Fo Fo Yo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Yo Fo Yo Fo Fo Vo Yo Fo Yo Fo Yo Fo Yo Fo Yo Po 90 Fo 90 90 To Fo Yo 99 99 90 90 0090 Restore callback interface reco
113. lose R restore file_desc of ok gt ok R restore file error Reason gt error Reason 78 10 C 10 1 Mnnesia module mnesia_frag 2696 Callback functions when accessed within an activity export lock 4 write 5 delete 5 delete object 5 read 5 match object 5 all keys 4 select 5 select 6 select cont 3 index match object 6 index read 6 foldl 6 foldr 6 table info 4 first 3 next 4 prev 4 last 3 clear table 4 D Callback functions which provides transparent 9090 access of fragmented tables from any activity 9090 access context lock ActivityId Opaque table Tab LockKind gt case frag_names Tab of Tab gt mnesia lock ActivityId Opaque table Tab LockKind Frags gt DeepNs mnesia lock ActivityId Opaque table F LockKind II F lt Frags mnesia_lib uniq lists append DeepNs end lock ActivityId Opaque LockItem LockKind gt mnesia lock ActivityId Opaque LockItem LockKind write ActivityId Opaque Tab Rec LockKind gt Frag record to frag name Tab Rec mnesia write ActivityId Opaque Frag Rec LockKind delete ActivityId Opaque Tab Key LockKind gt Frag key to frag name Tab Key mnesia delete ActivityId Opaque Frag Key LockKind 79 delete_object ActivityId Opaque Tab Rec LockKind gt Frag record_to_frag_name Tab Rec mnesia delete object
114. mber location Me employee emp_no 104732 name klacke salary 7 58 sex male phone 99586 room_no 221 015 dept B SFR projects erlang mnesia otp manager 114872 B SFR erlang mnesia otp o 114872 Mnesia Tab Key dept dept B SFR B SFR Dep Salary projects D get emps Salary Dep gt Q qle q E l E lt mnesia table employee E employee salary gt Sala
115. name klacke Erlang klacke otp klacke mnesia In_proj In pro in_proj klacke Erlang klacke otp klacke mnesia RANTS Mnesia Mnesia Mnesia boss klacke bjarne key fj object identifier El oid Tab Key boss klacke bjarne AY oid boss klacke set bag oid boss klacke bjarne Mnesia 2 2 6 employee employee 104465 Johnson Torbjorn 1 male 99184 242 038 employee 107912 Carlsson Tuu
116. ntext case mnesia read end end 4 7 mnesia read 3 Mnesia mnesia select Tab MatchSpecification LockKind gt transaction abort ObjectList mnesia select Tab MatchSpecification NObjects Lock gt transaction abort Object Continuation end of table mnesia select Cont gt transaction abort Object Continuation end of table mnesia match_object Tab Pattern LockKind gt transaction abort RecordList Tab Pattern mnesia select MatchSpecification ordered set RR _ Erlang lt number gt Erlang mnesia table_info Tab wild_pattern
117. opies disc copies disc_only_copies mnesia add table copy 3 mnesia del_table_copy 2 mnesia change_table_copy_type 2 n ram copies n disc_copies n disc only copies foreign Rey foreigners frag_names 48 frag_dist Count Nodae Count Ccount Node node pool node pool count frag_size Name Size Name Size frag_memory Name Memory Name Memory size memory 5 3 5
118. p in proj 104531 mnesia fin proj 104545 wolf in proj 104659 otp in proj 104659 wolf fin proj 104732 otp in proj 104732 mnesia in proj 104732 erlang in proj 117716 otp fin proj 117716 documentation fin proj 115018 otp fin proj 115018 mnesia 15 re corridor Re corr deii E 2 2 7 M DBMS mnesia read 3 mnesia read 1 raise Eno Raise gt F fun gt E mnesia read employee Eno write Salary E employee salary Raise New E employee salary Salary mnesia write New end mnesia transaction F mnesiazwrite 1 mnesia read e Mnesia
119. rd restore file file_desc cont Opens backup media for read 066 Returns ok OpaqueData or error Reason 76 open_read OpaqueData gt File OpaqueData case file read_file_info File of error Reason gt error Reason _FileInfo gt 9090 file exists case disk_log open file File name make_ref repair false mode read_only linkto self of ok Fd gt ok restore file File file_desc Fd cont start repaired Fd _ badbytes 0 gt ok restore file File file_desc Fd cont start repaired Fd _ gt ok restore file File file desc Fd cont start error Reason gt error Reason end end 9696 Reads Backupltems from the backup media 9090 Returns ok OpaqueData BackupItems or error Reason 9090 9090 Backupltems is interpreted as eof read OpaqueData gt R OpaqueData Fd R restore file_desc case disk_log chunk Fd R restore cont of error Reason gt error Possibly truncated Reason eof gt ok R J Cont gt read R restore cont Cont Cont BackupItems _BadBytes gt ok R restore cont Cont Backupltems Cont BackupItems gt ok R restore cont Cont Backupltems end 2696 Closes the backup media after restore 0090 TI Returns ok ReturnValueToUser or error Reason close_read OpaqueData gt R OpaqueData case disk_log c
120. rojNames gt insert emp 3 l Emp 2 DeptId 3 ProjNames list insert emp Emp Deptld ProjNames gt Fun Fun mnesia transaction Fun Fun Fun Emp employee emp_no 104732 name klacke salary 7 sex male phone 98108 room_no 221 015 insert_emp Me B SFR Erlang mnesia otp Funs Erlang Fun 2 2 5 klacke emp_no name salary sex phone room_no 104732 klacke 7 OO male 99586 921 015 Employee employee 104732 klacke 7 male 98108 221 0153 emp dept name klacke B SFR At_dep At dep at_dep klacke B SFR emp proj
121. ry E employee dept Dep F fun gt glc e Q end transaction F join getemps 2 59 6 Mnesia 6 1 e mnesia table_info Tab Key gt Info exit aborted Reason iRE e mnesia system_info Key gt Info exit aborted Reason iRHf X Mnesia 6 2 Core Dumps Mnesia MnesiaCore Node When mnesia_lib coredump0 Mnesia
122. sion Node AR Mnesia 69 e Imnesia backup_checkpoint Name Opaque Mod e mnesia backup Opaque Mod Mnesia mnesia activate checkpoint Args max MaxTabs and min MinTabs e mnesia traverse backup Source SourceMod JTarget TargetMod Fun Ac e mnesia uninstall_ fallback e mnesia restore Opaque Args e mnesia install_fallback Opaque Mod Mnesia I CD
123. t mnesia deactivate 1 mnesia_overload Details Mnesia Mnesia
124. te MatchSpec gt case MatchSpec of HeadPat _ _ when tuple HeadPat size HeadPat gt 2 gt KeyPat element 2 HeadPat case has_var KeyPat of false gt key to frag number State KeyPat true gt lists seq 1 N end _ gt lists seq 1 N end match_spec_to_frag_numbers OldState MatchSpec gt State convert_old_state OldState match_spec_to_frag_numbers State MatchSpec power2 Y gt 1 bsl Y trunc math pow 2 Y 86
125. te 3 write 1 s write 1 e mnesia delete 3 delete 1l s delete 1 e mnesia delete object 3 delete object 1l s delete object 1 e mnesia read 3 read 1 wread 1 e mnesia match object 2 match object 1 e mnesia select 3 select 2 e mnesia foldl 3 foldl 4 foldr 3 foldr 4 e mnesia all keys 1 e mnesiaiindex match object A index match object 2 e mnesiaiindex read 3 e mnesia lock 2 read lock table 1 write lock table 1 e mnesia table info 2 M DT e transaction e sync transaction e osync dirty e sync dirty e els fun mnesia sync_transaction Fun Args mnesia sync_transction SARA dirty_r
126. ts add_frag NodesOrDist del_frag n_fragment5 1 node_pool List add_node Node del_node Node Mnesia ee node_pool mnesia system info db_nodes 45 n_ram_copies Int ram copies 70 Bin disc copies Nln disc only copies 0 n ram copies 1 n_disc_copies Int disc copies 0 n disc only copies Int disc_only_copies 0 foreign key ForeignKey ForeignKey undefined ForeignTab Attr Attr ForeignTab Mnesia
127. ubles L n_fragments N State gt P SplitN 1 if P lt 1 gt PASE MergeN power2 L2 State2 State hash_state n_ fragments N 1 next_n_to_split MergeN n_doubles JEN State2 N MergeN true gt MergeN P State2 State hash_state n_ fragments N 1 next_n_to_split MergeN State2 N MergeN end del_frag OldState gt State convert_old_state OldState del_frag State o Fo 90 Fo Fo Yo Yo Fo Vo Fo Fo Vo Fo Fo Fo Fo Fo Vo Fo Fo Fo Fo Yo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Yo Fo Yo Fo Fo Vo Fo Fo Yo Fo Yo Fo Yo Fo Yo Po 90 90 90 To To 90 Yo Po key_to_frag_number hash_state function phash next_n_to_split SplitN n_doubles L Key gt P SplitN A erlang phash Key power2 L 85 if A lt P gt erlang phash Key power2 L 1 true gt A end key_to_frag_number hash_state function phash2 next_n_to_split SplitN n_doubles L Key gt P SplitN A erlang phash2 Key power2 L 1 if A lt P gt erlang phash2 Key power2 L 1 1 true gt A end key_to_frag_number OldState Key gt State convert_old_state OldState key_to_frag_number State Key o Fo 90 Fo To Yo Yo Fo Vo Fo Fo Vo Fo Fo Fo Fo Fo Vo Yo Fo Yo Fo Yo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Vo Fo Fo Yo Fo Fo Fo Fo Fo Yo Fo Yo Fo Yo Vo Fo Fo Yo Fo Yo Fo Yo Fo Yo Po 90 90 90 To To 90 Yo 0 match_spec_to_frag_numbers hash_state n_fragments N Sta
128. ute2 Typename Attributel Atrribute2 Options mnesia create_table 2 Key Valuel FRUITS tables fruit attributes name color taste vegetable attributes name color taste price fruit orange orange sweet fruit apple green sweet vegetable carrot orange carrotish 2 55 eS eS eS eS vegetable potato yellow none 0 45 Erlang shell fruits erl Erlang BEAM emulator version 4 9 Eshell V4 9 abort with G 1 gt mnesia load_textfile FRUITS New table fruit New table vegetable atomic ok 2 gt mnesia info 56 gt Processes holding locks lt gt Processes waiting for locks lt gt Pending remote transactions lt gt Active local transactions lt gt Uncertain transactions lt gt Active tables lt vegetable with 2 records occuping 299 words of mem fruit with 2 records occuping 291 words of mem schema with 3 records occuping 401 words of mem gt System info in version 1 1 debug level none lt opt disc Directory var tmp Mnesia nonode nohost is used use fallback at restart false running db nodes nonode 2 nohost stopped db nodes remote e
Download Pdf Manuals
Related Search
Mnesia user manual 4.4.10