Search results for query: *

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

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

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

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

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

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!

I've got a problem and it's making my head spin. I think there is a very simple solution to this but I can't figure it out. SELECT ck.id, ck.position AS position,ads.id,ads.bid_type,ads.bid_amount,sort_col FROM v.content_keyword ck STRAIGHT_JOIN vc.campaign_ad ads ON...

Hey Guys, Here are my specs: 1. Linux Redhat 2. MySQL 5.0.41 3. InnoDB Tables Two tables, campaign_ad and campaign_ads_live - campaign_ad contains all ads (2.2 Million records). - campaign_ads_live contains only ad_ids (from campaign_ad.id table)that are "Approved" and "Active". Not that...

Hi, This is kinda stupid, but for some reason I can't figure it out... I know exec,system, and backticks can be used to execute programs outside of the currently running perl script. I'm making an autoinstaller for apache that we'll use on a bunch of systems. It removes previous versions...

Hey Guys, Can anyone provide me with a sample Java code to extract URLs (anything following a href=, between quotes). I've been messing with it all day and can't get it to work. All the code samples out there are for PHP. I am using the matcher but it's always empty. Thanks! Luc L.

Hey Guys, I'm trying to extract the individual columns returned by an FTP server on a "dir" call which lists files and directories in the path. The fields are divided using spaces, but I don't know how to seperate them out (if there is a way to do this). Sample output: -rw-rw-rw- 1...

Hey Guys, I know how to open up a new socket, how to listen, send data, etc. But say I have to ethernet adapters on a server and I want to perform all the socket actions on a particular interfance, say not eth0 but eth1. Is there any way to specify the interface/ethernet card when creating...

Hey Guys, How do I create a new trigger for a table that already exists and has data in it? I'm guessing this is not the same as "stored procedures/functions" because the triggers are related to each table. I'm using mysqladministrator and query editor but don't see a trigger editing...

Hi Guys, I've edited out /etc/my.cnf to contain two new lines that deal with query caching.. query_cache_type=1 query_cache_size=25M Then I saved the file and restarted Mysql. This is under Linux Redhat. For some reason when I reconnect and check the variables using "SHOW VARIABLES LIKE...

Hi Guys, I'm trying to figure out whether I should have a primary key or not. Here is my situation.. I have a primary table, say: ptable that stores id (autoincrement primary key),name (varchar) Then I'll have lots of child tables that store various properties but those properties are...

Hi Guys, I'm scanning a very large table using LIKE for a certain pattern and I want to exclude results that contain a number or dash. For dash I do something like NOT LIKE '%-%' and it works extremely fast, but is there any way to exclude numbers, without going through NOT LIKE '%1%' AND NOT...

Hi, How can I obtain the size of an array that was passed as a reference. ex: &something(\@v1,\@v2); sub something{ my($arr1,$arr2)=@_; #get size of arr1? } I know I can loop through all the items by setting up a foreach(@$arr) but the regular old $# doesn't seem to work. I also...

Hi Guys, I've got a database that contains about 2 million records. I also have a form that allows the user to insert 500 new records at a time. I'm trying to figure out the best way to add the new records in bulk but also check to make sure they are not already in the database (only one...

Hi Guys, My query joins 2 different tables and the third original table. I'm getting the COUNT from one of the joined tables and a SUM from the other. Query: "SELECT u_id,u_handle,COALESCE(SUM(ratings.r_rating),0) as u_rating,FORMAT(COUNT(d_id),0) as u_domains FROM users LEFT JOIN ratings...