Tune MySQL
Mysql set up (“my.cnf”). The MySQL config file, my.cnf. Here is what to add under the [mysqld] heading. The two lines, “max_connections” and “max_user_connections” are …
Tags +
- .htaccess
- Acronis
- Active Directory
- Alerts
- Anonymous FTP
- Antivirus
- Apache
- Aptitude
- ASP
- Audio / Video
- Auto Responder
- AWStats
- BFD
- Bind
- CDONTS
- CDOSYS
- CentOS
- CGI Scripts
- chkrootkit
- Cloud
- Cloud Storage
- CloudLinux
- CMC
- ColdFusion
- cPanel
- CPU
- Cron Job
- CSF
- CSR
- Cute FTP
- DDoS
- Debian
- DeepMetrix
- DirectAdmin
- DNS
- Docker
- Domain Application Vault
- Domlogs
- Dreamweaver
- DrWEB
- Duplicati
- eAccelerator
- EasyApp
- Ensim
- Eudora
- Exim
- Fantastico
- Fedora
- ffmpeg
- FileZilla
- Firewall
- Flash
- FormMail
- Forwarder
- FreeBSD
- FrontPage
- FTP
- GeoTrust
- GRUB
- Helm
- Hivelocity FAQ
- Horde
- Hosting Controller
- Hotlink Protection
- Hsphere
- HTTP
- IIS
- Imagemagick
- IMP
- Incredimail
- inetd
- Intel
- IP Address
- IPMI
- iptables
- JFS
- Kernel
- KernelCare
- Kubernetes
- Linux
- LiteSpeed
- LiveStats
- LogWatch
- MailEnable
- Maldet
- Managed Services
- MBR
- MC
- Metabase
- MetaEdit
- Metered
- Midnight Commander
- Monitoring
- MPC
- MRTG
- MS Access
- MSDE
- MSSQL
- MX Record
- MySQL
- mysql.sock
- mytop
- MyV
- MyVelocity
- Nagios
- NAS
- NAT
- NDR
- Neomail
- Netscape Communicator
- Netstat
- NFS
- NTFS
- NTP
- OpenStack
- osCommerce
- Outlook
- Pegasus
- Percona
- Perl
- PHP
- phpBB
- phpMyAdmin
- PIP
- Plesk
- PostgreSQL
- Process Explorer
- Proxmox
- Python
- Qmail
- RDP
- RedHat
- Redirect
- ReiserFS
- Remote Desktop
- RootCheck
- RPM
- RSYNC
- Runlevel
- RVSiteBuilder
- securephp
- SendMail
- Settings
- Sharepoint
- SIM
- Sitebuilder
- SiteStudio
- Skeleton
- Slackware
- smartcheck
- SmartFTP
- SMTP
- Softaculous
- SpamAssassin
- speedtest
- SPF Record
- SQL
- SquirrelMail
- SSH
- SSL
- Suexec
- Swap Partition
- sysctl
- Tablespaces
- tar
- Task Scheduler
- Telnet
- Terminal Services
- Thunderbird
- tmp
- Tomcat
- Top
- Traceroute
- Troubleshooting
- True Site
- Ubuntu
- UFS partition
- Unix
- Unmetered
- Urchin
- VirtualHost
- Virtuozzo
- vmstat
- VPS
- vsftpd
- Wasabi
- WebAdmin
- Webalizer
- Webmail
- Webmin
- wget
- WHM
- Windows
- WordPress
- WS_FTP
- XFS
- YUM
- Zen Cart
- Zend Optimizer
- Zimbra
...
Latest articles
What to Do if MySql.sock File is Missing
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your …
Connect to MySQL through PHP
Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Connect to the MySQL server Use the following …
MySQL will not start, “MySQL File ‘/usr/share/mysql/charsets/?.conf’ not found” in error log.
The most common cause for this error, is a failed downgrade of MySQL from 4.1 to 4.0. Many changes were made between MySQL 3.x, 4.0.x, …
CPU/Memory/MySQL Usage
Overview This function displays a table of the processes that use CPU, memory, and MySQL. The table displays who is using the process, CPU usage …
Transferring MySQL database to new server::
While gettting transferred from one host to another you need to take many precautions one of them is of your database (MySQL) You should backup …
Fix the MYSQL ERROR: Client does not support authentication protocol
Solution This error is encountered by both scripts and applications, that are unable to use the new authentication protocol introduced by MySQL 4.1.x. The only …
Mysql gives error of access denied for root@localhost?
Solution Make sure root pass is in /root/.my.cnf This is usually the first root pass the box was given once cpanel is installed. If it …
Can you provide/recommend any tools for managing MySQL databases?
Solution: There is a multitude of administration tools ranging from ssh’ing into the server and directly issuing commands to commercial GUI software. phpMyAdmin is very …
How do I grant an MySQL user permission to a database?
Solution 1. Log into your cPanel ( https://www.yourdomain.com:2082). 2. Click on the “MySQL Databases” link. This will display the “MySQL Account Maintenance” screen. 3. Now …
Why is HC not backing up MySQL database and just creating a blank database backup file (.bak)?
First apply latest hotfix 2.8 on your machine and follow these steps: Stop all IIS and Hosting Controller Services. Copy mySQLdump.exe from (X:/mySQL installation path/Bin) …
Showing 45 - 55 of 121 articles