<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[技术分享]]></title><description><![CDATA[作为一个用户,人要迁就机器;作为一个开发者,要机器迁就人。]]></description><link>https://blog.youkuaiyun.com/xy2204</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; xy2204]]></copyright><item><title><![CDATA[Sphinx macos sql_connect: failed to load libmysqlclient]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/124965352</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/124965352</guid><author>xy2204</author><pubDate>Wed, 25 May 2022 14:25:58 +0800</pubDate><description><![CDATA[查看mysql安装位置之lib

find /usr/ -name 'libmysqlclient*'



设置变量

export DYLD_LIBRARY_PATH=/usr//local/Cellar/mysql@5.6/5.6.51/lib
重新启动即可

indexer --all
]]></description><category></category></item><item><title><![CDATA[PHP 7.1 Dockerfile]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/86622559</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/86622559</guid><author>xy2204</author><pubDate>Thu, 24 Jan 2019 10:53:04 +0800</pubDate><description><![CDATA[
FROM php:7.1.9-fpm

# Install any custom system requirements here
RUN apt-get update \
  &amp;amp;&amp;amp; apt-get install -y --no-install-recommends \
    curl \
    libicu-dev \
    libmemcached-dev \
   ...]]></description><category></category></item><item><title><![CDATA[PHP7 Protobuf安装使用]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/84883018</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/84883018</guid><author>xy2204</author><pubDate>Fri, 07 Dec 2018 17:52:20 +0800</pubDate><description><![CDATA[1.版本环境
系统：Ubuntu 14.04.5
PHP版本：PHP 7.1.7

protoc：libprotoc 3.6.1
php-protobuf：3.6.1

2.安装
 2.1 PHP请自行安装，这里不做描述

2.2 protobuf安装
php protobuf扩展安装

以下可以自行选择是否按照，如果是没有安装这些类库，请执行


sudo apt-get install -y ...]]></description><category></category></item><item><title><![CDATA[打开-修改安卓模拟器代理设置]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/81939490</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/81939490</guid><author>xy2204</author><pubDate>Wed, 22 Aug 2018 10:29:41 +0800</pubDate><description><![CDATA[adb connect 127.0.0.1:7555
adb shell am start -a android.intent.action.MAIN  -n com.android.settings/.wifi.WifiSettings]]></description><category></category></item><item><title><![CDATA[MYSQL 使用存储过程批量更新表数据]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/79290482</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/79290482</guid><author>xy2204</author><pubDate>Thu, 08 Feb 2018 15:56:40 +0800</pubDate><description><![CDATA[DELIMITER //CREATE PROCEDURE `update_user`()  BEGIN	DECLARE userId BIGINT;	DECLARE openId VARCHAR(40);	declare stop int default 0; 	DECLARE cur CURSOR FOR (SELECT open_id,uid FROM user_map);	/* 	定义游标的...]]></description><category></category></item><item><title><![CDATA[How to Reset the Root Password 5.5]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/78664718</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/78664718</guid><author>xy2204</author><pubDate>Wed, 29 Nov 2017 14:07:26 +0800</pubDate><description><![CDATA[B.5.3.2 How to Reset the Root Password





If you have never assigned a root password
 for MySQL, the server does not require a password at all for connecting as root.
 However, this is insec]]></description><category></category></item><item><title><![CDATA[SQL SERVER 小记]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/78499907</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/78499907</guid><author>xy2204</author><pubDate>Fri, 10 Nov 2017 15:03:04 +0800</pubDate><description><![CDATA[1.更改表名
EXEC sp_rename 'table_name','new_table_name';

2.TEXT字段类型数据追加
UPDATE table_name SET column= CAST(column AS VARCHAR) + 'append value' WHERE 1=1;]]></description><category></category></item><item><title><![CDATA[PHP 常用函数笔记]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/77840313</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/77840313</guid><author>xy2204</author><pubDate>Mon, 04 Sep 2017 18:18:59 +0800</pubDate><description><![CDATA[
/**
 *计算字符长度
 * 1个字符utf-8占用3个字节
 * @param $str
 * @return int
 */
function mbstrlen($str)
{
    $len = strlen($str);

    if ($len &amp;lt;= 0)
    {
        return 0;
    }

    $count  = 0;

    for ($...]]></description><category></category></item><item><title><![CDATA[Mysql 5.6添加修改用户名和密码]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/74520079</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/74520079</guid><author>xy2204</author><pubDate>Thu, 06 Jul 2017 10:04:40 +0800</pubDate><description><![CDATA[先登录mysql 
shell> mysql–user=root mysql 
有密码的需要添加 –password 或-p 选项添加用户 
mysql>CREATEUSER’finley’@’localhost’IDENTIFIEDBY’some_pass’; 
mysql>GRANTALLPRIVILEGESON*.*TO’finley’@’localhost’WITHGRANTOPTION;m]]></description><category></category></item><item><title><![CDATA[HTML5 标签随记]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/54094347</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/54094347</guid><author>xy2204</author><pubDate>Thu, 05 Jan 2017 16:11:41 +0800</pubDate><description><![CDATA[HTML5的文档类型<!DOCTYPE html>
<html lang="zh-cn">
......
</html>确保适当的绘制和触屏缩放，需要在 之中添加viewport元数据标签。<meta name="viewport" content="width=device-width, initial-scale=1.0">在移动设备浏览器上，通过为viewport meta标签添加user-s]]></description><category></category></item><item><title><![CDATA[Android开发SVN版本控制忽略文件列表--android studio]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/53905982</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/53905982</guid><author>xy2204</author><pubDate>Wed, 28 Dec 2016 10:04:27 +0800</pubDate><description><![CDATA[Android项目需要协同一起开发时，就需要保证项目同步完整性。
SVN忽略文件列表：
.gradle
.idea
build
local.properties
*.iml
app/*.iml
app/build.gradle
app/build]]></description><category></category></item><item><title><![CDATA[centos6.5 yum安装]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/51781287</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/51781287</guid><author>xy2204</author><pubDate>Fri, 25 Nov 2016 22:42:27 +0800</pubDate><description><![CDATA[查看、卸载已安装的yum包

查看已安装的yum包

[root@iZ23rter8cjZ ~]# rpm -qa|grep yum
yum-metadata-parser-1.1.2-16.el6.x86_64
yum-plugin-fastestmirror-1.1.30-17.el6_5.noarch
yum-plugin-security-1.1.30-17.el6_5.no]]></description><category></category></item><item><title><![CDATA[mysql proxy读写分离]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/52252870</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/52252870</guid><author>xy2204</author><pubDate>Fri, 19 Aug 2016 17:21:13 +0800</pubDate><description><![CDATA[mysql proxy 介绍 
    MySQL Proxy是一个处于你的client端和MySQL server端之间的简单程序，它可以监测、分析或改变它们的通信。它使用灵活，没有限制，常见的用途包括：负载平衡，故障、查询分析，查询过滤和修改等等。 
 
MySQL Proxy就是这么一个中间层代理，简单的说，MySQL Proxy就是一个连接池，负责将前台应用的连接请求转发给后台的数据库，并且]]></description><category></category></item><item><title><![CDATA[mysql配置文件my.cnf详解[部分]]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/52241986</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/52241986</guid><author>xy2204</author><pubDate>Thu, 18 Aug 2016 16:10:46 +0800</pubDate><description><![CDATA[mysql配置文件my.cnf详解[部分]








basedir = path

使用给定目录作为根目录(安装目录)。



character-sets-dir = path

给出存放着字符集的目录。



datadir = path

从给定目录读取数据库文件。



pid-file = filename

为mysql]]></description><category></category></item><item><title><![CDATA[Linux下web服务器备份恢复脚本]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/52051954</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/52051954</guid><author>xy2204</author><pubDate>Thu, 28 Jul 2016 09:29:51 +0800</pubDate><description><![CDATA[#!/bin/sh  


cat
 

    +----------------------------------------------------------------+  


    |             
 === 服务器备份、恢复脚本 ===         　　       |   

    |------------------http://]]></description><category></category></item><item><title><![CDATA[什么是CGI、FastCGI、PHP-CGI、PHP-FPM、Spawn-FCGI?]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/51906171</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/51906171</guid><author>xy2204</author><pubDate>Thu, 14 Jul 2016 09:19:49 +0800</pubDate><description><![CDATA[什么是CGI

CGI全称是“公共网关接口”(Common Gateway Interface)，HTTP服务器与你的或其它机器上的程序进行“交谈”的一种工具，其程序须运行在网络服务器上。

CGI可以用任何一种语言编写，只要这种语言具有标准输入、输出和环境变量。如php,perl,tcl等。

什么是FastCGI

FastCGI像是一个常驻(long-live)型的CGI，它]]></description><category></category></item><item><title><![CDATA[Mysql大数据量存储及访问的设计讨论]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/51858865</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/51858865</guid><author>xy2204</author><pubDate>Fri, 08 Jul 2016 10:33:48 +0800</pubDate><description><![CDATA[摘要：随着互联网应用的广泛普及，海量数据的存储和访问成为了系统设计的瓶颈问题。对于一个大型的互联网应用，每天几十亿的PV无疑对数据库造成了相当高的负载...

转载请注明来源：Mysql大数据量存储及访问的设计讨论

    一、引言

　　随着互联网应用的广泛普及，海量数据的存储和访问成为了系统设计的瓶颈问题。对于一个大型的互联网应用，每天几十亿的PV无疑对数据库造成了相当高的负载。]]></description><category></category></item><item><title><![CDATA[centos6.5安装php5.6]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/51784614</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/51784614</guid><author>xy2204</author><pubDate>Wed, 29 Jun 2016 17:28:11 +0800</pubDate><description><![CDATA[./configure   --prefix=/usr/local/php   --with-config-file-path=/usr/local/php/etc  \
 --with-fpm-user=www   --with-fpm-group=www   --enable-fpm   --enable-opcache=no  \
 --with-mysql=mysqlnd   --wi]]></description><category></category></item><item><title><![CDATA[centos6.5安装mysql5.6]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/51781683</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/51781683</guid><author>xy2204</author><pubDate>Wed, 29 Jun 2016 11:29:43 +0800</pubDate><description><![CDATA[1.下载mysql rpm包
下载地址：http://dev.mysql.com/downloads/repo/yum/
我选择的是：http://repo.mysql.com//mysql57-community-release-el6-8.noarch.rpm
添加mysql yum源仓库
rpm -ivh mysql57-community-release-el6-8.noarch.]]></description><category></category></item><item><title><![CDATA[Centos下多种PHP拓展安装方法]]></title><link>https://blog.youkuaiyun.com/xy2204/article/details/51690611</link><guid>https://blog.youkuaiyun.com/xy2204/article/details/51690611</guid><author>xy2204</author><pubDate>Thu, 16 Jun 2016 11:24:34 +0800</pubDate><description><![CDATA[Centos下，PHP有多种方式来安装拓展， 主要有 包管理式的yum安装、pecl安装， 以及底层的源码编译安装。

包管理式的安装卸载尤为方便，而源码编译式的安装则方便参数调优。

一般的搭建本机开发环境推荐包管理式的安装，节约时间。而线上部署环境则推荐编译安装， 方便调优。




yum安装
## yum方式安装能自动安装拓展的.so动态库，并配置好php.ini

#]]></description><category></category></item></channel></rss>