Hello:
Can anybody help me out to repair my database tables using ISAMCHK
utility. The MySQL server version is 3.21.33b installed on BSD server.
Many thanks
Sheni
Details of the problem that we are facing now:
We are facing a serious problem with the MySQL server installed on our web
Hi,
I'm developing a web site with PHP and I want to show some information
only if I'm able to connect to a mysql database . If I can´t connect ,
simply I don´t show some parts of the web page.
Sounds easy and it works fine in local , but when I install it in the
web server ,if it can´t
hi
Just to clarify my requirements again:
i need to add 2 buttons like ADD COMMENT EDIT
COMMENT at the bottom of every page of my site (which
uses PN). So that users can enter and edit (their own)
comments for each page on the site.
for eg look here:
Hi,
I'm developing a web site with PHP and I want to show some information
only
if I'm able to connect to a mysql database . If I can´t connect , simply I
don´t
show some parts of the web page.
Sounds easy and it works fine in local , but when I install it in the web
server ,
if it can´t
mysql / query
--
I have a DATETIME column type with format -MM-DD and I'd like to have
format DD-MM-
what do I have to do ?
_
MSN Photos est le
-Original Message-
From: Sampson, Peter
Sent: 16 May 2002 09:35
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: FW: Simple SQL
Roger et al. Thanks for your response in reference to MySQL Query
I'm interested to find out more on how to do the following.
You say that an
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
I am not agree. I take _another program_ which work fine during ~2 year
with previouse mysql version (mysql-3.23.44 for example).
And I send dump from this program.
Why I interested libmysqlclient_r?
I have a program, which try
Hi,
I think you can't.
You can create char field type on table (i.e. char(10)) and when you wish to
do some date comparison you can use the next mySQL
functions:LEFT,MID,RIGHT,TRIM.
I.E:
mydate-field in a_table:char(10);
date on this field: '10.01.2001','30.02.2000',...etc.
select * from a_table
Hi!
Under FreeBSD gethostbyname is not thread-safe
And there is no thread-safe gethostbyname_r
(function exist but not thread-safe)
Are mysql know about this!!!
Just a note about this problem:
We will add a wrapper for gethostbyname() in 3.23.51 and the 4.0.2
that will fix things
Hi!
On May 15, Jocelyn Fournier wrote:
A small question :
I have :
CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 )
in the field 'nom' .
How could I match BCI-11N for exemple ? (BCI* return nothing :( )
Thanks,
Jocelyn
Actually, it's a question for [EMAIL PROTECTED],
Dear all
I had a mysql Database in one of my Server, now i want to transfer this
whole Database to another Server, what should i do?
1. How i can export this Database to a file
2. How i can Load this File into my another Server which create a database
exactly same as the old Server?
Thx a lot!
mysql,select,query,sql
mysql / query
--
I have a DATETIME column type with format -MM-DD and I'd like to have
format DD-MM-
what do I have to do ?
Does it matter in what format it is in the database?
you can select
not sure about the Linux guys, but if you're using Windows just copy the directory for
your database (in the mysql\data directory) to the new server.
Restart MySQL Server on new machine
Cheers
Dave
-Original Message-
From: Jack [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2002 10:05
To:
Hi, all
Links to the information are necessary. Master/slave the architecture.
Implementation of the system of a high degree of availability on a basis master/slave.
Implementation of a control master/slave.
Examples of the code of implementation of a monitoring system.
Who realized
Greetings,
While working on a routine to clean out some duplicate entries from our IP management
table, I stumbled upon the following errant behavior...
Logging to file 'concatbug.txt'
mysql \s
--
Connection id: 73465
Current database: OBFmtable
Current user:
On Thu, 16 May 2002 17:05:25 +0800
Jack [EMAIL PROTECTED] wrote:
Dear all
I had a mysql Database in one of my Server, now i want to transfer this
whole Database to another Server, what should i do?
1. How i can export this Database to a file
If your DB server (source) is not running ...
Hello
I 've a question, how i can upgrade a MySQL Version 3.23.32-log to MySQL
Version 3.23.49a ?
I havn'tfound it in the documentation so i hope you could help me
Greetings Ed
-
Before posting, please check:
Hi all.
This may (or may not) be a newbie question. But I've called it a newbie
question since I am a newbie to MySQL (and SQL for that matter). Here is
what I want to do:
I want to join three tables into one, where one specific colomn may have
more than one entry for each row.
The spesifics
Hi!
Michael == Michael Chang [EMAIL PROTECTED] writes:
For example, have you called mysql_thread_init() before calling
mysql_real_connect() in all your threads ?
Michael However, to my understanding, mysql_thread_init() is not needed if
Michael only one database connection is used, and
What platform (Win32, Linux, BSD, etc.) are you using?
If you have Win32 machine in the mix (doesn't need to be a server), suggest
you use the Export tool in MySQL-Front (http://www.anse.de/mysqlfront/).
We've replicated databases from Win32 to Linux and Linux to Linux with it
many times.
On Tue, 14 May 2002, j.random.programmer wrote:
Can someone (who knows this sort of thing) give a
layman's introduction to the interplay between
various gcc versions and various mysql versions
(3.49, 3.50, 4.01 etc) ? I have some linux boxes
and don't really want to have to install/use
Hi!
Andrey == Andrey Kotrekhov [EMAIL PROTECTED] writes:
Andrey -L .-A
Andrey Are mysql know about this!!!
Sorry but if your OS doesn't support gethostbyname_r(), then
mysql_real_connect() is not thread safe (I have just updated our
documentation about this)
Andrey Thank you.
I have
Hi everybody.
Just installed Red Hat Linux on a machine. I included the MySQL packages
but cant get it up working.
When starting from shell it looks like this:
$ mysql
ERROR 2002: Can't connect to local MySQL server through socket
'var/lib/mysql/mysql.sock' (2)
What have I done wrong?
best
Gabriel.
This works fine and the two tables talk to each other.
BUT,
My website can have 5 - 10 news stories per month. So in the tblNews I
could have
nMonth t1 t2
2 I am a line This is one,
too.
2
Hi,
I have installed MySQL from rpm's downloaded from mysql.com.
All seems ok except when I try to do rpm -i MySQL-bench-3.23.49a-1.i386.rpm
I get an error message from rpm saying the I need MySQL-DBI-perl-bin.
Where can I find this MySQL-DBI-perl-bin?
Thanks in advance!
/Curt
Hi there,
I have a huge querry which takes for ever on a table containing only 2000
records.
Maybe there is a way to reorganize this querry since it contains a join and
lots of other stuff I am not really familar with.
Let me first show you the sql query:
SELECT DISTINCT
u.user_id,
On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql
3.23.??, I think) I have a testing and programming box, only one user is
connecting to the database at a time.
Now, the mysqld startup sequence automatically starts 5 occurances of the
mysqld server.
Id like to
Dear MySQL list monitors...
Please do something about the following address that has apparently joined
the list.
every time I send a message to the list, I get a bouned message saying that
the message is undeliverable.
Thanks
From: Mailer-Daemon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Regarding mysql...
1) Are primary keys and foreign keys by default indexes for a table?
2) Do I have to use a special data other than float to allow for negative numbers,
i.e. I want to be able to enter -1.76 and be able to later do math against that
number...
Thanks,
Taylor
Taylor Lewick
[snip]
SELECT DISTINCT
u.user_id,
u.user_name,
max(
if(u.sex=2,25,0) +
if(u.age=4,25,0) +
if(u.country='gm',25,0)+
if(l.language_id='de',25,0)
)
AS ranking,
c.country_code,
c.country,
ct.city,
Hi there,
I have a user table with lots of different column types. Now I do experiance
problems filtering out special date. The performance is really bad.
So maybe I did just pick the wrong column types?!
This is what I picked so far:
| Type | Null | Key | Default | Extra
|
Make sure mysql owns the tables and their directorys, and has write
privileges to them.
I talking about UNIX permissions here, not mysql permissions.
Bill Flanagan wrote:
Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM
tables on which I am unable to do updates or
From my understanding primary keys and foreign keys are indexed. Someone
correct me if I'mwrong here. And you shouldn't have to do anything else to field
besides
make it a float to usenegative numbers.
-Nick
Regarding mysql...
1) Are primary keys and foreign
keys by default indexes for a
Check your indexes.
Daniel Lim wrote:
Hi there,
I have MySql version: 3.23.36 running on RedHat 7.1, it has been
working fine for sometimes until a day ago when the INSERT into for new
record appeared to return OK status but upon verifying the record isn't
there?
This is an example;
To
This is the explain select sql query on this table containing 500 records
now:
| table | type | possible_keys| key | key_len | ref
| rows | Extra |
+---++--+--+-+--
Hi!
Sasha == Sasha Pachev [EMAIL PROTECTED] writes:
Sasha On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote:
After even more tracking stuff down, I managed to isolate it to a
change made in MySQL 4.0.1. ?The query in question was doing:
? INSERT INTO ... SELECT ...
rather than
Rance,
Thursday, May 16, 2002, 4:13:04 PM, you wrote:
RH On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql
RH 3.23.??, I think) I have a testing and programming box, only one user is
RH connecting to the database at a time.
RH Now, the mysqld startup sequence
Jaan,
Thursday, May 16, 2002, 5:19:20 PM, you wrote:
JJ Just installed Red Hat Linux on a machine. I included the MySQL packages
JJ but cant get it up working.
JJ When starting from shell it looks like this:
JJ $ mysql
JJ ERROR 2002: Can't connect to local MySQL server through socket
JJ
Tom,
Thursday, May 16, 2002, 4:30:50 AM, you wrote:
TB I am trying to turn off the query log in mysql on redhat linux. It generates
TB huge log files
TB (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance.
TB safe_mysqld was run with --log, and it seems like I want to
Norris,
Wednesday, May 15, 2002, 6:54:46 PM, you wrote:
Neoen I have been using (very happily) mysql on unix boxes. I am in a new job and
Neoen there is not a unix box in sight!!! ouch!
Neoen This is a windows 2000 shop. Here is the situation and I am looking for any
Neoen and all
Eigner,
Thursday, May 16, 2002, 2:05:01 PM, you wrote:
EE I 've a question, how i can upgrade a MySQL Version 3.23.32-log to MySQL
EE Version 3.23.49a ?
EE I havn'tfound it in the documentation so i hope you could help me
What OS do you use? Linux?
If you use MySQL from RPM just
rpm -Uvh
Bill,
Wednesday, May 15, 2002, 11:42:00 PM, you wrote:
BF Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM
BF tables on which I am unable to do updates or inserts. I get error
BF message #1036 'Table is read only.' I am able to sign on to the database
BF through the root,
Hello,
I am using mysql 3.23.38 on winnt.
I have a table already filled with default value, that way we do only
updates during our processing.
One column is specified as not null in the table definition and it's also an
index.
everything was working fine, Until we decided to use Optimize
I have now installed mysql-DBI-perl-bin.
But I still get a message about failed dependencies: MySQL-DBI-perl-bin is
needed by MySQL-bench-3.23.49a-1.
Is this because of the spelling of mysql / MySQL?
Or is it something else?
/Curt
torsdagen den 16 maj 2002 14.23 skrev Curt Söderberg:
Hi,
I
I made a program with delphi and I would like to get the message when is
execute any query.
eg: select ...
10 rows in set (0.04 sec) .
This message is important for me. How can I get it.
Alexander
A busca mais veloz e precisa da internet. Acesse
I made a program with delphi and I would like to get the message when is
execute any query.
eg: select ...
10 rows in set (0.04 sec) .
This message is important for me. How can I get it.
Alexander
A busca mais veloz e precisa da internet.
group,
Here is the situation. I have to connect to Mysql running on another
windows 2000 box. I have never done this before. Do I set this up in the
tables as another
host and use the -h parm in command shell and the host parm in my perl
scripts? or is there another way to do it?
Any help
We have just migrated a huge installation to InnoDB from MyISAM.
While I can feel the power and potential and appreciate this
sophistication of what I have at my disposal, I am having some
performance issues that are most likely due to my ignorance.
Answers to the following questions should help
Hi,
I don't know what caused it, nor whether it's reproducable, but on an AIX system,
I just found out that both of the 4.0.1 masters (typical master=slave_of_master loop
using same source tree configuration) have created 100.000+ files of the replication
log.
I can only think they are
Hi!
Going through my email backlog...
Just a short update on this.
Sasha == Sasha Pachev [EMAIL PROTECTED] writes:
Sasha On Monday 29 April 2002 04:39 am, David Harper wrote:
Description:
I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49
with master/slave
Hi all,
I would like to know how often (delay in sec.) the slave checks the master for new
records in the log, and if one can control that .
Thanks in advance
Vlady
(mysql)
-
Before posting, please check:
http://rpmfind.net
Thank You
Daniel Negrón
Lotus Notes Administrator / Developer
KB Electronics, Inc.
954.346.4900x122
http://www.kbelectronics.com
|+
|| Curt Söderberg|
|| curt.soderber|
|| [EMAIL
Terra wrote:
Greetings,
cut
mysql select *,concat_ws('.',oct1,oct2,oct3,oct4)
ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by
oct1,oct2,oct3,oct4 having c1;
+--+--+--+--+--+-+---+--++---+
| ID | OCT1
I have partitioned my data such that each client has its own database
(clientdb1, clientdb2, ... clientdbN). All the databases have the same
structure (same tables, columns, etc.). This design works great except for
one caveat - when I make a change to the database structure I have to make
the
I'm finally getting around to working with InnoDB for real :-)
Anyway, is there any reason to still use MyISAM on any tables.
Concurrency is my biggest problem (Locked tables, etc.). My theory is
that the tables that wouldn't benefit from converting to InnoDB are so
small (5-50 rows?) that I
I am working with a mySQL database in which some column names contain
hyphens. These have to be enclosed in backquotes (`table-name1) within
SQL statements.
Problem: when generating its own SQL statements, mysqldump does not
enclose these names in backquotes -- so when I try to restore a
Alexander,
Thursday, May 16, 2002, 5:40:41 PM, you wrote:
AB I made a program with delphi and I would like to get the message when is
AB execute any query.
AB eg: select ...
AB 10 rows in set (0.04 sec) .
AB This message is important for me. How can I get it.
In general you can't get
I want to ignore a database from bin-logging. I know that in
my.cnf, I can set binlog-ignore-db=database_name but for various
reasons, that's not available to me. How would I pass that option
in on the command line via safe_mysqld? Passing it in as an option
or a set-variable option causes
Norris,
Thursday, May 16, 2002, 5:57:51 PM, you wrote:
Neoen Here is the situation. I have to connect to Mysql running on another
Neoen windows 2000 box. I have never done this before. Do I set this up in the
Neoen tables as another
Neoen host and use the -h parm in command shell and the host
Andre,
Wednesday, May 15, 2002, 6:05:16 PM, you wrote:
AS Were running replication on our Prod. DB (3.23.42 on SuSE 7.0) since a
AS half year. Our way to rotate the binlog files was to stop all software
AS inserting data into the Prod. DB and then reset the master and the
AS replication server.
Taylor,
Thursday, May 16, 2002, 4:22:37 PM, you wrote:
TL Regarding mysql...
TL 1) Are primary keys and foreign keys by default indexes for a table?
Yeah. Primary key is index by default. Foreign key constraints you can create only
on indexed column.
TL 2) Do I have to use a special data other
Hello Alexander,
At 11:25 AM 5/16/2002, Alexander Keremidarski wrote:
Terra wrote:
Greetings,
cut
mysql select *,concat_ws('.',oct1,oct2,oct3,oct4)
ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group by
oct1,oct2,oct3,oct4 having c1;
Hi all,
I would like to know how often (delay in sec.) the slave checks the
master for new records in the log, and if one can control that .
Thanks in advance
Vlady
(mysql)
-
Before posting, please check:
Sampson, Peter wrote:
Gabriel.
This works fine and the two tables talk to each other.
BUT,
My website can have 5 - 10 news stories per month. So in the tblNews I
could have
[Snip multiple rows]
I need to use DISTINCT in the SQL lingo as I bind the recordset's
nMonth to a
Hello.
On Thu, May 16, 2002 at 01:39:59AM +0200, [EMAIL PROTECTED] wrote:
[...]
It sounds as if you want
ALTER TABLE your_table ADD INDEX( message_id )
[...]
Well, the FAQ is where I went first, of course. And then I came up with
this,
ALTER ignore table $table MODIFY message_id
Hi.
Well, what's the problem with using isamchk in detail?
Shut down the mysql daemon, run isamchk on all tables to find out
which are corrupted and run isamchk -r on those. Then restart
mysqld. Do not forget to make backup copies of the tables in question
beforehand, in case anything
Hi.
IMHO you need to do some more digging yourself and present more
precise question. At least, if you get no other answers, which I
rather doubt.
The problem is that the answers depend heavily on information you did
not provide (e.g. what are the requirements for the system? high
availibility
Hi!
Good questions!
- Original Message -
From: Michael Bacarella [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, May 16, 2002 6:41 PM
Subject: MySQL/InnoDB questions from a MyISAM background
We have just migrated a huge installation to InnoDB from MyISAM.
While
T.D.,
Thursday, May 16, 2002, 6:54:45 PM, you wrote:
TDH I am working with a mySQL database in which some column names contain
TDH hyphens. These have to be enclosed in backquotes (`table-name1) within
TDH SQL statements.
TDH Problem: when generating its own SQL statements, mysqldump does not
Unsure exactly what you want but I use message box's in my apps to say if
there is an error or whatever.
This, as far as I know, has to be done in the program not in the SQL.
Alexander,
Thursday, May 16, 2002, 5:40:41 PM, you wrote:
AB I made a program with delphi and I would like to get
Please stop reposting your question.
You should be able to get this information from Delphi. Set up a time object
before you execute the query.
On Thursday 16 May 2002 10:19 am, Alexander Burbello wrote:
I made a program with delphi and I would like to get the message when is
execute any
Hello.
On Thu, May 16, 2002 at 06:25:42PM +0300, [EMAIL PROTECTED] wrote:
[...]
mysql select *,concat_ws('.',oct1,oct2,oct3,oct4)
ip,concat(oct1,'.',oct2,'.',oct3,'.',oct4) test,count(*) c from ips group
by oct1,oct2,oct3,oct4 having c1;
Hi.
shell mysqldump --help | grep 'quote\|Ver'
mysqldump Ver 8.14 Distrib 3.23.38, for pc-linux-gnu (i686)
-Q, --quote-names Quote table and column names with `
don't know why it isn't the default, but it seems you can force them
this way.
Regards,
Benjamin.
On Thu, May 16,
Can you login to mysql from a perl script by passing it an encrypted password..?
Taylor...
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply.
Hi All,
Using MySQL server version 3.23.49-nt I get strange results when running the
following very simple test. I am wondering if this is a bug, feature or
perhaps a standart SQL behaviour??
CREATE TABLE test(id BIGINT UNSIGNED);
CREATE INDEX test_idx on test(id);
INSERT INTO test VALUES
Hello.
On Thu, May 16, 2002 at 12:10:10PM -0400, [EMAIL PROTECTED] wrote:
At 11:25 AM 5/16/2002, Alexander Keremidarski wrote:
[...]
It is normal to have a difference there. It is not beacuse of how
concat() and() concat_ws() work, but how GROUP BY works.
Is this 'unpredictable behavior'
Hi,
Same bug with MySQL-4.0.2 latest source.
Regards,
Jocelyn Fournier
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Alexander Keremidarski [EMAIL PROTECTED]
Cc: Terra [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, May 16, 2002 7:49 PM
Hi,
In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i
have to use in Mysql ??
thank´s
Marcel.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Peace to All,
In Bible said:
If a man doing something wrong for the first time or he don't know , give
the second chance and show him the right way...and if don't want to follow
it , let him
...or something like that.
If you use ODBC you have many ways but the short one is to have a
Isn't the following:
SELECT * FROM t1, t2 where tl.ID=t2.foreignKey;
logically equivalent to:
SELECT * FROM t1 LEFT JOIN t2 ON t1.ID=t2.foreignKey WHERE t2.ID IS NOT
NULL;
Because I had a query in the first format that took about two minutes to
run on MySQL, and then I changed it into the
restart the MySQL server
happened to me this week when I was copying files (and changing the schema) while the
server was running
HTH
Dave
-Original Message-
From: Frederic Dhorne [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2002 15:32
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:
Hi.
What you observe is the fact that -1 will be converted to the format
of the index, else the index could not be used.
Converting -1 to an unsigned number give the biggest possible number
for the type in question (here BIGINT UNSIGNED). None of your numbers
is bigger than this, so you get an
i think u dont need to it will automatically deal with it.
- Original Message -
From: Marcel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 16, 2002 3:26 PM
Subject: STRING TO NUMBER
Hi,
In Oracle i use TO_NUMBER to convert a String to a Number what Function Do
i
have
Sergei Golubchik wrote:
rebuild your indexes (the proper way to do it is to issue
REPAIR table_name USE_FRM
Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick?
TIA,
Vadim.
/* sql, mysql to satisfy the spam police */
From my sql How can I see what the types of tables I have are.. i.e. how do I verify
if a table is an ISAM, HEAP, InnoDB...
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply.
I read in the Mysql manual where you can change the default column seperator, but it
didnt specify how to do this.
So, how can I tell the LOAD DATA command to use commas, or better yet, where can I go
to find out about mysql command syntax...?
Thanks,.
Taylor Lewick
Unix System
MySQL do it for you:)
Quoted from the online documentation is:
MySQL automatically converts numbers to strings as necessary, and
vice-versa:
mysql SELECT 1+1;
- 2
mysql SELECT CONCAT(2,' test');
- '2 test'
If you want to convert a number to a string explicitly, pass it as the
SHOW CREATE TABLE tablename;
or
SHOW TABLE STATUS LIKE 'tablename';
gives you what you want...
See:
http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html
http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html
Gurhan
-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent:
Everytime you have something to ask, first point your browser to :
http://www.mysql.com/doc/
Type in the keywords (in this case LOAD DATA)
The first url in the resultset will be :
http://www.mysql.com/doc/L/O/LOAD_DATA.html
which is what you are looking for.
Gurhan
-Original Message-
Hi,
Look at http://www.mysql.com/doc/L/O/LOAD_DATA.html
and you can try this...
load data infile 'yourfile' into table your_table fields terminated by
'\your_separator_char_for_fields' lines terminated by
'\your_separator_char_for_row';
Regards,
Gelu
Hi,
try :
show tables status;
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Taylor Lewick [EMAIL PROTECTED]
To: [EMAIL
Hello,
I like to limit the size of a database (or if possible all databases of a
mysql user) to some value. It should work like the disk quota for disk
space.
Thanks for any hints,
Alexander Newald
-
Before posting, please
I am running mysql and apache on windows 2000. Everything is running
smoothly and then all of the sudden my perl scripts that have been running
just find are loading
very very slowly. I am not sure if it is mysql, perl, apache or what. These
are the same scripts that have been running just fine
Perhaps memory utilization issues? Does the box start thrashing?
Norris, Joseph wrote:
I am running mysql and apache on windows 2000. Everything is running
smoothly and then all of the sudden my perl scripts that have been running
just find are loading
very very slowly. I am not sure if
I'm not new to MySQL but have only recently familiarized myself with InnoDB.
One question I have so far been able to find an answer on is the datafiles.
Let's assume I have 5 GB worth of information, this information changes
regularly. Performance wisewould I be better off using a single 5GB
Hi,
Let´s supose that we have a table with this features :
- about 7 records;
- only a primary index;
- about 30 fields;
- 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
typically uses about 3 or 4 fields in the WHERE clause.
Creating indexes, one for each field used on SELECTS,
* Joao A. Marques
Let´s supose that we have a table with this features :
- about 7 records;
- only a primary index;
- about 30 fields;
- 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
typically uses about 3 or 4 fields in the WHERE clause.
None of them beeing the primary key,
You might try running queries seperately and check performance to see
if it Perl or mySQL
mike
Norris, Joseph wrote:
I am running mysql and apache on windows 2000. Everything is running
smoothly and then all of the sudden my perl scripts that have been running
just find are
Dear MySQL wizards,
Perhaps this is more of a Perl question than a mySQL question but I am trying
to access a mySQL database.
Here is the line of code.
if ($q-param('field') eq ) {printform()} else {results()}
This gives the reply:
Use of unitialized value in string eq at select.cgi
Hi,
What characters should i parse when using an INSERT statement that has
string values? So far, i had troubles with single quotes and minus signs.
What should i do with them? Is there any others?
Thank u very much,
Edilson.
Edilson Vasconcelos de Melo Junior
[EMAIL
1 - 100 of 108 matches
Mail list logo