<?xml version="1.0" encoding="utf-8"?>
<!--  RSS generated by tsingfun.com RSS Builder [2026-04-21 22:28:20]  --> 
<rss version="2.0" xmlns:im="http://purl.org/rss/1.0/item-images/" xmlns:dc="http://purl.org/dc/elements/1.1/" >
<channel>
<pubDate>Tue, 21 Apr 2026 22:28:20 +0800</pubDate>
<lastBuildDate>Tue, 21 Apr 2026 22:28:20 +0800</lastBuildDate>
<docs>https://m.tsingfun.com</docs>
<link>https://m.tsingfun.com</link>
<title>数据库(内核)</title>
<image>
<title>数据库(内核)</title>
<url><![CDATA[]]></url>
<link>https://m.tsingfun.com</link>
</image>
<webMaster>https://m.tsingfun.com</webMaster>
<generator>https://m.tsingfun.com</generator>
<ttl>60</ttl>
<dc:creator>https://m.tsingfun.com</dc:creator>
<dc:date>Tue, 21 Apr 2026 22:28:20 +0800</dc:date>
<item>
<title><![CDATA[【解决】mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock']]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock.html]]></link>
<description><![CDATA[mysql_real_connect: Can& 39;t connect to local MySQL server through socket & 39; tmp mysql sock& 39;解决方法（挨个试）：1、ln -s  run mysql mysql sock  tmp mysql sock2、ln -s  var lib mysql mysql sock  tmp mysql sock3、service mysql restart]]></description>
<pubDate>2021-07-24 20:16:32</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[OceanBase使用libeasy原理源码分析：服务器端]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2556.html]]></link>
<description><![CDATA[<img src=https://www.tsingfun.com/uploadfile/2021/0110/thumb_150_150_20210110101642509.png border='0' /><br />libeasy是个网络框架，这个网络框架基于事件驱动模型，libeasy可以有多个网络I O线程，每个网络I O线程一个event loop，事件驱动模型基于开源的libev实现。我认为，libeasy不同于   ]]></description>
<pubDate>2021-01-10 22:16:00</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2556.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[OceanBase使用libeasy原理源码分析：客户端]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2555.html]]></link>
<description><![CDATA[这篇主要写libeasy作为客户端的情形。结合OceanBase 0 4的mergeserver使用libeasy的情况进行分析,mergeserver请求chunkserver是异步请求，chunkserver使用update是同步请求，在li   ]]></description>
<pubDate>2021-01-10 22:08:30</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2555.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[sqlite 命令行创建一个空库]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/sqlite_create_empty_db.html]]></link>
<description><![CDATA[SQLite创建一个空白的数据库，具有被识别为有效的SQLite数据库的优势，比touch创建一个空文件好。$sqlite3 foo db &quot;create table t(f int); drop table t;&quot;可以通过以下方   ]]></description>
<pubDate>2021-01-08 09:22:42</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/sqlite_create_empty_db.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[mysql 库二进制数据默认存放路径]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2495.html]]></link>
<description><![CDATA[一般放在  var lib mysql，每个库一个子目录。]]></description>
<pubDate>2020-09-30 15:39:37</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2495.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[Oracle 分组后取每组第一条数据]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2297.html]]></link>
<description><![CDATA[Oracle 分组后取每组第一条数据的SQL如下，亲测有效：SELECT *    FROM (SELECT ROW_NUMBER() OVER(PARTITION BY T field1, T    ]]></description>
<pubDate>2018-02-02 09:20:13</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2297.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[Oracle中translate与replace的使用]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2296.html]]></link>
<description><![CDATA[SELECT TRANSLATE(&amp; 39;,abcdefghij,&amp; 39;,&amp; 39;,jabcdefghi&amp; 39;,&amp; 39;+&amp; 39;) FROM dual; --第二、三参数一一对应，没有对应就删除原   ]]></description>
<pubDate>2018-01-19 16:19:38</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2296.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[解决：ORA-01658: 无法为表空间space中的段创建 INITIAL 区]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2286.html]]></link>
<description><![CDATA[原因：表空间大小不够造成在建表或则其他需要占用表空间的时候报错，包括建立索引等操作。解决：首先，我们先分析我们对应的表空间大小有多   ]]></description>
<pubDate>2017-11-15 14:52:59</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2286.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[解决：ORA-00054:资源正忙,要求指定NOWAIT]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2262.html]]></link>
<description><![CDATA[<img src=https://www.tsingfun.com/uploadfile/2017/0626/thumb_150_150_20170626041216859.jpg border='0' /><br />创建索引的时候报错ORA-00054: resource busy and acquire with NOWAIT specified解决步骤：1：等待其他会话释放资源2：找出占用资   ]]></description>
<pubDate>2017-06-26 16:09:53</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2262.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[如何查看Oracle用户的SQL执行历史记录？]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2257.html]]></link>
<description><![CDATA[select * from v$sqlarea t order by t LAST_ACTIVE_TIME desc注意 ：执行此语句等等一些相关的语句 必须具有DBA 的权限 虽然   ]]></description>
<pubDate>2017-06-09 11:00:44</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2257.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[Oracle的列操作(增加列,修改列,删除列)，包括操作多列]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2246.html]]></link>
<description><![CDATA[增加一列： alter table emp4 add test varchar2(10);修改一列： alter table emp4 modify test varchar2(20);删除一列：alter   ]]></description>
<pubDate>2017-05-15 15:02:02</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2246.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[关于ORA-00903. 表名无效的错误]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2245.html]]></link>
<description><![CDATA[可能创建表（或字段）时是用双引号中的小写表名创建的，就像下面这样：createtable&quot;mytable&quot;(&quot;a&quot;int,&quot;b&quot;varchar2(2));使用这个表（或字段）   ]]></description>
<pubDate>2017-05-15 11:36:43</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2245.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[oracle group 取每组第一条]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2227.html]]></link>
<description><![CDATA[Oracle查询:取出每组中的第一条记录按type字段分组,code排序,取出每组中的第一条记录方法一：select type,min(code) from group_infogro...]]></description>
<pubDate>2017-04-06 16:56:31</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2227.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[SQL中使用update inner join和delete inner join；Oracle delete join替代方案]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2223.html]]></link>
<description><![CDATA[UpdateUpdate XXX set XXX where 这种写法大家肯定都知道，才发现update和delete居然支持inner join的update方式，这个在表间关联来...]]></description>
<pubDate>2017-03-28 11:02:45</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2223.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[oracle top 替代方案]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2211.html]]></link>
<description><![CDATA[由于Oracle不支持select top 语句，所以在Oracle中经常是用order by 跟 rownum的组合来实现select top n的查询。select * from (...]]></description>
<pubDate>2017-03-17 15:55:04</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2211.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[【Mysql】报mysqli_real_connect(): (HY000/2002)错误]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/2204.html]]></link>
<description><![CDATA[原因分析：手动编译安装mysql指定位置后，所有的mysql文件都在指定的目录或者data目录下面，而php默认只会通过 temp mysql.sock路径寻找soc...]]></description>
<pubDate>2017-03-07 11:18:39</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/2204.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[MySQL 启动报错 Table 'mysql.plugin' doesn't exist ]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/1982.html]]></link>
<description><![CDATA[启动报错： opt szy bin mysqld: Table   &amp;#39;mysql.plugin  &amp;#39; doesn  &amp;#39;t exist141211 15:06:12 [ERROR] Can  &amp;#39;t open t...]]></description>
<pubDate>2016-08-04 23:18:49</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/1982.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[[解决]MySql提示:The server quit without updating PID file(…)失败]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/1981.html]]></link>
<description><![CDATA[<img src=https://www.tsingfun.com/uploadfile/2016/0804/thumb_150_150_20160804104007691.jpg border='0' /><br />服务器症状：今天网站web页面提交内容到数据库，发现出错了，一直提交不了，数找了下原因，发现数据写不进去！第一反应，重启mysql数据库，...]]></description>
<pubDate>2016-08-04 22:39:04</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/1981.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[Linux MySql的启动、关闭]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/1980.html]]></link>
<description><![CDATA[首先是MySql的编译安装，这里不详解。make install后，需要启动mysql，可以将mysql添加到service中，并配置开机启动。如果不添加服务，则...]]></description>
<pubDate>2016-08-04 22:28:36</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/1980.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
<item>
<title><![CDATA[创建增量同步Oracle物化视图问题]]></title>
<link><![CDATA[https://www.tsingfun.com/it/database_kernel/1949.html]]></link>
<description><![CDATA[我们采用Oracle的物化视图增量刷新机制定时将数据库A上的某个表的数据同步到另一个数据库B上。我们常用的最简单的实现步骤是这样。首先在数...]]></description>
<pubDate>2016-07-28 08:40:24</pubDate>
<guid><![CDATA[https://www.tsingfun.com/it/database_kernel/1949.html]]></guid>
<author>https://m.tsingfun.com</author>
</item>
</channel>
</rss>
