MyCat配置文件详解--server.xml

小鱼儿 2022-04-23 19:56 344阅读 0赞

server.xml 包含mycat的系统配置信息，它有两个标签，分别是user和system，掌握system标签的各项配置属性是mycat调优的关键。

<?xml version="1.0" encoding="UTF-8"?>
    
    <!DOCTYPE mycat:server SYSTEM "server.dtd">
    <mycat:server xmlns:mycat="http://io.mycat/">
    	<system>
    		
    	<property name="charset">utf8</property>  
        	
    	<property name="processorBufferChunk">4096/property>   
        	
    	<property name="processors">4/property>   
        
           
        
        
     
        
     
        	
     
        
        
    	
    	
    	
    	
     
     
    	
        
        
        
     
    	
        
        
        
     
    	
        
     
     
        
     
        
    	<property name="useGlobleTableCheck">0</property>  
     
    	<property name="useSqlStat">0</property>  
     
     
           
           
    	 
    	
    		
    		<property name="processorBufferPoolType">0</property>
    		
    		
    		
    		
    		
    		<property name="handleDistributedTransactions">0</property>
    		
    		
    		<property name="memoryPageSize">1m</property>
     
    		
    		<property name="spillsFileBufferSize">1k</property>
     
    		<property name="useStreamOutput">0</property>
     
    		
    		<property name="systemReserveMemorySize">384m</property>
     
    		
    		<property name="useZKSwitch">true</property>
     
    	</system>
    	
    	
    	
    	
    	<user name="root">
    		<property name="password">123456</property>
    		
    		<property name="schemas">TESTDB</property>
    		
    		<property name="readOnly">true</property>
    		
    		<property name="benchmark">11111</property>
    		
    		<property name="usingDecrypt">1</property>
    		
    		
    	</user>
    </mycat:server>