Linux Open File number too many open files solution
Too many open files is prompted because the number of file/socket connections that the program opens exceeds the system setting.
To view the maximum allowable number of open files per user
The code is as follows:
Ulimit-a
fdipzone@ubuntu:~$ ulimit-a
Core file size (blocks,-c) 0
Data seg Size (Kbytes,-D) Unlimited
Scheduling Priority (-e) 20
File size (blocks,-f) Unlimited
Pending Signals (I.) 16382
Max locked Memory (Kbytes, L) 64
M
log: # Tail-50f/var/tmp/mysql-proxy.log
2.mysql-proxy parameters
--ADMIN-ADDRESS=HOST:PORT Specifies a mysqo-proxy management port, the default is 4041;
-P, the--proxy-address=
-R,--proxy-read-only-backend-addresses=
-B,--proxy-backend-addresses=
--defaults-file=
--daemon Mysql-proxy Run as Daemon
--keepalive try to restart the proxy if it crashed, keep the connection started process there will be 2, a process to monitor the second process, if the second process dies automatically resta
=======log4j.properties
# Global Logging Configuration log4j.rootlogger=warn,fileout,stdout log4j.appender.stdout= Org.apache.log4j.ConsoleAppender Log4j.appender.stdout.layout=org.apache.log4j.patternlayout # to output the
Caller ' s file name and line number. Log4j.appender.stdout.layout.conversionpattern=%4d%p-%c{1}.%m (%l) | %m%n #datacenter log4j.categoryorg.com.morningstar=debug # rolling log file output ... log4j.appender.fileout=
Org.apache.log4j.RollingFileAppender Log4j.appender.fileo
in addition to some items, paranoid match the IP address you want to control and its domain name mismatch (domain name camouflage).
For example, the/etc/hosts.deny file on the server is set as follows:
# Cat/etc/hosts.deny
portmap:192.168.102.15
Then load the shared directory on the client 192.168.102.15
# Mount 192.168.102.47:/home/share/mnt
Mount to NFS server ' 192.168.102.47 ' failed.
We found that the shared directory could not be loaded now.
**********************
6. Resource use
In addit
memory management unit MMU, and the MMU maps the virtual address to the physical memory address through the page table, as shown in the following figure:Three. Mapping mechanism implementation The mapping of virtual address space to physical memory addresses is shown in the table above. (1) When a program tries to access a mapped page, such as executing instructions MOV REG, 0 it will Access Virtual page 0 of the No. 0 byte corresponding to the physical address, the address sent
,b.name2 from dba_extents A,v$datafile b3 where a.file_id=b.file# and a.owner= ' SCOTT ' and a.segment_name= ' TEST ';file_id block_id BLOCKS NAME---------- ---------- ---------- ---------------------------------------------4 520 8/U01/APP/ORACLE/ORADATA/ORCL/USERS01.DBF---The block where the record in the table is found[Email protected]>select distinct dbms_rowid.rowid_block_number (ROWID) from Scott.test;Dbms_rowid. Rowid_block_number (ROWID)------------------------------------523524---Destroy
Label:The following issues occurred when importing. dmp files to Oracle with Plsql: Import started on 2015/11/18 10:42:44E:\oracle\product\10.2.0\db_1\bin\imp.exe Log=c:\users\lrb\appdata\local\temp\plsimp.log file=e:\work\doc\2015-0 ~1\2015-09-11.dmp userid=lrb/[email protected] buffer=30720 commit=no full=yes grants=yes ignore= Yes Indexes=yes Rows=yes show=no constraints=yes Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-productionWith the partitioning, OLAP and Data
contains the master, Tempdb, model, and msdb types.Data storage units for SQL Sever 2008:1. Page: the most basic unit.8KB is a page, 128 pages is 1MB, starts with a 96B header,The number of data bytes per row in the table cannot exceed 8192-96b (8192=1024*8)2. District: The basic unit of management space.8 link pages are a zone, that is, 64KB is a zone, 16 zones are 1MB,There is a mixed disk in the storage
package cannot get empty_blocks statistics, so you need to collect statistics with analyze command again
SQL> SELECT blocks, Empty_blocks, num_rows from user_tables WHERE table_name =' T1 ';
BLOCKS Empty_blocks Num_rows
--------------------------------
4302 0 299248
SQL> Analyze table T1 compute statistics;
Table has been analyzed.
SQL> SELECT blocks, Empty_blocks, num_rows from user_tables WHERE table_name =' T1 ';
BLOCKS Empty_blocks Num_rows
# Uncomment the following if you is using InnoDB tables#innodb_data_home_dir =/data/mysqldata#innodb_data_file_path = Ibdata1:10m:autoextend#innodb_log_group_home_dir =/data/mysqldata# you can set: _buffer_pool_size up to 50-80% of RAM# But beware of setting memory usage too highInnodb_buffer_pool_size = 16MInnodb_additional_mem_pool_size = 2M# Set: _log_file_size to% of buffer pool sizeInnodb_log_file_size = 5MInnodb_log_buffer_size = 8MInnodb_flush_log_at_trx_commit = 1Innodb_lock_wait_timeout
Atitit. the principle and practice of improving language readability table 1-1 Language evaluation criteria and their linguistic characteristics 11.3.1.2 orthogonality 21.3.2.2 support for abstraction 31.3.2.3 Expression 3. 6 trade-offs in language design 4 table 1-1 Language evaluation criteria and their linguistic characteristics
Standard
Characteristics
Readability
Writable
Reliability
si
.
Start NFS serviceService nfs start
Service nfs restart
Service nfs stop
Service nfs reload when the/etc/exports file is modified, you do not need to restart the service to execute this command.
Client mountingMount by using the mount commandMount 192.168.1.162:/home/stb/mnt/stbMount-t nfs 192.168.1.162:/home/stb/mnt/stb-o nolock
// The client must have the/mnt/stb directory.
2. Mount the NFS file system through/etc/fstab
Another way to mount NFS shares on other machines is to add a row in the/
; alter system dump datafile 14 block min 127 block max 131;
System altered.
BYS @ bys3> select value from v $ diag_info where name like 'de % ';
VALUE
Bytes ----------------------------------------------------------------------------------------------------
/U01/diag/rdbms/bys3/bys3/trace/bys3_ora_12377.trc
################
DUMP data block content analysisPart 2: -- Bitmap header
Start dump data blocks tsn: 9 file #: 14 minblk 1 maxblk 4Block 1 (file header) not dumped: use dump file header c
cannot be loaded now.
(6) resource usage
1>: automatic mounting upon startup
Modify the/etc/fstab file of the client and add the following lines:
192.168.102.47:/home/share /mnt nfs rsize=8192,wsize=8192,timeo=14,intr
Restart the client to automatically mount shared resources when the system starts.
2>: Use autofs to implement resource hanging
Autofs uses the automo
software when installing the system, so as to facilitate the configuration during use.
If you have a firewall, make sure ports 32771, 111, and 2049 are open.
2. Manual mountingUse the mount command to mount the NFS Directory shared by other machines.
Format: $ sudo Mount [server IP]:/[Share dir] [local mount point]
For example:$ Sudo Mount-t nfs [-O nolock] localhost:/opt/friendlyarm/mini2440/root_nfs/mnt/root_nfs or$ Sudo Mount-T nfs-O nolock 192.168.1.101:/opt/friendlyarm/mini2440/root_nfs/mn
)---------- ---------------- 6 0000000081dae000
In dump buffer_cache, run the following command:
[emailprotected]> alter session set events‘immediate trace name buffers level 1‘;Session altered.[emailprotected]> col value for a85[emailprotected]> select * from v$diag_info where name=‘Default Trace File‘; INST_ID NAME VALUE---------- -------------------------------------------------- --------------------------------------------------------
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.