karatos.in Open in urlscan Pro
167.86.125.3  Public Scan

Submitted URL: http://karatos.in/
Effective URL: https://karatos.in/
Submission: On July 18 via api from GB — Scanned from GB

Form analysis 0 forms found in the DOM

Text Content

Toggle navigation


KARATOS

 * home Home
 * webOptions
   * contactsContact
   * policyPolicies
   * infoAbout
 * 

WEB DEVELOPMENT

--------------------------------------------------------------------------------

WEB DEVELOPMENT

PHP OCR BUSINESS LICENSE RECOGNITION

Jayce
schedule1 min read

WEB DEVELOPMENT

USE THE API TO CREATE ITEMS UNDER THE ACCOUNT

Timothy
schedule1 min read

WEB DEVELOPMENT

STARTUP SCRIPT AND CRONOLOG LOG SEGMENTATION

Bentley
schedule3 min read

WEB DEVELOPMENT

MY PHP & MYSQL FAQ

php Chinese character string length and fixed-length interception problem Use
str_len("China"), the result is 6. The php system defaults a Chinese character
length of 3, you can use the mb_strlen function to obtain the length, and the
mb_substr function to intercept the characters mb_strlen($str, "utf -8"); //1
Chinese character is 1 character mb_strlen($str, "gb2312"); //The system will
consider 1 Chinese character to be 2 characters mb_strlen($str); //If not added,
the system will consider 1 C

Adriana
schedule6 min read

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

FRONT END TECHNOLOGIES

--------------------------------------------------------------------------------

TRENDING_UP FRONT END TECHNOLOGIES

SIMPLE USE OF REGULAR POSITION MATCHING

Bryce
favorite1386

TRENDING_UP FRONT END TECHNOLOGIES

"PRO GIT" READING NOTES 1

Avery
favorite312

TRENDING_UP FRONT END TECHNOLOGIES

GIT BASICS

Brandon
favorite1516

TRENDING_UP FRONT END TECHNOLOGIES

PROMISE BASICS

Asher
favorite233

TRENDING_UP FRONT END TECHNOLOGIES

FUNCTION CURRY (HASKELL CURRY)

Hannah
favorite1850

TRENDING_UP FRONT END TECHNOLOGIES

SEVERAL METHODS TO CLEAR FLOATS

Matthew
favorite523

--------------------------------------------------------------------------------

JAVASCRIPT

--------------------------------------------------------------------------------

JAVASCRIPT

FRONT END DATA STRUCTURE AND ALGORITHM (14): 01 THE ART OF
EXECUTION-BACKTRACKING ALGORITHM (PART 2)

PrefaceFollowing the book, the previous chapter made a progressive introduction
from recursion to backtracking. I believe that I have a preliminary
understanding of backtracking. Next, I will mainly introduce more topics related
to backtracking, and deepen its understanding in breadth.Alignment
problem46-Full arrayGiven a sequence without repeated numbers, return all
possible permutations. Example: Input: [1, 2, 3] Output: [
[1,2,3],[1,3,2],[2,1,3], [2,3,1],[3,1,2],[3,2,1] ] Source: LeetCode Lin

Melanie
schedule16 min read

JAVASCRIPT

FRONT END DATA STRUCTURE AND ALGORITHM (13): 01 THE ART OF
EXECUTION-BACKTRACKING ALGORITHM (PART 1)

Carter
schedule16 min read

JAVASCRIPT

FRONT END DATA STRUCTURE AND ALGORITHM (12): INTERESTING ALGORITHM-MULTI-POINTER
AND SLIDING WINDOW

Nolan
schedule6 min read

JAVASCRIPT

FRONT-END DATA STRUCTURE AND ALGORITHM (11): A BINARY SEARCH ALGORITHM THAT
SEEMS SIMPLE AND MADDENING

Cora
schedule19 min read

--------------------------------------------------------------------------------

SERVER SIDE PROGRAMMING

--------------------------------------------------------------------------------

SERVER SIDE PROGRAMMING

BUILD A THREE-NODE HIGH-AVAILABILITY ARCHITECTURE BASED ON MYSQL 5.7
MULTI-SOURCE REPLICATION AND KEEPALIVED

