No errors.) This is what is sometimes referred to as the "White Screen of Death". Occasionally the page is completely blank (No content. The installation script needs permissions to write to the configuration files settings.php. Cannot write to configuration files settings.php The installation script needs permissions to create these directories inside the sites/default folder. Cannot create directories 'files' or 'private' Check if the username, password and hostname that you provided are correct. The installation script cannot connect to the database. Failed to connect to your MySQL database server This error can be resolved by adding an extra line to Drupal's configuration files. The error "Allowed memory size exhausted" indicates that Drupal needs more memory than has been allocated under current settings. Fatal error: Allowed memory size of n bytes exhausted More troubleshooting information is available at the Troubleshooting FAQ. join_buffer_size, increase in small amounts it will be multiplied by max_connections.Links to some of the more common installation issues are listed below.tmp_table_size, max_heap_table_size variable: keep these equal and high.Watch the performance metrics section of the mysqltuner report.Once you get past a certain point any adjustments you make will only result in minor improvements, and you'll be better off either improving the application, or looking at scaling up your database environment through either using more powerful hardware or by adding slave servers. You may find it useful to spend some time searching for database tuning tips based on what applications you're using it for. Performance is dependent on the types of queries, use of indexes, how efficient the database design is and so on. For example, what works best for Wordpress might not be the best for Drupal, Joomla or proprietary applications. One final comment on tuning databases: Whilst we can broadly say that certain settings are the best, performance can vary from application to application. Increase table_cache gradually to avoid file descriptor limits Run OPTIMIZE TABLE to defragment tables for better performance The following is part of an example report from a production database which shows there may be some benefit from increasing the amount of query cache: Most of these can be altered live on the server without restarting, look through the official MySQL documentation (link in Resources section) for the relevant variables to change in production. The top section provides general information about the database server, and the bottom section provides tuning suggestions to alter in your my.cnf. Then once its been installed, run it: mysqltunerĪnd wait for its final report. You can get install mysqltuner from the Ubuntu repositories: sudo apt-get install mysqltuner In a production environment, consider waiting for at least 24 hours before running the tool. The longer the server has been running for, the better the advice mysqltuner can provide. MySQL Tuner is a useful tool that will connect to a running MySQL instance and offer suggestions for how it can be best configured for your workload. General answer from the serverguide wiki: Looking at the error logs, I can see that mysqld was out of memory: Feb 17 11:02:06 111488 kernel: Out of memory: Kill process 20719 (mysqld) score 75 or sacrifice childįeb 17 11:02:06 111488 kernel: Killed process 20719 (mysqld) total-vm:1347424kB, anon-rss:30524kB, file-rss:0kB Here are my partitions: NAME FSTYPE SIZE MOUNTPOINT LABEL I'm a bit confused about which settings to change in my my.conf file to optimise for my server (the mysql server keeps crashing due to our high traffic).Īnd the server specs are: CPU Cores 2 cores
0 Comments
Leave a Reply. |