LAMP Performance Optimisation Flashcards
(25 cards)
What is LAMP performance optimization?
LAMP performance optimization enhances the speed and efficiency of Linux, Apache, MySQL, and PHP components.
Optimizing a LAMP stack reduces WordPress page load times, improving user experience and SEO. Freelancers tune performance for client sites, while enterprise architects scale systems for high traffic, aligning with your WordPress performance interests.
How do you monitor Linux resource usage in LAMP?
Use top or htop to view CPU, memory, and process usage.
Identifies bottlenecks for WordPress servers. Freelancers monitor resources, while enterprise architects integrate with tools like Prometheus, per your Linux basics deck.
What is vm.swappiness in Linux for LAMP?
vm.swappiness controls swap usage, set in /etc/sysctl.conf, like vm.swappiness=10.
Low values prioritize RAM for WordPress performance. Freelancers adjust it, while enterprise architects optimize for high-memory systems, per your performance goals.
How do you optimize Linux file system for LAMP?
Use SSDs and enable noatime in /etc/fstab, like noatime for mounts.
Reduces disk I/O for WordPress file access. Freelancers configure storage, while enterprise architects use fast storage solutions, per your Linux basics deck.
What is Apache’s KeepAlive directive for LAMP?
KeepAlive On allows persistent connections to reduce latency.
Speeds up WordPress page loads. Freelancers enable it in httpd.conf, while enterprise architects tune MaxKeepAliveRequests, per your Apache deck.
How do you optimize Apache’s MPM in LAMP?
Use the event MPM with a2enmod mpm_event and tune threads in /etc/apache2/mods-available/mpm_event.conf.
Handles high WordPress traffic efficiently. Freelancers configure MPM, while enterprise architects scale threads, per your Apache configuration knowledge.
What is mod_expires in Apache for LAMP?
mod_expires sets cache expiration headers, like ExpiresByType text/css “access plus 1 month”.
Caches WordPress assets. Freelancers enable it, while enterprise architects optimize cache durations, per your WordPress performance deck.
How do you enable compression in Apache for LAMP?
Enable mod_deflate with a2enmod deflate and configure AddOutputFilterByType DEFLATE text/html.
Reduces WordPress page size. Freelancers compress assets, while enterprise architects fine-tune compression, per your performance interests.
How do you optimize MySQL queries in LAMP?
Use EXPLAIN to analyze queries and add indexes, like CREATE INDEX idx_post_status ON wp_posts(post_status);.
Speeds up WordPress database access. Freelancers optimize queries, while enterprise architects scale indexes, per your MySQL deck.
What is the innodb_buffer_pool_size in MySQL?
innodb_buffer_pool_size sets memory for data caching, like innodb_buffer_pool_size=512M in my.cnf.
Improves WordPress query performance. Freelancers adjust it, while enterprise architects allocate memory for large databases, per your MySQL deck.
How do you enable MySQL query cache in LAMP?
Set query_cache_type=1 and query_cache_size=32M in /etc/mysql/my.cnf.
Caches WordPress query results. Freelancers enable caching, while enterprise architects use it selectively, per your performance goals.
How do you optimize PHP in LAMP?
Enable opcache in php.ini with opcache.enable=1 and increase memory_limit to 256M.
Speeds up WordPress PHP execution. Freelancers tune settings, while enterprise architects optimize for high loads, per your PHP core concepts deck.
What is PHP’s opcache in LAMP?
opcache caches compiled PHP bytecode, like opcache.revalidate_freq=0.
Reduces WordPress processing time. Freelancers enable it, while enterprise architects fine-tune cache settings, per your WordPress performance deck.
How do you use a Content Delivery Network (CDN) in LAMP?
Configure a CDN (e.g., Cloudflare) to serve WordPress static assets and update wp-config.php for CDN URLs.
Offloads traffic. Freelancers set up CDNs, while enterprise architects integrate with global CDNs, per your performance deck.
What is memcached in LAMP?
memcached is an in-memory caching system, installed with sudo apt install memcached.
Caches WordPress data. Freelancers use plugins like W3 Total Cache, while enterprise architects scale caching, per your performance interests.
How do you enable memcached for WordPress in LAMP?
Install php-memcached, configure memcached in /etc/memcached.conf, and use a plugin like Memcached Object Cache.
Speeds up WordPress. Freelancers configure caching, while enterprise architects optimize cache distribution, per your PHP core concepts deck.
How do you optimize Apache logs in LAMP?
Rotate logs with logrotate and disable unnecessary logging in httpd.conf.
Reduces WordPress server overhead. Freelancers manage logs, while enterprise architects automate rotation, per your Apache deck.
How do you troubleshoot slow WordPress in LAMP?
Check logs (/var/log/apache2/error.log), use EXPLAIN for MySQL, and monitor with top.
Identifies WordPress bottlenecks. Freelancers debug issues, while enterprise architects use monitoring tools, per your error handling deck.
What is HTTP/2 in LAMP?
HTTP/2 improves performance with multiplexing, enabled in Apache with a2enmod http2.
Speeds up WordPress asset delivery. Freelancers enable HTTP/2, while enterprise architects ensure SSL compatibility, per your Apache deck.
How do you optimize WordPress database in LAMP?
Run OPTIMIZE TABLE wp_posts; and clean transients with plugins like WP-Optimize.
Reduces WordPress database size. Freelancers optimize tables, while enterprise architects automate maintenance, per your MySQL deck.
How do you scale Apache for high traffic in LAMP?
Use mpm_event, tune MaxRequestWorkers, and enable load balancing.
Handles WordPress traffic spikes. Freelancers configure workers, while enterprise architects implement clustering, per your Apache knowledge.
How do you optimize Linux swap in LAMP?
Increase swap space with fallocate and set vm.swappiness=10 in /etc/sysctl.conf.
Manages WordPress memory under load. Freelancers adjust swap, while enterprise architects optimize for performance, per your Linux basics deck.
What is query caching in WordPress on LAMP?
Query caching stores database results, enabled with plugins like Query Monitor or memcached.
Reduces WordPress query load. Freelancers implement caching, while enterprise architects scale cache systems, per your performance deck.
How do you use Varnish in LAMP?
Install Varnish, configure it to cache HTTP responses, and set Apache to listen on a different port (e.g., 8080).
Caches WordPress pages. Freelancers use Varnish for speed, while enterprise architects configure reverse proxies, per your performance goals.
