Dear all,
On my server there are thousands of database files contenting Chinese
records. The total data volumn is over 20GB. Is there an easy way to
upgrade the whole system from MySQL 3.23.x to 4.1.x?
"mysqldump" is NOT a good way for me. It will be a hard and time costing
work. Is it possi
Dear all,
On my server there are thousands of database files contenting Chinese
records. The total data volumn is over 20GB. Is there an easy way to
upgrade the whole system from MySQL 3.23.x to 4.1.x?
"mysqldump" is NOT a good way for me. It will be a hard and time costing
work. Is it possi
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 g
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
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
"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,
> 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 l
> 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 l
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
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 "'" inst
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
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 o
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 t
> -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 alte
> 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 o
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.
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 s
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 g
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 b
> -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
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 record
> -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 spac
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 b
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
"St
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
> -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 we
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 mention
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
dat
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
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 replicatio
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 r
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 sha
... 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
a
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 applicatio
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
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
> 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
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.
Whic
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 limitation
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 t
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 of
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.
- persona
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
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 tha
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
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 a
> 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 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]
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
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
50 matches
Mail list logo
