y*****g
发帖数: 677 | 1 这个可能没什么原因。 如果你的TABLE很大，比如几十，几百G的话，是得花几分钟，
十几分钟的。可能是一个BUG IN INNODB.
For insert, 原因可能和你的table and indexes related.
贴 出来看看INSERT STATEMENT 和 TABLE DDL |
|
n****e
发帖数: 1403 | 2 (1). In database A, table `client`
CREATE TABLE `client` (
`pin` INT(11) NOT NULL,
`create_user` INT(11) NULL DEFAULT NULL,
`update_user` INT(11) NULL DEFAULT NULL,
`update_time` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
`dob` DATE NULL DEFAULT NULL,
`create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
`dob_type` INT(11) NULL DEFAULT NULL,
`ethnicity_code` VARCHAR(10) NULL DEFAULT NULL,
`gender_code` VARCHAR(10) NULL ... 阅读全帖 |
|
y*****g
发帖数: 677 | 3 显得很可疑的是这个部分，
select max(h_key) from C.customer_home ch where ch.client_key = B.
client_key
最好先设成 null, 然后在update 为正确的值。
另外， 为什么要把名字设成100个字节长？ 看着有些不符合常规，还有其他的一些
column 有类似的问题。 |
|
s**********o
发帖数: 14359 | 4 TABLE很小的时候，就几个RECORD或者几百个
TABLE高频率的INSERT，索引要小心，因为INDEX多会降低INSERT速度
比如LOGGIN TABLE
TRUNCATE TABLE不需要索引 |
|
A*******n
发帖数: 625 | 5 在一个sql server上我有好几个database， 比如EIS和Intranet两个databases， 系统
在backup EIS，网页在访问Intranet，比如run一些query，是不是会影响网页在访问的
速度。
我碰到这样的问题，网页在访问Intranet的时候，有的时候特别慢（run query）。可
是同样的query在SSMS上面直接跑，却很快。过一个小时候后网页在访问Intranet又很
正常。这是为何？
还有一个问题是，如果我truncate了一些tables的数据（数据比较多），还有必要re-
index吗？
ty |
|
m******y
发帖数: 588 | 6 这个比较好玩。
我经常面试问的一个问题是： what's your biggest mistake you made in the past
and how you fix the issue. 通常就是delete, truncate 或者 drop. |
|
n****f
发帖数: 905 | 7 you already find the issue.
in the wizard, you should set the width to 1024.
not only this field, but ALL fields must be E or L than org one. |
|
s*******s
发帖数: 162 | 8 可以在网上下载 Microsoft sample database： adventureworks2012， 里面的sample
data用来练习SQL skill 挺不错的, 也可以在这些数据上建一些aggregated datamart
tables, 比如说 monthly total sales & total sales amount by salesId,
productid, productCategory, Country...
想难度更大一些可以下载另一个Sample DB: adventureworksDW2012, 然后truncate
那些Fact tables 里所有的数据，自己试着写store procedure/SSIS ETL process 把
数据从 adventureworks2012 load到 adventureworksDW2012 里面的fact tables |
|
w****n
发帖数: 266 | 9 更新一下。
原来的删除语句用的 truncate table,要求 exclusive lock. Insert data 用shared
lock， 改用delete from my table where xxxx,可以要求shared lock. |
|
|
i****a
发帖数: 36252 | 11 试了些方案，只有 amazon 自帶的 scheme 和 data migration tool 可以最小 down
time。
但是前印度人坑爹，做了无数 table 沒 pk，无数 truncate, 甚至 drop recreate
table 的码，amazon data migration 就出问题了。
Amazon 的人建议表都加上 pk。唉 |
|
i****a
发帖数: 36252 | 12 试了些方案，只有 amazon 自帶的 scheme 和 data migration tool 可以最小 down
time。
但是前印度人坑爹，做了无数 table 沒 pk，无数 truncate, 甚至 drop recreate
table 的码，amazon data migration 就出问题了。
Amazon 的人建议表都加上 pk。唉 |
|
z*********e
发帖数: 10149 | 13 Hi all
I was trying to create a filter and forward some email to my cell phone as
text message when they arrived at my in-box of gmail account. However I'm
stuck at verifying this forwarding account cuz the verification email sent
from my gmail account to my cell phone as text message truncated a large
portion of its context and I can't see the verification code on my cell
phone. How can I set this up in any way?
My goal is the forward some email to my cell phone as text message when I
received ... 阅读全帖 |
|
w********e
发帖数: 1416 | 14 查看sleepstudy report发现其中有个 “ir truncate percentage”占的比例低的话就
不耗电，高的话就不行。谁知道这个是怎么回事？ |
|
T***B
发帖数: 137 | 15 【 以下文字转载自 BuildingWeb 讨论区,原文如下 】
发信人: TFIIB (小明), 信区: BuildingWeb
标 题: 紧急求教：网页只显示一半
发信站: Unknown Space - 未名空间 (Fri Apr 1 00:15:14 2005) WWW-POST
I use Apache and cgi in the server side. when visiting the site via browser,
the returned html file is truncated.
If I run the cgi at the server machine directly, I can alway get the full html
file created by the perl cgi.
Can anyone help? Thank you very very much! |
|
h*********o
发帖数: 62 | 16 Not sure if this caused your problem. But I doubt it
It seems that there is a small bug in the code. Since the network is slower
than cpu, cpu will dump data much faster than network. This will cause
sometimes inputstream to read empty tempary stream ( the stream is not
closed yet). So the count can be 0. I suggest that you cahnge:
if (count <= 0) break;
to if (count == -1) break;
Please note that this doesn't happen so often. But you still have a chance
to truncate your file.
To debug your code |
|
g**********y
发帖数: 14569 | 17 今天突然Eclipse出问题了，按F3 open declaration, 弹出“java.lang.
ClassFormatError: Truncated class file”。运行程序，debug, 又没问题，但是一
旦要追踪代码, 就有问题。
我甚至把workspace全部清理掉，重建一遍也一样。
有谁遇到过类似的吗？ |
|
b***i
发帖数: 3043 | 18 刚做了个applet, 本机上eclipse测过好用。用export, runnable jar file, package
required library into...
然后，上载到微软的officelive上，出现如下错误
trucated class file
这是什么问题？怎么会这样？
java.lang.ClassFormatError: Truncated class file
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(Unknown Source)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
at java. |
|
l********g
发帖数: 39 | 19 I have some large text files formated as 12 columns, but with a very large
number of rows, say one million lines. I have about 10 of this kind of files
, maybe more up to 100, which may make a total of several GBs. Thinking
about using cat to merge them.
something like this: $ cat smalljunks*.txt > newlargejunk.txt
The questions:
can the 'cat' command handle these large files? is it possible that it
truncates the files to fit to its limit (if there is any) so that the merge
is incomplete? Becau |
|
Z**0
发帖数: 1119 | 20 你可以测试一下。每个包头是28bytes。1500-28=1472。所以你用这个命令测试：
ping -c 5 -M do -s 1472 www.google.com
看看出来什么，应该是
PING www.l.google.com (64.233.169.104) 1472(1500) bytes of data.
72 bytes from yo-in-f104.google.com (64.233.169.104): icmp_seq=1 ttl=49 (
truncated)
如果你用ping -c 5 -M do -s 1473 www.google.com出来
PING www.l.google.com (64.233.169.147) 1473(1501) bytes of data.
From amd64.leinux.com (130.74.64.114) icmp_seq=1 Frag needed and DF set (mtu
= 1500)
你就从1742开始测试，出现不丢包时候的数字＋28就是MTU。（成功的时候，那个echo
出来的括弧里边里边的数字, |
|
E*V
发帖数: 17544 | 21 readlink(2) - Linux man page
Name
readlink - read value of a symbolic link
Synopsis
#include
ssize_t readlink(const char *path, char *buf, size_t bufsiz);
Description
readlink() places the contents of the symbolic link path in the buffer buf,
which has size bufsiz. readlink() does not append a null byte to buf. It wil
l truncate the contents (to a length of bufsiz characters), in case the buff
er is too small to hold all of the contents.
Return Value
The call returns the count of char |
|
v*****r
发帖数: 1119 | 22 组里请的一个 consultant, 非要给大家做 how to use debugger 的 presentation，
不禁想起了 Linux 的 I am a bastard 的宣言.
http://lists.insecure.org/linux-kernel/2000/Sep/1177.html
Subject: Re: Availability of kdb
From: Linus Torvalds (t******[email protected])
Date: Sep 06 2000
On Wed, 6 Sep 2000, Tigran Aivazian wrote:
> very nice monologue, thanks. It would be great to know Linus' opinion.
> I mean, I knew Linus' opinion of some years' ago but perhaps it
> changed? He is a living being and not some set of rules written i... 阅读全帖 |
|
W*****x
发帖数: 684 | 23 $ cd geoip-api-c-master
$ libtoolize
$ aclocal
$ autoconf
$ automake --add-missing
$./configure
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
... 阅读全帖 |
|
s*********e
发帖数: 17 | 24 char * strtok( const char * string, const char * delimiters );
Sequentially truncate string if delimiter is found.
第一部分：
If string is not NULL, the function scans string for the first occurrence of
any character included in delimiters. If it is found, the function overwrites
the delimiter in string by a null-character and returns a pointer to the token
, i.e. the part of the scanned string previous to the delimiter.
第二部分：
After a first call to strtok, the function may be called with NULL as str |
|
B********s
发帖数: 3610 | 25 Code is as below. after I got the actural local ip information (credit to
ansel), I got a correct hostname but it was truncated at the first period.
For example, it gives "abc" instead of "abc.cs.mit.edu"
How can I get the full hostname then? Please pay attention to "my code" part.
Thanks.
fd = socket(AF_INET, SOCK_DGRAM, 0);
memset(&ifr, 0, sizeof(ifr));
memcpy(ifr.ifr_name, "eth0", sizeof(ifr.ifr_name));
ioctl(fd, SIOCGIFADDR, &ifr);
sin_ptr = (struct sockaddr_in *) &ifr.ifr_addr;
myself = sin |
|
g*****u
发帖数: 298 | 26 85. You have an abstract computer, so just forget everything you know about
computers, this one only does what I'm about to tell you it does. You can
use as many variables as you need, there are no negative numbers, all
numbers are integers. You do not know the size of the integers, they could
be infinitely large, so you can't count on truncating at any point. There
are NO comparisons allowed, no if statements or anything like that. There
are only four operations you can do on a variable.
1) You |
|
X****r
发帖数: 3557 | 27 什么语言？
如果是C/C++的话，规定是truncate，就是小数点后部分去掉。 |
|
w***g
发帖数: 5958 | 28 是truncate。我记错了。一直当四舍五入用的，程序里不知道出了多少bug。 |
|
l***8
发帖数: 149 | 29 The "double" type has enough bits to hold small integers (such as 28032400)
without loss of accuracy. Here the "without loss of accuracy" means at the
magnitude of 1e+7 the error is less than +/- 0.5. Internally this number
might be 28032399.999 but after truncation you get 28032399.
Use round() to 四舍五入 |
|
z******i
发帖数: 59 | 30 It is a truncation. You can write a simple C code, and check its
assemly to figure out what it is doing. X86 has the fistpl (convert float to
integer) instruction to do that.
But be careful if performance is important in your code. Since the
conversion
is very slow (stall FPU due to fldcw - load FPU control word).
146 80483ee: d9 6d e4 fldcw -0x1c(%ebp)
147 80483f1: db 5d f4 fistpl -0xc(%ebp)
148 80483f4: d9 6d e6 fldcw -0x1a(%ebp)
int to |
|
P********e
发帖数: 2610 | 31 他好象说：name too long, truncated
我也不知道具体什么意思 |
|
h**o
发帖数: 548 | 32 I want to have a input string parsed by sscanf (or other function which
can work) in this way:
if the first part of the string is less than 10bytes, parse it and
assign it to a variable;
if the first part of the string is more than 10bytes, truncate it and
assign it to a variable.
Her is my expected result:
suppose input[] = "ThisStringFieldShouldBeTruncated 123
OtherStringFieldWhichAlsoShouldBeTruncated 456";
I want to parse it to
char v1[11]="ThisString"; int b1= 123, char v2[5] = "Othe", int |
|
t****t
发帖数: 6806 | 33 for C/C++, it is always true that
(a/b)*b+a%b==a (if a/b is representable).
C90: result of a/b is truncated toward 0.
c++98: implementation-defined.(but C90 way is preferred)
result
gcd give unexpected results when input has negative numbers. |
|
s******s
发帖数: 505 | 34
Oh, Yeah! I was thinking about truncating, lol.
Thank you. |
|
F*********k
发帖数: 42 | 35 好的，谢谢谢谢，我想我大概明白了，
我之前没看明白 FixedAllocator::Chunk::Deallocate 里边的
*toRelease = firstAvailableBlock_; 这句
其实这句实际上把当前和之前的连接起来了。
我把源码贴这里
void FixedAllocator::Chunk::Reset(std::size_t blockSize, unsigned char
blocks)
{
assert(blockSize > 0);
assert(blocks > 0);
// Overflow check
assert((blockSize * blocks) / blockSize == blocks);
firstAvailableBlock_ = 0;
blocksAvailable_ = blocks;
unsigned char i = 0;
unsigned char* p = pData_;
for (; i != blocks; p += blockSize)
... 阅读全帖 |
|
w**z
发帖数: 8232 | 36 整行删除就没问题了吧。或者，多搞几个CF, 一小时一个，处理完就truncate the CF
老魏对C*完全没概念，啥他都敢喷。 |
|
a*****e
发帖数: 1700 | 37 绝对的 kill time 利器 :-)
ByteString.Lazy 和 ByteString.Lazy.Char8 怎么会不兼容呢，后者是为前者提供向
Char 转化的工具（直接 truncate），但是操作的结果和对象可都是 ByteString.Lazy
啊。所以你用 Codec.Archive.Zip 读写的 ByteString.Lazy.ByteString 类型的值，
直接用 ByteString.Lazy.Char8 里面的函数操作即可。
不过说实在话，我不知道你为什么喜欢用 Char，直接用 Word8 并没有很不方便。
尤其是 String literal 可以直接使用 {-# LANGUAGE OverloadedStrings #-}
如果你说的是 ByteString 和 [Char] 之间转换，只需要用到 ByteStirng.Lazy.Char8
.pack 和 unpack 两个函数，其它不需要考虑。如果你需要 UTF8 编码转换，用 utf8-
string 这个库。 |
|
n*******e
发帖数: 4894 | 38 $MACAddress =sprintf("%.8s" ,(sprintf("%08x", $MACAddress)));
也许这是想要的？如果大于八位，就去掉末尾多余的
$MACAddress = sprintf("%08x", $MACAddress) =~ s/.*(\w{8})$/$1/r;
如果想truncate的是前面的，就用上面这种办法 |
|
l******9
发帖数: 579 | 39 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: IIS7.5 大于 64KB 文件不能下载 ?
发信站: BBS 未名空间站 (Tue Jun 23 12:47:53 2015, 美东)
大于 64KB 文件不能下载 (from C# code). 大于 文件不能完全下载， 只能下载 64KB
， 然后
truncated. Why ?
I have published a web service application (C# built in VS2010) to a desktop
with IIS 7.5 win7.
The web service has been hosted successfully on win 7.
Now I can install the application on my laptop (win 7) by accessing the URL
http://myDesktopName.domain.com/MyApp/MyAppSetup.msi
... 阅读全帖 |
|
f*********e
发帖数: 8453 | 40 用一个停止开发的jar。原来的开发人也找不到了，也没有相应版本的源程序。找了个
旧版源程序分析了一下，发现就是用到的一个url硬码写在源程序里的几个类里了，现
在这个url改了。我在网上找了个工具：https://sourceforge.net/projects/
classeditor/files/试着改了一个类改成现在的url，用java工具更新jar之后一部分功
能恢复了。可是用相同方法改另一个类运行之后给我扔出个什么ClassFormatError:
truncated class file之类的异常就退出了。谁知道是怎么回事？有啥解决办法没？ |
|
D**C
发帖数: 6754 | 41 每行就十个columns,一天只写一次，然后truncate |
|
l*******m
发帖数: 1096 | 42 其实开一个10—20G的shuffle buffer, 加上truncated 二进制文件，基本和随机读差
不多了 |
|
g****t
发帖数: 31659 | 43 你那问题找出来第一条...
http://netsec.ws/?p=180
Controlling EIP
Using the pattern create tool a string of 2100 bytes is created (output
truncated for brevity)
ruby /usr/share/metasploit-framework/tools/pattern_create.rb 2100
Aa0Aa1Aa2A.......Cr5Cr6Cr7Cr8Cr9
We place the string on our exploit and send this to the server instead of
our variable length payload. |
|
r*t
发帖数: 34 | 44 【 以下文字转载自 Database 讨论区 】
发信人: rgt (一脸无辜), 信区: Database
标 题: Oracle求助，thanks!!!
发信站: BBS 未名空间站 (Sun Oct 26 16:07:18 2008), 转信
An urgent problem, thanks a lot if anybody can help!!!
I have several parallel processes like this:
my_program parameter1 &
my_program parameter2 &
...
my_program parametern &
In most of time, it runs as expected, but sometime it do give me an error li
ke this:
"Truncating table TABLE_A, ORA-00054: resource busy and acquire with NOWAIT
specified"
I am very positive that I |
|
b***s
发帖数: 373 | 45 I got lots of "Warning: ridiculously long PATH truncated". |
|
o*****c
发帖数: 7 | 46 It's not about the input method at all. The
problem is that the input bytes are truncated.
Say any chinese will result in two ascii on
my screen. And I wrote a program and found if
the highest bit is set to 1 in these two
ascii, then they ended up with the chinese
char I am looking for. |
|
d*****t
发帖数: 17 | 47 Hi, everyone,
I'm editing a text file in Emacs. Once I'm in a paragraph and want to move to
the next line (Emaca wrapped the paragraph into several lines but I didn't let
it truncate the text), using the down arrow key brings me to the next
paragraph instead. Does any body know how I can use the down/up arrow keys to
move the cursor in a paragraph as I did in MS Word?
Thanks in advance. |
|
h**o
发帖数: 548 | 48 I want to have a input string parsed by sscanf (or other function which
can work) using solaris C language in this way:
if the first part of the string is less than 10bytes, parse it and
assign it to a variable;
if the first part of the string is more than 10bytes, truncate it and
assign it to a variable.
Her is my expected result:
suppose input[] = "ThisStringFieldShouldBeTruncated 123
OtherStringFieldWhichAlsoShouldBeTruncated 456";
I want to parse it to
char v1[11]="ThisString"; int b1= 123, |
|
