Hello Jerry,
Thanks for the reply. You are right. Thats why it finally took me
10-12 work hours to convert a single DB (split over two work days) to
a UTF-8 compliant version.
While it wasnt necessarily difficult to do (once you figured it out),
it can put extra pressure on your eyes if y
Hi Lee
better you start to benchmark your system using tools like
http://sysbench.sourceforge.net/
You will find out, what boundary you hit, if you hit max thread,
reduce thread stack size but very careful on this stuff :)
On 1/18/07, Shain Lee <[EMAIL PROTECTED]> wrote:
Hi Friends ,
I have h
Hi Friends ,
I have huge WAP content database and it's included with wallpapers, ringtones,
games ...etc.That content database getting hits more that 1000 /sec. This is
actually massive.
My Webserver s are Tomcat and apache , because some applications written in
java and some are php . per
I don't have any way of selecting a host. I only have one host on my system and
I don't see anything in the program that explicitly shows me where to select
the host.
>>> Igor Alexandrov <[EMAIL PROTECTED]> 1/17/07 9:30 PM >>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ed Reed wrote:
> Unabl
There was already a bug report submitted. That's where I found other users that
have the same problem.
>>> Colin Charles <[EMAIL PROTECTED]> 1/17/07 6:05 PM >>>
Ed Reed wrote:
> Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
> that I'm not the only one with this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ed Reed wrote:
> Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
> that I'm not the only one with this problem but no one seems to have an
> answer for it.
>
> The problem is that when you select a user in the user list
Hi,
After having compiled (debug and optimized version) of MySQL 5.1.14 on
Itanium-2 using icc, I have run
mysql_install_db --user=...
and started mysqld_safe in both scenarios (debug and optimized). In both
cases mysqld starts without any errors.
Unfortunaly when
Karl Larsen wrote:
I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5
of any other and find with Core 4 I can yum only mysql version 4.
I imagine Core 5 might be able to yum mysql version 5 but not certain
of that. Is there a way I can yum the later version? I studied t
VeeJay wrote:
How and at What place, can I configure the Makefile under
/usr/ports/databases/mysql50-server/
to have MySQL server working with above mentioned configurations?
Why not just use MySQL that comes from ports?
If you really want to build from source, read:
http://dev.mysql.
Nishant Gupta wrote:
When i try to run mysqld_safe cmd, it fails saying :
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
070105 20:23:40 mysqld ended
Also mysqld.pid does not exist at the given path!
It looks like the mysql
Kristen G. Thorson wrote:
Hi!
But all I really get from this reading is 0 turns it off, 1 prints some
warnings, and 2 prints level 1 warnings plus aborted connections
warnings. I have not been able to find any additional information in my
search. Am I missing something, or is this all the doc
Ed Reed wrote:
Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
that I'm not the only one with this problem but no one seems to have an answer
for it.
Have you reported a bug to bugs.mysql.com ?
kind regards
--
Colin Charles, Community Engineer
MySQL AB,
While I think optimize does an analyze, you may find that just an ANALYZE
will do it instead of a full OPTIMIZE:
http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html
On 18/01/07, William R. Mussatto <[EMAIL PROTECTED]> wrote:
Just a thought, did you try running Optimize Table from the My
Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
that I'm not the only one with this problem but no one seems to have an answer
for it.
The problem is that when you select a user in the user list of the prog the
user's detail don't appear on the right side so that t
Just a thought, did you try running Optimize Table from the MySQL
Administrator. I'm thinking that when you restarted it re-examined the
table statistics and was able to pick a better index.
On Wed, January 17, 2007 14:31, John Anderson said:
>
>
> mysql> SELECT SQL_NO_CACHE COUNT(rb.subscription_
mysql> SELECT SQL_NO_CACHE COUNT(rb.subscription_id) as
recurring_cc_count,
-> SUM(rb.grace_price) as recurring_cc,
-> COUNT(sb.subscription_id) as single_cc_count,
-> SUM(sb.initial_amt) as single_cc
-> FROM customerdetail a
-> LEFT JOIN recurringbilling rb
Greetings,
It seems the lists.mysql.com imposes a 50KB limit on messages, so this
message will be sent in two parts. Thanks for your patience.
I'm in the process of converting most of my databases from MyISAM to
InnoDB, and I've come across the most peculiar problem. It seems that
after r
OK. I don't recall having a problem with this before, but, how do I assign
a variable to a MySQL Bit field? I'm trying to set up a CheckBox that is on
my form, and I've tried variations of the following:
FirstTime.Checked = CBool(RS("FirstTime"))
FirstTime.Checked = CBool(RS("FirstTime").ToStri
I want to update new column in a table with data from other tables.
The following query give me the data:
select t.id,min(r.starttime)
from teams as t
inner join rider_team as rt on (rt.team_id=t.id)
inner join participants as p on (p.rider_id=rt.rider_id)
inner join races as r on (r
I concede to the MySQL engineer :-)
-Original Message-
From: Shawn Green [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 3:30 PM
To: Jonathan Langevin
Cc: Chris White; Richard Reina; mysql@lists.mysql.com
Subject: Re: Does Update allow for aliases?
Hi all,
Multi-table update
On Wed, 2007-01-17 at 11:47 -0600, Peter Brawley wrote:
> Daniel,
>
> CREATE TABLE tbl (
> lab_number int(11) default NULL,
> result int(11) default NULL,
> release_time datetime default NULL
> );
> select * from tbl;
> +++-+
> | lab_number | result |
Daniel,
CREATE TABLE tbl (
lab_number int(11) default NULL,
result int(11) default NULL,
release_time datetime default NULL
);
select * from tbl;
+++-+
| lab_number | result | release_time|
+++-+
|
On Wed, 2007-01-17 at 09:56 -0600, Peter Brawley wrote:
> Daniel,
>
> >find the lab_number where ALL the tests have been performed and
> >not the lab_numbers which have partial results.
>
> SELECT t1.lab,t1.res,t1.dt
> FROM tbl t1
> WHERE NOT EXISTS(
> SELECT lab FROM tbl t2 WHERE t1.lab=t2.lab
Daniel,
find the lab_number where ALL the tests have been performed and
not the lab_numbers which have partial results.
SELECT t1.lab,t1.res,t1.dt
FROM tbl t1
WHERE NOT EXISTS(
SELECT lab FROM tbl t2 WHERE t1.lab=t2.lab AND t2.res IS NULL
);
The decorrelated version uses an exclusion join, r
Sorry about the last email, sent it before I finished it. As I was saying...
Just so I'm straight on this. You want to select 20 random people, then select
one random picture for each of those 20 people,
ending up with 20 random pictures, each from a different account
Your query I'm pretty sure
Just so I'm straight on this. You want to select 20 random people, then select one random picture for each of those 20 people,
ending up with 20 random pictures, each from a different account
Your query I'm pretty sure gives you all pictures from the 20 random accounts,
ordered randomly.
If we
I have a table with numerous columns but needing to perform a query
based on three columns:
Lab_number, result, release_time.
What I want to do is search for lab_number where there is a result but
not released. The problem that is making this difficult for me, is that
there are multiple entries
Hello All,
Our queries were running fine on MySQL 4.1.11. Since we upgraded to MySQL
5.0.22 The same queries are taking a long long time to execute.
Running an explain on the queries shows an index_merge in the type column.
And it shows using intersect algorithm in Extra column of the output.
28 matches
Mail list logo
