-
T3.6 - If we are going to use HSRUN, read serial number before
2020-12-25 17:49:48<div><p>If we are runnig at over 120mhz and turn on HSRUN mode, we can not read in the USB serial number. <p>This is one attempt to see if we can read it in before we switch to HSRUN mode. <p>My quick... -
XRP transaction tag number one last digit missed
2020-12-06 15:00:22I put correct XRP address but in tag number I put wrong actually I missed last digit number of my tag number now unocoin not credit my XRP they are saying "Hello As you can see in the screenshots... -
We are already in the process of making n+ connections and the number of simultaneous builds has bee
2015-01-19 10:30:52simultaneous-build-throttle: ...This is the maximum number of connections we can be building at any one time. That is, the number of new connections that have been requested but aren’t yet available
simultaneous-build-throttle:
This is the maximum number of connections we can be building at any one time.
That is, the number of new connections that have been requested but aren’t yet available for use.
Because connections can be built using more than one thread (for instance, when they are built on demand)
and it takes a finite time between deciding to build the connection and it becoming available we need some
way of ensuring that a lot of threads don’t all decide to build a connection at once. (We could solve this in a
smarter way – and indeed we will one day) Default is 10.
是指在任一时刻,可以(同时)建立的最大连接数,也就是说,就是已经请求的、但还没可用的新连接数量。因为连接可以用多线程建立,
从决定要建立连接到连接 可用是需要一定时间的,所以我们需要一些方式来避免大量的线程想同时建立连接。
(我们本应该找一个更聪明的方式来解决这个问题,总有一天我们会找到的)默 认值是10
当我使用140个用户,进行压力测试时,发现偶尔,会有多于10个要求同时建立连接的请求,当请求数量超过限定的数值时,会出现连接失败的情况。
因此结论就是,当数据库并发连接可能会比较高的应用,这个值应该适当的设大一点。
如果并发请求很高,可能出现的bug为Caused by: java.sql.SQLException: We are already in the process of making 11 connections and the number of simultaneous builds has been throttled to 10
maximum-active-time:
If the housekeeper comes across a thread that has been active for longer than this then it will kill it. So make sure you set this to a number bigger than your slowest expected response! Default is 5 minutes.
如果一个线程活动时间超过这个数值,线程会被杀死。所以要确保这个数值设置得比最慢的响应时间长。默认是5分钟。守护进程会把连接池中多余的可用线程(未 用的、超过这个时间的)杀死,最终保留的连接数量就是minimum-connection-count规定的数量。守护进程会根据house- keeping-sleep-time参数设置的时间隔定时检查。maximum-connection-lifetime:
The maximum amount of time that a connection exists for before it is killed (milliseconds). Default is 4 hours.
指一个连接最大的存活时间(毫秒为单位),超过这个时间,连接会被杀死。默认值是4小时。overload-without-refusal-lifetime:
This helps us determine the pool status. If we have refused a connection within this threshold (milliseconds) then we are overloaded. Default is 60 seconds.
这个参数帮助我们确定连接池的状态,如果在这个时间阀值内(单位为毫秒)拒绝了一个连接,就认为是过载了。默认值是60。
alias:数据源的别名driver-url:url连接串,须确定用户名和密码
driver-class:驱动名
username:用户名(proxool没有使用,但是不能没有)
password:密码(proxool没有使用,但是不能没有)
maximum-new-connections:没有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受
test-before-use:
If you set this to true then each connection is tested (with whatever is defined in house-keeping-test-sql) before being served. If a connection fails then it is discarded and another one is picked. If all connections fail a new one is built. If that one fails then you get an SQLException saying so.
如果连接池在运行当中,出现网络或者数据库故障而无法连接到数据库,在恢复正常以后,由于连接是在连接池中持久保存的,会出现连接仍然不可用的情况,这时连接池里的连接实际上都是坏连接,怎么让连接池可以自动重连清除这些坏连接呢? 只要配置了test-before-use 参数,即每次取出连接都检查连接是否可用,就可以做到让连接池实现在故障恢复后自动重连接
需要注意一点,对于Mysql数据库还必须在连接参数里加上autoReconnect=true 参数,否则即使打开了test-before-use 参数,仍然不能重连接!
fatal-sql-exception:
它是一个逗号分割的信息片段.当一个SQL异常发生时,他的异常信息将与这个信息片段进行比较.如果在片段中存在,那么这个异常将被认为是个致命错 误(Fatal SQL Exception ).这种情况下,数据库连接将要被放弃.无论发生什么,这个异常将会被重掷以提供给消费者.用户最好自己配置一个不同的异常来抛出.
fatal-sql-exception-wrapper-class:正如上面所说,你最好配置一个不同的异常来重掷.利用这个属性,用户可以包装SQLException,使他变成另外一个异常.这个异常或者继承 SQLException或者继承字RuntimeException.proxool自带了2个实 现:’org.logicalcobwebs.proxool.FatalSQLException’ 和’org.logicalcobwebs.proxool.FatalRuntimeException’ .后者更合适.
house-keeping-sleep-time:proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁 默认30秒)
house keeper 保留线程处于睡眠状态的最长时间,house keeper 的职责就是检查各个连接的状态,并判断是否需要销毁或者创建.
house-keeping-test-sql:如果发现了空闲的数据库连接.house keeper 将会用这个语句来测试.这个语句最好非常快的被执行.如果没有定义,测试过程将会被忽略。
一般mysql可用select SYSDATE ,Oracle可用 select sysdate from dual 或者 select 1 from dual
injectable-connection-interface: 允许proxool实现被代理的connection对象的方法.
injectable-statement-interface: 允许proxool实现被代理的Statement 对象方法.
injectable-prepared-statement-interface: 允许proxool实现被代理的PreparedStatement 对象方法.
injectable-callable-statement-interface: 允许proxool实现被代理的CallableStatement 对象方法.
jmx: 略
jmx-agent-id: 略
jndi-name: 数据源的名称
maximum-active-time: 如果housekeeper 检测到某个线程的活动时间大于这个数值.它将会杀掉这个线程.所以确认一下你的服务器的带宽.然后定一个合适的值.默认是5分钟.
maximum-connection-count:The maximum number of connections to the database. Default is 15.
最大的数据库连接数.默认是15
minimum-connection-count: 最小的数据库连接数,默认是5
prototype-count:If there are fewer than this number of connections available then we will build some more (assuming the maximum-connection-count is not exceeded). For example. Of we have 3 active connections and 2 available, but our prototype-count is 4 then it will attempt to build another 2. This differs from minimum-connection-count because it takes into account the number of active connections. minimum-connection-count is absolute and doesn’t care how many are in use. prototype-count is the number of spare connections it strives to keep over and above the ones that are currently active. Default is 0.
连接池中可用的连接数量.如果当前的连接池中的连接少于这个数值.新的连接将被建立(假设没有超过最大可用数).例如.我们有3个活动连接2个可用 连接,而我们的prototype-count是4,那么数据库连接池将试图建立另外2个连接.这和 minimum-connection-count不同. minimum-connection-count把活动的连接也计算在内.prototype-count 是spare connections 的数量.
recently-started-threshold: 略statistics: 连接池使用状况统计。 参数“10s,1m,1d”
statistics-log-level: 日志统计跟踪类型。 参数“ERROR”或 “INFO”
test-after-use: 略
trace: 如果为true,那么每个被执行的SQL语句将会在执行期被log记录(DEBUG LEVEL).你也可以注册一个ConnectionListener (参看ProxoolFacade)得到这些信息.
verbose: 详细信息设置。 参数 bool 值
-
How can we move to the given page number?
2020-12-02 04:32:20<div><p>Suppose we are on the page 2 and we click one row and go on inner detail page. But when we click browser back it take us to page 1. <p>So do we have any option we can pass the page number and... -
Multiple oneof fields are being set
2020-12-09 08:00:24<p>This gets messy if there are multiple oneofs in a message (# lines of code is exponential in the number oneofs), but we can clean this up by letting GAX do the work in a utility function that ... -
Expose metric for number of publishers when metrics are aggregated
2020-12-09 08:52:13<p>This is the metrics that we are returning when aggregating - we cannot count all publishers, the total count is 3, one per node: <p><img alt="image" src=... -
deck number convention creates issues when we add new decks to ship
2020-12-08 19:55:44lets say we add a new deck to ship with wagic, deck106, and the player had already created an ai deck that took the slot for 106...heres where the issue araises, they now have a conflict, one could ... -
Can We Build This One?
2017-10-24 07:53:54The first line of input contains three integers N, M and Q (1 ≤ 1,000, N − 1 ≤ M ≤ 100,000, 0 ≤ 100,000), where N is the number of villages, M is the number of paths, and Q is the number of ... -
NeuronConnectFormatted.xlsx, which one we will use & why...
2020-12-09 12:14:22we use but seem to have conflicting information and there are possibly multiple different versions. <p>Somewhere there needs to be a record of where they come from, which one will be used and how ... -
Stop one time entry if two are running
2020-12-01 14:44:59<div><p>This PR checks if there are multiple running time entries right after the user starts the app (when he/she is already logged in) and uses <code>BatchUpdate</code> to make sure we have at most ... -
Flag to keep scheduler busy when there are many small one-time tasks?
2020-12-02 09:36:16Increasing the number of threads is not a solution for us as this leads to other issues (max number of simultaneous connections we can make to third party providers). <p>What are your thoughts on this... -
Question: Why are we using stored procedures?
2020-12-01 15:46:47<div><p>Why do we use stored procedures here when both the <a href="https://github.com/mozilla/fxa-profile-server/blob/a1703a4eecacb09e96de8950f44c020b50963f95/lib/db/mysql/index.js#L114">profile</a> ... -
FeatureFloodCount results are incorrect and change with number of MPI tasks
2020-12-31 01:12:58this is the one I was asking about this afternoon. <h3>Rationale for the enhancement or information for reproducing the error <p>I created an example file and included a copy in <code>modules/phase_... -
Child processes are not reaped - growing number of zombie processes
2021-01-09 21:01:32<p>Researching the cause, we have found, that there are thousands of zombie processes and the number was steadily growing. <p>The call in our Dockerfile looked like: <pre><code> ENTRYPOINT ["... -
Don't allow new package versions to be pushed if there are X number not in a final state
2020-12-01 19:45:31<p>I feel we should consider limiting pushes of new package versions if there are x number not in an <em>final</em> state (ie. Approved or Rejected).</p><p>该提问来源于开源项目:chocolatey/... -
Group View member list should at least show one available phone number or email address
2020-12-02 01:11:33t there at least be a phone number listed if one is available? Or both, if possible? <p>Same holds for email address: some members of groups - like our 'secretary', who is Non-attender(staff) ... -
sprintf complains unless the correct number of arguments are passed
2020-12-27 21:45:49This was fixed a little while ago, in one case it was replaced but in another it was omitted. Since <code>sprintf</code> throws a warning when the format uses numbered arguments but insufficient ... -
Drivers (s3) get stuck when a large number of failures are seen
2020-12-27 03:07:42<div><p>In a highly degenerate case where hardware is overwhelmed and failing many writes, we are seeing one or more drivers getting stuck past the time based termination point for a test. These ... -
Limit the number child pages that are permitted for the campaigns route
2020-12-01 23:41:48<p>Note that we may need to move the one blog post that lives under <code>campaigns</code> right now, in order for this PR to land. <p>Alternatively I can put the BlogPage back as permitted type, but ... -
Can we specify the max parallel number of tasks for a worker?
2020-11-22 15:44:34<div><p>Currently, the miner distribute tasks automatically, however, we don't want lotus-seal-worker to parallel process too many sectors. for example, Miner distributed 4 sectors to one of my ... -
Should we consider automatically flagging posts which hit more than one filter?
2021-01-02 07:47:30(I assume the answer would be yes, since they are already considering integration with us at our current accuracy, and with a little tweaking we can make auto-flags based on the number of filters ... -
How can we minimize the number of redis connections used by bee-queue?
2020-12-01 22:21:37<div><p>I am currently using redis ... How can we keep the number of connections low? Is there any settings required for a connection pool?</p><p>该提问来源于开源项目:bee-queue/bee-queue</p></div> -
fixes #1723 Restricted number of opened date dialog's to one
2020-12-27 08:01:29<h4>Do we need any specific form for testing your changes? If so, please attach one. <p>No, just the all widgets form will do.</p><p>该提问来源于开源项目:getodk/collect</p></div> -
005 Number of ways to remove one digit from a string so it lexicographically smaller than other se
2020-09-28 05:03:23Given two string, s and t. both consisting of lowercase letters and digits. now we want to make s lexicographically smaller than t. rules: remove only one ...Pay attention: digits are smaller than letterGiven two string, s and t.
both consisting of lowercase letters and digits.
now we want to make s lexicographically smaller than t.
rules: remove only one digit from s.
now return how many ways can we do this.Pay attention: digits are smaller than letter in lexicographically way.
of course we can do this in brute force way.
public int removeOneDigit(String s, String t) { int sLen = s.length(); int tLen = t.length(); int count = 0; check(s, sLen, count, t); check(t, tLen, count, s); return count; // for (int i = 0; i < sLen; i++) { // if (Character.isDigit(s.charAt(i))) { // String temp = s.substring(0, i) + s.substring(i+1); // if (temp.compareTo(t) < 0) { // count++; // } // } // } // //and then we try it on t // for (int i = 0; i < tLen; i++) { // if (Character.isDigit(t.charAt(i))) { // String temp = t.substring(0, i) + t.substring(i+1); // if (temp.compareTo(s) < 0) { // count++; // } // } // } // return count; } private void check(String s, int len, int count, String t) { for (int i = 0; i < len; i++) { if (Character.isDigit(s.charAt(i))) { String temp = s.substring(0, i) + s.substring(i+1); if (temp.compareTo(t) < 0) { count++; } } } }
-
The number of workers is not perfectly right if more than one coordinators exist in the same cluster
2020-11-28 21:16:07I find the number of workers is not perfectly right if more than one coordinator exist in the same cluster。For example ,if a cluster has 5 nodes and there are two coordinators in this 5 nodes, the ... -
`irm -r` is slow when there are a large number of data objects in the ICAT
2020-12-25 17:17:03<p>We are actually using iRODS 3.3.1, but I suspect this issue will be present when we are finally able to switch to 4.0. -Schroeder and I traced the slowdown to a general query executed from ... -
Only one Cluster is Created after training. How can we increase these clusters?
2020-12-01 13:00:16I am to Train this with custom data, but after completion of training , total number of Clusters created is Only One. I have with increasing the number of nodes also tried by decreasing the same, but ... -
Why are delegated target roles limited to one key?
2020-11-26 16:26:47<div><p>When I use signercli.py to make a target role delegation... Should we not allow any positive number of keys for better security?</p><p>该提问来源于开源项目:theupdateframework/tuf</p></div> -
How can one control the number of TBB threads being used? ( perspective-python )
2021-01-08 02:23:49Profiling one of those threads shows TBB as the top hitter 47.97% python libtbb.so [.] tbb::internal::rml::private_worker::run 20.77% python libtbb.so [.] tbb::internal::rml::private_server::wake_...