Hi!
On Dec 16, Ken Johanson wrote:
Hi all,
Does anyone know fo a way to run the server in more of a string-quoting
standards compliant mode, so that a generic SQL string quoting function
only has to escape single quotes, instead of also '', '\', and '\0'?
I've tried the ANSI_QUOTES
Hi!
On Dec 17, Sergei Golubchik wrote:
On Dec 16, Ken Johanson wrote:
Hi all,
Does anyone know fo a way to run the server in more of a string-quoting
standards compliant mode, so that a generic SQL string quoting function
only has to escape single quotes, instead of also '', '\',
Hi,
I came across this term several times while reading about character set
and collation handling, e.g. in the last paragraph of the online manual
section 10.3.2 (http://dev.mysql.com/doc/mysql/en/Charset-database.html):
The character set and collation for the default database are available
John, Harrison,
- Original Message -
From: John McCaskey [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 17, 2004 3:33 AM
Subject: Re: Relative efficiency (in terms of disk io) between REPLACE and
Ahhh, thats very good to know. Thank you.
On Wed, 2004-12-15
Daniel,
- Original Message -
From: Daniel Andersen [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 17, 2004 2:04 AM
Subject: Weird load issues
Hey,
A couple days ago my SQL server started hogging the entire CPU for no
reason
that I can find. I'm running
Gleb Paharenko wrote:
What output does the following command produce?
myisamchk -dvv host.MYI
the result is:
myisamchk: File '/usr/share/mysql/charsets/italian.conf' not found (Errcode: 2)
myisamchk: Character set '#'83' is not a compiled character set and is not
specified in the
mos wrote:
At 12:05 PM 12/13/2004, you wrote:
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive,
and simple index searches that should be instant will wait and wait
and wait before responding.
I dont want one user to kill
Are you sure innodb is better for tables larger than 4 gig?
| 12 | xotech | localhost:3115 | finlog | Query | 238224 | copy to tmp
table | alter table bragg_stat engine=innodb pack_keys=0 |
| 14 | xotech | localhost:3356 | NULL | Query | 0 |
NULL |
No InnoDB here, just some old ISAM tables.
Sorry about my stupidity on this one, I have only myself to blame...
I have a bunch of old-school ISAM tables that need to be converted to
MyISAM, is there any way to do this en-masse?
(I.E. not having to go through each DB in the DBMS and
ALTER TABLE
Hello.
I searched a while but could not find an explanation.
So the question remains:
what is the default database?
See:
http://dev.mysql.com/doc/mysql/en/mysql_select_db.html
Dr. Frank Ullrich [EMAIL PROTECTED] wrote:
Hi,
I came across this term several times while
Hello.
Does that imply that if we set this flush_time value to zero (ie no
periodic flush to disk), then some of the data will not be committed to
disk, and if we had a subsequent power failure, then any data since the
last flush would be lost? We have innodb_flush_log_at_trx_commit set to
Hello.
Your MySQL distribution doesn't have support for BDB.
What do I need to do to enable BDB support on the system that
currently does not have it?
See:
http://dev.mysql.com/doc/mysql/en/BDB_install.html
sol beach [EMAIL PROTECTED] wrote:
I have two systems running mysql
It's the one you're using at that moment. That is, it's the one you don't
have to explicitly mention to access its tables. If you connect with
mysql [options] db1
or issue a
USE db1
command, then db1 is the default database.
This is in the manual http://dev.mysql.com/doc/mysql/en/USE.html.
I guess that translates (for those users not using the C API) to mean
whatever database was last USEed ? So if I say USE Mydatabase, is
Mydatabase now the default database or does the concept of default
database only apply to those users using the C API?
Shawn Green
Database Administrator
Thanks!!! Yes, I found the bug on it, but it looks like its not working
yet Is the bug simply no updated to show the fix perhaps?
ken
Sergei Golubchik wrote:
Hi!
On Dec 17, Sergei Golubchik wrote:
On Dec 16, Ken Johanson wrote:
Hi all,
Does anyone know fo a way to run the server in more of a
please check the my.cnf parameters with recommended values given in
my_huge.cnf file in support files.
to my knowledge For 2 GB RAM values you set are very high. I think system
is going for heavy swapping that might be the
reason it is going very slowly.
Anil
-Original Message-
Gleb Paharenko wrote:
Hello.
I searched a while but could not find an explanation.
So the question remains:
what is the default database?
See:
http://dev.mysql.com/doc/mysql/en/mysql_select_db.html
While it does explain default database, that page documents a function in
the Mysql C API. That
Gleb
- Original Message -
Hello.
Does that imply that if we set this flush_time value to zero (ie no
periodic flush to disk), then some of the data will not be committed to
disk, and if we had a subsequent power failure, then any data since the
last flush would be lost? We have
Have you tried posting this to the PHP general mailing list?
Respectfully,
Ligaya Turmelle
---
Life is a game... so have fun.
---
www.PHPCommunity.org
Open Source, Open Community
Visit for more information or to join the movement
Fernando F. Retagi wrote:
Hi All!
I have installed mysql 4.0.20
Tried the build 5.0.2-alpha-nt:
select 'te\''st' returns te''t
and
select 'te\'''st' causes a fast server crash:
-ken
(the function symbols are missing so a stacktrace is a bit hard)
Application exception occurred:
App: (pid=1188)
When: 12/17/2004 @ 09:07:05.253
Exception
Can you post your my.ini or my.cnf
sense your restore actually worked
Mine is not swapping, in fact, mysql is only using 610,824 K of ram,
there is still over 1 gig of ram free
Our next server will have 16 gig of ram and quad xeons, I'm going to
completely disable the swap files
--
MySQL
Hi, I have solved .. I have writed in 'Index' file:
cp1251 83
still thanks, thanks gelbs !!. :-))
Salvatore.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 16, 2004 6:39 PM
Subject: Re: No connect to mysql
Hello.
[EMAIL
Hello.
Oops, yes, perhaps I was thinking about some[body] else while answering %-)
Sure, the last USEd database is the default one and that's a simplier
way to understand the concept of a default database. Thank you.
And it's friday! :-)
[EMAIL PROTECTED] wrote:
I guess that
I have an installation of 4.1 and 5 running on the same test server... I
want to start using 5 for testing but still want to use the same test data
I had before... Is it possible to simply point MySQL 5 to the old 4 data
dir?
--
MySQL General Mailing List
For list archives:
I'm using MySQL 4.1.7 and need to create a column to store date and
time. Also, I need to be able to update the column with something like:
update machines set update3_status='y', update3_time=SOMETHING;
I don't want update3_time to be automatically changed any time another
column changes.
Description:
Mysql 4.1.8 installs libmysqlclient as libmysqlclient.14.0.0 instead
of libmysqlclient.so.14.0.0 which is the correct for Linux.
How-To-Repeat:
make install
Fix:
Correct the installation process
Submitter-Id: submitter ID
Originator:
On Fri, 17 Dec 2004 16:19:25 -0200 (BRST)
[EMAIL PROTECTED] wrote:
Description:
Mysql 4.1.8 installs libmysqlclient as libmysqlclient.14.0.0
instead of libmysqlclient.so.14.0.0 which is the correct for
Linux.
I wish you were about 1/2 hour faster, I just finished
I am new to MySQL and have an odd problem of which I am hoping someone can
assist. I am attempting to insert data into my db using C++ and the C-API.
The database connects fine, and I can get a select statement to return data,
but the insert will not work from the program. I then had the
You have 4 options for storing datetime values:
You can use an UNSIGNED INTEGER column to store the # of seconds since
EPOCH
You can use a CHAR or VARCHAR column to store any arbitrary string
(including a string that looks like a formatted date)
You can use a DATETIME field
You can use a
I can't seem to make the Load Data statement work inside of a stored procedure.
ie
LOAD DATA LOCAL INFILE file.txt INTO my_table
this works fine in PHP, but when I use it in a procedure, and pass in
the file name as a parameter, it won't compile.
LOAD DATA LOCAL INFILE fileParameter INTO
Jason Joines wrote:
I'm using MySQL 4.1.7 and need to create a column to store date and
time. Also, I need to be able to update the column with something like:
update machines set update3_status='y', update3_time=SOMETHING;
I don't want update3_time to be automatically changed any time
Does anyone know what Column Type the result of the Year() function is?
In other words, if I execute:
select Year(Hiredate) as mycolname
from mytable;
is the result a smallint? a char()? a varchar()?
Unfortunately, the manual doesn't say and I can't think of a quick way to
figure it out
hi,
i want to use an udf function that lives in a library A that is
dynamically linked against another library B. when running `create
function...' i get error 1126, an undefined symbol in lib A that lives
in lib B. when checking A with ldd, all seems ok (lib B is shown and no
unresolved symbols
At 03:24 PM 12/17/2004, you wrote:
Does anyone know what Column Type the result of the Year() function is?
In other words, if I execute:
select Year(Hiredate) as mycolname
from mytable;
is the result a smallint? a char()? a varchar()?
Unfortunately, the manual doesn't say and I can't think of a
Rhino wrote:
Does anyone know what Column Type the result of the Year() function is?
In other words, if I execute:
select Year(Hiredate) as mycolname
from mytable;
is the result a smallint? a char()? a varchar()?
Unfortunately, the manual doesn't say and I can't think of a quick way to
figure it
Is there a correlation between myisam table file size and related .myi file
size ?
If I need to introduce additional index for some field in 40-50Gb table, would
there be any concerns about my.ini settings like key_buffer_size etc. Is it
possible to place index file to memory to speed up
Hello,
I have a mysql master and slave server. I use ibbackup to backup the
master nightly. I have the latest version of ibbackup and mysql version
4.0.21. Every time I run ibbackup the slave stops replicating. I have to
run the following commands twice...
SET GLOBAL SQL_SLAVE_SKIP_COUNTER =1;
Hi,
This is my first post so I hope I've done it right. I am having trouble
querying an email address from MySQL and then placing that field into the
PHP mail function. It doesn't work. Here's my code:
$query_string = SELECT Email FROM instructors WHERE HSA_NO = '$insthsaid';
$result =
MySQL Manual
A.7.3 TEMPORARY TABLE
You cannot refer to a TEMPORARY table more than once in the same query.
Anything in the works to fix this pretty major limitation?
Also, any chance of being able to specify wildcards in table names in
GRANT statements any time soon? E.g.
GRANT ALL ON
Jason,
- Original Message -
From: Jason Davis [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, December 18, 2004 1:23 AM
Subject: ibbackup and mysql slaves
Hello,
I have a mysql master and slave server. I use ibbackup to backup the
master nightly. I have the latest
40 matches
Mail list logo