[GitHub] [shardingsphere] peilinqian commented on issue #22480: In the federation scenario, use ‘order by’ when creating a view, and use the ‘limit 10,5 ’clause when select the view, and the order of the result data is incorrect

[GitBox]

peilinqian commented on issue #22480:
URL: 
https://github.com/apache/shardingsphere/issues/22480#issuecomment-1338632006

   listen_addresses = '*'
   max_connections = 4096
   remote_read_mode = non_authentication
   allow_concurrent_tuple_update = true
   audit_enabled = off
   cstore_buffers = 16MB
   enable_alarm = off
   enable_codegen = false
   enable_data_replicate = off
   full_page_writes = off
   max_files_per_process = 100000
   max_prepared_transactions = 2048
   shared_buffers = 500GB
   use_workload_manager = off
   wal_buffers = 1GB
   work_mem = 1MB
   transaction_isolation = 'read committed'
   default_transaction_isolation = 'read committed'
   synchronous_commit = off
   fsync = on
   maintenance_work_mem = 2GB
   vacuum_cost_limit = 10000
   autovacuum = off
   autovacuum_mode = vacuum
   autovacuum_max_workers = 20
   autovacuum_naptime = 5s
   autovacuum_vacuum_cost_delay = 10
   update_lockwait_timeout = 20min
   enable_mergejoin = off
   enable_nestloop = off
   enable_hashjoin = off
   enable_material = off
   wal_log_hints = off
   log_duration = off
   checkpoint_timeout = 15min
   autovacuum_vacuum_scale_factor = 0.1
   autovacuum_analyze_scale_factor = 0.02
   enable_save_datachanged_timestamp = false
   enable_double_write = on
   enable_incremental_checkpoint = on
   enable_opfusion = on
   advance_xlog_file_num = 100
   track_activities = off
   enable_instr_track_wait = off
   enable_instr_rt_percentile = off
   track_counts = on
   track_sql_count = off
   enable_instr_cpu_timer = off
   plog_merge_age = 0
   session_timeout = 0
   enable_instance_metric_persistent = off
   enable_logical_io_statistics = off
   enable_page_lsn_check = off
   enable_user_metric_persistent = off
   enable_xlog_prune = off
   enable_resource_track = off
   instr_unique_sql_count=0
   remote_read_mode=non_authentication
   wal_level = archive
   hot_standby = off
   hot_standby_feedback = off
   client_min_messages = ERROR
   log_min_messages = FATAL
   enable_asp = off
   enable_bbox_dump = off
   bgwriter_flush_after = 32
   wal_keep_segments = 1025
   enable_bitmapscan = off
   enable_seqscan = off
   enable_beta_opfusion=on
   checkpoint_segments=8000
   enable_stmt_track=false
   bgwriter_delay = 5s
   incremental_checkpoint_timeout = 5min
   xloginsert_locks = 16
   walwriter_cpu_bind =0
   wal_file_init_num = 20
   pagewriter_sleep = 10ms
   walwriter_sleep_threshold = 50000
   gs_clean_timeout = 0
   undo_zone_count = 0
   pagewriter_thread_num = 2
   max_redo_log_size = 400GB
   max_io_capacity = 1GB
   local_syscache_threshold = 32MB
   segment_buffers = 1GB
   
   numa_distribute_mode = 'all'
   enable_thread_pool = on
   thread_pool_attr = '400,4,(cpubind:0-31,48-127)'
   
   #!/bin/bash
   irq_list=`cat /proc/interrupts | grep enp135s0f0 | awk {'print $1'} | tr -d 
":"`
   irq_array_net=($irq_list)
   
   cpu_array_irq=(32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47)
   queue_num=16
   
   for (( i=0;i<16;i++ ))
   do
           echo ${cpu_array_irq[$i]}  > 
/proc/irq/${irq_array_net[$i]}/smp_affinity_list
   done
   
   for j in ${irq_array_net[@]}
   do
           cat /proc/irq/$j/smp_affinity_list
   done


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscr...@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org