Hi,
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...
So, I started learning, how MySQL 5.0 handles character sets. It is, what
I think about
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
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
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
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,
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
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:
|
|
| /| /|
|/ |/ |
| / | /
| / | /
| /|
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]
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.
I have a PHP script that displays data like this:
Eurasia
Eurasiasupisland/sup
Africa
Where Eurasia and Africa are mainland parents of
ecological regions and Eurasiasupisland/sup is a
parent of an ecological system that is associated with
a continent. For example, Borneo would be
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'.
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.168.0.4'
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
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
(identifying
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 a
David Blomstrom wrote:
I have a PHP script that displays data like this:
Eurasia
Eurasiasupisland/sup
Africa
Where Eurasia and Africa are mainland parents of
ecological regions and Eurasiasupisland/sup is a
parent of an ecological system that is associated with
a continent. For example, Borneo
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 set
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
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_PosterID
=
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,
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
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
--- 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 | na
IM1003 |
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
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:
|
|
| /| /|
|/ |/ |
|
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 speed up
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 -einsert into user(Host,User,Password)
values('localhost','guestbook',password('guestbook') mysql -p
this is the error:
$ ERROR 1064 (42000) at line 1:
Everything snipped
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)
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
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)
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 -einsert into user(Host,User,Password)
values('localhost','guestbook',password('guestbook') mysql -p
$ mysql -uroot -einsert into user
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,
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
Does
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.
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.
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 using
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
FROM
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
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
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,
--- [EMAIL PROTECTED] wrote:
Everything snipped
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)
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:
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
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
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
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 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
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
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
49 matches
Mail list logo