…te, and provides more complete recommendations. If you are running MySQL 5 or later, the configuration statements can be in the following form (example from one of my servers): [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 innodb_file_per_table = 1 thread_concurrency = 8 query_cache_size = 64M query_cache_limit = 4M thread_cache_size = 8 myisam_sort_buffer_size = 64M read_rnd_buffer_size = 8M… […]
Search results for "mysql-connexions"
…rDefault’] = 1; ?> Create the phpmyadmin database for advanced functionality Look in phpMyAdmin folder /usr/share/phpMyAdmin/examples for create_tables.sql ssh to server as root user mysql — or if it asks for password — mysql -u your-mysql-superuser -pyour-superuser-password mysql > source /usr/share/phpMyAdmin/examples/create_tables.sql Log in to PMA Now you can log into PMA with your mysql root […]
Decades of experience hosting websites, from small local sites with only a few html pages, to high-traffic sites with thousands of users and pages. Website hosting, evolved Web hosting has changed dramatically in the last few years. The majority of accounts are now running PHP scripts and MySQL, whereas in the past most accounts were only […]
…from the Internet’s millions of malicious and compromised servers and personal computers. Reconfigured Apache web server, PHP and MySQL to better utilize the server’s horsepower. Cpanel’s efault Apache and MySQL configurations were limiting the number of concurrent user sessions the server could handle. Changed PHP to run as FastCGI (fcgid) and recompiled Apache to better […]
Chris Gilligan Web Developer, Information Architect, Web Server Administrator, Media Producer web • video • print email@example.com chrisgilligan.com I design and produce information and communication media for university, corporate, small business, manufacturing and non-profit clients: web sites Information architecture and design for open source content management systems Front-end UI design, HTML, PHP, LESS Linux Apache […]
…oomla and PHPbb have code that is pre-optimized with hooks for APC, but WordPress requires a plugin called W3 Total Cache. First Things First Please read my posts about APC on commodity virtual hosting servers and Apache and MySQL performance tuning before you begin. If you are running your virtual servers under FCGId, then you […]
…TEDxToronto. I made a few tweaks and improvements to better fit our event, and worked with April Cox from UT Chattanooga to dial in the design and architecture. Developed on an Amazon EC2+Ubuntu+Webmin server running a Nginx+MySQL+PHP-FPM stack, the site should handle plenty of traffic, and can be scaled up to meet spikes in demand […]