Hi Shawn:
Just wanted to publicly thank you for the time you took to help me. I think
that it is important that guys like yourself who take time out from your busy
work be appreciated when their solution made a huge difference.
I was developing an ASP application along with Crystal reports for
Hi listers
1. environment
[EMAIL PROTECTED] ~> uname -a
Linux myhost.mydom.tld 2.6.12-1.1390_FC4_cubbi4_swsusp2 #1 Sat Jul 9
12:34:47 CEST 2005 i686 i686 i386 GNU/Linux
[EMAIL PROTECTED] ~>
2. mysql
[EMAIL PROTECTED] ~> rpm -qa |grep -i mysql
MySQL-server-4.1.14-0
MySQL-shared-4.1.14-0
MySQL-
On Oct 28, 2005, at 1:06 AM, BÁRTHÁZI András wrote:
I'm new on this list, so a very short intro about me: I'm Andras
Barthazi, a Hungarian web developer. I like MySQL very much, I'm
using it since 3.x versions, so I think I know it very well. But...
I'm new to everything, but I can tell you
Shawn,
That's a very reasonable answer. Thanks for pointing me to the
examples. This one addresses the second question:
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.
html . There is no example answering both questions in one query.
Regards,
Bill
__
on 10/28/05 5:52 AM, Brent Baisley at [EMAIL PROTECTED] wrote:
> You can nest the IF statement, putting another where 'soon' is like
> Jasper suggested. Or you can use the CASE WHEN THEN construct if you
> have a lot of conditions you need to check for.
Can you show me an example of the CASE meth
Gleb Paharenko wrote:
Follow links which have been meant in the error log. Resolve the
stack trace and send it to the list. See:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
I of course attempted to do that before asking for help. Though I
compiled mysql with debug enabled, there
[EMAIL PROTECTED] wrote:
"Michael J. Pawlowsky" <[EMAIL PROTECTED]> wrote on 10/28/2005 11:28:42
AM:
When creating an index in phpMySQL I get a warning message about having
2 indexes using the same field.
The table is simply a product comment table.
The first index is simply an INDEX on
Flavio Gonçalves wrote:
I want to permit only MyISAM tables to be created in my server. How can I
disable all the other engines?
Put:
skip-innodb
skip-bdb
in your my.cnf file, [mysqld] section.
Mihail
--
Mihail Manolov
Government Liquidation, LLC
Special Projects Leader
202 558 6227
--
--- [EMAIL PROTECTED] wrote:
> <<<>>>
>
> David, is it at all intuitive to organize your
> geography into a tree-type
> structure? Here is an example:
>
> Western Hemisphere (hemisphere)
> C. America (continent)
> Guatemala (country)
> N. America (continent)
>
Thankyou sheeri kritzer
You win an all expenses paid trip around David Launge :-)
hahaha
cheers
Ben
> OMG,
> Very sorry for my stupidness
> I new it would be something stupid, it was cut and pasted from a website so
> I dont have
> to take all the blame as it should have just worked, aye
OMG,
Very sorry for my stupidness
I new it would be something stupid, it was cut and pasted from a website so I
dont have
to take all the blame as it should have just worked, aye...aye?
lol, thankyou very much
Ben
;-)
> Yes, you need to add a second close parenthesis at the e
I'm not sure if this will help you, but it might:
http://jeremy.zawodny.com/blog/archives/000173.html
(brief excerpt)
"So the moral of the story is this: If you have a busy server that's
getting a lot of quick connections, set your thread cache high enough
that the Threads_created value in SHOW S
"Bill Adams" <[EMAIL PROTECTED]> wrote on 10/28/2005 01:49:28 PM:
> All,
>
> In the following query, some of the values are averaged over several
> rows, but some are not:
>
> SELECT hostname, volname, qtreename, round(avg(used/allocated*100),0),
>round(avg(used)), allocated, available
>
Yes, you need to add a second close parenthesis at the end -- you
close the parenthesis for password('guestbook') but not for the
values('localhost',. . .
-Sheeri
On 10/28/05, Ben <[EMAIL PROTECTED]> wrote:
> hey,
>Could you tell me someone please why this simple setup wont work!
> I am u
Hello.
> What am I missing? I installed MySQL using the installer package.
Usually installer has run mysql_install_db, but if you still want to
rerun it, invoke mysql_install_db with --user=mysql option under the
root account, and fix possible issues with the rights using 'chmod' later.
Hello.
Do you have your Slave is still trying to reconnect? If yes, are
you sure that you don't have network problems?
> I have a script checking for when the replication fails but that does
>not include this type problem. Is this a bug in replication or do I
>need to update my script to
Hello.
Use ft_stopword_file system variable. See:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
Merlin wrote:
> Hi there,
>
> as mysql docs describe, there is a stop words table by default:
> http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html
>
>
Hello.
Follow links which have been meant in the error log. Resolve the
stack trace and send it to the list. See:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
Don Doumakes wrote:
> I'm installing MySQL 4.1.14 on a new Gentoo box. When I try to connect
> to the mysqld daemon,
Ben wrote:
hey,
Could you tell me someone please why this simple setup wont work!
I am using SuSE9.3 and trying to set this up:
$ mysql -uroot -e"insert into user(Host,User,Password)
values('localhost','guestbook',password('guestbook')" mysql -p
$ mysql -uroot -e"insert into user
All,
In the following query, some of the values are averaged over several
rows, but some are not:
SELECT hostname, volname, qtreename, round(avg(used/allocated*100),0),
round(avg(used)), allocated, available
FROM quota_entries
WHERE date_sub(now(), interval 1 day) < time
We have MySQL running on a Redhat server (RHEL 3.2). We issued a
service mysql
restart yesterday and for some reason MySQL didn't shut down properly.
The init
script said it "gave up waiting" and deleted the PID file anyway. Since
we issued a restart,
I suspect a second copy of MySQL got star
<<<>>>
David, is it at all intuitive to organize your geography into a tree-type
structure? Here is an example:
Western Hemisphere (hemisphere)
C. America (continent)
Guatemala (country)
N. America (continent)
Canada (country)
hey,
Could you tell me someone please why this simple setup wont work!
I am using SuSE9.3 and trying to set this up:
$ mysql -uroot -e"insert into user(Host,User,Password)
values('localhost','guestbook',password('guestbook')" mysql -p
this is the error:
$ ERROR 1064 (42000) at line 1:
"Michael J. Pawlowsky" <[EMAIL PROTECTED]> wrote on 10/28/2005 11:28:42
AM:
>
> When creating an index in phpMySQL I get a warning message about having
> 2 indexes using the same field.
>
> The table is simply a product comment table.
>
> The first index is simply an INDEX on the product_id to
Martijn van den Burg wrote:
Greetings,
I've been keeping track of Bytes_sent and Bytes_received for a while in
the fashion of 'mysqlreport': divide those values over Uptime in order
to obtain a data rate (bytes/sec).
The resulting graphs look like this:
|
|
| /| /|
|/ |/ |
|
Jigal van Hemert wrote:
Stefan Kuhn wrote:
Am Thursday 27 October 2005 12:56 schrieb Raphaël 'SurcouF' Bordet:
Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
I'm using it with four machines (geographically separate) and it works
fine. Stefan
And can writes on each ser
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> > ANIMALS TABLE
> > Canis_lupus | wolf
> > Panthera_tigris | tiger
> >
> > JOIN TABLE
> > SPECIES | ECOREGION
> > Canis_lupus | NA1008
> > Canis_lupus | NA1010
> >
> > ECOREGIONS TABLE
> > ID | NAME | Geog | Geog2
> > NA1008 | Alaska tundra | na
I want to permit only MyISAM tables to be created in my server. How can I
disable all the other engines?
Flávio Gonçalves
When creating an index in phpMySQL I get a warning message about having
2 indexes using the same field.
The table is simply a product comment table.
The first index is simply an INDEX on the product_id to speed up
displaying them when someone wants to lookup the comments for that product.
The s
Hi,
Is it a so hard, or a so easy question, that nobody answers it? :) Or just
should wait some more hours, and don't hurry so much? ;)
Bye,
Andras
So, I started learning, how MySQL 5.0 handles character sets. It is, what I
think about it:
character_set_client | latin1
This is, what
"Simon Longstaff" <[EMAIL PROTECTED]> wrote on
10/28/2005 10:50:24 AM:
> I'm trying to run this :
>
> SELECT DISTINCT A.B_IP FROM w3t_Posts A , w3t_Users B WHERE A.B_PosterID
=
> B.U_Number and B.U_Username = 'user1'
> UNION
> SELECT DISTINCT C.B_IP FROM w3t_Posts C , w3t_Users D WHERE C.B_Pos
I'm trying to run this :
SELECT DISTINCT A.B_IP FROM w3t_Posts A , w3t_Users B WHERE A.B_PosterID =
B.U_Number and B.U_Username = 'user1'
UNION
SELECT DISTINCT C.B_IP FROM w3t_Posts C , w3t_Users D WHERE C.B_PosterID =
D.U_Number and D.U_Username = 'user2'
and it's failing saying
SQL Error:
sheeri kritzer wrote:
> What is max_connections set to (my.cnf?)? How many connections are
> there at a time? (show processlist) That would result in a "too many
> connections" error, but it's worth a shot.
Max connections: 2000
typically 10-20 used (hardly ever >100).
> What is the thread cache
David Blomstrom wrote:
I have a PHP script that displays data like this:
Eurasia
Eurasiaisland
Africa
Where Eurasia and Africa are mainland parents of
ecological regions and Eurasiaisland is a
parent of an ecological system that is associated with
a continent. For example, Borneo would be
Eurasi
What is max_connections set to (my.cnf?)? How many connections are
there at a time? (show processlist) That would result in a "too many
connections" error, but it's worth a shot.
What is the thread cache set to?
-Sheeri
On 10/28/05, Johannes B. Ullrich <[EMAIL PROTECTED]> wrote:
>
> I am having
Sean, you definately got me :)
Your solution is simpler and much more elegant!
Had the visual aids here on paper, but I'm not as good
with the ascii art as you.
I definately learned something!
Thanks!
-Mike
--- [EMAIL PROTECTED] wrote:
> Mike, you did a wonderful job at analysis
> (identifyin
Mike, you did a wonderful job at analysis (identifying the 6 cases) but I
think a series of visual clues would have made a simpler query more
obvious. Here's how I understand the issue (I am a more visual thinker)
Start with the case of needing to see if a new record (NR) overlaps with
an exis
156 Oud wrote:
> Hi,
>
> I've got a very strange problem with one of my MySQL servers.
> I've got 2 dedicated servers with MySQL 4.0.21, all is fine there.
>
> My new server with MySQL-4.1.14 give me some headakes !
> Sometimes i've got errors like
> UPDATE command denied to user 'MyUser'@'192.16
Hi,
I've got a very strange problem with one of my MySQL servers.
I've got 2 dedicated servers with MySQL 4.0.21, all is fine there.
My new server with MySQL-4.1.14 give me some headakes !
Sometimes i've got errors like
UPDATE command denied to user 'MyUser'@'192.168.0.4' for table 'MyTable'.
Bu
I have a PHP script that displays data like this:
Eurasia
Eurasiaisland
Africa
Where Eurasia and Africa are mainland parents of
ecological regions and Eurasiaisland is a
parent of an ecological system that is associated with
a continent. For example, Borneo would be
Eurasiaisland.
The finished s
I am having a very odd issue with one of my mysql 4.1.14 servers.
Randomly, the server returns "permission denied" to queries even if
identical queries succeeded within the same connection.
To test the problem, I setup a script that connects to the database, and
issues the same query 50,000 times
You can nest the IF statement, putting another where 'soon' is like
Jasper suggested. Or you can use the CASE WHEN THEN construct if you
have a lot of conditions you need to check for.
On Oct 28, 2005, at 12:22 AM, Scott Haneda wrote:
on 10/27/05 6:34 PM, Scott Haneda at [EMAIL PROTECTED]
Greetings,
I've been keeping track of Bytes_sent and Bytes_received for a while in
the fashion of 'mysqlreport': divide those values over Uptime in order
to obtain a data rate (bytes/sec).
The resulting graphs look like this:
|
|
| /| /|
|/ |/ |
| / | /
| / | /
| /|
Hi!
LMS wrote:
Jeff Smelser escribió:
On Wednesday 26 October 2005 04:24 pm, LMS wrote:
Hi,
I have this structure:
---
CREATE TABLE tabla (
id int(10) unsigned NOT NULL auto_increment,
nombre varchar(100) NOT NULL default '',
because your d
Hi Brent,
Wow, it seems like you are going to extremes. To jump from myisam to
heap is a big step. Did you try using InnoDB? It would handle locking
issues much better since it doesn't lock the table. Heap tables can
be pretty dangerous since it's all in memory. If the machine crashes,
yo
Hi Merlin,
you can create your own stopword file (one word per line) and activate it
in my.cnf like this:
# The MySQL server
[mysqld]
set-variable= ft_stopword_file=/etc/my.stopwords
HTH,
Thomas
On Fri, 28 Oct 2005, Merlin wrote:
> Hi there,
>
> as mysql docs describe, there is a stop wo
Hi there,
as mysql docs describe, there is a stop words table by default:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html
Does anybody know how to add a german table ( I guess there is an
equivalent to the engl. one)?
Does this also work with MySQL 4.0.18?
Thank you for any hel
George,
there seem to be two bottlenecks:
1) InnoDB has contention on the buffer pool mutex;
2) the workload is also disk-read-bound.
For 1), we might have an improvement available in the future. We must let
the threads leave the 'wait array' in sync0arr.c without reserving the wait
array mut
48 matches
Mail list logo
