On Tuesday 03 August 2004 01:11 pm, Jon Drukman wrote:
> We were having terrible problems with a master/slave setup. The master
> does a huge amount of writes, and the slave simply started lagging
> behind, despite both machines being identical hardware-wise. This made
> the application basically
Hi,
I have following code to insert a row into a table - schema follows:
:
PreparedStatement insertData = targetConnection.prepareStatement("insert
into CompanyParticipationLevel (siteId,nodeId,companyId,editionId,participation
LevelId,participationText,participationLogo) values (?, ?, ?, ?, ?,
>...
> mysql> SELECT col2 FROM test ORDER BY col2 COLLATE utf8_swedish_ci;
> ++
> | col2 |
> ++
> | M(u-diaresis)ller |
> | Muffler|
> | MX Systems |
> | MySQL |
> ++
> ...
> I expect M(u-diaeresis)ller to sort after MX Systems in the following:
At 09:37 PM 8/3/2004, Scott Haneda wrote:
I am building a mailing list manager, using mysql 4 at the moment. I want
to have a simply web interface where one can remove themselves from a
mailing list. This will most likely be supplied as a link in a email that
will be sent to them when they email i
Hi, I use BK to download a snap shot of mysql-4.1. On make test, it said failed at
ps_2myisam. What am I doing wrong?
I am using the BUILD/compile-pentinum-max script to build mysql. I change the setting
to disable openssl and berkeley-db and change prefix to /usr/local/mysql-cluster
Best regar
- Original Message -
From: "Karl-Heinz Schulz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 9:18 PM
Subject: SQL Syntax Question
> I tried to get an answer on the PHP mailing list and I was told that this
> list would be quicker to get me a solution.
>
>
>
- Original Message -
From: "Scott Haneda" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 10:37 PM
Subject: Best options for unique string
> I am building a mailing list manager, using mysql 4 at the moment. I want
> to have a simply web interface whe
Hi everyone,
Is there a standard way to specify a default user name and password for the java
driver? For example, will it recognize .my.cnf like most mysql clinets do?
Thanks,
Sergei
I am building a mailing list manager, using mysql 4 at the moment. I want
to have a simply web interface where one can remove themselves from a
mailing list. This will most likely be supplied as a link in a email that
will be sent to them when they email in and request info about a mailing
list.
thank you very much
On Tue, 3 Aug 2004 20:08:51 -0500 (CDT),
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
> Hello,
>
> I have made apresentation at MySQLs UC2004 about using Japanese character
> sets with MySQL. You may find this a good starting point. Links are below:
>
> http://dev.mysql.com/d
I tried to get an answer on the PHP mailing list and I was told that this
list would be quicker to get me a solution.
I have two tables "Event" and "Eventdetails" (structures dump can be found
at the end of the message).
I want to display all events and the related information from the
eventdetai
Is it possible to store foreign language characters like arabic,
russian, etc on mysql? when a user send out data via the web?
where should i start?
--
Louie Miranda
http://www.axishift.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
A client wants access to some data in mysql 3, it is a simple case of a user
table and a registered_serials table, there is always one user, and there
can be many resistered serials. (One to many)
They want to somehow get this data into Excel, so I want to give them one
record per user, even thoug
can anyone help me with my problem regarding mysql 4.0.2. I'm having a
problem with the sequencing of the auto incremnt field. if my application
makes an insert mysql inserts the new row somewhere in the middle of the
sequence. example
autoinc_field data_field
1 qwe
2
Hi Jeremy, Greetings All,
First, thank you for taking the time to discuss this issue. It is
important that people let us know when they upset with us.
Next, it is clear that we need to look at the issues that were raised
by this thread.
When more of the right people from MySQL return from Linux
Actually, Oracle can shrink or grow datafiles:
ALTER DATABASE DATAFILE '/usr01/oracle/sid/data001' resize 200M;
On Aug 3, 2004, at 15:59, David Griffiths wrote:
Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when
data is deleted either.
David
Marc Slemko wrote:
On Tue, 3 Aug 2004
Jocelyn Fournier wrote:
Hi,
A quick fix would be to set the wait_timeout variable in the my.cnf to a
much smaller value than 28800 (default value).
Try to add wait_timeout=60 in the my.cnf for example, the connections should
be automatically closed after 60 secondes if there are not used anymore.
Hi,
A quick fix would be to set the wait_timeout variable in the my.cnf to a
much smaller value than 28800 (default value).
Try to add wait_timeout=60 in the my.cnf for example, the connections should
be automatically closed after 60 secondes if there are not used anymore.
Regards,
Jocelyn Four
> From: David Griffiths [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 03, 2004 1:04 PM
> Subject: Re: Replication + InnoDB = badness
>
> Could it be a network bandwidth issue? Remember, all that
> data needs to
> be transmitted across to the slave. If you are on a
> 10-megabit network,
>
What you want to do is "pivot your data into a crosstab report". This has
been covered several times so you should be able to find more information
if you search on either "pivot table", "crosstab" or "cross tab".
Here's how to do it for a week's worth of dates, I will let you extend it
to fit
HI all, i am tweaking some tables for an upgrade to MySQL 4.0.13 using InnoDB
tables. I have a bunch of columns defaulted to NULL, and have been reading
about using NULL's vs defined defaults, such as 0 or ''. I dont really have
any need to differentiate between a blank and a null, so i am looki
Could it be a network bandwidth issue? Remember, all that data needs to
be transmitted across to the slave. If you are on a 10-megabit network,
it could be the cause. Remember, Ethernet is not exactly an efficient
protocol, and efficiency drops as network traffic increases.
A second machine mig
Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when data
is deleted either.
David
Marc Slemko wrote:
On Tue, 3 Aug 2004 12:42:03 -0400 , David Seltzer <[EMAIL PROTECTED]> wrote:
Thanks Marc,
Is there really no way to reclaim unused space in an InnoDB table space? If
not, why is
Hello
right now I have a table which looks like this
(including duplicate entries)
Error Date
A0012004-07-08
A0012004-07-08
A2222004-07-08
A0012004-07-09
Now I query for the quantity one error occurs during a
day (select Date, Error,
Count(*) FROM table1 GROUP BY Date and E
I am attempting to use the new UTF8 collations in MySQL 4.1.3 to perform
case-insensitive, accent-insensitive sorting. Based on the example in
section 11.3.13 of the manual
(http://dev.mysql.com/doc/mysql/en/Charset-collation-effect.html )
I expect M(u-diaeresis)ller to sort after MX Systems in t
Hi Jim,
First of all, you should assingn a greater value for the key_buffer_size
variable than 16k. This should help to reduce the readings on your hd.
You should consider to set up the query cache.
Best regards
Alejandro
-Mensaje original-
De: Jim [mailto:[EMAIL PROTECTED]
Enviado el
> > Also even after we re-converted all the slave's Inno tables back to
> > MyISAM it *still* lagged out. Only after I disabled the
> Inno engine
> > entirely did the problem abate.
> >
> > Any ideas why? Does InnoDB use resources even if there are no
> > active tables using the engine?
>
>
Jim wrote:
Hi. I'm wondering if anyone can help me tune this database so it runs
better on my hardware. I've made some attempts, but either they've
made it worse or not changed anything. Changing the database design
itself has shown the most improvement, but I'd still like to know how
to tun
On Tue, Aug 03, 2004 at 12:44:05PM +0530, [EMAIL PROTECTED] wrote:
>
> Hi Friends:
>
> We are using mysql version 4.0.17 on Linux with a master and a single
> slave both running on the same node.
>
> We have encountered a problem in replication in the following scenario:
>
> First the slave go
On Tue, Aug 03, 2004 at 11:11:52AM -0700, Jon Drukman wrote:
>
> We were having terrible problems with a master/slave setup. The
> master does a huge amount of writes, and the slave simply started
> lagging behind, despite both machines being identical hardware-wise.
> This made the application ba
Hi. I'm wondering if anyone can help me tune this database so it runs
better on my hardware. I've made some attempts, but either they've made
it worse or not changed anything. Changing the database design itself
has shown the most improvement, but I'd still like to know how to tune
things on
On Tue, Aug 03, 2004 at 01:08:58PM -0400, [EMAIL PROTECTED] wrote:
>
> I agree with David. If there is no present way to recover unused
> InnoDB tablespace, then we (as a community) seriously need to create
> a tool to do just that. How have we gone so long without it?
Because it's just not a pro
On Tue, Aug 03, 2004 at 11:16:43AM -0600, Michael Gale wrote:
> Hello,
>
> I am new to mysql and am in the middle of upgrading our mysql
> server to the latest release. Upon viewing our currently data
> directory I noticed a large amount of hostname-bin-### files.
>
> Some of hostname-bin-#
Are you running the server with the log-bin option? If you do not need these
for restoration and or backup purposes you can purge these files.
-Original Message-
From: Michael Gale
To: [EMAIL PROTECTED]
Sent: 8/3/04 12:16 PM
Subject: mysql bin files
Hello,
I am new to mysql and a
We were having terrible problems with a master/slave setup. The master
does a huge amount of writes, and the slave simply started lagging
behind, despite both machines being identical hardware-wise. This made
the application basically unusable because eventually the slave was
hours behind the
Jeff Mathis said:
> my understanding is that the datafiles are created when the server
> initializes, and this this is the designed and expected behavior. Most
> other database products use a similar model. Your scenario cannot
> happen. You specify how many innodb data files and how large in your
>
>
> Thanks for the two responses.
>
> William Mussatto said:
>> Are you running mod_perl?
>
> Yes I am, with Perl 5.8.3.
>
> Victor Pendleton said:
>> What does mysql "show processlist" look like?
>
> Here is what it looks like currently, but the system is not in its
> "unresponsive" phase right
That sounds like a typical mod_perl-problem. The script is making new
connections and doesn't close the old ones.
You should add debug-code to your script and add
* * * * * root mysql -e 'show processlist'
>/tmp/mysql_processlist_debug_`date +%s`.txt
to your /etc/crontab in order to log the proce
my understanding is that the datafiles are created when the server
initializes, and this this is the designed and expected behavior. Most
other database products use a similar model. Your scenario cannot
happen. You specify how many innodb data files and how large in your
config file. when the
Shawn,
This is precisely the situation that I am in So it seems I cannot
accomplish what I need while on-line. Does anyone know of a tool/method for
doing this offline?
-Dave
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 1:0
Hello,
I am new to mysql and am in the middle of upgrading our mysql server to the
latest release. Upon viewing our currently
data directory I noticed a large amount of hostname-bin-### files.
Some of hostname-bin-### have time stamps of January -- from the documentation I have
read I c
I agree with David. If there is no present way to recover unused InnoDB
tablespace, then we (as a community) seriously need to create a tool to do
just that. How have we gone so long without it? I always assumed it was
possible (I guess I have been just lucky enough to not need to do it
yet...
We are evaluating the replacement of a Sybase database with MySQL. The
databases are 60+GB, containing more than 100 tables.
Since we need transactions, that implies InnoDB. We were happy with the
early results, but we hit a major roadblock when trying to import the
biggest table (20+GB, with 4
Thanks for the two responses.
William Mussatto said:
> Are you running mod_perl?
Yes I am, with Perl 5.8.3.
Victor Pendleton said:
> What does mysql "show processlist" look like?
Here is what it looks like currently, but the system is not in its
"unresponsive" phase right now. I can't force
On Tue, 3 Aug 2004 12:42:03 -0400 , David Seltzer <[EMAIL PROTECTED]> wrote:
> Thanks Marc,
>
> Is there really no way to reclaim unused space in an InnoDB table space? If
> not, why is this not considered a tremendous limitation?
Some do consider it a tremendous limitation. It all depends on ho
Thanks Marc,
Is there really no way to reclaim unused space in an InnoDB table space? If
not, why is this not considered a tremendous limitation?
-Dave Seltzer
-Original Message-
From: Marc Slemko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 12:31 PM
To: David Seltzer
Cc: [E
On Tue, 3 Aug 2004 10:07:25 -0400 , David Seltzer <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I've been searching the archives & mysql documentation for a while and I
> can't seem to find an answer to my question -
>
> Is there a way to force InnoDB to shrink its filesize? I just dropped a 7GB
> tab
Mr Stassen
The point I am making is that any query employing EXISTS/NOT EXISTS will try
to use an Index on the referenced column
IF you decide to use a subquery at a later point in time the Index on the
column would
STILL be employed when EXISTS/NOT EXISTS is used to reference a column which
is
- Original Message -
From: "Claire Lee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 11:28 AM
Subject: distinct based on two fields--please help
> I have a table like this
>
> name price type
> A10 1
> B30 2
> A20
David Brodbeck wrote:
Ext2 has not had a 2 gig filesize limit for a long time.
32-bit file offsets are still the default in Linux on 32-bit systems, so
these systems will still have the 2GB limit by default. You have to
compile your programs with special options to get 64-bit offsets.
I'm cer
From: Claire Lee [mailto:[EMAIL PROTECTED]
> I have a table like this
>
> name price type
> A10 1
> B30 2
> A20 1
> B20 2
>
> would like to distinct based on name and type, do a
> sum and get the following result
>
> name price type
> A
> -Original Message-
> From: Eric Gunnett [mailto:[EMAIL PROTECTED]
> Depends on what file system you are running that is a
> ext2 limit if you move to ext3 or reiser you should be fine.
> But then a default config on MySQL will run into a 4.29 Gig
> limit, which you can change.
I have a table like this
name price type
A10 1
B30 2
A20 1
B20 2
would like to distinct based on name and type, do a
sum and get the following result
name price type
A 30 1
B 50 2
How do I do this with one sql qu
And I have a table like this
click send on accident?
A
Don't leave me hangin'!!
-- Tripp
--- Claire Lee <[EMAIL PROTECTED]> wrote:
> I have a table like this
>
> name price type
> A
>
>
>
> __
> Do you Yahoo!?
> New and Improved Yahoo
I have a table like this
name price type
A
__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
I said something wrong: Count(Distinct ) counts how many unique values
appear in a set. NOT how many times each unique value appears in a set.
Shawn
[EMAIL PROTECTED] wrote on 08/03/2004 10:28:33 AM:
> Ok, I haven't completely tested this but I have confidence in the
> approach.
>
> If yo
On Tue, 03 Aug 2004 06:50:46 -0600, Martin Gainty wrote:
>
> Keep in mind that when you use LIKE you will NOT use an index but you will
> use a full table scan instead
> Also instead of using IN EXISTS uses Indexes on the master table query..if
> you have master-heavy or parent-heavy query use EXI
Ok, I haven't completely tested this but I have confidence in the
approach.
If you have the tables: campaign, foo, bar, example, and another
And, each table has something unique per row (like an ID column)
Then, this query should give you the number of rows returned from each
table because
Martin Gainty wrote:
Andrew et al-
Keep in mind that when you use LIKE you will NOT use an index but you
will use a full table scan instead.
Agreed.
Also instead of using IN EXISTS uses Indexes on the master table
query..if you have master-heavy or parent-heavy query use EXISTS/NOT
EXISTS vs IN/
For reference,
WHERE 9 IN (REPLACE(geo_region,'|',','))
did not work because IN expects a list of columns, each of whose values is
to be compared to 9. You put 1 column in the list. Had you compared the
string '9' this way, you would have gotten only those rows where
geo_region='9'. Because
Hi all,
I've been searching the archives & mysql documentation for a while and I
can't seem to find an answer to my question -
Is there a way to force InnoDB to shrink its filesize? I just dropped a 7GB
table, but it hasn't freed up the disk space and I need it back. From what
I've been reading,
> Hi,
>
> I just upgraded to mysql-4.0.20 compiled using gcc-3.3.3. All my C++ DB
> interfaces connecting to this mysql database seem to run into a problem -
> when I try to disconnect, mysql_close() is called but the program just
> hangs there without being able to close the connection. Can some
First thing I'd do is copy all of the database/table files to a safe
location. Burn them to CD, upload them to a file server, etc. It's the
data that's the paramount concern... not the database software.
Once you are certain that your data has been backed-up appropriately,
uninstall all mysql s
Have you tried using a binary from Mysq.com?
-Original Message-
From: Mahesh S
To: [EMAIL PROTECTED]
Sent: 8/3/04 8:24 AM
Subject: my MySql is DEAD
hi all,
i'm using MySql 3.23.54a-11 that comes with RH Linux 9 distro. the
daemon starts properly, but the very next moment it's
hi all,
i'm using MySql 3.23.54a-11 that comes with RH Linux 9 distro. the daemon starts
properly, but the very next moment it's in the dead state. in the services list, a
message reads like ...
"sqld dead, but subsys locked"
Andrew et al-
Keep in mind that when you use LIKE you will NOT use an index but you will
use a
full table scan instead
Also instead of using IN EXISTS uses Indexes on the master table query..if
you have master-heavy or parent-heavy query use EXISTS/NOT EXISTS vs IN/NOT
IN
http://archives.postgr
Hi,
I've followed the discussion about UTF8 and MySQL-4.0 in the last days
... But now I need some additional explanation.
With version 4.1, support of different character sets is included. I see
it in my server, that 'show variables like "%character%"' gives me some
interesting information:
+--
Does that means that we need to change the column type from varchar to some other
type? Which type to use?
thank you.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 6:24 PM
To: [EMAIL PROTECTED]
Subject: Re: set up UTF8 for MySQL 4.0.x
"
(BThank you.
(B
(BIn the PDF doc:
(B4.1.0 Server based Character Settings
(BSetting the servers default character set
(B>mysqld ?default-character-set=ujis
(Bor (in my.cnf etc.)
(B[mysqld]
(Bdefault-character-set=ujis
(B
(BThat's what I want by my last mail.
(B
(BFor my case, shall I
Hi.
Thanks Stephen, the works like a dream... Unlike this database which is more
like a nightmare!!!
Best Regards
Andrew.
-Original Message-
From: Stephen E. Bacher [mailto:[EMAIL PROTECTED]
Sent: 03 August 2004 12:16
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: In Statement
[EMAIL PROTECTED] wrote:
>My connection to the mysql is correct, that is "host, username, password",
>however when I click the link of form so that it will pull out data from
>mysql database, I see the php code of the form, any guidance, please.
This is a Web server configuration issue.
Assumin
Hi!
On Aug 02, Tinley, Jeremy wrote:
> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
> ALTER test results of sql-bench had been greatly improved, CREATE has
> shown nasty performance degradation. Just before needing to make the
> decision to revert back to 3.23.58, we fo
Andrew Dixon <[EMAIL PROTECTED]> wrote:
>Hi Everyone.
>
>I require some help with an IN statement I'm trying to get working. I have
>inherited a database from someone else in which there is a table with
>project information and a field containing which geographic regions the
>projects relate. As a
Can you give me a bit more detailed instructions on what i am
uninstalling and what I should back up?
Thanks
Wolfgang Riedel wrote:
[EMAIL PROTECTED] schrieb:
I am trying to upgrade to the new version of mySQL on Fedora Core 2
Linux. I have "mysql Ver 11.18 Distrib 3.23.58, for
redhat-linux-
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> äÏÂÒÙÊ ÄÅÎØ.
áÇÁ, ÄÏÂÒÙÊ, but we speak english here. :)
> Usually I run configure like this:
Well I don't remember the configure options used in mysql40-server port, but
these are recommended. You just want to enable linuxthreads and buildstatic
an
"Guofeng Zhang" <[EMAIL PROTECTED]> wrote:
> Our web site will store the text in a number of languages in the mysql =
> DB, so that we think that MySQL should be configured to store chars in =
> UTF8.
>
> For my requirement, how to configure the MySQL. to store Unicode =
> characters?
No need.
Hi,
Currently, a VIEW lists "NULL" as value for the "Engine" column in
the SHOW TABLE STATUS resultset. Is this the right behaviour?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
M
Hi,
Absolutely great news!
Thanks.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
since GPLed software can also be commercial i think
the subject of the thread should probably read
"using mysql in proprietary software." instead of "commercial"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
- Original Message -
From: <[EMAIL PROTECTED]>
> "Issac Goldstand" <[EMAIL PROTECTED]> wrote on 03/08/2004 09:47:31:
> > - Original Message -
> > From: "mos" <[EMAIL PROTECTED]>
> > > Well, I'm not so sure. Here it is straight from the horses mouth
> namely
> > > [EMAIL PROTECTED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 5.0.1, a new version of the popular Open Source/Free Software
Database Management System, has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://www.mysql.com/downloads/ a
Hi
I've just taken a look at a recent bin-log, and found a stack of code
which started with 'SET ONE_SHOT CHARACTER_SET_CLIENT=33', and went on to
deleting blank users from the user table and inserting rows into the
mysql.db table, such as 'test', 'test\_%', and some of the existing dbs.
I do
Our web site will store the text in a number of languages in the mysql DB, so that we
think that MySQL should be configured to store chars in UTF8.
For my requirement, how to configure the MySQL. to store Unicode characters?
Thank you very much.
--
MySQL General Mailing List
For list archiv
"Issac Goldstand" <[EMAIL PROTECTED]> wrote on 03/08/2004 09:47:31:
>
> - Original Message -
> From: "mos" <[EMAIL PROTECTED]>
> > Well, I'm not so sure. Here it is straight from the horses mouth
namely
> > [EMAIL PROTECTED]
> >
> > >>
> > "Free use for those who never copy,
> > modi
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
> At 03:41 AM 8/2/2004, Jeremy Zawodny wrote:
> >On Mon, Jul 26, 2004 at 11:49:02PM -0500, mos wrote:
> > > At 04:43 PM 7/26/2004, you wrote:
> > >
> > > >looks like the answer is no. As soon as fee based software touches
the
> > > >my
Quick question if anyone can help.
I was reading through the manual and it states something about the character
sets being different from mysql version 4 to version 4.1.1
We have just upgraded from 4 to version 4.1.1 and are having problems with
accent characters on our database table. Some field
Hi Rhino
I had pretty much already suggested doing that, but I have been told that
I'm not allowed to redesign the database as there is already lots other code
working on it already that would need changing as well. I personally think
the database design is terrible, but I have to work with what I
Hi Friends:
We are using mysql version 4.0.17 on Linux with a master and a single
slave both running on the same node.
We have encountered a problem in replication in the following scenario:
First the slave got abnormally terminated while there were some active
connections to the master.
The m
88 matches
Mail list logo
