On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote:
> Hello,
>
>
>
> I am seeking information on best practices with regards to Data Warehousing
> and MySQL. I am considering moving to PostgreSQL.
> * Table 1: 80,000,000 rows - 9.5 GB
> * Table 2: 1,000,000,000 rows - 8.9 GB
Ju
Hi,
I'm looking at creating some aggregrate table based on ~2hr pull from
the main DB and looking to get standard stuffs like min/max/ave etc.
I'm having some issues with getting stdev which would be representative
of the stdev of say 10 hours of data.
>From this website : (it references using S
On Thu, 2007-03-15 at 01:25 -0700, Daevid Vincent wrote:
> Can anyone recommend a real, quality, professional level mySQL GUI for
> Linux?
> KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right.
>
has it got to be Free of COST and FLOSSware? If Not, then consider Aqua
Data Studi
On Wed, 2007-02-28 at 15:05 +0530, abhishek jain wrote:
> Hi Friends,
> I have been developing one application over Windows and now i want to
> move/port that into linux, i want to know will the casing of the table name
> matter on linux ie if i have table name as tab1 and i execute query like
> se
Under MSSQL there's a stored procedure called sp_lock which can be used.
Is there an equivalent one in mySQL?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, 2006-10-31 at 10:35 -0600, Dan Nelson wrote:
> In the last episode (Oct 31), Ow Mun Heng said:
> > Just wanted to post this here to see if anyone knows the difference.
> >
> > In MSSQL, there is a hint which can be used to ask the DB to not lock
> > the tables
On Tue, 2006-10-31 at 01:30 -0800, Cabbar Duzayak wrote:
> Hi,
>
> Could you please tell how I can tell how much memory does mysql server
> allocate on a linux box? I tried doing:
>
> top -b -n 1 | grep mysql
>
> But, it printed out bunch of processes for mysql. Are these all using
> shared memo
Hi,
Just wanted to post this here to see if anyone knows the difference.
In MSSQL, there is a hint which can be used to ask the DB to not lock
the tables during queries and then to read un-commited/dirty data. This
command is like
select count(*) from MyTable nolock
in MySQL, I found that I can
On Sun, 2006-10-29 at 22:06 +0800, Ow Mun Heng wrote:
> Hi,
>
> Learning about MySQL's stored procedure programming.
>
> trying to do things like count(*) of the # of rows in a specific table.
> When I try to put the table_names as a variable I don't get anything
&g
Hi,
Learning about MySQL's stored procedure programming.
trying to do things like count(*) of the # of rows in a specific table.
eg:
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`sp_countrows`$$
CREATE [EMAIL PROTECTED] PROCEDURE `sp_countrows`()
BEGIN
SELECT count(*) AS 'Test1(QTY)' FROM test
On Sat, 2006-10-28 at 05:44 +0300, George-Cristian Bîrzan wrote:
> On Saturday 28 October 2006 05:34, Ow Mun Heng wrote:
> > Hi,
> >
> > just wondering if there a quick way to determine the # of rows in a
> > mysql table.
> >
> > I know I can do a count(*)
Hi,
just wondering if there a quick way to determine the # of rows in a
mysql table.
I know I can do a count(*) but that would entail a table scan etc.
I found out that I can do the query into the information_schema table,
however, I don't get a consistent reading.
executing it multiple times, I
On Fri, 2006-10-27 at 11:16 -0500, Gerald L. Clark wrote:
> Ow Mun Heng wrote:
> > Hi,
> >
> > I'm trying to load some data from a primary MySQL DB into a VMware image
> > for R&D purposes.
> > Instead of doing a mysqldump of nearly 10G of data, I would
Hi,
I'm trying to load some data from a primary MySQL DB into a VMware image
for R&D purposes.
Instead of doing a mysqldump of nearly 10G of data, I would like to just
select a subset of it and load it into the VMware image.
I'm facing a snag with regard to NULL values.
I've tried doing
$mysql
On Thu, 2006-10-26 at 08:44 -0500, Dan Buettner wrote:
> I'm sure there are people who would find it useful! Post it on MySQL
> Forge - http://forge.mysql.com !
Will take a look at the site
>
> Dan
>
> On 10/26/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> >
Hi All,
just wondering if anyone here is interested in a (bash)script that does
DB replication/synchronisation between a MSSQL server to a MySQL server
running in Linux.
I just completed writing it and it seems to be working well, although
there are 1 or 2 more features which I would like to add.
On Sun, 2006-10-22 at 21:32 +0800, 黄小聪 wrote:
> "it says this is done so that other read processes can still
> access the DB/table in it's OLD state w/o any hiccups."
> I do not understand
> so how does the MSSQL DB work when we alter table add column
Frankly, I don't really know. I tried adding
On Fri, 2006-10-20 at 09:06 -0700, William R. Mussatto wrote:
> On Thu, October 19, 2006 18:24, Ow Mun Heng said:
> > Just curious to know,
> >
> > I tried to update a table with ~1.7 million rows (~1G in size) and the
> > update took close to 15-20 minutes before it
Just curious to know,
I tried to update a table with ~1.7 million rows (~1G in size) and the
update took close to 15-20 minutes before it says it's done.
Is this kind of speed expected?
I don't really understand how the alter table add column is done, but
when I look at the "show processlist" I
On Wed, 2006-10-18 at 09:29 +0800, Ow Mun Heng wrote:
> Just curious to know,
>
> I tried to update a table with ~1.7 million rows (~1G in size) and the
> update took close to 15-20 minutes before it says it's done.
> Is this kind of speed expected?
>
> I don't
Just curious to know,
I tried to update a table with ~1.7 million rows (~1G in size) and the
update took close to 15-20 minutes before it says it's done.
Is this kind of speed expected?
I don't really understand how the alter table add column is done, but
when I look at the "show processlist" I
Hi Guys,
Need some pointers. I've got a MySQL server (5.0.22) which is basically
pulling data from SQL Server into a file and then I'm using mysqlimport
to load the data into the DB.
The updates are being generated like every 2 to 5 seconds.
Due to this, my Binary Log files are huge! (and many)
On Fri, 2006-10-13 at 08:22 +0200, Rocco Di Leo wrote:
> Hello Ow Mun,
>
> there are various ways to backup InnoDB tables
>
> 1. SELECT ... INTO OUTFILE statement for your tables and reimport them
> 2. ibbackup (a commercial tool to copy InnoDB Databases while the
> server
d, and you do a "flush tables"
> before you tar up the TEST_DB directory.
The tables are innodb.
I can stop the daemon before I do anything if it's needed.
I know that some other RDBMs has the feature whereby one can just copy
and attach the DB from A -> B system
>
> On F
Hi All,
Wondering if it's possible for me to just tar up the DB (eg: TEST_DB)
and then move it AS IS to another system?
Is this possible or will I have to do a mysqldump (inclusive of create
tables / data etc)??
It would be good if I can just copy (tar) the DB to another system and
then re-atta
Sorry for the multiple post screw up.
My Bad
On Thu, 2006-10-12 at 11:43 +0800, Ow Mun Heng wrote:
> On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> > Hey
> >
> > 方外 醉月 wrote:
> > >
> > > How can i do if i want to drop tables with the s
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
Anyone here uses OLAP, running in MySQL? Any OpenSOurce OLAP query
tools?
How does one goes about doing OLAP? Is there any documentation w/ MySQL
anywhere. (I'm currently looking at Pentaho and Mondrian etc but the
Pre-configured demo didn't work as it should, meaning it doesn't run for
X reasons)
On Wed, 2006-10-11 at 13:12 -0500, Peter Brawley wrote:
> >Still don't get it
> Did you read the section of that manual page headed "Join processing
> changes in MySQL 5.0.12"? It explains why and how to rewrite all such
> queries using explicit JOIN ... ON | USING syntax.
>
This works in 4.x but
On Mon, 2006-10-09 at 14:13 -0700, Bruce Dembecki wrote:
> On Oct 9, 2006, at 7:15 AM, Ow Mun Heng wrote:
>
> > Hi All,
> >
> > Just wanted to know if it would be faster/better to implement this
> > option into my.cnf
> >
> > innodb_file_per_table = 1
On Mon, 2006-10-09 at 15:42 -0600, James Eaton wrote:
> - Original Message -
> From: "Bruce Dembecki" <[EMAIL PROTECTED]>
> To:
> Cc: "Ow Mun Heng" <[EMAIL PROTECTED]>
> How do you go about converting InnoDB databases from the single table
Hi All,
Just wanted to know if it would be faster/better to implement this
option into my.cnf
innodb_file_per_table = 1
which would essentially make each table a file on it's own rather than
have it all in 1 file.
My belief is that it would be slightly more advantageous compared to 1
BIG file.
On Mon, 2006-10-09 at 13:02 +0700, Ady Wicaksono wrote:
> On 10/9/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > On Mon, 2006-10-09 at 11:42 +0700, Ady Wicaksono wrote:
> > > Is your MSSQL data structure contain such foreign key?
> > >
> > > If yes, my isa
nodb :)
I know it's transaction safe and all, but not too sure if I need the
extra overhead.
>
> On 10/8/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > I'm just curious as to which would have better performance for my needs.
> >
> > backend is a MSSQL ser
I'm just curious as to which would have better performance for my needs.
backend is a MSSQL server and I want to replicate it into a MySQL
Frontend for user accesses.
replication would be done via "mysqlimport/load data infile". I'm
thinking of doing the inserts something like ever 5 seconds or s
On Sat, 2006-10-07 at 13:55 +0800, Ow Mun Heng wrote:
> Hi,
>
> Anyone here familiar with sqsh?
> I'm trying to get bcp going here for replication between a MSSQL
> server(2000) to a MySQL server (5.0).
>
> Since I've not found any "decent" way to do th
Hi,
Anyone here familiar with sqsh?
I'm trying to get bcp going here for replication between a MSSQL
server(2000) to a MySQL server (5.0).
Since I've not found any "decent" way to do the replication, I'm now
using sqsh to do it via the CLI.
$sqsh -S Server -U user -i ~/bcp.txt -L bcp_colsep=','
On Wed, 2006-10-04 at 17:22 +0200, Martijn Tonies wrote:
> > Is there a tool available which can be used to transfer (periodically)
> > between a MSSQL server and that of a MySQL Server?
> > Is there anyone here who does this periodically? Either through a tool
> > or via a command line script or s
other than that.. it worked as
advertised. However, it's not what I want. I would like something to
replicate to a MySQL server in the backend,( to serve as a front - end
for end-users so they don't touch the SQL server. - Licensing /
loading / bad queries etc)
> Dan
>
> O
Hi,
Is there a tool available which can be used to transfer (periodically)
between a MSSQL server and that of a MySQL Server?
Is there anyone here who does this periodically? Either through a tool
or via a command line script or something?
Would appreciate any feedback or suggestions.
Thanks
-
On Wed, 2006-09-27 at 13:00 +0800, Wai-Sun Chia wrote:
> On 9/27/06, Arjun Bhandari <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I have been using MS SQL for the last one year, however would not like to
>
> Huh? If you would NOT like to transition to MySQL, then why are you
> asking all these stuff?
On Mon, 2006-09-25 at 15:27 +0530, Mugunthan SIFY wrote:
> If you have enough disk space, create a temporary table with the four new
> columns. Insert into this table selecting records from the original table.
> Finally rename the tables.
isn't this resource intensive?
Then again, since the OP did
On Mon, 2006-08-21 at 07:39 +1000, Chris wrote:
> Ow Mun Heng wrote:
> > On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
> >> On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> >>> I'm have a query like so
> >>>
> >>> select
On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote:
> On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > I'm have a query like so
> >
> > select
> > A,
> > index_A
> > from
> > tableA
> > join tableB
> > on tableB.i
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index or the one which isn't index?
--
MySQL General Maili
On Mon, 2006-08-14 at 05:43 -0700, Steffan A. Cline wrote:
> Here is a better example
>
> mysql> select listName from listItem limit 3;
> +-+
> | listName|
> +-+
> | PWC |
> | Small Boats |
> | Fiberglass |
> +-+
> 3 rows in set (0.02 sec)
>
> mysq
On Sun, 2006-08-13 at 15:53 -0700, Steffan A. Cline wrote:
> I am in a situation where I have say 1 column called "attribute" I need and
> the result set is 3 rows. i.e.
> ROW 1 - Mechanic
> ROW 2 - Carpenter
> ROW 3 - Plumber
> I want to have the rows returned as one row
> Such as
> ROW 1 Mechani
table.column IN @temp1
Is it possible?
--
Ow Mun Heng <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ke a cartesian joins
Left joins will omit annything which does not exist on the Right side of
the table.(meaning table data)
--
Ow Mun Heng <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
5.5
Param4 4.4 5.56.6
Param5 5.5 6.6 7.7
Thanks
--
Ow Mun Heng <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ve to use a subquery??
--
Ow Mun Heng <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and exit
--version output version information and exit
SIZE may have a multiplier suffix: b for 512, k for 1K, m for 1 Meg.
Report bugs to .
--
Ow Mun Heng
Gentoo/Linux on DELL D600 1.4Ghz 1.5GB RAM
98% Microsoft(tm) Free!!
Neuromancer 16:06:57 up 1 day, 7:07, 4 users, load average: 1.56, 1.
.
--
Ow Mun Heng
Gentoo/Linux on DELL D600 1.4Ghz 1.5GB RAM
98% Microsoft(tm) Free!!
Neuromancer 10:38:25 up 2 days, 15:24, 6 users, load average: 0.71,
0.56, 0.35
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Anyone? Hope that does not mean that mySql is not used with large dbs ... :)
Thanks
--- ow <[EMAIL PROTECTED]> wrote:
> Hi,
>
> We are considering using mySql or postgreSql for an app that handles large
> volume of data. Somehow, it appears (mostly from the mailing lists) t
Hi,
We are considering using mySql or postgreSql for an app that handles large
volume of data. Somehow, it appears (mostly from the mailing lists) that mySql
does not handle large volumes of data very well (crashes, db corruptions, etc).
Would ppl who use mySql for large volumes of data share the
ime NOT NULL default '1970-01-01 00:00:01',
date_received datetime NOT NULL default '1970-01-01 00:00:01',
date_sent datetime NOT NULL default '1970-01-01 00:00:01',
dept_id smallint(3) unsigned NOT NULL default '0',
user_id int(7) unsigned NOT NULL default '0',
PRIMARY KEY (fa_id),
UNIQUE KEY serial_no (serial_no)
)
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
=4
3. Kernel is custom compiled with minimal drivers. Only
what hardware is on the system is compiled. No modules.
4. I think the Athlns just preform better too.
<-ENd Chris comments--->
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-78
t of the lot.. (hang on.. I've yet to test it
on my Laptop, my 5 1/2 yr old Dell Latitude 166MMX with 72MB Ram) I'm sure
It's BLAZING slow..:)
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: NTLUG [mailto:[EMA
t;\t" . '';
echo mysql_field_name($l_results,$k);
echo " \n";
}
As someone pointed out to me, remember to reset your pointer back to 0, else
you'll only get output from row 2 (data4,5 & 6) as the pointer is alreadly
incremented by 1.
use -> mysql_da
513988 kB
LowFree:166468 kB
SwapTotal: 192772 kB
SwapFree: 173080 kB
Committed_AS: 125268 kB
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 20
Thanks for the Info Paul
I guess since I'm a newbie and the server's not especially loaded or
anything, I'll just leave it be.. (for the time being)
Thank
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Paul D
aybe this is true as
well?)
I'm just starting out and my innoDB files are small.
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 9:03 AM
To: [EMAIL P
s then? If My insert statements are formatted
properly enough that I put in all the values as needed into the table,
myself ensuring that what I've inputted is actually already there in the
other table.
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
--
M
You need to create a cookie session using start_session() and something like
that. I'm actually reading up on it on this book
PHP & MySQL Web development - luke welling & Laura thomson (i think)
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
rpm and it installed the mysql.so file into the
/usr/lib/php4 directory.
After that, you need to stop and restart httpd
/sbin/service httpd restart
Try again, that should do it.
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: B
perl-DBD-mysql.
Can anyone please let me know how I can upgrade or I need to compile
it on my own or ??? Pls Help.
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
Hi All,
I know I'm re-posting but there must be someone out there who can
explain. Please Help. Thanks
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-----
From: Ow Mun Heng
Sent: Thursday, June 05, 2003 9:47 AM
To: [EMAIL
d the rpm from MySQL.com
PS : Does this rpm installs to the *SAME* location as Redhat RPMs?
DO I Upgrade or install? (rpm -U or Rpm -i since this is not Redhat
RPM)
Thanks
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
--
MySQL General Mailing Lis
smbd/reply.c:reply_sesssetup_and_X(858)
Domain=[MY] NativeOS=[Windows 2000 2195] NativeLanMan=[Windows 2000 5.0]
[2003/06/05 09:30:56, 3] smbd/reply.c:reply_sesssetup_and_X(868)
sesssetupX:name=[OW_MH]
Appreciate if someone could help explain this problem. How come it 'No
Session Setup"??
Cheers,
M
72 matches
Mail list logo
