Rhino [EMAIL PROTECTED] wrote on 21/02/2004 16:59:27:
I am new to most aspects of MySQL administration so I was wondering
if someone can help me figure out what GRANTs I need for a
particular situation.
I have a user who needs to be able to run some MySQL scripts that
create and load
Karam Chand [EMAIL PROTECTED] wrote:
Hello
I am CS student. I want to understand the architecture
and code of MySQL (guess the subjects says it
all)...What do you think will be the best place to
start off?
Download and install BitKeeper. Then clone MySQL manual with command:
bk
Karam,
I am CS student. I want to understand the architecture
and code of MySQL (guess the subjects says it
all)...What do you think will be the best place to
start off?
Any docs on the architecture of MySQL?
You may want to have a look at internals.texi. As its name implies,
this is a
mark warren bracher [EMAIL PROTECTED] wrote:
heh, sometimes the obvious is right in front of you...
I still can't get the full dataset to load with indexes on the table,
but I _can_ apply indexes after the load. the indexes apply cleanly, so
it doesn't seem to have been a data issue. in
Hi All,
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql select 'This is a' || ' test string';
+---+
| 'This is a' || ' test string' |
+---+
Title: Bug on MYSQL-5.0 in statement OPTIMIZE TABLE
Hi,
TABLE CREATE DESCRIPTION :
CREATE TABLE T1(IDAP INT(16),TVAL INT(2),CH_VAL_SEC INT(16),INDEX(IDAP),INDEX(TVAL),INDEX(CH_VAL_SEC));
RUNNING CONDITIONS:
-use persistent connection.
RUNNING SEQUENCE:
1-Open 1-st connection.
I get the same thing on our system (MySQL 4.0.15 running on Linux Mandrake
9.1).
According to the manual, section 1.8.4:
MySQL Server understands the || and operators to mean logical OR and
AND, as in the C programming language. In MySQL Server, || and OR are
synonyms, as are and AND. Because
Hassan Shaikh [EMAIL PROTECTED] wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql select 'This is a' || ' test string';
+---+
| 'This is a' || ' test string' |
Hi,
I have written in intermediate, on the appropriate position in this
discussion, please go thru in full.
--- Michael Widenius [EMAIL PROTECTED] wrote:
hi!
A == Arunachalam [EMAIL PROTECTED] writes:
A As per my searching I have found the right C API in libmysql.lib from
A MySQL
Hi, Sasha:
I got replication working now. Thanks veryyy much for your suggestion.
Liying
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How are you ensuring syncronization between the ram disk and the HD? Is
there a writeback / writethrough mechanism for ram disks? Are you not
risking major data loss if ever you have a power failure or PC failure?
Thanks for the info!
Eric
Mark Maunder [EMAIL PROTECTED] wrote in message
Donny Simonton [EMAIL PROTECTED] writes:
But as a manager, the first thing I do is ask for code examples, as well as
table structures. I don't even need to see a resume once I look at
somebody's code and table structures.
Unfortunately I will have to disagree with you on this one. Having
Can anyone offer advice?
I have come across a MySQL database on Linux with duplicate table names - Accounts
and accounts. This seems fine on Linux, but does not transfer to the Windows
environment - it is rejected because of the duplicate name. However I do see that
Column Names have to be
Hi Christof,
You don't mention the OS version you are using (So I will assume
Linux) is there a sysctl for the max number of threads on your OS?
Ken
- Original Message -
From: Christof Egner [EMAIL PROTECTED]
To: James Kelty [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday,
Set this in you're my.cnf and restart and see if that solves your problem.
open-files-limit=36864
*** Don't ask me what that number is, it's just a random number.
Donny
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 10:20 AM
To:
Tim Hayes said:
Can anyone offer advice?
I have come across a MySQL database on Linux with duplicate table
names - Accounts and accounts. This seems fine on Linux, but
does not transfer to the Windows environment - it is rejected
because of the duplicate name. However I do see that Column
Hi,
we have a big problem with inserting large amounts of data (2GB) into our MyISAM
databank (version 4.0.12).
The dataset is loaded in using
LOAD DATA infile 'bla' ignore into table tab fields terminated by ' ' optionally
enclosed by '' (int1, int2, int3, date);
The format of the text file
Tim Hayes [EMAIL PROTECTED] wrote on 23/02/2004 16:15:36:
Can anyone offer advice?
I have come across a MySQL database on Linux with duplicate table
names - Accounts and accounts. This seems fine on Linux, but
does not transfer to the Windows environment - it is rejected
because of
OK
There is still the possibility of an in-compatability between the 2
platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not
recognized / updateable using the set command!
I get - Unknown system variable 'lower_case_table_names'
Tim Hayes
- Original Message
Dear Brad,
Your problem is too much experiences not the lack of skills.
I am in the same situation...it is very frustating.
Regards,
Bernard
On Monday 23 February 2004 11:14, Brad Eacker wrote:
Donny Simonton [EMAIL PROTECTED] writes:
But as a manager, the first thing I do is ask for code
Hi!
Please observe the following about InnoDB table names on Windows:
http://www.innodb.com/ibman.php#Moving
On Windows InnoDB stores the database names and table names internally
always in lower case. To move databases in a binary format from Unix to
Windows or from Windows to Unix you should
Hello,
This is a long post, my apologies.
I have been working on migrating a database from MS SQL to MySQL for about 1
month now and am at a point where I can start running some tests to see how
they compare. I'll provide a little background to help you out.
The MS SQL database is 120million
Hi Chris,
Chris Fossenier wrote:
This is a long post, my apologies.
Speaking for myself, I found the detail most helpful. Thanks!
See response at bottom.
...snip...
QUERY1
~~~
Indexed Fields (link, phone_pander,state, exact_age, estimated_age, phone,
first, last, address)
MS SQL QUERY
hi,
I have the same problem with executing mysql_install_db in mysql 4.1 after
compiling it on debian 3.0, lust like Bug #2915 installation of grant tables
failed!
after sucessfully configure (./configure --prefix=/usr/local/mysql
--with-innodb) make make install and executing
I specifically wrote my import script to parse out the fields that we need
and add NULLs. I was told that having NULL values was faster than using ' '.
If this isn't the case, I'd like to know.
Thanks.
-Original Message-
From: Kurt Hansen [mailto:[EMAIL PROTECTED]
Sent: Monday, February
I saw the same that ms sql is faster but I think it's because of the ms
sql makes better use of index's
I had a table with almos 300mil records on ms sql query with index'es it
was no problem (in about 5 min I got the result) and with a much smaller
db on mysql (with 80 mil records it took almost
Matt W wrote:
Hi Ted,
Heh. :-) This could be many GBs. There's no problem reading rows that
are in RAM (cached by the OS) -- can read over 10,000/second. If
there's enough RAM, the OS will take care of it (you could cat table.MYD
to /dev/null). No ramdisk necessary. :-)
BTW, this is for
Eric B. wrote:
Sure! Here it is:
CREATE TABLE `index2` (
`id` varchar(50) NOT NULL default '',
`recordid` varchar(20) NOT NULL default '',
`transid` varchar(20) NOT NULL default '',
`formid` varchar(20) NOT NULL default '',
`groupid` varchar(20) NOT NULL default '',
`clientid` varchar(20) NOT
Matt Fagan wrote:
Hello,
I'm trying to run an SQL update statement like:
UPDATE ControlTable SET @prevval := NextID, NextID = NextID
+ 1
I've tried using a range of different syntax, but nothing
seems to work. This is something that does work in another
SQL server I used to use.
Does anybody
At 16:56 + 2/23/04, Tim Hayes wrote:
OK
There is still the possibility of an in-compatability between the 2
platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not
recognized / updateable using the set command!
Correct. You must set it using an option at server
At 9:31 + 2/23/04, [EMAIL PROTECTED] wrote:
Rhino [EMAIL PROTECTED] wrote on 21/02/2004 16:59:27:
I am new to most aspects of MySQL administration so I was wondering
if someone can help me figure out what GRANTs I need for a
particular situation.
I have a user who needs to be able to run
Christof Egner wrote:
Hello James,
thanks for your answer, but max_connections is set high enough (double
the number of the currently used threads). I think the error would be
Too many connections, wouldn't it?
This error comes from LinuxThreads when pthread_create() fails for one reason or
Hi,
I know this question has been posed in the past, but I haven't been able to
find an answer for it yet.
Is there any way in MySQL to pre-load a table's index file into the key
cache at startup? I know the key cache will build itself while exectuing
queries, but this will obviously slow down
On Mon, 2004-02-23 at 08:56, Tim Hayes wrote:
OK
There is still the possibility of an in-compatability between the 2
platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not
recognized / updateable using the set command!
I get - Unknown system variable
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh [EMAIL PROTECTED] wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql select 'This is a' || ' test string';
At 13:35 -0500 2/23/04, Eric B. wrote:
Hi,
I know this question has been posed in the past, but I haven't been able to
find an answer for it yet.
Is there any way in MySQL to pre-load a table's index file into the key
cache at startup?
Yes, this is something that was implemented recently:
Bernard Clement [EMAIL PROTECTED] writes:
Your problem is too much experiences not the lack of skills.
I am in the same situation...it is very frustating.
Bernard,
It appears I'm not the only one :( Though such an observation
makes me wonder if it may be a case of age discrimination being
Bernd Jagla wrote:
Hi,
we have a big problem with inserting large amounts of data (2GB) into our MyISAM databank (version 4.0.12).
The dataset is loaded in using
LOAD DATA infile 'bla' ignore into table tab fields terminated by ' ' optionally enclosed by '' (int1, int2, int3, date);
The format
The table I'm using is non-critical data, so it's not really an issue
for me. But I was browsing through the mysql manual looking for a way to
rebuild an MYI file from the .frm and MYD file (is there a way?) when I
came across this:
http://www.mysql.com/doc/en/CACHE_INDEX.html
Index caches are
Try this...works on 4.1.2
UPDATE ControlTable SET NextID= 1 + (select @prevval := NextID)
Ed
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 11:19 AM
To: Matt Fagan
Cc: [EMAIL PROTECTED]
Subject: Re: Setting variables on update
Matt
Chris Fossenier writes:
... Query 1
a1.phone_pander_flag 'Y'
AND state.state = 'PA'
AND ( h1.homeowner = 'Y'
OR h2.probable_homeowner IN ('8','9')
OR h2.homeowner_probability_model BETWEEN '080' AND '102' )
AND ( p1c.exact_age BETWEEN '40' AND '60'
OR estimated_age BETWEEN '40'
hi ,
i have a problem with Mysql Vs php . Can somebody
help me to sort out this problem ?
I wrote a php script to connet mysql data base and
get some data from some table of the database. It works well ..
1 data1
data2
5 ccc
xcx
3 aaa
123
2 klkl
opop
4 opop
pop
I want do the sort
Bruce Dembecki wrote:
Help, I seem to be running into a problem with replication which up until
now has served us well.
We run mysql servers in pairs, with each server in a pair mastering off the
other. So for example mysql1 masters off mysql2, which masters off mysql1.
Friday morning one server
Victoria Reznichenko wrote:
[snip]
Could you create repeatable test case (table structure (output of SHOW CREATE TABLE) and text file with data that will be enough to reproduce the above behavior)?
I'll see if I can get something generic to error out. there's pretty
much no way I'll be able to
Index caches are new to 4.1.x, but key caches have been around for a while.
Definitely in 4.0, can't remember about 3.x. Either way though, I don't see
either helping with inserts or updates. Only with queries.
MySQL does suggest using a seperate key cache for temporary tables though:
Thanks!
One question though - in the Index Preloading section, it says:
If there are enough blocks in a key cache to hold blocks of an entire
index, or at least the blocks corresponding to its non-leaf nodes
How can I determine the number of blocks in an index, or the number of
blocks for
I wrote a cold fusion script to migrate data from an access 2000 db to a
mysql 4.0.18 db and when I display the data with cold fusion I see these
little box characters in different spots.
I'm assuming that it's an issue with the encoding. How do I correct this?
Thanks.
Mitchell S.
Greetings -
Been scouring the docs for this all day and I come up with nothing for
'delimiter' - Id like to change the default delimiter in mysql to something
other than tab.
Is there a command to do this, and what are the options?
Thank you!
David
I'm not sure in what context you want to change the delimiter, but
here's the doc page on the LOAD DATA command which shows how to
terminate (a.k.a. delimit) fields with different characters:
http://www.mysql.com/doc/en/LOAD_DATA.html
On Mon, 2004-02-23 at 13:53, David Perron wrote:
Hi,
I'm bundling MySQL with a Java app, and it is currently working on Windows
and Mac OS X. Right now I'm porting it to Solaris.
The problem I'm having is when I try to create a database (CREATE DATABASE
mydb) I get the error: ERROR 1006: Can't create database 'mydb'. (errno:
2)
Using perror,
411 is packed with features I'm dying to have on my production server,
but I had it on my dev box, and I got some table corruption which,
admittedly, I was too lazy to try to reproduce. So I've downgraded to
production 4 again. I have a heavily updated fulltext index which may be
the root of the
Thanks Garth. Actually Im trying to change the delimiter in the context of
running a sql file from the command line - so in this case, I would want to
change from tab to csv
mysql -h db#-reports.adz -u readonly -p script.sql output.csv ads12
-Original Message-
From: Garth Webb
I am using the ~new~ MySQL Administrator and i'm trying to load the
Startup Variables and i'm receiving a Could
not find my.cnf error. my.cnf is located in the /etc directory and I
have temporarily relaxed the permissions to
777. Is there something that i'm missing here? Or is there a bug in
Hello List:
This is the basic of the basic question. I have recently installed and
tested MySQL and am happy with it. Now I want to setup a production server.
I notice that there are two MySQL products listed on the MySQL org site (1)
MySQL (2) MaxDB MySQL.
My question is; which of these two
Hi,
I am about to start using UTF-8 for my internal data storage and display
for a CMS that I'm building. Are there any issues that I should be aware
of related to mysql and storing UTF-8 encoded characters? What versions
of mysql offer full UTF-8 support, and are there any weird caveats with
the
Oh we are using Red Hat Enterprise Linux WS ver 3.0
Thanks
Matt
Thomas Taylor wrote:
what platform are you on?
On Feb 23, 2004, at 4:27 PM, Matt Silva wrote:
I am using the ~new~ MySQL Administrator and i'm trying to load the
Startup Variables and i'm receiving a Could
not find my.cnf error.
version 4.1 and up are the versions to be unicode enabled.
Ligaya Turmelle
Beau Hartshorne [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I am about to start using UTF-8 for my internal data storage and display
for a CMS that I'm building. Are there any issues that I should be
Hello Folks,
Am trying to upgrade MySQL with rpms. rpm -Uvh
MySQL-shared-compat-4.0.17-0i386.rpm worked fine. When I try to upgrade
the client or server I get warnings that the files conflict with the
older versions that are currently installed. I've tried to erase the
older versions with
There are some excellent tutorials for PHP at www.codewalkers.com under the
tutorials/basics section. You can sort the fields with SQL or with PHP (see
Sorting Database Results with PHP) and in the Display section of the
tutorials are Alternating row colors with PHP and MySQL and Multicolumn
At 04:40 PM 2/23/2004, you wrote:
Hello List:
This is the basic of the basic question. I have recently installed and
tested MySQL and am happy with it. Now I want to setup a production server.
I notice that there are two MySQL products listed on the MySQL org site (1)
MySQL (2) MaxDB MySQL.
My
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a
GRANT ALL on *.* to root IDENTIFIED BY 'password';
which is great, but if I run mysql so
mysql -u [EMAIL
At 12:50 -0600 2/23/04, Paul DuBois wrote:
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh [EMAIL PROTECTED] wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql select 'This is a' || '
At 17:20 -0600 2/23/04, Paul DuBois wrote:
At 12:50 -0600 2/23/04, Paul DuBois wrote:
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh [EMAIL PROTECTED] wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing
At 15:18 -0800 2/23/04, Jim Richardson wrote:
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a GRANT ALL on *.* to
root IDENTIFIED BY 'password';
which is great,
At 17:17 -0500 2/23/04, David Perron wrote:
Thanks Garth. Actually Im trying to change the delimiter in the context of
running a sql file from the command line - so in this case, I would want to
change from tab to csv
mysql -h db#-reports.adz -u readonly -p script.sql output.csv ads12
You
On Mon, Jan 05, 2004 at 09:12:24AM +1300, Sam Vilain wrote:
No-one out there doing step-by-step replay of binary logs ?
mysqlbinlog
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 162 days,
Hello
Today I run large query. It took more than 1 minute to start printing the
results. The output was about 5 rows. However, when I run the query
second time it took a couple of seconds before printing the results. Why is
that? Because data still in the RAM?
Thanks
Hi Mike,
- Original Message -
From: Mike Mapsnac
Sent: Monday, February 23, 2004 5:49 PM
Subject: run query second time
Hello
Today I run large query. It took more than 1 minute to start printing
the
results. The output was about 5 rows. However, when I run the
query
second
Hi Mark,
- Original Message -
From: Mark Maunder
Sent: Monday, February 23, 2004 4:17 PM
Subject: Re: HEAP tables vs MYISAM on ramdisk
411 is packed with features I'm dying to have on my production server,
but I had it on my dev box, and I got some table corruption which,
admittedly,
On Feb 23, 2004, at 10:36 AM, Sasha Pachev wrote:
Christof Egner wrote:
Hello James,
thanks for your answer, but max_connections is set high enough
(double the number of the currently used threads). I think the error
would be Too many connections, wouldn't it?
This error comes from LinuxThreads
I saw something like this as well. Using 4.1.2 made it go away. Try doing a
bk pull of the dev version of 4.1.2 and give it a go.
-steve--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chris,
We run a large data warehouse with tables similar to yours. We basically gave up on
indexing and the overhead involved and just tablescan. The key is to partition the
data using a concept called Merge Tables. However, since we currently use Oracle,
eager to migrate to MySQL - I don't
Kevin,
As I mentioned earlier, set this in you're my.cnf and restart mysql. It has
helped me on many occasions.
open-files-limit=36864
Donny
-Original Message-
From: Kevin Marks [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 6:27 PM
To: [EMAIL PROTECTED]
Subject: Re:
Hello
I have a number of servers.
I have one running RH7.3 with mysql-3.23.56-1.73
one running RH9 with mysql-3.23.58-1.9
My question is when i do a ps -ef
on RH7.3 a get a number of /usr/libexec/mysqld
on RH9 i only get one.
can someone please explain why. does RH9 display thread
Hello
I would like to ask how to migrate my table in database SQL Server to MYSQL.
The field name and data type mostly are different from the one I've prepared
in MYSQL. Could somebody show me the way or any recommended website which
discussing about this? For additional information, I am using
hi,
I am new in PHP, and I would like to create some user interface with PHP.
Could anyone tell me what is the easiest way to do this?
thanks a lot,
Enhebatu
_
Store more e-mails with MSN Hotmail Extra Storage 4 plans to choose
On Mon, Feb 23, 2004 at 05:30:38PM -0600, Paul DuBois wrote:
At 15:18 -0800 2/23/04, Jim Richardson wrote:
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a GRANT
Hi,
I want to add better support for Unicode in our application.
Currently we use the default charset of the application, but code our data
to UTF8 (It's a Delphi-Application with a native Component to connect to
MySQL). This works fine also for MySQL 3.23 with some limitations (No
hi ,
when i try to get mysql data to the web browser via
php , always it is showing
Parse error: parse error, unexpected T_LNUMBER, expecting
',' or ';' in /var/www/html/smsc/test1.php on line 14
error message. but i tried to rectify the essage ,
i couldn't.
can some body help me to solve
79 matches
Mail list logo