CentOS7安装MySQL8.0要负责任解决的回答 20C

yum方式的。在安装过程中超级慢,用网上的方式也解决不了。

我想要解压安装的方式去配置MySQL,我要详细版的。不要那种不负责的博客,看了好多都是假的,完全不能安成功,希望哪位好心人帮我一下。谢谢

qq_39170130
wwys 你是指下载rpm包的速度慢?那这个没办法,是网络的原因,你安装时可以提前下载好rpm包这样安装就很快
7 个月之前 回复
wojiushiwo945you
毕小宝 回复贵阳挖掘机马善福自备车辆专业挖游泳池: 问答大神啊,为什么你的昵称总在变呢,这次的昵称太长,光荣榜上显示用户名昵称时直接错乱了啦!
7 个月之前 回复
caozhy
贵阳老马马善福专业维修游泳池堵漏防水工程 csdn收了你的钱,你应该找csdn去负责。
7 个月之前 回复
caozhy
贵阳老马马善福专业维修游泳池堵漏防水工程 就这么一点破分还要负责任,而且商城都跑路了,负你个头啊
7 个月之前 回复

2个回答

1、yum仓库下载MySQL:sudo yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

2、yum安装MySQL:sudo yum install mysql-community-server

3、启动MySQL服务:sudo service mysqld start

4、检查MySQL服务状态:sudo service mysqld status

5、查看初始密码(如无内容直接跳过):sudo grep 'temporary password' /var/log/mysqld.log

6、本地MySQL客户端登录:mysql -uroot -p

7、输入密码为第5步查出的,如果没有,直接回车,然后输入命令 flush privileges

8、修改root登录密码:ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';(注意要切换到mysql数据库,使用use mysql)

注意:开始遇到问题是不输入密码或输错密码都能连接MySQL server,后来在修改允许阿里CentOS7允许远程操作MySQL数据库时,

才发现需要去调整 /etc/my.cnf文件,注释掉skip-grant-tables,重启MySQL服务(sudo service mysqld restart),quit退出连接,重新连接就需要输入密码了

后期如果忘记密码,可以通过skip-grant-tables配置跳过输入密码登录MySQL,执行7、8步进行修改,如果‘root’@'localhost'变为'root'@'%',那么alter语句中的也要修改

9、配置MySQL允许外部访问:1)首先设置阿里云安全组规则入方向,支持MySQL端口3306可访问(协议类型下拉菜单中有MySQL端口)

              2)服务端登录MySQL,use mysql;然后执行select user,host from user可查看用户及对应允许访问主机

                然后执行update user set host = '%' where user ='root';允许任何外部可访问;再执行上一步查看命令,可比较结果

10、如此即可连接

补充:show global variables like 'port';可查看MySQL服务端口,如果看到的value为0,则说明没有使用密码登录,需要去修改my.cnf文件;

my.cnf文件也可以通过port=3306来指定MySQL服务端口,重启MySQL服务即可

11、java连接8.0及以上MySQL数据库使用新驱动

这个问题是在我用本地工具可以连同阿里云服务器上的MySQL,而本地用java怎么也连不上,偶然间点开工具测试连接的详细信息发现新的驱动,更改java对应驱动后,连接成功

qq_34417433
Gosse0405 我说了。yum安装超级慢,你怎么还给我提供这个方案,就算提供,你也需要帮我解决yum下载慢的问题啊。不负责任,复制粘贴
7 个月之前 回复

