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
Just
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
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 Studio.
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
select
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 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 memory so
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 during queries and then to read un
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
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
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
eg:
DELIMITER $$
DROP PROCEDURE
Hi,
I'm trying to load some data from a primary MySQL DB into a VMware image
for RD 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 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 RD purposes.
Instead of doing a mysqldump of nearly 10G of data, I would like to just
select a subset of it and load
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,
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(*) but that would entail a table scan etc.
I found
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
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
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 says it's done.
Is this kind of speed
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 a
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)
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 really understand how the alter table
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 Fri, Oct 13, 2006 at 12:11:24PM +0800, Ow Mun Heng wrote
-- *.ibd
-- *.frm
/mysql/ib_logfile0
/mysql/ib_logfile1
/mysql/ibdata1
I use innodb_file_per_table = 1
Thanks
Option 3 is probably what you want to do.
greets
Rocco
On 10/13/06, Ow Mun Heng [EMAIL PROTECTED] wrote:
On Thu, 2006-10-12 at 23:43 -0500, Brian Ivins wrote
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 same predix?
If you are using 5.0:
DELIMITER //
DROP
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
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 not in
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 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 VARCHAR(63))
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 VARCHAR(63))
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 VARCHAR(63))
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 VARCHAR(63))
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 isam is not suitable for you
Actually, you know what? I
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 15:42 -0600, James Eaton wrote:
- Original Message -
From: Bruce Dembecki [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Ow Mun Heng [EMAIL PROTECTED]
How do you go about converting InnoDB databases from the single tablespace
to those using the table-per
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
which would essentially make each table a file on it's
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
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 server and I want to replicate it into a MySQL
Frontend for user accesses
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 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 the replication, I'm now
using sqsh to do it via
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
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
On 10/4/06, Ow Mun Heng [EMAIL PROTECTED
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
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?
Stop
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 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.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A
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
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
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
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)
mysql
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 Mechanic,
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]
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]
??
--
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]
--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 bug-coreutils@gnu.org.
--
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
.
--
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
Hi All,
Just a quick question on whether I need both fields to be indexed.
The table is as below.. I'm wondering if I need to have these 2 fields -
fa_id serial_no
fa_id would be a 7 character int like 001, 002
serial_no would be like WMACK001, WMACM121
most of the
I think you want the column headers right??
Header1 header2 header3 this is what you want right?
data1 data2 data3
data4 data5 data6
echo '!-- Results Table Header Field Names --';
for ($k = 0; $k sizeof($l_row) ; $k++)
{
echo
Had Free Time.. hehe..
AMD 1900+ (512RAM) 0.61
P4 2*2.8(2GB RAM) 0.66
P4 2GHz(? RAM) 0.86
P4 1.8G(512 RAM)0.91
1G Mac Pbook(1GB RAM) 1.07
AMD 1GHZ1.21
Celeron 733(win2k) 1.63
P3 850Mhz 1.91
G3 333Mhz
Had Free Time.. hehe.. (MORE included I'm Still Slowest!! Where's
HyperThreading??)
P4 2.4GHz (1GB RAM) 0.53 (on Win2K) Maybe cpu no loaded??
2x Athlon2100(2GB RAM) 0.54 --FASTEST - Tuning parameters below
AMD 1900+ (512RAM) 0.61
AMD 1666Mhz(1GB RAM)0.64
P4 2*2.8(2GB RAM)
Hi,
This is OFF-TOPIC but can you tell me how I can 'dedicate' a chunk
of memory to MySQL Query Caching? I have 512MB but as listed below, a lot of
those are being used as 'cached and Inact_dirty'
Whatever is Inact_dirty anyway?
MemTotal: 513988 kB
MemFree:166468 kB
PROTECTED]
Sent: Wednesday, July 09, 2003 11:02 AM
To: Ow Mun Heng; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Disable InnoDB
At 9:46 +0800 7/7/03, Ow Mun Heng wrote:
Hi,
This may be a stupid question but can I still just ask it?
Why do you want to disable the use of InnoDB
Hi,
This may be a stupid question but can I still just ask it?
Why do you want to disable the use of InnoDB tables? If you don't
use it, couldn't the files still be there? It's not like it's a security
risk (or is it?) or that it takes up lots of space? (maybe this is true as
Hi All,
Can anyone please explain to me the usage of foreign keys?
As I understand it, foreign keys are used to relate one table to another.
But, mysql (new version can?) cannot ensure that what's inputted is an
actual key in that other table.
What's the need for foreign keys then? If
Hi,
I'm a newbie too. Was faced with this the other day.. I'm using
Redhat 8.0 PHP-4.2.2-8.07 and when this problem surfaced, found out that
phpinfo() states that it is compiled with the --with-mysql=shared. But I did
not install php-MySQL*.rpm
Did a rpm -Uvh php-MySQL*.rpm and it
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
DID : 03-7870 5168
Hi All,
I have a dependency problem in libmysqlclient.so.10 when I try to
install MySQL 4.0 (rpm downloaded from www.mysql.com) This is a Redhat 8.0
system (original rpm install)
If I perform a rpm -e mysql* it will tell me there's a dependency
for libmysqlclient.so.10 for
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 PROTECTED
Hi All,
Can someone help me debug this?
[2003/06/05 09:24:45, 3] smbd/reply.c:reply_sesssetup_and_X(858)
Domain=[] NativeOS=[Windows 2000 2195] NativeLanMan=[Windows 2000 5.0]
[2003/06/05 09:24:45, 3] smbd/reply.c:reply_sesssetup_and_X(868)
sesssetupX:name=[]
[2003/06/05 09:24:45, 1]
Hi All,
Newbie question.
Stock Standard Redhat 8.0 install with MySQL 3.23. Have not started using,
so thought I can upgrade to Version 4.0 it before I face more problems later
on.
RPM -e mysql*
libmysqlclient.so.10 needed by perl-DBD-MySQL
from the Mysql manual, it says that we can
70 matches
Mail list logo