Manage Query Cache
You can check whether the query cache is present in your MySQL server using the following statement: mysql> SHOW VARIABLES LIKE ‘have_query_cache’; You can defragment …
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 for tag: MySQL
Access MySQL from the command line
mysql -u -p -h By default you would use the root user with no password if connecting to localhost only. While it does simplify administration …
MySQL Cluster vs. Replication
In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave …
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 …
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 …
“Cannot connect to the database” errors
Here are a few initial things (common mistakes) to take a look at: – Make sure that after you created your database and database user …
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 …
Service Manager
Overview The Service Manager area enables you to start and stop available services on your server. The following services are available: antirelayd – The …
Restart Services
You can restart any of the available services on the web server at any time. You can restart the following services: Mail Server (Exim) DNS/Name …
Showing 34 - 44 of 62 articles