I am using CentOS Linux for service purpose. Main reason to use CentOS is cheaper hosting for private purpose. Actually MySQL requires periodical optimization process in my experiences, and I use / etc / cron.hourly usually for those kind of bath processi...
I am using CentOS with php, and mysql for web service, and sometimes my server is dead by unknown reason so I optimize mysql database and restart web server manually. Following is the first my / etc / cron.hourly / optimze process for seamless servic...
edit the file / etc / my.cnfThe file should look like this:Increase 100,000 to the number you desire.After the setting is applied, you should restart your database.
Below is from Aurimas Griciūnas showing hierarchical layers for AI Agents.Sometimes 𝗔𝗜 𝗔𝗴𝗲𝗻𝘁𝘀 might seem simple from the outside.They are not 👇There are many moving pieces that production ready Agentic Systems rely on. I like to split the 𝗛𝗶𝗲𝗿...
Below bash script is for installing gcc 4.9.4 in CentOS 7. For your information,you should have sudo permission to install the above.
CPUs (Central Processing Units) are designed for general-purpose tasks,prioritizing sequential processing and complex instructions,while GPUs (Graphics Processing Units) are specialized for parallel processing of many simpler instructions simultaneously.GP...
STEP 1.Install Let’s Encrypt Certbot Tool.Before you can create free wildcard certificates,you need certbot installed.I’m using an CentOS Server here.To install it,run the following commands: .STEP 2.Generate Let’s Encrypt Wildcard SSL Certificate.After...
In order to mount windows shared folder on CentOS, you need to install some packages like belowAnd the easiest way can mount the folder you want will be like belowIn case that you encounter error message like “mount error(12): Cannot allocate memory to th...
On Centos 6.7,you can check IP address configuration by ifconfig command as below: .The below is the example of files on " / etc / sysconfig / network-scripts". Among above,ifcfg-eth0 and ifcfg-eth1 is wired network,and below is the reference example: .If ...
If you installed Centos in minial installation mode, you should install Apache + PHP + MySQL manually.The followings are the procedure to install Apache + PHP + MySQL:Making apache and mysql to start automatically
The software utility Cron is a time-based job scheduler in Unix-like computer operating systems. People who set up and maintain software environments use cron to schedule jobs (commands or shell scripts) to run periodically at fixed times, dates, or interv...
“mcrypt” is an interface to the mcrypt library, which supports a wide variety of block algorithms such as DES, TripleDES, Blowfish (default), 3-WAY, SAFER-SK64, SAFER-SK128, TWOFISH, TEA, RC2 and GOST in CBC, OFB, CFB and ECB cipher modes. Additionally, ...
When using OAuth 1.0a, it requires timestamp for authentication. The followings are the example of shell commands which can set time information. Setup timezoneTo set the timezone of your system clock do the following:# rm -rf / etc / localtime# ln -...
I am using Virtual Private Hosting service, and I found that my server has some problem as below. As you can see the CPU occupation rate is more than 300%. So my server response speed is the most slower than I had experiences before. I had read some articl...
Following code converts EUC-KR format document to UTF8. utfconvert.sh.
There are lots of ways to select a random record or row from a database table.Here are some example SQL statements that don't require additional application logic,but each database server requires different SQL syntax.Select a random row with MySQL:Select ...
This example shows a very simple form together with the form handling process on a single page. Below is another approach based on Heredoc I like:
Grabs the referring URL - get the HTTP_REFERER and save it to a variable. code snippet: .While not inherently intended for API security,the HTTP_REFERER header can be a valuable tool for implementing an API that restricts access to certain resources based ...
Whatever the formatted string is,strtotime() function convert the formatted date time string to datetime.Following example shows the simple reference can convert date time string whatever the formatted input is.
PHP provides the alternate function which can control time limit that defined in php.ini. Following is the alternate function can control time limit.void set_time_limit (int seconds);Set the number of seconds a script is allowed to run. If this is reached,...
The time () function generates a long string of numbers representing how many seconds have passed since January 1, 1970. It is possible to add and subtract time by adding and subtracting seconds.
The three most basic searches using regular expressions are searching for the strings start, the strings end, or for characters it contains. We can do these using the following symbols:^ indicates the string starts with the specified characters, so "^strcp...
This source code describes how to send email with php with headers .
This code prints array count values
See below as calculator with basic four functions.
In this article we'll make number format like 0001, 0002, 0003 in stead of 1, 2 ,3. It's very easy to do this for your counter, category or product ID. etc.
This basically randomly pick a number between the min and max values. This is made because the rand() and mt_rand() function can not accept numbers larger than 2^31 or 2^63,depend on your processor and complier.
Encryption and password account accessFunction AccountCryptPassword($password,$salt) { if($salt=="") { srand(time()); $random=rand(); $itoa64=". / 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"; ...
This php based script will find numbers and give them a cardinal ending.This can be useful for displaying rankings or results of a competition.The script is easy to install and use .Explanation::addOrdinalSuffix($number): This function adds the appropriate...
URL Rewriter PHP is a short code that can be used to rewrite dynamic PHP urls as URL's that link to static htmlpages.Increases search engine rankings by creating a static system of page linking as well as making all content available. Associated Data for U...