Search results for query: *

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...

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...

That makes perfect sense. Thank You!

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...

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...

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...

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...

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...

That's exactly right. Thanks Roger. I actually figured it out myself over the last few days, but the result is identical. Thanks! Luc

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.

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...

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...

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...

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...

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.

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...

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...

That worked. Thanks a lot!

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...

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!