"packet too large" error. and close the connection. For some clients, if the communication packet is too large, you may encounter a "missing connection to the MySQL server" error during query execution. The default value is 16M.#dev-doc:http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.htmlMax_allowed_packet = 32M# sort_buffer_size is a connection-level parameter that allocates the set of memory once for the first time each connection (session) needs to use this Buffer.#Sort_Buffer_Size i
, the recommended setting is an integer less than 512. QUERY_CACHE_SIZE=32 # Query cache size, used to cache select query Results read_buffer_size=4m #默认为64K, # used for the buffer size used for full table scan of MyISAM table. Allocated for each thread (provided a full table scan is performed). IntoWhen rows are sorted, MySQL scans the buffer first to avoid disk searches, improve query speed, and, if you need to sort large amounts of data, raise the value appropriately.
However, MySQL will issu
the number of the stack is back_log. If the number of pending connections exceeds Back_log, the connection resource will not be granted. This works when the primary MySQL thread gets very many connection requests in a very short period of time.(3) Key_buffer_sizeThe size of the index buffer, which determines the speed of index processing, especially the speed of index reads.By checking the status values key_read_requests and Key_reads, you can see if the key_buffer_size settings are reasonable.
default value is 16M, and when the MySQL client or mysqld server receives packets larger than Max_allowed_packet bytes, it will issue a "packet too large" error. and close the connection. For some clients, if the communication packet is too large, you may encounter a "missing connection to the MySQL server" error during query execution. The default value is 16M.#dev-doc:http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.htmlMax_allowed_packet = 32M# sort_buffer_size is a connection-level p
(default setting is 100)Max_connect_errors = 6000//Per client connection maximum number of errors allowed, if this limit is reached, this client will be The MySQL service blocks until "flush hosts" is executed or User Service restartexternal-locking = FALSE//Allow external file-level locks, opening file locks can adversely affect performance, so only if you This option is only used when running multiple DB instances on the same file (note still There will be other constraints! ), or you use som
When you import a database using phpMyAdmin, you may encounter problems that cannot be imported because the database file is too large!The English tips are as follows: File exceeds the maximum allowed sizeIf the host you are using can customize the php.ini, you can directly modify the file to resolve, that is, by editing the php.ini file to re-set the size of the upload file limits, specific steps:The first step: Open php.ini, find Upload_max_filesize, Memory_limit, post_max_size these three par
Space" is requested for memory, it is possible to obtain a page from high-end memory (see VMALLOC implementation), so that high-end memory may be mapped to "kernel dynamic mapping Space" .2. Permanent Kernel mappingHow do I find a linear space for a page with a high-end memory corresponding to the Alloc_page ()? The kernel specifically leaves a linear space for this, from Pkmap_base to Fixaddr_start, to map high-end memory . On the 2.4 kernel, this address range is 4g-
processing in the development of some large-scale games or resource-consuming applications, using The Settargetheaputilization method provided by the Dalvik.system.VMRuntime class can enhance the processing efficiency of the program heap memory. Of course, we can refer to the specific principle of open source engineering, here we only say how to use: Private final static floattarget_heap_utilization = 0.75f; You can call Vmruntime.getruntime () when the program OnCreate. Settargetheaputilizatio
In Android apps, the most memory-intensive is the picture resource. And on Android, when reading bitmap bitmap, the stack size of the pictures in the virtual machine is only 8M, and if exceeded, a outofmemory exception occurs. Therefore, the memory optimization of the image is an important part of Android application development. 1) to recover bitmap memory in time The bitmap class has a method recycle (), which can be seen from the method name meani
In Android apps, the most memory-intensive is the picture resource. And on Android, when reading bitmap bitmap, the stack size of the pictures in the virtual machine is only 8M, and if exceeded, a outofmemory exception occurs. Therefore, the memory optimization of the image is an important part of Android application development.1) to recover bitmap memory in timeThe bitmap class has a method recycle (), which can be seen from the method name meaning
immediately, this reduces the user wait time. What about the data behind that? We can write a while loop, Read the file for a period of time reads it out at a time, until the file is fully output, so that the browser can continue to receive data without waiting for all files to be read. In addition, this approach solves another serious problem. For example, a file is 100M, if the buffer is not turned on, you need to read all the 100M files into memory, and then output. But what if the PHP pro
Source: Reprinted from: http://mobile.51cto.com/abased-410796.htmIn Android apps, the most memory-intensive is the picture resource. And on Android, when reading bitmap bitmap, the stack size of the pictures in the virtual machine is only 8M, and if exceeded, a outofmemory exception occurs. Therefore, the memory optimization of the image is an important part of Android application development.1, in time to recover bitmap memoryThe bitmap class has a m
Sometimes when we run the PHP program again, it appears
Allowed memory size of 8388608 bytes exhausted (tried to allocate 1298358 bytes)
The reason for this error: In order to ensure that it is not the cause of the program (such as a dead loop), is due to PHP page consumption of the maximum memory default is 8M (can be seen in the PHP INI),
This error occurs if the file is too large or the picture is too large to read.
Workaround:
1. Modify the php.i
Php+ffmpeg implements the automatic transcoding of video into H264 standard MP4 file,
Configuring the php.ini File
File_uploads = on;//whether to allow the switch to upload files over HTTP. The default is on is open upload_tmp_dir;//File upload to the server where temporary files are stored, if not specified will be used the system default temporary folder Upload_max_filesize = 1024m;//Wang Wen Business, that is, the maximum size allowed to upload files. The default is 2M, we set to 1gpost_max_s
precaution against scripting attacks through forms. If you need to consider compatibility issues with earlier PHP 3.x scripts, you should put on. Register_globals = Off One of the variables associated with form submission is post_max_size, which controls the maximum amount of data that PHP can receive in a single form submission using the Post method. It seems unlikely that you need to change the default of 8 MB to a larger size. Instead, it should be appropriately lowered to a more realistic v
folder, different versions, that is, the folder to place the DLL files)
The following two are time-outs: General 60-120
Max_execution_time = 90
Max_input_time = 90
Post_max_size = 8M (6-10m best)
Upload_max_filesize = 8M (maximum upload attachment size)
Default_socket_timeout = 90 (port time 60-120)
Session.gc_maxlifetime = 3600 (session default time to live, seconds)
Session.save_path = "c:php (as the
Sometimes when we run the PHP program again, it appears
Allowed memory size of 8388608 bytes exhausted (tried to allocate 1298358 bytes)
The reason for this error: In order to ensure that it is not the cause of the program (such as a dead loop), is due to PHP page consumption of the maximum memory default is 8M (can be seen in the PHP INI),
This error occurs if the file is too large or the picture is too large to read.
Workaround:
1. Modify the
reference only.
[plain] # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /opt/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /opt/mysql/mysql.sock # Change following line if you want to store your database elsewhere basedir=/usr datadir = /opt/mysql skip-external-locking key_buffer_size = 16M max_allowed_packet = 1M
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.