Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Large Heap Tables - Limits on 64bit Systems?
Cool, thanks. The only reason I've been delaying the server purchase is because I'm not sure if I should spend the few extra grand on memory or not. A server with 64GB of ram will run a few thousand and would be a waste for my needs if mysql didn't support that for memory tables. I'll give it... -
Large Heap Tables - Limits on 64bit Systems?
Hey guys, I'm looking to store large tables in memory for quick access. I've done this before on standard 32bit systems running mysql/linux but there is a 4GB heap table limit. I'm looking to store memory tables that are 32GB-128GB in size on a 64bit system running latest mysql and linux and... -
-
web request via Socket issue
Ok, it took me forever to figure this out and it's something really stupid, BUT I still need help with this. The code is below. You can try it out. Basically, by changing the outgoing headers to use the HTTP 1.0 standard, the output is fine, but if you use the HTTP 1.1 standard, the output... -
web request via Socket issue
Hey Guys, I've got a weird problem. I'm using standard sockets to pull up web pages (I know java has a built in class to do this but there is a special reason I'm using sockets). Anyways, when the data starts flowing in, I get weird "8a", "40a", etc strings in between some of the HTML... -
Java in Console. Not releasing RAM
I guess what happens is that redhat waits for the memory buffer to fill up before it performs a big cleanup. So, when I force kill the java program, its data remains in memory for some reason, but eventually the memory is reclaimed when another program eats up all of the memory or whenever... -
Java in Console. Not releasing RAM
Hey Guys, I've got a java program that runs in the console (Linux redhat). If I let it run and finish, it seems to clean up ram OK, however if I CTRL+C it and force stop the execution, the ram never frees up (not even an hour or two later or when I launch another copy of it). Both the... -
Variable table names in Stored Procedures
I have not reached a limit yet on the query size, only on the return value which I control by adjusting the heap tables (my queries are also kinda long). Side note, when I was using this approach in a stored procedure to perform an INSERT SELECT with ON DUPLICATE KEY UPDATE there was a bug... -
Variable table names in Stored Procedures
That's exactly right. Thanks Roger. I actually figured it out myself over the last few days, but the result is identical. Thanks! Luc -
Can set this kindf of replication
Also, you could have master1 replicate itself to master2 and master2 replcate itself to master1, so you would have both copies of the DB on each master, then you could just hook the slave up onto one of the masters (which has both dbs) and replicate off of it normally. -
Can set this kindf of replication
A slave can only have one master, but a master can have many slaves. This is assuming you don't start hacking up the mySQL code yourself. There is a way around that though using federated tables. What you do is have the slave replicate DB1, and then create federated DB and federated tables of... -
LOAD_FILE doesn't work
Hi, So you're not getting an error but the LOAD_FILE always returns a NULL/blank? I've had this problem before. In my situation it was caused by two things, one, the file needs to be on the MYSQL SERVER and mySQL server must have rights to it. If you're running the command from a client that... -
Variable table names in Stored Procedures
Hi guys, I need to perform some automated tasks in a stored procedure that require the table name to be generated in the stored procedure. I basically have to look at a few tables, and based on their size determine where to insert data or whether or not to create a new shard to insert data... -
Storage Engine for large amounts of data
When you say fail? Do you mean lag? Or become corrupt? If your crawler is multi threaded, as any crawler should be, then you probably want to stay away from MyISAM tables because they perform poorly with unique keys and multiple inserts. This is because they don't provide row level locking... -
Simple Thread / Postback question
I guess the easiest way is to just create a threadhandler class that keeps track of the active and max threads and can be added to any project along with anything that uses threads. brain freeze. case closed. sorry, it's late. -
Simple Thread / Postback question
btw, the error java is returning is "method increment_thread is undefined for type Thread) my threaded class is declared like: public class threadedClass extends Thread I realize it extends to the Thread class, but still wonderig if there is a way to access the thread that originally... -
Simple Thread / Postback question
Hi guys. I've got two classes. The first, is the primary (with void main, etc), it calls the secondary which is threaded to do something, waits for an available thread, then launches another one. at any time there should be 10 threads running. the main function doesn't care about anything... -
-
Simple InputStream Help
Hi Guys, I've got an outside FTP library that either accepts a filename or an inputstream when uploading a file. It has an append function that will let me append data to an existing file but that requires using an inputstream as the data parameter (instead of input file). How can I convert... -
Long is showing up as negative. Why?
I feel silly asking this but I am not sure what the problem is. long max_daily_bytes2 = 10 * (1024 * 1024 * 1024); System.out.println(max_daily_bytes2); Output: -2147483648 What's causing this? Java longs should have a range of up to 9,223,372,036,854,775,807 Thanks!
