I have the following query (all tables are innoDB)
INSERT INTO busy_machines(machine)
SELECT machine FROM all_machines
WHERE machine NOT IN (SELECT machine FROM busy_machines)
and machine_name!='Main'
LIMIT 1
Which causes a deadlock when I run it in threads, obviously because of the inner select, right?
The error I get is:
(1213, 'Deadlock found when trying to get lock; try restarting transaction')
How can I avoid the deadlock? Is there a way to change to query to make it work, or do I need to do something else?
I am using the paypal mass pay feature but i am unable to make payments greater than $20. When I attempt to make large transactions (say for $120) i get the error that says the account has insufficient funds.
My account has more than the requisite amount to make the payment. I am trying to find a solution as there is no documentation that says anything about an a limit for each payment in the mass pay api.
I would appreciate any help on this.
We are using C#.net & use access database code for import of text file specification into access table
is there any access database limit for this action, as we may have records 5 lac (500,000) ,will this process work for huge records??
If No then how can we handle huge records insertion in access database for same ?
Thanks
Short of using static IP addresses, is it possible to have a Cisco ASA use a DNS name rather than an IP address? For instance, if I want tolimit a host in the DMZ to access only one particular web service, but that web service might be globally load balanced or using DynDNS or cloud, how can the ACL be expressed so that a fixed IP address isn't used and the admin doesn't have to keep opening and closing down IP addresses?
hey guys
i managed to select from a table that saves my latest posts
but i need to have double condition in selection
here is my code :
$sql_query = "SELECT b.*,u.username AS MY_Sender
FROM TABLE_users u,TABLE_blogs b
Where b.reciever = '0' AND u.user_id = b.sender
UNION
SELECT b.*,u.username AS MY_reciever
FROM TABLE_users u,TABLE_blogs b
Where b.reciever != '0' AND u.user_id = b.reciever
ORDER BY bid DESC
LIMIT 0,7 ";
but MY_reciever is Null and empty
Am i wrong in using UNION for this need ?!
I used Linq to insert objects into database.But if i used threads to simultanously create 20 object within 1 second, then system will fail to add 20 objects into database.
And I found it is not because of the sql server 's limit. so the only possible is Linq, any one have idea ? How can I create 20 records or more in 1 second within 1 second ?
i have text such as
http://pastebin.com/H8zTbG54
we can say this text is set of rules splitted by "OR" at the end of lines
i need to put set of lines(rules) into buckets (bash array members) but i have character limit for each array member which is 1024
so each array member should contain set of rules but character count for each array member can not exceed 1024
can anybody help me to do that
solaris 10
I am using the following query to select 1 random record -
SELECT name FROM table WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM table ) ORDER BY id LIMIT 1
but it gives me the same set of records every time I call it. How do I get better random record?
So im just playing around with PHP and the MD5 functionality, sorry if this sounds really silly, but I cant seem to understand, how is it possible to represent an unlimited number of characters of input into a 32 bit character output? Is my logic sound here? Or is there a limitto the input that a MD5 function can take?
Thanks...
We're seeing lots of virtual memory fragmentation and out of memory errors and then it hits the 3GB limit.
The compilation debug is set to true in the web.config but I get different answers from everyone i ask, does debug set to true cause each aspx to compile into random areas of ram thus fragmenting that ram and eventually causing out of memory problems?
I have been accumulating points all afternoon, but seem to be stuck at 176. Seems an odd number to get stuck on, but I know the reputation limit is 200 a day. Any ideas?
My app needs to save files that will range from about 2-20mb. When I tried to do this I was getting an OutOfMemoryException. I did some reading and it's looking like Android has a file size limit of 1mb. Is this correct? If so, is there a way around this limitation, other than splitting up every file into 1mb chunks?
I have two tables: comments(id(primary key), author, ip(index)) and visitors(id(primary key), date_time, ip(index))
I want to join them like that:
SELECT visitors.date_time
FROM comments
LEFT JOIN visitors ON ( comments.ip = visitors.ip )
WHERE comments.author = 'author'
LIMIT 10
It works, but very slow.. In EXPLAIN it shows that it doesn't use the index on the visitors table:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE comments ref author author 78 const 9660 Using where
1 SIMPLE visitors ALL NULL NULL NULL NULL 8033
Any ideas? Thanks!
I would like to know the best Practice that you guys follow when it comes to access the SharePoint List Items / Doc Lib using Object Model. To start let me share few things I have found.
Limit the number of Items Per container to 2K items.
Use ProcessWebData method of SPWeb to do Update/Insert of Large items
I am thinking of using phplist to manage newsletter and other types of subscriptions. but i guess there is a limit applied by ISP on how much email i can send..
Any tips and tricks around how to use phplist and have a professional mass mailing software running
Hi, I made an android application with googlemap api, and draw some 16x16 png (about 200 count) on overlay. When I move or zoom on/in mapview, "out of memory" error occurs very often.
I also used the googlemap appication in my htc itself. Seams that it uses about 14+MB memmory, and never happens "out of memory".
How to save memmory usage in a googlemap api, or how to enlarge android api memmory limit.
Thanks a lot!
I'd like tolimit the text length of EditText widget,
And if user type more charactes than the limited length,
I want to show a kind of warning popup, however I can't show popup.
The problem is that we can't show popup while typing,
Probably, many people think a way of utilizing OnKeyListener or OnKeyDown.
But, when the word is composing, nothing come into OnKeyListener or OnKeyDown,
So, we can't show popup when we want to.
Is there anyone who have smart idea to solve this problem?
Soon I'll be launching my new site and i was planning on using gmail as the email server for things like registration and lost password.
I'll be using google apps (free version) so I can have [email protected].
Besides the 500/day limit are there any other potential problems with using gmail for this service?
Hi everyone,
I want to crate new table for each new user on the web site and I assume that there will be many users, I am sure that search performance will be good, but what is with maintenance??
It is MySQL which has no limit in number of tables.
Thanks a lot.
Hi Guys,
I am wanting to utilize JSONP for a project with x-domain scripting but little concerned with the 2048 character limit in IE.
Does JSONP support "chunking" automatically if character size exceeds 2048 ? If yes, does anyone have any examples they can share ?
Thx
I want to crawl a website and store the content on my computer for later analysis. However my OS file system has a limit on the number of sub directories, meaning storing the original folder structure is not going to work.
Suggestions?
Map the URL to some filename so can store flatly? Or just shove it in a database like sqlite to avoid file system limitations?
Hello,
I have a list of urls for which I want to display first 200 or 250 characters. Can I do it using jquery or should I download them on the server side [using PHP] and store them in database?
I guess I will have to use fopen with limit of characters. **
I have a ByteBuffer containing bytes that were derived by String.getBytes(charsetName), where "containing" means that the string comprises the entire sequence of bytes between the ByteBuffer's position() and limit().
What's the best way for me to get the string back? (assuming I know the encoding charset) Is there anything better than the following (which seems a little clunky)
byte[] ba = new byte[bbuf.remaining()];
bbuf.get(ba);
try {
String s = new String(ba, charsetName);
}
catch (UnsupportedEncodingException e) {
/* take appropriate action */
}