Basic environment preparationUse Centos 6.X 64-bit system using MySQL
MySQL-5.7.17-x86_64version, go to the official
mysql-5.7.17-linux-glibc2.5-x86_64.tar.gzversionMachine nameoperating
systemIPnode1centos-6.8192.168.11.100node2centos-6.8192.168.11.101node3centos-6.8192.168.11.102Set
the VIP of the three-node cluster to 192.168.11.110Generally we recommend
closing iptables[wubx@zhishuedu.com ~]# chkconfig —del iptables
[wubx@zhishuedu.com ~]# /etc/init.d/iptables stopAnd close selinux[wubx@zhis

Benjamin
schedule 3 min read

SERVER SIDE PROGRAMMING

THE WHOLE PROCESS OF TROUBLESHOOTING MEMORY LEAKS AND OOM ISSUES UNDER MYSQL 5.7

GuideMy personal website uses MySQL version 5.7 in the backend. Some time ago, I
was often killed by oom-kill. With the help of new features in 5.7, after some
investigation, I finally caught this ghost.1. Problem phenomenonSome time ago,
my website often got wind from time to time, prompting that the database could
not be connected, prompting:Error establishing database connectionI thought it
was a personal website anyway, and it didn’t matter. It might also be because
the VPS configuration is

Isaac
schedule 6 min read

SERVER SIDE PROGRAMMING

SQL OPTIMIZATION IN PARTITIONED TABLE SCENARIOS

GuideOne table is partitioned, one partition per day.There is a query on this
table. It often only queries the data of a certain day in the table, but almost
all data in the entire partition is scanned every time. Is there any way to
optimize it?Scene to be optimizedThere is a large table, the amount of data
generated every day is about 1 million, so the table partitioning scheme is
adopted, one partition per day.Here is the DDL of the table:CREATE TABLE `t1` (
`id` bigint(20) NOT NULL AUTO_INCR

Mark
schedule 5 min read

SERVER SIDE PROGRAMMING

OPTIMIZATION CASE: CASE WHEN FOR SQL REWRITING OPTIMIZATION

GuideToday, I will share with you a SQL optimization case that is unique through
SQL rewriting.Scene to be optimizedFound the following record in SLOW QUERY
LOG:... # Query_time: 59.503827 Lock_time: 0.000198 Rows_sent: 641227
Rows_examined: 13442472 Rows_affected: 0 ... select uid,sum(power) powerup from
t1 where date>='2017-03-31' and
UNIX_TIMESTAMP(STR_TO_DATE(concat(date,'',hour),'%Y-%m-%d %H'))>=1490965200
and UNIX_TIMESTAMP(STR_TO_DATE(concat(date,'',hour),'%Y-%m-%d %H'))<14921748

Daniel
schedule 7 min read

SERVER SIDE PROGRAMMING

MYSQL FAQ SERIES: HOW TO VIEW THE CURRENT LATEST TRANSACTION ID

Written in the front: In some cases, you may need to check the current latest
transaction ID in order to make some business logic judgments (for example, use
the transaction ID change and the time difference before and after, and count
the response time of each transaction, etc.).Generally, there are two ways to
view the current transaction ID:1. Execute SHOW ENGINE INNODB STATUS to view
transaction related information==================================== 150303
17:16:11 INNODB MONITOR OUTPUT ===

Carter
schedule 5 min read

SERVER SIDE PROGRAMMING

MYSQL FAQ SERIES-HOW TO SWAP TWO TABLE NAMES

problemA classmate asked me, in a scenario similar to pt-osc, the two table
names need to be swapped, how can I be sure of everything?analysisIt is
estimated that the other students laughed. Isn’t it easy to rename the table
names? Rename each other.However, what we want is to complete the table name
swap at the same time. If it is reversed one after another, it may cause some
data write failures. What should we do?ReplyIn fact, it is not difficult. You
can find a method from the MySQL manual, t

Sydney
schedule 2 min read

--------------------------------------------------------------------------------

1 2 3 4 5 6 7 8 9 10

--------------------------------------------------------------------------------

© 2022 - Karatos  
Policies   Contact  About