1、从官网给出的配置表 https://www.mysql.com/support/supportedplatforms/database.html 来看 ,CentOS 是支持 MySQL 8.0 的。
2、这个实践过程还是比较复杂的,只能自己摸索了。
建议按照官网说明 https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html
自己逐步摸索安装吧。

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
在CentOS-7-x86_64-Minimal-1810安装mysql8.0.16问题
老师好: 最近在学习centos搭建lamp环境,在csdn中找到好多帐子很实 用,也学到不少命令。 现在我的问题是装到mysql这一环节给卡住了, 我的安装环境是:CentOS-7-x86_64-Minimal-1810 根据这个贴子https://blog.csdn.net/qq_38821502/article/details/90053717 安装很顺利,但是到了第10.授予root用户远程访问权限中的4)grant all privileges on . to ‘root’@’%’ identified by ‘tsk007’ with grant option; 这一步我的机子出现错误提示,想问一下这应该怎么解决? ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. to ‘root’@’%’ identified by ‘123456789’ with grant option' at line 1
Druid连接Mysql出现错误,create connection SQLException
``` 2020-01-17 23:43:11.284 ERROR 1710 --- [reate-161314577] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.151.130:6666/secondskill?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8, errorCode 1049, state 42000 java.sql.SQLSyntaxErrorException: Unknown database 'secondskill' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.18.jar:8.0.18] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.18.jar:8.0.18] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.18.jar:8.0.18] at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.18.jar:8.0.18] at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.18.jar:8.0.18] at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.18.jar:8.0.18] at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1643) ~[druid-1.1.20.jar:1.1.20] at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1709) ~[druid-1.1.20.jar:1.1.20] at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2715) ~[druid-1.1.20.jar:1.1.20] ``` 这个错误是在我修改Mysql时区后出现的,但是我不能确定是不是修改时区导致的这个问题,这个Mysql是在centos系统上的docker里运行的,在我本机上通过navicat是可以连接上Mysql数据库的,用户名和密码是可以保证正确的.这个是出现的错误码 **errorCode 1049, state 42000**,我曾尝试更换了Mysql连接jar包为5.1.38的也是出现这个错误.程序运行是没有问题的,如果过程中有对数据库的操作的话就会也现这个错误,请问这个问题在那里呢?
关于centos7.0进入mysql5.7无法输入中文
我用的是云服务器,然后用bitwise SHH和putty远程登录 装了mysql5.7数据库,不能输入中文,只能输入字符,没进入数据库的话,就可以在控制台 输入中文。数据库编码我全设为utf8也没有用。敲中文就是敲不进去
您的PHP似乎没有安装运行WordPress所必需的MySQL扩展。
wordpress要的都有了,为啥还是说缺少东西啊,哪位大哥,可以解惑下不,万分感谢。php用的7.3.12;mysql用的8.0.13;apache用的2.4.6 (CentOS);nginx用的1.17.6; ![图片说明](https://img-ask.csdn.net/upload/201912/30/1577671230_409648.png) ![图片说明](https://img-ask.csdn.net/upload/201912/30/1577671213_738187.png)
在线等!!!linux服务器连接mysql5.7数据库报错 Could not get JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException
以下是服务器上的报错代码 ![图片说明](https://img-ask.csdn.net/upload/201911/12/1573526989_375593.png) ``` >org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 1000, active 0, maxActive 500, creating 1 ``` 问题就是出在这里. 1,本地项目正常启动,无任何报错,数据库连接正常(使用的都是linux上面的数据库). ![图片说明](https://img-ask.csdn.net/upload/201911/12/1573527132_402324.png) 2,数据库工具使用无任何问题 ![图片说明](https://img-ask.csdn.net/upload/201911/12/1573527246_699888.png) 3,下面放出jdbc配置文件和spring配置文件 ``` jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://..XXXXXX.:/XXXXXX?useUnicode=true&characterEncoding=UTF-8&useSSL=false jdbc.username=xxxx jdbc.password=xxxxx jdbc.filters=stat jdbc.maxActive=500 jdbc.initialSize=1 jdbc.maxWait=1000 jdbc.minIdle=10 jdbc.maxIdle=15 jdbc.timeBetweenEvictionRunsMillis=60000 jdbc.minEvictableIdleTimeMillis=300000 jdbc.validationQuery=SELECT 'x' jdbc.testWhileIdle=true jdbc.testOnBorrow=false jdbc.testOnReturn=false jdbc.maxOpenPreparedStatements=20 jdbc.removeAbandoned=true jdbc.removeAbandonedTimeout=180 jdbc.logAbandoned=true ``` spring 配置 ``` <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <!-- 扫描service包下所有使用注解的类型 --> <context:component-scan base-package="com.yoFish.service"/> <!-- 配置数据库相关参数properties的属性:${url} --> <context:property-placeholder location="classpath:jdbc.properties"/> <!-- 阿里 druid 数据库连接池 --> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close"> <!-- 数据库基本信息配置 --> <property name="driverClassName" value="${jdbc.driverClassName}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <property name="filters" value="${jdbc.filters}"/> <!-- 最大并发连接数 --> <property name="maxActive" value="${jdbc.maxActive}"/> <!-- 初始化连接数量 --> <property name="initialSize" value="${jdbc.initialSize}"/> <!-- 配置获取连接等待超时的时间 --> <property name="maxWait" value="${jdbc.maxWait}"/> <!-- 最小空闲连接数 --> <property name="minIdle" value="${jdbc.minIdle}"/> <!-- 最大空闲连接数 --> <property name="maxIdle" value="${jdbc.maxIdle}"/> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}"/> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="${jdbc.minEvictableIdleTimeMillis}"/> <property name="validationQuery" value="${jdbc.validationQuery}"/> <property name="testWhileIdle" value="${jdbc.testWhileIdle}"/> <property name="testOnBorrow" value="${jdbc.testOnBorrow}"/> <property name="testOnReturn" value="${jdbc.testOnReturn}"/> <property name="maxOpenPreparedStatements" value="${jdbc.maxOpenPreparedStatements}"/> <!-- 超过时间限制是否回收 --> <property name="removeAbandoned" value="${jdbc.removeAbandoned}"/> <!-- 1800 秒,也就是 30 分钟 --> <property name="removeAbandonedTimeout" value="${jdbc.removeAbandonedTimeout}"/> <!-- 关闭 abanded 连接时输出错误日志 --> <property name="logAbandoned" value="${jdbc.logAbandoned}"/> </bean> <!-- 配置SqlSessionFactory对象 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!-- 注入数据库连接池 --> <property name="dataSource" ref="dataSource"/> <!-- 扫描model包 使用别名 --> <property name="typeAliasesPackage" value="com.yoFish.model"/> <!-- 扫描sql配置文件:mapper需要的xml文件 --> <property name="mapperLocations" value="classpath:mapper/*.xml"/> </bean> <!-- 配置扫描Dao接口包,动态实现Dao接口,注入到spring容器中 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!-- 注入sqlSessionFactory --> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> <!-- 给出需要扫描Dao接口包 --> <property name="basePackage" value="com.yoFish.dao"/> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <!-- 注入数据库连接池 --> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置基于注解的声明式事务 --> <tx:annotation-driven transaction-manager="transactionManager"/> </beans> ``` 这个问题搞了很久了,主要就是不知道问题在哪,本地真的是没有任何问题,很多方式我也试过了.很头疼,求大佬帮忙解决
CentOS7 中启动sonarqube7.3,启动后自己会关闭,mysql是5.7版本,jdk是openjdk1.8版本。这个是什么情况
--> Wrapper Started as Daemon Launching a JVM... Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved. 2018.10.26 11:15:47 INFO app[][o.s.a.AppFileSystem] Cleaning or creating temp directory /usr/local/sonar/sonarqube-7.3/temp 2018.10.26 11:15:47 INFO app[][o.s.a.es.EsSettings] Elasticsearch listening on /127.0.0.1:9001 2018.10.26 11:15:47 INFO app[][o.s.a.p.ProcessLauncherImpl] Launch process[[key='es', ipcIndex=1, logFilenamePrefix=es]] from [/usr/local/sonar/sonarqube-7.3/elasticsearch]: /usr/local/sonar/sonarqube-7.3/elasticsearch/bin/elasticsearch -Epath.conf=/usr/local/sonar/sonarqube-7.3/temp/conf/es 2018.10.26 11:15:47 INFO app[][o.s.a.SchedulerImpl] Waiting for Elasticsearch to be up and running 2018.10.26 11:15:47 INFO app[][o.e.p.PluginsService] no modules loaded 2018.10.26 11:15:47 INFO app[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin] 2018.10.26 11:15:48 WARN app[][o.s.a.p.AbstractProcessMonitor] Process exited with exit value [es]: 1 2018.10.26 11:15:48 INFO app[][o.s.a.SchedulerImpl] Process [es] is stopped 2018.10.26 11:15:48 INFO app[][o.s.a.SchedulerImpl] SonarQube is stopped <-- Wrapper Stopped
Navicat 连接不上虚拟机centos的mysql
[root@bogon ~]# service mysql start Redirecting to /bin/systemctl start mysql.service [root@bogon ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.45 MySQL Community Server (GPL) Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> grant all privileges on *.* to root@"%" identified by "new_mysql"; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on *.* to root@"bogon" identified by "new_mysql"; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye [root@bogon ~]# iptables -F [root@bogon ~]# systemctl stop firewalld [root@bogon ~]# systemctl disable firewalld [root@bogon ~]# ifconfig ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 192.168.131.131 netmask 255.255.255.0 broadcast 192.168.131.255 inet6 fe80::20c:29ff:fe4e:4a5b prefixlen 64 scopeid 0x20<link> ether 00:0c:29:4e:4a:5b txqueuelen 1000 (Ethernet) RX packets 284 bytes 28044 (27.3 KiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 395 bytes 31836 (31.0 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536 inet 127.0.0.1 netmask 255.0.0.0 inet6 ::1 prefixlen 128 scopeid 0x10<host> loop txqueuelen 1000 (Local Loopback) RX packets 0 bytes 0 (0.0 B) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 0 bytes 0 (0.0 B) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500 inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255 ether 52:54:00:d0:d8:4b txqueuelen 1000 (Ethernet) RX packets 0 bytes 0 (0.0 B) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 0 bytes 0 (0.0 B) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 [root@bogon ~]# ping www.baidu.com PING www.a.shifen.com (163.177.151.109) 56(84) bytes of data. 64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=1 ttl=128 time=38.4 ms 64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=2 ttl=128 time=34.7 ms 64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=3 ttl=128 time=33.1 ms ^A64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=4 ttl=128 time=33.2 ms 64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=5 ttl=128 time=30.1 ms 64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=6 ttl=128 time=32.9 ms 64 bytes from 163.177.151.109 (163.177.151.109): icmp_seq=7 ttl=128 time=47.0 ms http://img.mukewang.com/climg/5d3d2999000169bb05660668.jpg 虚拟机网络是通的 Navicat的ip地址也没错 root的密码也没错 为什么就是连接不上呢?
centos6.5断电重启后,MySQL启动失败
MySQL启动的错误日志如下: 161213 16:07:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 2016-12-13 16:07:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-12-13 16:07:40 5243 [Note] Plugin 'FEDERATED' is disabled. 2016-12-13 16:07:40 5243 [Note] InnoDB: The InnoDB memory heap is disabled 2016-12-13 16:07:40 5243 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-12-13 16:07:40 5243 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-12-13 16:07:40 5243 [Note] InnoDB: Using Linux native AIO 2016-12-13 16:07:40 5243 [Note] InnoDB: Using CPU crc32 instructions 2016-12-13 16:07:40 5243 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2016-12-13 16:07:40 5243 [Note] InnoDB: Completed initialization of buffer pool 2016-12-13 16:07:40 5243 [Note] InnoDB: Highest supported file format is Barracuda. 2016-12-13 16:07:40 5243 [Note] InnoDB: Log scan progressed past the checkpoint lsn 6528157 2016-12-13 16:07:40 5243 [Note] InnoDB: Database was not shutdown normally! 2016-12-13 16:07:40 5243 [Note] InnoDB: Starting crash recovery. 2016-12-13 16:07:40 5243 [Note] InnoDB: Reading tablespace information from the .ibd files... 2016-12-13 16:07:40 5243 [Note] InnoDB: Restoring possible half-written data pages 2016-12-13 16:07:40 5243 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 6528267 2016-12-13 16:07:40 5243 [Note] InnoDB: 128 rollback segment(s) are active. 2016-12-13 16:07:40 5243 [Note] InnoDB: Waiting for purge to start 2016-12-13 16:07:40 7f161458c700 InnoDB: Assertion failure in thread 139732807370496 in file trx0purge.cc line 699 InnoDB: Failing assertion: purge_sys->iter.trx_no <= purge_sys->rseg->last_trx_no InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 08:07:40 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268435456 read_buffer_size=1048576 max_used_connections=0 max_threads=151 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 728082 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0x9024f5] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x3e8)[0x66f518] /lib64/libpthread.so.0[0x3030a0f710] /lib64/libc.so.6(gsignal+0x35)[0x3030632925] /lib64/libc.so.6(abort+0x175)[0x3030634105] /usr/local/mysql/bin/mysqld[0x9d8308] /usr/local/mysql/bin/mysqld[0x9d9936] /usr/local/mysql/bin/mysqld[0x9c82eb] /usr/local/mysql/bin/mysqld[0x9cc0b8] /lib64/libpthread.so.0[0x3030a079d1] /lib64/libc.so.6(clone+0x6d)[0x30306e8b6d] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 161213 16:07:40 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysqld.pid ended
centos6.5,跑了一个tomcat,8080端口的,一段时候后第一次访问很慢
公司在电信机房托管了一台服务器,装的是centos6.5的系统,最小化安装.上面跑了一个mysql5.6的数据库,一个8080端口的tomcat8,自己安装的jdk1.8.0_121的JDK,还要一个放SSH撞库的DenyHosts软件.现在有一个很棘手的问题.我现在tomcat上跑了一个项目,项目还没正式上线,一般除了我自己上去测试是没有人访问的.问题就出在这里,只要是一段时间没有访问,过一段时间后的第一次访问就会变得很慢(期间tomcat没有认为的重启或者其他操作,就是挂着一会不动,时间大概是半个小时左右),非常非常慢,只要第一次请求完成后,第二次开始速度又会正常了,然后如果又一段时间没人去访问的话,就又会出现这种问题,非常奇怪,求各位前辈帮一下忙
Mysql5.7.19交叉编译用于移植ARM时编译出现问题,求助
ometry/util/math.hpp:28, from /root/work/mysql-arm/sql/gis_bg_traits.h:38, from /root/work/mysql-arm/sql/item_geofunc_internal.h:35, from /root/work/mysql-arm/sql/geometry_rtree.cc:16: /usr/bin/locale:16:279: error: expected declaration before ‘}’ token make[2]: *** [sql/CMakeFiles/sql.dir/geometry_rtree.cc.o] Error 1 make[1]: *** [sql/CMakeFiles/sql.dir/all] Error 2 make: *** [all] Error 2 源码是mysql-boost-5.7.19.tar.gz 位将源码解压复制成两份,mysql-64/ 、 mysql-arm。一份用于CentOs64位上gcc编译,一份用于交叉编译。编译到45%左右死活过不去。求解 贴上错误log [ 45%] Building CXX object sql/CMakeFiles/sql.dir/geometry_rtree.cc.o In file included from /usr/bin/boost/lexical_cast/detail/converter_lexical_streams.hpp:43:0, from /usr/bin/boost/lexical_cast/detail/converter_lexical.hpp:54, from /usr/bin/boost/lexical_cast/try_lexical_convert.hpp:35, from /usr/bin/boost/lexical_cast.hpp:32, from /usr/bin/boost/math/constants/constants.hpp:18, from /root/work/mysql-arm/include/boost_1_59_0/patches/boost/geometry/util/math.hpp:28, from /root/work/mysql-arm/sql/gis_bg_traits.h:38, from /root/work/mysql-arm/sql/item_geofunc_internal.h:35, from /root/work/mysql-arm/sql/geometry_rtree.cc:16: /usr/bin/locale:1:1: error: stray â<80><98>\177â<80><99> in program ^?ELF^B^A^Aso.2^BX W H<8b>|$^Hè<93>úÿÿL<89>ÿè[^F^C¾ÿÿÿÿé^FÿÿÿH<89>ëéîþÿÿf<90>f.^O^_<84>tD<84>Àt@Áà^L%^O<84>ÿ^O<84>ÐÆ^AH<83>Á^A<8b>^U _ ëÀH<85>Û^O<84>ÎýÿÿI<89>Åé^Cþÿÿ1Òé.ÿÿÿ<8b>^U<81>^ H<8b><85>PßÿÿL<8d><85><80>ßÿÿL<89>êL)úL<89>ù¿@[@I<8b>6H<8d><95><80>ßÿÿ¿ ^ /usr/bin/locale:1:1: error: stray â<80><98>\2â<80><99> in program ./usr/bin/locale:1:1: error: stray â<80><98>\2â<80><99> in program /usr/bin/locale:1:1: error: stray â<80><98>\1â<80><99> in program /usr/bin/locale:1:1: error: stray â<80><98>\1â<80><99> in program /usr/bin/locale:1:8: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:1: error: stray â<80><98>\2â<80><99> in program /usr/bin/locale:1:18: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:20: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:1: error: stray â<80><98>\1â<80><99> in program /usr/bin/locale:1:22: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:27: error: stray â<80><98>@â<80><99> in program /usr/bin/locale:1:28: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:33: error: stray â<80><98>@â<80><99> in program /usr/bin/locale:1:34: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:1: error: stray â<80><98>\330â<80><99> in program /usr/bin/locale:1:1: error: stray â<80><98>\217â<80><99> in program /usr/bin/locale:1:43: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:53: error: stray â<80><98>@â<80><99> in program /usr/bin/locale:1:54: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:56: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:59: error: stray â<80><98>@â<80><99> in program /usr/bin/locale:1:60: warning: null character(s) ignored [enabled by default] /usr/bin/locale:1:1: error: stray â<80><98>\35â<80><99> in program . . . . . . . from /usr/bin/boost/lexical_cast/try_lexical_convert.hpp:35, from /usr/bin/boost/lexical_cast.hpp:32, from /usr/bin/boost/math/constants/constants.hpp:18, from /root/work/mysql-arm/include/boost_1_59_0/patches/boost/geometry/util/math.hpp:28, from /root/work/mysql-arm/sql/gis_bg_traits.h:38, from /root/work/mysql-arm/sql/item_geofunc_internal.h:35, from /root/work/mysql-arm/sql/geometry_rtree.cc:16: /usr/bin/locale:5:721: error: ‘libc’ does not name a type In file included from /usr/bin/boost/lexical_cast/detail/converter_lexical_streams.hpp:43:0, from /usr/bin/boost/lexical_cast/detail/converter_lexical.hpp:54, from /usr/bin/boost/lexical_cast/try_lexical_convert.hpp:35, from /usr/bin/boost/lexical_cast.hpp:32, from /usr/bin/boost/math/constants/constants.hpp:18, from /root/work/mysql-arm/include/boost_1_59_0/patches/boost/geometry/util/math.hpp:28, from /root/work/mysql-arm/sql/gis_bg_traits.h:38, from /root/work/mysql-arm/sql/item_geofunc_internal.h:35, from /root/work/mysql-arm/sql/geometry_rtree.cc:16: /usr/bin/locale:12:234: error: expected unqualified-id before numeric constant In file included from /usr/bin/boost/lexical_cast/detail/converter_lexical_streams.hpp:43:0, from /usr/bin/boost/lexical_cast/detail/converter_lexical.hpp:54, from /usr/bin/boost/lexical_cast/try_lexical_convert.hpp:35, from /usr/bin/boost/lexical_cast.hpp:32, from /usr/bin/boost/math/constants/constants.hpp:18, from /root/work/mysql-arm/include/boost_1_59_0/patches/boost/geometry/util/math.hpp:28, from /root/work/mysql-arm/sql/gis_bg_traits.h:38, from /root/work/mysql-arm/sql/item_geofunc_internal.h:35, from /root/work/mysql-arm/sql/geometry_rtree.cc:16: /usr/bin/locale:16:279: error: expected declaration before ‘}’ token make[2]: *** [sql/CMakeFiles/sql.dir/geometry_rtree.cc.o] Error 1 make[1]: *** [sql/CMakeFiles/sql.dir/all] Error 2 make: *** [all] Error 2
dockerfile构建MySQL+Java+springboot项目容器???
各位大佬,救救孩子吧,现在让把MySQL+Java+springboot项目构建成一个镜像,我也不晓得这样写对不对,更不晓得怎么写下去,哪位大佬能够指点哈小弟我,跪求!!!,小弟我要哭了,QQ也行,1048188066(微信同) ``` FROM centos MAINTAINER evan<evan@163.com> # add java8 ADD jdk-8u11-linux-x64.tar.gz /dockerr/tom/ # add manager ADD usermanagement-0.0.1-SNAPSHOT.jar /dockerr/tom/ # install mysql RUN yum -y install vim CMD echo "vim-------Successs!" RUN yum -y install wget CMD echo "wget------Success!" RUN wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm CMD echo "mysql------Success!" # login ENV MYPATH /usr WORKDIR $MYPATH # JAVA ENV JAVA_HOME /usr/local/jdk1.8.0_11 ENV CLASSPATH $JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar CMD echo "java环境“ # port EXPOSE 8081:8080 3307:3306 ENTRYPOINT ["java","-jar","usermanagement-0.0.1-SNAPSHOT.jar"] ~ ```
Mantis提交问题时描述和摘要部分中文乱码怎么办?
![图片说明](https://img-ask.csdn.net/upload/201910/24/1571906618_494825.png) 我想请问有人知道这部分(只有摘要和内容,如果第一次添加评论也会乱码)中文乱码怎么解决吗? 我的Mantis版本为2.22.0 php版本7.3.5 其他的地方中文都不会乱码,而且也修改了mysql数据库的默认编码问utf8 最关键是只有在提交问题的时候才会乱码,如果点击问题重新编辑保存就不会, 去查看数据库也是前者是乱码的,后者是正常的。 所以我认为应不是数据库配置问题,是mantis配置出错了 在config_default_inc.php 和config_inc.php里面都改了语言设置为chinese_simplified 我的mantis是在Centos6.5的服务器上跑的 试了一下1.3.1版本和php5.4的mantis就不会出现这种问题,但界面太粗糙了,所以还是选择去解决这个版本的
linux下使用sqoop连接windows的MySQL数据库报错
刚入门学习hadoop,然后在sqoop数据迁移这里遇到了问题,linux下使用sqoop连接不上windows系统的MySQL数据库,按照网上的许多方法都没解决。 linux系统是centos6.4,然后hadoop2.4.1,sqoop1.4.7,windows下是mysql5.7 下面是报错信息: [root@itcast01 bin]# ./sqoop list-tables --connect jdbc:mysql://192.168.147.100:3306/sqoopex1 --username root -password 1234 18/07/12 16:17:28 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7 18/07/12 16:17:28 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 18/07/12 16:17:28 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset. 18/07/12 16:18:31 ERROR manager.CatalogQueryManager: Failed to list tables com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 1,531,383,511,816 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59) at org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:102) at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at org.apache.sqoop.Sqoop.main(Sqoop.java:252) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 1,531,383,511,809 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137) ... 21 more Caused by: java.net.ConnectException: 连接超时 at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at java.net.Socket.connect(Socket.java:538) at java.net.Socket.<init>(Socket.java:434) at java.net.Socket.<init>(Socket.java:244) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290) ... 22 more zookeeper和hadoop服务都开启了的,防火墙也关闭了,去度娘有人说修改my.ini文件,说在[mysqld] 那里加一行: wait_timeout=86400 。 但是我修改后还是报同样的错误。mysql权限也赋予了的。数据库连接驱动使用mysql-connector-5.1.8.jar。 ![图片说明](https://img-ask.csdn.net/upload/201807/12/1531385340_467365.png) ![图片说明](https://img-ask.csdn.net/upload/201807/12/1531384769_440982.png) 连接的ip地址192.168.147.100是windows的VMnet1的ip地址,能ping通。然后就是连接不上数据库。使用Navicat连接也能连得上。 ![图片说明](https://img-ask.csdn.net/upload/201807/12/1531384494_888105.png) ![图片说明](https://img-ask.csdn.net/upload/201807/12/1531384583_92826.png) 有没有大牛知道我问题出在哪里?感激不尽!
centos7上用rpmbuild建立rpm安装包问题(急)
centos7.1 php-5.6.25 $ ls rpmbuild/ BUILD BUILDROOT RPMS SOURCES SPECS SRPMS $cat rpmbuild/SPECS/php.spec Name: php Version: 5.6.25 Release: 1%{?dist} Summary: compiled from 5.6.25 by Kevin Group: System Environment/Daemons License: GPL URL: https://secure.php.net Source0: php-5.6.25.tar.gz BuildRoot: %(mktemp -ud %{_tmppath}/%{name}-%{version}-%{release}-XXXXXX) BuildRequires: gcc, gcc-c++, openssl-devel Requires: wireshark-gnome %description php server. Compiled from 5.6.25 by Kevin %prep %setup -q %build ./configure '--with-libdir=lib64' '--prefix=/usr/local/php5.6' '--with-fpm-systemd' '--enable-fpm' '--enable-mbstring' '--with-mysql' '--with-mysqli' '--with-pdo-mysql' '--with-gd' '--enable-gd-native-ttf' '--with-freetype-dir' '--with-curl' '--with-openssl' '--with-mcrypt' '--enable-zip' '--enable-intl' make %{?_smp_mflags} %install rm -rf %{buildroot} make install DESTDIR=%{buildroot} %clean rm -rf %{buildroot} %files %defattr(-,root,root,-) %defattr(-,root,root,-) /usr/local/php5.6/bin/* /usr/local/php5.6/sbin/* /usr/local/php5.6/include/* /usr/local/php5.6/php/php/fpm/* /usr/local/php5.6/php/man/man1/* /usr/local/php5.6/php/man/man8/* /usr/local/php5.6/lib/php/* /usr/local/php5.6/lib/php/extensions/* /usr/local/php5.6/lib/php/extensions/no-debug-non-zts-20131226/* /usr/local/php5.6/lib/php/build/* /usr/local/php5.6/lib/php/build/shtool/* /usr/local/php5.6/lib/php/.registry/* /usr/local/php5.6/lib/php/.channels/* /usr/local/php5.6/lib/php/Archive/* /usr/local/php5.6/lib/php/doc/* /usr/local/php5.6/lib/php/doc/Archive_Tar/* /usr/local/php5.6/lib/php/doc/Archive_Tar/docs/* /usr/local/php5.6/lib/php/doc/Structures_Graph/* /usr/local/php5.6/lib/php/doc/Structures_Graph/docs/* /usr/local/php5.6/lib/php/doc/Structures_Graph/docs/tutorials/* /usr/local/php5.6/lib/php/doc/Structures_Graph/docs/tutorials/Structures_Graph/* /usr/local/php5.6/lib/php/doc/Structures_Graph/LICENSE/* /usr/local/php5.6/lib/php/doc/XML_Util/* /usr/local/php5.6/lib/php/doc/XML_Util/examples/* /usr/local/php5.6/lib/php/doc/PEAR/* /usr/local/php5.6/lib/php/doc/PEAR/LICENSE/* /usr/local/php5.6/lib/php/doc/PEAR/INSTALL/* /usr/local/php5.6/lib/php/Console/* /usr/local/php5.6/lib/php/test/* /usr/local/php5.6/lib/php/test/Console_Getopt/* /usr/local/php5.6/lib/php/test/Console_Getopt/tests/* /usr/local/php5.6/lib/php/test/Structures_Graph/* /usr/local/php5.6/lib/php/test/Structures_Graph/tests/* /usr/local/php5.6/lib/php/test/XML_Util/* /usr/local/php5.6/lib/php/test/XML_Util/tests/* /usr/local/php5.6/lib/php/Structures/* /usr/local/php5.6/lib/php/Structures/Graph/* /usr/local/php5.6/lib/php/Structures/Graph/Manipulator/* /usr/local/php5.6/lib/php/XML/* /usr/local/php5.6/lib/php/OS/* /usr/local/php5.6/lib/php/PEAR/* /usr/local/php5.6/lib/php/PEAR/ChannelFile/* /usr/local/php5.6/lib/php/PEAR/Command/* /usr/local/php5.6/lib/php/PEAR/Downloader/* /usr/local/php5.6/lib/php/PEAR/Frontend/* /usr/local/php5.6/lib/php/PEAR/Installer/* /usr/local/php5.6/lib/php/PEAR/Installer/Role/* /usr/local/php5.6/lib/php/PEAR/PackageFile/* /usr/local/php5.6/lib/php/PEAR/PackageFile/Generator/* /usr/local/php5.6/lib/php/PEAR/PackageFile/Parser/* /usr/local/php5.6/lib/php/PEAR/PackageFile/v2/* /usr/local/php5.6/lib/php/PEAR/REST/* /usr/local/php5.6/lib/php/PEAR/Task/* /usr/local/php5.6/lib/php/PEAR/Task/Postinstallscript/* /usr/local/php5.6/lib/php/PEAR/Task/Replace/* /usr/local/php5.6/lib/php/PEAR/Task/Unixeol/* /usr/local/php5.6/lib/php/PEAR/Task/Windowseol/* /usr/local/php5.6/lib/php/PEAR/Validator/* /usr/local/php5.6/lib/php/data/* /usr/local/php5.6/lib/php/data/PEAR/* %config /usr/local/php5.6/etc/* /usr/local/php5.6/var/run/* /usr/local/php5.6/lib/* %dir /usr/local/php5.6/var/log/ %post cp /usr/local/php5.6/etc/php-fpm.conf.default /usr/local/php5.6/etc/php-fpm.conf ln -s /usr/local/php5.6/bin/php /usr/bin/php %changelog * Tue Aug 30 2016 Kevin<kevin_liao@163.com> 5.6.25 - first rpm from php-5.6.25 然后用一个user用户为centos,没在root下执行 $ rpmbuild -ba rpmbuild/SPECS/php.spec 最后报错 Build complete. Don't forget to run 'make test'. + exit 0 Executing(%install): /bin/sh -e /var/tmp/rpm-tmp.QjJHDq + umask 022 + cd /home/centos/rpmbuild/BUILD + '[' /home/centos/rpmbuild/BUILDROOT/php-5.6.25-1.el7.centos.x86_64 '!=' / ']' + rm -rf /home/centos/rpmbuild/BUILDROOT/php-5.6.25-1.el7.centos.x86_64 ++ dirname /home/centos/rpmbuild/BUILDROOT/php-5.6.25-1.el7.centos.x86_64 + mkdir -p /home/centos/rpmbuild/BUILDROOT + mkdir /home/centos/rpmbuild/BUILDROOT/php-5.6.25-1.el7.centos.x86_64 + cd php-5.6.25 + rm -rf /home/centos/rpmbuild/BUILDROOT/php-5.6.25-1.el7.centos.x86_64 + make install DESTDIR=/home/centos/rpmbuild/BUILDROOT/php-5.6.25-1.el7.centos.x86_64 Installing shared extensions: /usr/local/php5.6/lib/php/extensions/no-debug-non-zts-20131226/ Installing PHP CLI binary: /usr/local/php5.6/bin/ Installing PHP CLI man page: /usr/local/php5.6/php/man/man1/ Installing PHP FPM binary: /usr/local/php5.6/sbin/ Installing PHP FPM config: /usr/local/php5.6/etc/ Installing PHP FPM man page: /usr/local/php5.6/php/man/man8/ Installing PHP FPM status page: /usr/local/php5.6/php/php/fpm/ Installing PHP CGI binary: /usr/local/php5.6/bin/ Installing PHP CGI man page: /usr/local/php5.6/php/man/man1/ Installing build environment: /usr/local/php5.6/lib/php/build/ Installing header files: /usr/local/php5.6/include/php/ Installing helper programs: /usr/local/php5.6/bin/ program: phpize program: php-config Installing man pages: /usr/local/php5.6/php/man/man1/ page: phpize.1 page: php-config.1 Installing PEAR environment: /usr/local/php5.6/lib/php/ [PEAR] Archive_Tar - already installed: 1.4.0 [PEAR] Console_Getopt - already installed: 1.4.1 [PEAR] Structures_Graph- already installed: 1.1.1 [PEAR] XML_Util - already installed: 1.3.0 [PEAR] PEAR - already installed: 1.10.1 Wrote PEAR system config file at: /usr/local/php5.6/etc/pear.conf You may want to add: /usr/local/php5.6/lib/php to your php.ini include_path /home/centos/rpmbuild/BUILD/php-5.6.25/build/shtool install -c ext/phar/phar.phar /usr/local/php5.6/bin ln -s -f phar.phar /usr/local/php5.6/bin/phar Installing PDO headers: /usr/local/php5.6/include/php/ext/pdo/ + /usr/lib/rpm/find-debuginfo.sh --strict-build-id -m --run-dwz --dwz-low-mem-die-limit 10000000 --dwz-max-die-limit 110000000 /home/centos/rpmbuild/BUILD/php-5.6.25 find: '/home/centos/rpmbuild/BUILDROOT/php-5.6.25-1.el7.centos.x86_64': No such file or directory error: Bad exit status from /var/tmp/rpm-tmp.QjJHDq (%install) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.QjJHDq (%install)
openssl和mysql冲突 ERR_remove_thread_state
openssl版本:openssl-1.1.0k mysql版本:mysql-5.7.27 静态库,编译报如下错误: /thirdparty/mysql/lib/libmysqlclient.a(ssl.cpp.o): In function `ERR_remove_thread_state': /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/extra/yassl/src/ssl.cpp:1619: multiple definition of `ERR_remove_thread_state' /home/lics/code/transfer/thirdparty/openssl/lib/libcrypto.a(err.o):err.c:(.text+0xb60): first defined here collect2: error: ld returned 1 exit status make[1]: [build] Error 1 (ignored) 请问有谁遇到过吗?
hadoop hive 初始化报错
环境:centos7 hadoop3.1.2 hive2.3.0 [root@hadoop metastore]# schematool -initSchema -dbType mysql Exception in thread "main" java.lang.ClassNotFoundException: org.apache.hive.beeline.HiveSchemaTool at java.net.URLClassLoader.findClass(URLClassLoader.java:382) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at org.apache.hadoop.util.RunJar.run(RunJar.java:311) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) [root@hadoop metastore]# hive which: no hbase in (/root/mysql/apache-hive-2.3.0-bin/bin:/root/train/hadoop-3.1.2/sbin:/root/train/hadoop-3.1.2/bin:/root/train/jdk1.8.0_211/bin:/root/train/hive/bin:/root/train/hadoop-3.1.2/sbin:/root/train/hadoop-3.1.2/bin:/root/train/jdk1.8.0_211/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin) Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hadoop/hive/ql/CommandNeedRetryException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at org.apache.hadoop.util.RunJar.run(RunJar.java:311) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.ql.CommandNeedRetryException at java.net.URLClassLoader.findClass(URLClassLoader.java:382) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 4 more Navicat Premium 都能成功登入mysql建立的hive数据库 hive 配置文件都没问题 mysql连接器也放入了lib
急求帮助,centOS下tomcat的java进程无故终止
求助! 目前环境centOS6.6+Nginx1.8.0+tomcat7.0.42+mysql5.6.24 另外还装了安全狗和clamd杀毒软件。 碰到的问题是tomcat的java进程隔几天会无故终止。tomcat的catalina日志里没有 tomcat停止的日志。操作系统日志/var/adm/messages里也没有tomcat的java进程停止的日志。 tomcat的home目录下也没有找到java虚拟机崩溃的日志。 打开进程日志,看到tomcat的java进程收到终止信号停止,java进程有X标志。 cat root __ 0.00 secs Thu Jul 30 09:48 sh root __ 0.00 secs Thu Jul 30 09:48 egrep root __ 0.00 secs Thu Jul 30 09:48 cat root __ 0.00 secs Thu Jul 30 09:48 sh root __ 0.00 secs Thu Jul 30 09:48 awk root __ 0.00 secs Thu Jul 30 09:48 head root __ 0.00 secs Thu Jul 30 09:48 cat root __ 0.00 secs Thu Jul 30 09:48 ## java S X root __ 2728.72 secs Wed Jul 29 10:38 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 du root __ 0.00 secs Thu Jul 30 09:48 sh root __ 0.00 secs Thu Jul 30 09:48 awk root __ 0.00 secs Thu Jul 30 09:48 head root __ 0.00 secs Thu Jul 30 09:48 cat root __ 0.00 secs Thu Jul 30 09:48 sh root __ 0.00 secs Thu Jul 30 09:48 awk root __ 0.00 secs Thu Jul 30 09:48 head root __ 0.00 secs Thu Jul 30 09:48 cat root __ 0.00 secs Thu Jul 30 09:48 sh root __ 0.00 secs Thu Jul 30 09:48 grep root __ 0.00 secs Thu Jul 30 09:48 grep root __ 0.00 secs Thu Jul 30 09:48 ps S root __ 0.02 secs Thu Jul 30 09:48 但是在这个时间段并没有kill发送信号,那这个信号是由哪个进程发起的,有没有办法查看。 我最初怀疑过操作系统内存耗尽,tomcat进程被OOM_killer杀死了,但是操作系统日志/var/adm/messages里会有out of memory杀进程的日志,我在虚拟机上测试,/var/adm/messages里是有相应日志。下面是free -m的输出: total used free shared buffers cached Mem: 32085 26304 5780 1 258 21274 -/+ buffers/cache: 4771 27313 Swap: 16111 50 16061 也怀疑过ssh连接异常关闭导致tomcat进程被杀,但是我在虚拟机上并没有模拟重现故障。 因为centOS ssh登录采用公钥秘钥的方式,并且在故障时间段进程日志里并没有找到kill命令,暂时排除人为强杀进程的情况。 不知道现在的情况我能通过什么方式来定位故障原因。求指点。 另外在tomcat的localhost日志里,有类似如下的异常日志: Jul 30, 2015 12:14:27 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [jsp] in context with path [] threw exception [javax.servlet.ServletException: javax.servlet.jsp.JspException: Problem accessing the absolute URL "http://www.d1wudal.com:80/getHomeItem.action?navBz=1". java.io.FileNotFoundException: http://www.d1wudal.com:80/getHomeItem.action?navBz=1] with root cause java.io.FileNotFoundException: http://www.d1wudal.com:80/getHomeItem.action?navBz=1 at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1625) at org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireReader(ImportSupport.java:331) at org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:241) at org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:161) at org.apache.jsp.index_jsp._jspx_meth_c_005fimport_005f0(index_jsp.java:177) at org.apache.jsp.index_jsp._jspService(index_jsp.java:109) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:96) at com.st.core.filter.Struts2Filter.doFilter(Struts2Filter.java:24) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) 我在虚拟机上模拟重现了这个异常,是由客户端的异常请求造成的。我也怀疑过遭到了类似DDOS的攻击,但是查看了系统的连接数量应该不足以让tomcat进程终止。 麻烦帮忙分析下!
MySql Clustor 管理节点连不上 sql节点
实在没辙了,倒腾了很久,看了很多帖子都没有解决。 PS:国内程序员的习惯太不好,很多不结贴,而且就算自己解决了,也不说解决方案。诶。。。 背景:管理节点和数据节点已经成功启动,sql节点也运行了,sql节点的log没有错误日志,而且本机数据库能正常登陆 管理节点:Linux CentOS 6.2 IP:192.168.10.226 数据节点:Linux CentOS 6.2 IP:192.168.10.52 SQL节点1:Linux CentOS 6.2 IP:192.168.10.41 SQL节点2:Linux CentOS 6.2 IP:192.168.10.42 每台服务器的防火墙均已关闭。 管理节点配置: ``` datadir = /usr/local/mysql/ndbdata [ndbd default] NoOfReplicas = 1 DataMemory = 80M IndexMemory = 18M datadir = /usr/local/mysql/ndbdata [ndb_mgmd] NodeId = 1 HostName = 192.168.10.226 [ndbd] NodeId = 2 HostName = 192.168.10.52 [mysqld] NodeId = 3 HostName = 192.168.10.41 [mysqld] NodeId = 4 HostName = 192.168.10.42 ``` 数据节点的配置文件 ``` [root@test-socket2 bin]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ndbcluster ndb-connectstring = 192.168.10.226 [mysql_cluster] ndb-connectstring = 192.168.10.226 [root@test-socket2 bin]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ndbcluster ndb-connectstring = 192.168.10.226 [mysql_cluster] ndb-connectstring = 192.168.10.226 [root@test-socket2 bin]# vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql ndbcluster ndb-connectstring = 192.168.10.226 [mysql_cluster] ndb-connectstring = 192.168.10.226 ``` SQL 节点的配置文件: ``` [root@test-web1 data]# cat /etc/my.cnf [mysqld] #datadir=/var/lib/mysql socket=/tmp/mysql.sock user=mysql port=3306 basedir=/usr/local/mysql/ datadir=/usr/local/mysql/ndbdata # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ndbcluster ndb-connectstring = 192.168.10.226 [ndbd] connect-string=192.168.10.52 [ndbd_mgm] connect-string=192.168.10.226 [ndbd_mgmd] config-file=/etc/config.ini [mysql_cluster] ndb-connectstring = 192.168.10.226 ``` 管理节点链接状态: ``` ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 1 node(s) id=2 @192.168.10.52 (mysql-5.6.27 ndb-7.4.8, Nodegroup: 0, *) [ndb_mgmd(MGM)] 1 node(s) id=1 @192.168.10.226 (mysql-5.6.27 ndb-7.4.8) [mysqld(API)] 2 node(s) id=3 (not connected, accepting connect from 192.168.10.41) id=4 (not connected, accepting connect from 192.168.10.42) ```
centos虚拟机重启后,MySQL服务启动不了了,求解?
#MySQL版本5.1.73 贴出日志如下: 170808 23:02:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170808 23:02:19 InnoDB: Initializing buffer pool, size = 8.0M 170808 23:02:19 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 170808 23:02:19 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 170808 23:02:19 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 170808 23:02:19 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 170808 23:02:19 InnoDB: Started; log sequence number 0 0 170808 23:02:19 [Note] Event Scheduler: Loaded 0 events 170808 23:02:19 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 170809 5:21:42 [Note] /usr/libexec/mysqld: Normal shutdown 170809 5:21:42 [Note] Event Scheduler: Purging the queue. 0 events 170809 5:21:42 InnoDB: Starting shutdown... 170809 5:21:45 InnoDB: Shutdown completed; log sequence number 0 89508 170809 5:21:45 [Note] /usr/libexec/mysqld: Shutdown complete 170809 05:21:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170810 18:53:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170810 18:53:14 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. /usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file 170810 18:53:14 [ERROR] Aborting 170810 18:53:14 [Note] /usr/libexec/mysqld: Shutdown complete 170810 18:53:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170810 18:54:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170810 18:54:30 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. /usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file 170810 18:54:30 [ERROR] Aborting 170810 18:54:30 [Note] /usr/libexec/mysqld: Shutdown complete 170810 18:54:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended ``` ```
Java学习的正确打开方式
在博主认为,对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结,前三者博主将淋漓尽致地挥毫于这篇博客文章中,至于总结在于个人,实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍,博客次之,这又是一个层次了,这里暂时不提后面再谈。博主将为各位入门java保驾护航,各位只管冲鸭!!!上天是公平的,只要不辜负时间,时间自然不会辜负你。 何谓学习?博主所理解的学习,它是一个过程,是一个不断累积、不断沉淀、不断总结、善于传达自己的个人见解以及乐于分享的过程。
程序员必须掌握的核心算法有哪些?
由于我之前一直强调数据结构以及算法学习的重要性,所以就有一些读者经常问我,数据结构与算法应该要学习到哪个程度呢?,说实话,这个问题我不知道要怎么回答你,主要取决于你想学习到哪些程度,不过针对这个问题,我稍微总结一下我学过的算法知识点,以及我觉得值得学习的算法。这些算法与数据结构的学习大多数是零散的,并没有一本把他们全部覆盖的书籍。下面是我觉得值得学习的一些算法以及数据结构,当然,我也会整理一些看过...
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、电子书搜索 对于大部分程序员...
linux系列之常用运维命令整理笔录
本博客记录工作中需要的linux运维命令,大学时候开始接触linux,会一些基本操作,可是都没有整理起来,加上是做开发,不做运维,有些命令忘记了,所以现在整理成博客,当然vi,文件操作等就不介绍了,慢慢积累一些其它拓展的命令,博客不定时更新 free -m 其中:m表示兆,也可以用g,注意都要小写 Men:表示物理内存统计 total:表示物理内存总数(total=used+free) use...
比特币原理详解
一、什么是比特币 比特币是一种电子货币,是一种基于密码学的货币,在2008年11月1日由中本聪发表比特币白皮书,文中提出了一种去中心化的电子记账系统,我们平时的电子现金是银行来记账,因为银行的背后是国家信用。去中心化电子记账系统是参与者共同记账。比特币可以防止主权危机、信用风险。其好处不多做赘述,这一层面介绍的文章很多,本文主要从更深层的技术原理角度进行介绍。 二、问题引入 假设现有4个人...
程序员接私活怎样防止做完了不给钱?
首先跟大家说明一点,我们做 IT 类的外包开发,是非标品开发,所以很有可能在开发过程中会有这样那样的需求修改,而这种需求修改很容易造成扯皮,进而影响到费用支付,甚至出现做完了项目收不到钱的情况。 那么,怎么保证自己的薪酬安全呢? 我们在开工前,一定要做好一些证据方面的准备(也就是“讨薪”的理论依据),这其中最重要的就是需求文档和验收标准。一定要让需求方提供这两个文档资料作为开发的基础。之后开发...
网页实现一个简单的音乐播放器(大佬别看。(⊙﹏⊙))
今天闲着无事,就想写点东西。然后听了下歌,就打算写个播放器。 于是乎用h5 audio的加上js简单的播放器完工了。 演示地点演示 html代码如下` music 这个年纪 七月的风 音乐 ` 然后就是css`*{ margin: 0; padding: 0; text-decoration: none; list-...
Python十大装B语法
Python 是一种代表简单思想的语言,其语法相对简单,很容易上手。不过,如果就此小视 Python 语法的精妙和深邃,那就大错特错了。本文精心筛选了最能展现 Python 语法之精妙的十个知识点,并附上详细的实例代码。如能在实战中融会贯通、灵活使用,必将使代码更为精炼、高效,同时也会极大提升代码B格,使之看上去更老练,读起来更优雅。
数据库优化 - SQL优化
以实际SQL入手,带你一步一步走上SQL优化之路!
通俗易懂地给女朋友讲:线程池的内部原理
餐盘在灯光的照耀下格外晶莹洁白,女朋友拿起红酒杯轻轻地抿了一小口,对我说:“经常听你说线程池,到底线程池到底是个什么原理?”
经典算法(5)杨辉三角
杨辉三角 是经典算法,这篇博客对它的算法思想进行了讲解,并有完整的代码实现。
使用 Docker 部署 Spring Boot 项目
Docker 技术发展为微服务落地提供了更加便利的环境,使用 Docker 部署 Spring Boot 其实非常简单,这篇文章我们就来简单学习下。首先构建一个简单的 S...
英特尔不为人知的 B 面
从 PC 时代至今,众人只知在 CPU、GPU、XPU、制程、工艺等战场中,英特尔在与同行硬件芯片制造商们的竞争中杀出重围,且在不断的成长进化中,成为全球知名的半导体公司。殊不知,在「刚硬」的背后,英特尔「柔性」的软件早已经做到了全方位的支持与支撑,并持续发挥独特的生态价值,推动产业合作共赢。 而对于这一不知人知的 B 面,很多人将其称之为英特尔隐形的翅膀,虽低调,但是影响力却不容小觑。 那么,在...
面试官:你连RESTful都不知道我怎么敢要你?
干货,2019 RESTful最贱实践
刷了几千道算法题,这些我私藏的刷题网站都在这里了!
遥想当年,机缘巧合入了 ACM 的坑,周边巨擘林立,从此过上了"天天被虐似死狗"的生活… 然而我是谁,我可是死狗中的战斗鸡,智力不够那刷题来凑,开始了夜以继日哼哧哼哧刷题的日子,从此"读题与提交齐飞, AC 与 WA 一色 ",我惊喜的发现被题虐既刺激又有快感,那一刻我泪流满面。这么好的事儿作为一个正直的人绝不能自己独享,经过激烈的颅内斗争,我决定把我私藏的十几个 T 的,阿不,十几个刷题网...
白话阿里巴巴Java开发手册高级篇
不久前,阿里巴巴发布了《阿里巴巴Java开发手册》,总结了阿里巴巴内部实际项目开发过程中开发人员应该遵守的研发流程规范,这些流程规范在一定程度上能够保证最终的项目交付质量,通过在时间中总结模式,并推广给广大开发人员,来避免研发人员在实践中容易犯的错误,确保最终在大规模协作的项目中达成既定目标。 无独有偶,笔者去年在公司里负责升级和制定研发流程、设计模板、设计标准、代码标准等规范,并在实际工作中进行...
SQL-小白最佳入门sql查询一
不要偷偷的查询我的个人资料,即使你再喜欢我,也不要这样,真的不好;
redis分布式锁,面试官请随便问,我都会
文章有点长并且绕,先来个图片缓冲下! 前言 现在的业务场景越来越复杂,使用的架构也就越来越复杂,分布式、高并发已经是业务要求的常态。像腾讯系的不少服务,还有CDN优化、异地多备份等处理。 说到分布式,就必然涉及到分布式锁的概念,如何保证不同机器不同线程的分布式锁同步呢? 实现要点 互斥性,同一时刻,智能有一个客户端持有锁。 防止死锁发生,如果持有锁的客户端崩溃没有主动释放锁,也要保证锁可以正常释...
项目中的if else太多了,该怎么重构?
介绍 最近跟着公司的大佬开发了一款IM系统,类似QQ和微信哈,就是聊天软件。我们有一部分业务逻辑是这样的 if (msgType = "文本") { // dosomething } else if(msgType = "图片") { // doshomething } else if(msgType = "视频") { // doshomething } else { // doshom...
Nginx 原理和架构
Nginx 是一个免费的,开源的,高性能的 HTTP 服务器和反向代理,以及 IMAP / POP3 代理服务器。Nginx 以其高性能,稳定性,丰富的功能,简单的配置和低资源消耗而闻名。 Nginx 的整体架构 Nginx 里有一个 master 进程和多个 worker 进程。master 进程并不处理网络请求,主要负责调度工作进程:加载配置、启动工作进程及非停升级。worker 进程负责处...
“狗屁不通文章生成器”登顶GitHub热榜,分分钟写出万字形式主义大作
一、垃圾文字生成器介绍 最近在浏览GitHub的时候,发现了这样一个骨骼清奇的雷人项目,而且热度还特别高。 项目中文名:狗屁不通文章生成器 项目英文名:BullshitGenerator 根据作者的介绍,他是偶尔需要一些中文文字用于GUI开发时测试文本渲染,因此开发了这个废话生成器。但由于生成的废话实在是太过富于哲理,所以最近已经被小伙伴们给玩坏了。 他的文风可能是这样的: 你发现,...
程序员:我终于知道post和get的区别
是一个老生常谈的话题,然而随着不断的学习,对于以前的认识有很多误区,所以还是需要不断地总结的,学而时习之,不亦说乎
《程序人生》系列-这个程序员只用了20行代码就拿了冠军
你知道的越多,你不知道的越多 点赞再看,养成习惯GitHub上已经开源https://github.com/JavaFamily,有一线大厂面试点脑图,欢迎Star和完善 前言 这一期不算《吊打面试官》系列的,所有没前言我直接开始。 絮叨 本来应该是没有这期的,看过我上期的小伙伴应该是知道的嘛,双十一比较忙嘛,要值班又要去帮忙拍摄年会的视频素材,还得搞个程序员一天的Vlog,还要写BU...
加快推动区块链技术和产业创新发展,2019可信区块链峰会在京召开
11月8日,由中国信息通信研究院、中国通信标准化协会、中国互联网协会、可信区块链推进计划联合主办,科技行者协办的2019可信区块链峰会将在北京悠唐皇冠假日酒店开幕。   区块链技术被认为是继蒸汽机、电力、互联网之后,下一代颠覆性的核心技术。如果说蒸汽机释放了人类的生产力,电力解决了人类基本的生活需求,互联网彻底改变了信息传递的方式,区块链作为构造信任的技术有重要的价值。   1...
Java世界最常用的工具类库
Apache Commons Apache Commons有很多子项目 Google Guava 参考博客
程序员把地府后台管理系统做出来了,还有3.0版本!12月7号最新消息:已在开发中有github地址
第一幕:缘起 听说阎王爷要做个生死簿后台管理系统,我们派去了一个程序员…… 996程序员做的梦: 第一场:团队招募 为了应对地府管理危机,阎王打算找“人”开发一套地府后台管理系统,于是就在地府总经办群中发了项目需求。 话说还是中国电信的信号好,地府都是满格,哈哈!!! 经常会有外行朋友问:看某网站做的不错,功能也简单,你帮忙做一下? 而这次,面对这样的需求,这个程序员...
网易云6亿用户音乐推荐算法
网易云音乐是音乐爱好者的集聚地,云音乐推荐系统致力于通过 AI 算法的落地,实现用户千人千面的个性化推荐,为用户带来不一样的听歌体验。 本次分享重点介绍 AI 算法在音乐推荐中的应用实践,以及在算法落地过程中遇到的挑战和解决方案。 将从如下两个部分展开: AI算法在音乐推荐中的应用 音乐场景下的 AI 思考 从 2013 年 4 月正式上线至今,网易云音乐平台持续提供着:乐屏社区、UGC...
【技巧总结】位运算装逼指南
位算法的效率有多快我就不说,不信你可以去用 10 亿个数据模拟一下,今天给大家讲一讲位运算的一些经典例子。不过,最重要的不是看懂了这些例子就好,而是要在以后多去运用位运算这些技巧,当然,采用位运算,也是可以装逼的,不信,你往下看。我会从最简单的讲起,一道比一道难度递增,不过居然是讲技巧,那么也不会太难,相信你分分钟看懂。 判断奇偶数 判断一个数是基于还是偶数,相信很多人都做过,一般的做法的代码如下...
为什么要学数据结构?
一、前言 在可视化化程序设计的今天,借助于集成开发环境可以很快地生成程序,程序设计不再是计算机专业人员的专利。很多人认为,只要掌握几种开发工具就可以成为编程高手,其实,这是一种误解。要想成为一个专业的开发人员,至少需要以下三个条件: 1) 能够熟练地选择和设计各种数据结构和算法 2) 至少要能够熟练地掌握一门程序设计语言 3) 熟知所涉及的相关应用领域的知识 其中,后两个条件比较容易实现,而第一个...
Android 9.0 init 启动流程
阅读五分钟,每日十点,和您一起终身学习,这里是程序员Android本篇文章主要介绍Android开发中的部分知识点,通过阅读本篇文章,您将收获以下内容:一、启动流程概述一、 启动流程概述Android启动流程跟Linux启动类似,大致分为如下五个阶段。1.开机上电,加载固化的ROM。2.加载BootLoader,拉起Android OS。3.加载Uboot,初始外设,引导Kernel启动等。...
相关热词 c# 二进制截断字符串 c#实现窗体设计器 c#检测是否为微信 c# plc s1200 c#里氏转换原则 c# 主界面 c# do loop c#存为组套 模板 c# 停掉协程 c# rgb 读取图片
立即提问