Follow is a part of my my.ini.
---
[client]
port=3306
default-character-set=utf8
---
If "
Ok greg,
I'll report this bug
Thx
Greg 'groggy' Lehey wrote:
On Wednesday, 16 November 2005 at 20:40:35 +0700, Ady Wicaksono wrote:
I have MySQL with about 12 billion rows when i try to create 2
process, each select count(*) on the same table after a long
time about 30 minutes it crash
[EMAIL PROTECTED] wrote:
I have an idea for preventing sql injection attacks, however it would
have to be implemented by the database vendor. Let me know if I am on
the right track, this totally off base, or already implemented
somewhere...
Lets say you could have a format string such as in pr
I have an idea for preventing sql injection attacks, however it would
have to be implemented by the database vendor. Let me know if I am on
the right track, this totally off base, or already implemented
somewhere...
Lets say you could have a format string such as in printf
$format=" SELECT %s
Your query was:
SELECT distinct accomodation.accom_id FROM accomodation LEFT JOIN
student_accom ON accomodation.accom_id = student_accom.accom_id where
((student_accom.start_date Between '2005-10-01' And '2005-11-30') OR
(student_accom.leave_date Between '2005-10-01' And '2005-10-30'))
The logic:
Hi There,
We are reaching 4GB with one of our tables (v4.1 on debian sarge) and
are needing to run:
ALTER TABLE tbl_name MAX_ROWS=10 AVG_ROW_LENGTH=nnn;
as per the documentation.. I would be greatful for any input on best
practices to do this, as the database needs to be offline for
...that is the question.
I have some queries that would possibly benefit from subqueries,
which means upgrading my stock Mac OS X Server 10.3.9 installation of
MySQL (version 4.1.10a).
The question is, and I would appreciate any comments, should I go
just to 4.0.26 for the subqueries, or
Hi Marc,
I would be a bit suspicious of the version of zlib or something similar.
If it has only been compiled with a 32bit compiler, this could be
causing an artificial limit of 2Gb on a pointer.
The ARCHIVE engine uses the zlib for its compression, that comes with
mysql. I am presuming if it ha
C.R.Vegelin wrote:
Hi All,
I have a "simple" problem and hope you can help me.
I have an input table Updates with various fields, incl. Month and MonthlyValue.
The field Updates.Month ranges from 1 to 12.
I also have a target Data table with 12 fields, called Jan, Feb, Mar, ... `Dec`.
Depending o
> Is there any message in the log files? or any error
> message from the OS?
David -
When the mysqld process restarts, there is nothing in
the logfile except the basic startup info. I have
listed it below:0:33).
051116 10:06:33 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '5.0
Hi Mikhail,
I may not have been precise in my question, but the Unique Index in
question is a two fields index, and I was looking to find out wisdom
from the List if there is sense and/or experience in keying second(left)
field on in the Unique Index to speed up a search.
If you have a UNIQUE(
Mikhail,
>Is it possible or makes sense to key a field that is a part of
Unique
>Index already?
MySQL won't stop you, but it's a waste of space & cpu cycles unless
there's a high-priority query performance need for it.
PB
-
Mikhail Berman wrote:
Hello everyone,
Is it possible or
On 17-Nov-05, at 2:41 PM, [EMAIL PROTECTED] wrote:
René Fournier <[EMAIL PROTECTED]> wrote on 11/17/2005 04:19:25 PM:
OK, after reading http://dev.mysql.com/doc/refman/5.0/en/order-by-
optimization.html I have learned improved the speed somewhat by
creating a multi-column index on account_id
Hi Marc,
Is there any message in the log files? or any error message from the OS?
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mar
Marc:
Define "crashing the server". Does the whole machine shut down? The
mysqld process? What do error logs say? What version of MySQL are
you using? What's the create table statement? what's the current
avg_row_length and max_rows? What is ulimit -f as the MySQL user say?
-Sheeri
On 11/
What does your my.cnf configuration for mysql say? Check out:
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
I think you want "character_set" as your variable, not "default_character_set".
Just my guess, not seeing any of your config files.
-Sheeri
On 11/16/05, wangxu <[EMAIL
René Fournier <[EMAIL PROTECTED]> wrote on 11/17/2005 04:19:25 PM:
> OK, after reading http://dev.mysql.com/doc/refman/5.0/en/order-by-
> optimization.html I have learned improved the speed somewhat by
> creating a multi-column index on account_id and time_sec, such that:
>
> --
Dear Jasper,
I may not have been precise in my question, but the Unique Index in
question is a two fields index, and I was looking to find out wisdom
from the List if there is sense and/or experience in keying second(left)
field on in the Unique Index to speed up a search.
I am dealing with 32M ro
OK, after reading http://dev.mysql.com/doc/refman/5.0/en/order-by-
optimization.html I have learned improved the speed somewhat by
creating a multi-column index on account_id and time_sec, such that:
--
SELECT date_
Mikhail Berman wrote:
Is it possible or makes sense to key a field that is a part of Unique
Index already?
It's possible, but it doesn't make sense. A unique index is a normal
index with an added unique constraint. Adding another index on the same
field would make no sense (unless the field
Hello everyone,
Is it possible or makes sense to key a field that is a part of Unique
Index already?
Regards and thank you
Mikhail Berman
Oskar Joelson wrote:
I found this in
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
:
"REGEXP and RLIKE use the current character set (cp1252 Latin1 by
default) when deciding the type of a character. Warning: These
operators are not multi-byte safe."
"These operators ar
Hi!
I hope this is the right mailing list for my problem. :)
I recently changed the collation/character set in the whole database
for a project I'm working on to utf8. After a while I realized that
REGEXP didn't work as it used to. I looked in the manual and saw that
REGEXP was not multibyte safe
Hello.
I've written a stored procedure that can help you. However, I'd like to
see a solution which will work for 4.1 as well.
Here is the results. First group is select from the original table,
second group is select from the temporary table with the results.
id value
1 10
I have the following table:
CREATE TABLE history (
id int(10) unsigned NOT NULL auto_increment,
time_sec int(10) unsigned NOT NULL default '0',
account_id int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id),
KEY account_id (account_id),
KEY time_sec (time_sec),
) TYPE=MyISAM AUTO
Hi Rick,
Below are some MySQL functions that might help with your problem.
Sorry, for not much of direct answer.
But the idea is that you can combine some of these (string) functions ->
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html to parse
out the string you are looking for. If
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
---
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for compa
Rick
>I need to read the first 4 positions in the phone number to determine
it's location.
>My statement looks like this:
>'Select mid(phone, 1,4) as phoneareacode from phonetable'
>This works but if the number is entered as 1(203)-555-1212 the above
would return "1(20" which is not >wha
I'm trying to execute a MySQL Stored Procedure from my ASP.NET page:
Cmd=New MySqlCommand("sp_InsertNewCamper",Conn)
Cmd.CommandType = CommandType.StoredProcedure
paramReqID = Cmd.Parameters.Add("return",SqlDbType.Int)
paramReqID.Direction = ParameterDirection.ReturnValue
Cmd.Parame
The fact that the data is coming from the text logs doesn't really change
anything; _something_ is generating the text logs so that something could be
changed to force users to supply phone numbers in whatever format you want.
Of course, that doesn't mean _you_ can force those changes to take p
Hello.
At least there is one verified crash of MySQL Administrator on Mac OS,
however, not during the connection process:
http://bugs.mysql.com/bug.php?id=14269
You have a good description of your problem, and may want to report it at:
http://bugs.mysql.com
Yves Goergen wrote:
Hello.
I haven't said that this is the most effective solution, however, in my
opinion it should work :)
Fan, Wellington wrote:
> Gleb,
>
> Thanks; using REPLACE(), as I understand it, would require me to list ALL
> non-alpha characters, and assuming just ASCII characters, approx (127
Hello.
> 051116 16:27:54 [ERROR] Fatal error: Can't open and lock privilege
tables:=
> Table 'mysql.host' doesn't exist
Have a invoked mysql_install_db? See:
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
Jörg Nowak wrote:
>
>
> Hello list,
>
> I compi
Hello.
>4. triggers reference another table
They're allowed as of MySQL 5.0.10. See:
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
Jenny Chen wrote:
>Does the current latest MySQL 5.0 support:
>1. column based triggers
>2. trigger restriction
>3. multiple triggers o
Unfortunately, the phone numbers come from text logs that get
imported into mysql. Because the phone number is often displayed on
a document for the customer, they will dictate how they want it to
appear (i.e. with ( ) etc.). The phone logs simply record those
values as they are so data
- Original Message -
From: "Rick Dwyer" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 17, 2005 10:28 AM
Subject: A bit of SQL help for a MySQL novice.
Hello All.
I am hoping for a bit of help with some code that has really given me
some trouble. If this is not he correct forum
Rick Dwyer <[EMAIL PROTECTED]> wrote on 11/17/2005 10:28:51 AM:
> Hello All.
>
> I am hoping for a bit of help with some code that has really given me
> some trouble. If this is not he correct forum for this any help in
> pointing me to a more suited list would be appreciated.
>
> I have a My
Not sure what you are asking for. If you are trying to get the
opposite of what you are getting, try adding
AND student_accom.start_date IS NULL
to the end of the query. You can actually use just about any field
instead of start_date.
For easier readability, you can rephrase your query to
Hello All.
I am hoping for a bit of help with some code that has really given me
some trouble. If this is not he correct forum for this any help in
pointing me to a more suited list would be appreciated.
I have a MySQL 4.1.x database containing records with phone numbers.
Most of the phon
Hi, and thank you both for valuable tips.
The MySQLd in question runs on a mailserver, and a large amount of
processes (Postfix, Maildrop and Squirrelmail) connect to it, run one
or two simple queries, and then disconnects.
There is only one client that is constantly connected, namely a
uhh.NO!
That's what databases are for, to "remember" things. They do that by
writing data to disk and reading it back to you when you ask for it. What
exactly do you think you will be losing by stopping and restarting the
server daemon ("service" to you MS-types). What data do you think
Hi All,
I have a "simple" problem and hope you can help me.
I have an input table Updates with various fields, incl. Month and MonthlyValue.
The field Updates.Month ranges from 1 to 12.
I also have a target Data table with 12 fields, called Jan, Feb, Mar, ... `Dec`.
Depending on Updates.Month the M
I need to pass to a stored procedure a var a table name.
But I don't known how use the variable in the sql statement.
If I use the method described belowe I get an error, the procedure use the
variable name as the name of the table.
Someone can help ?
CREATE FUNCTION `myFunc`( tbl_name varchar(10
On Wednesday, 16 November 2005 at 20:40:35 +0700, Ady Wicaksono wrote:
> I have MySQL with about 12 billion rows when i try to create 2
> process, each select count(*) on the same table after a long
> time about 30 minutes it crashed :(
>
> ANy information?
>
> ...
>
> InnoDB: We intentionally
Yeah, sorry for that language, but I couldn't believe what I had just
read and lost it...
On 17/11/05, Peter J Milanese <[EMAIL PROTECTED]> wrote:
> Don't know if that's the word I'd use, but credibility is lost for that
> nonsense. No proffesionalism whatsoever. If I were admin I'd ban for less.
Don't know if that's the word I'd use, but credibility is lost for that
nonsense. No proffesionalism whatsoever. If I were admin I'd ban for less.
-
Sent from my NYPL BlackBerry Handheld.
- Original Message -
From: Raz [EMAIL PROTECTED]
Sent: 11/17/2005 05:08 AM
To: ky
Kyle, you're a twat for sending s**t like this to this list...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sheeri kritzer schrieb:
Hi folks,
You might be amazed getting answers that link right to the MySQL
documentation. The documentation is fabulous, but of course we cannot
memorize it! One tip I picked up in a MySQL course (which was worth
the $$ of the course itself), which is IMMENSELY useful,
Hello Gleb!
The answer to the scrambled characters in the shell und XP is, as you
assumed, that the shell simply does not handle characters like the
Windows-GUI does... .
Now, that I know about this fact it's no longer a problem ( perhaps a
feature, ;-) ?).
Thx again & have a good time,
Goetz
Scott Haneda wrote:
Hello, with the release of 5, I seem to have all dead links to my old docs
for mysql 4. The way they keep changing the urls is a little maddedning :-)
I usually search using: http://www.mysql.com/
http://www.mysql.com/subquery will lead to:
http://dev.mysql.com/doc/refman/
on 11/16/05 7:06 PM, Jasper Bryant-Greene at [EMAIL PROTECTED] wrote:
> Scott Haneda wrote:
>> Google this:
>> subselect site:dev.mysql.com
>> And I get mostly non English stuff, limiting to english and I get a whopping
>> 37 pages, none of which seem to help me much.
>
> Try googling for "subqu
51 matches
Mail list logo
