Hello Nils,
sorry if I sounded perhaps unfriendly. That was not against you.
Imagine that many people read the list (+20.000), some which read this
which might take your word for granted and just do as you told ;-).
No worries, I should have stated that --in this particular case--
(to me)
what about :
http://dev.mysql.com/doc/mysql/en/dsn-on-unix.html
2005/9/22, Ananda Kumar [EMAIL PROTECTED]:
Hi Pooly,
I know your busy, but please help me, i need to submit this by today for the
testing team.
If you dont mind can you please guide to any url or documentation where i
can find
Hi Pooly,
I tried this also, its not working.
Also the odbc.ini file created by the package is empty. I found the same
entires in /usr/etc/myodbc3-32.template file.
So i copied the contents of this and created an odbc.ini file.
After doing this
isql is not connecting to MYSQL database..
regards
I need links about good database design information for high loaded web
sites...
regards, okan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I need links about good database design information for high loaded web
sites...
A database design should start with the logical data-related requirements,
not with performance related issues.
IMO, of course.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird,
I disagree completely.
I prefer to have regard to the statement of requirement, which in this case
is a concern over performance. If following conventional design rules
creates performance issues, then performance related issues come first when
considering design.
In times long since gone by (I
Hi,
Please reply to the list and not to me personally only.
I want to explain my condition. I have a web site that habe 110onlne users
at same time. But cpu usage is 2.00/2.00 (p4 3.0ghzHT)
I think my database design is horrible because of this high cpu load.
Did you do an analysis to come
Hello Tim,
I disagree completely.
I prefer to have regard to the statement of requirement, which in this
case
is a concern over performance. If following conventional design rules
creates performance issues, then performance related issues come first
when
considering design.
Given that the
sorry for wrong reply:(
And
Did you do an analysis to come to this conclusion? Is it really MySQL
that's hogging your CPU?
Did you analyse what queries were bringing the server down?
The senteces above are my big problem. How can I be sure about the quesries
making my server down Please, any
Tim Hayes wrote:
I disagree completely.
I prefer to have regard to the statement of requirement, which in this case
is a concern over performance. If following conventional design rules
creates performance issues, then performance related issues come first when
considering design.
-
My 2 cents..
Before you actually start worrying about the performance tuning of database
parameters or hardware required for the DB, you should make sure that you
have designed the database properly by taking care of all aspects like
normalisation, denormalisation (??). If you don't take care
This is an interesting subject area.
In a data warehousing environment, one tends to adopt table structures such
as snowflake layouts which lead to improved performance.
Createing a perfect normalised database design may well lead to performance
issues. The more joins you have, by far the worse
Martijn Tonies wrote:
Given that the OP did not state that there were any issues with an
existing website, logical requirements come first. Period. No discussion ;)
Logical requirements may come first, but may be overruled later by
requirements caused by performance issues or system
Hi,
Given that the OP did not state that there were any issues with an
existing website, logical requirements come first. Period. No discussion
;)
Logical requirements may come first, but may be overruled later by
requirements caused by performance issues or system limitations.
Which is
This is an interesting subject area.
In a data warehousing environment, one tends to adopt table structures
such
as snowflake layouts which lead to improved performance.
Createing a perfect normalised database design may well lead to
performance
issues.
If this is the case, go bug the
This is what I am also saying.
The effects of a bad logical DB design will effect you the most only in the
long term. In the earlier stages you always trust your own design and always
look for additional h/w resources to improve the performance. But in the
long term you will realize that there is
I agree totaly to what Sujay Koduri writes :
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
My 2 cents..
Before you actually start worrying about the performance tuning of database
parameters or hardware required for the DB, you should make sure that you
have designed
I have searched the internet and scanned the manual, but have not found any
pointers to using mysql or its embedded server on a windows CE device.
A few quick questions which might seem to be trivial to you but will help me go
ahead:
1. Can I use embedded server in a win CE device
... this one is peculiar, and I *do* hope there's a workaround:
Using MySQL 3.23.58 and cannot upgrade. When running SELECT * FROM tblname
WHERE match(a) against('very_common_word') LIMIT 1 the whole table is scanned
just to give me no results at all. The very common word *does* appear, and
Nitzan,
In the unlikely event that you can recompile but not upgrade, you could add
your common words to the full text stopword list in myisam/ft_static.c and
rebuild mysql.
Otherwise, this might be helpful
http://lists.mysql.com/mysql/132649
Andy
-Original Message-
From: nitzan
Hey all,
I've got a production database that made up of all MyISAM tables. I'd
like to change some of the more heavily written to tables to InnoDB to
take advantage of the record level locking and thus improve write
performance of our applications.
I currently have a second db server that is
You will need to make sure you have innodb configured in the my.cnf
file and you have enough space built for it in the shared table
space. InnoDB also needs it's own memory pool, so make sure you give
it enough memory. For day to day issues there is no problem doing
innodb/myisam
On Sep 21, 2005, at 5:23 AM, Jeff wrote:
I am interested in how you go about doing a delayed replication to
protect against operator error. We've already fallen victim to that
situation here.
The long story short is we use the fact that MySQL has the ability to
run the SQL thread and the
This seems to be a common question, but answers aren't that common...
What are people using as a web-based reporting tool? I'd like to add a
user-facing interface to allow users to run pre-defined reports (in which
they may need to enter data, like Start Date and End Date) against their
data.
We very recently began replicating data from a master to a slave and
since doing that we've noticed that most of the RAM in the machine 2 GB
is being used with very little (relatively) free (12MB - 50MB). I've
looked at several forums and have done some web searches to see if there
was any
-Original Message-
From: Warrick Wilson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 12:09
To: mysql@lists.mysql.com
Subject: Web-based reporting tool?
This seems to be a common question, but answers aren't that common...
What are people using as a web-based
In the last episode (Sep 22), Blumenkrantz, Steve said:
We very recently began replicating data from a master to a slave and
since doing that we've noticed that most of the RAM in the machine 2
GB is being used with very little (relatively) free (12MB - 50MB).
I've looked at several forums
Classification: UNCLASSIFIED
Caveats: NONE
Well this is probably getting off topic, but I didn't start it ;). And I
know there's a lot of expertise on the list...
So, one of the items mentioned by Warrick dealt with
snip [ pre-defined reports (in which they may need to enter data, like
If you're considering Java, how about looking at Jasper?
http://jasperreports.sourceforge.net/
Wiebe
-Original Message-
From: Warrick Wilson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 9:09 AM
To: mysql@lists.mysql.com
Subject: Web-based reporting tool?
This seems to
-Original Message-
From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 11:41
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
You will need to make sure you have innodb configured in the my.cnf
file and you have enough space built
hi ,,
we are converting our oracle DB to MySQL DB. One problem i see is that the
abg row length in MySQL is much higher compared to that of Oracle.
In oracle it is around 180 bytes and in MySQL it is around 686 bytes. So as
a result, MySQL is taking more space to store the same number of
-Original Message-
From: Sujay Koduri [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 15:23
To: mysql@lists.mysql.com
Subject: Avg row length is varying a lot from oracle to MySQL
hi ,,
we are converting our oracle DB to MySQL DB. One problem i
see is that the
Each row in the table takes around 600 bytes, taking every thing into
consideration and assuming every field is used to its maximum bytes. But the
major portion of this 600 bytes are composed of varchar's (100 + 150 + 50 +
16 + 50 + 20 + 9..)
Out of these 400 bytes we generally use only 40 to 50
On Sep 22, 2005, at 11:46 AM, Jeff wrote:
True, is there a way to tell a slave to not replicate certain queries
like alter table or would I need to get creative and stop replication
and all writes to the main database, then issue the alter table
statement, then restart replication with a set
Jeff wrote:
True, is there a way to tell a slave to not replicate certain queries
like alter table or would I need to get creative and stop replication
and all writes to the main database, then issue the alter table
statement, then restart replication with a set global
slave_sql_skip_counter=1
Bump!
Ed Reed [EMAIL PROTECTED] 9/21/05 2:09:58 PM
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In
the previous version Group_Concat returned a text string and after the upgrade
they are returning a blob.
Each row in the table takes around 600 bytes, taking every
thing into consideration and assuming every field is used to
its maximum bytes. But the major portion of this 600 bytes
are composed of varchar's (100 + 150 + 50 + 16 + 50 + 20 +
9..) Out of these 400 bytes we generally use only
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 16:14
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
Jeff wrote:
True, is there a way to tell a slave to not replicate
certain queries
like alter table or
Hello,
I have a Fedora Core 3 installation on an Intel 64bit processor.
I need PHP MySQL 4.1.
The OS installed is the 64bit version of FC3.
PHP 4.3.9 is installed by FC3, but this has been upgraded to 4.3.11 and
works OK.
I have upgraded MySQL from 3.23 to 4.1 and I have installed
Jeff wrote:
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 16:14
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
Jeff wrote:
True, is there a way to tell a slave to not replicate
certain queries
like alter table
Greg 'groggy' Lehey wrote:
On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote:
Jasper Bryant-Greene wrote:
Sometimes when I execute this stored procedure ... I get the error
Lost connection to MySQL server during query.
I am using MySQL 5.0.12-beta-log on Gentoo
hi...
from the docs... it appears the the mysql_real_escape_string function (from
php) is used to backslash a set of chars in the string for insertion into
the mysql db...
however, given that the '/' is mysql, vs ansi, i was wondering if there's a
way to force it to use the ansi standard '
bruce wrote:
from the docs... it appears the the mysql_real_escape_string function (from
php) is used to backslash a set of chars in the string for insertion into
the mysql db...
however, given that the '/' is mysql, vs ansi, i was wondering if there's a
way to force it to use the ansi standard
The OS installed is the 64bit version of FC3.
I have upgraded MySQL from 3.23 to 4.1 and I have installed the shared
library. (MySQL-shared-4.1.14-0.glibc23.x86_64.rpm)
The problem is that PHP complains that it cannot find
'libmysqlclient.so.10'.
I think you need the shared-compat
The following might also be helpful (not all info in there is
Opteron-specific):
http://hashmysql.org/index.php?title=Opteron_HOWTO
Argh - should have read my own entry on that wiki page.
If you use PHP v4.3 (as installed with FC3) then it requires the MySQL v3.23
interface libraries (aka
bruce [EMAIL PROTECTED] wrote on 09/22/2005 09:15:56 PM:
hi...
from the docs... it appears the the mysql_real_escape_string function
(from
php) is used to backslash a set of chars in the string for insertion
into
the mysql db...
however, given that the '/' is mysql, vs ansi, i was
Hi,
I have an odd situation where I was handed just bad data, and while I
have cleaned it up to the best of my ability one hurdle remains.
I have a situation where I have the following example in a field:
Canna ÒBengalÒ.
Note the odd chrs Ò in the field ? I need to get rid of those, my
Hi Friends,
I have set up all the drivers and configured the Hetrogenous service in
oracle and set all the relevent parameter. Now when i am connecting to MYSQL
from ORACLE i am getting the below error
select counter from ebay_stats@test where rownum 2
*
ERROR at line 1:
ORA-28500: connection
m i l e s wrote:
Hi,
I have an odd situation where I was handed just bad data, and while I
have cleaned it up to the best of my ability one hurdle remains.
I have a situation where I have the following example in a field:
Canna ÒBengalÒ.
Note the odd chrs Ò in the field ? I need to
49 matches
Mail list logo