On Thu, 9 Dec 2004 13:13:10 -0600
Jeff Smelser [EMAIL PROTECTED] wrote:
On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote:
and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then
dit from the commandline create database and then run the create table
On Thu, 9 Dec 2004 12:34:36 -0800
Dathan Pattishall [EMAIL PROTECTED] wrote:
This is a very broad question, I sometimes do this myself. But to answer
I know, but where must i begin ...
the question to the best of my ability I have to ask a few.
Are you using RAID? If so what RAID level?
We have 2 distinct groups of developers - Windows vs. Linux. Our production
server is going to run on Solaris.
The issue is that all developers run there own instance of MySQL server Linux
or Windows based and the same version 4.1.7. Also, each developer has the
database for their particular
Can any body tell me what the 4.1.x client library loads_defaults function
returns if it can't find the .my.cnf file?
It's listed in the header as int load_defaults() but the documentation for
it is atrocious. Even Paul fails to check/use the return in his MySQL
definitive guide, just assumes it
On Thu, 9 Dec 2004, sharif islam wrote:
How mysql deals with spaces in table / column name? I am also using
mysqlcc. If I try the following in the doesn't work. Creating table
name with spaces from mysqlcc didn't give any error. But the following
does:
INSERT INTO 'tbl name with spaces'
You are probably a little short of RAM for that size db. Lack of swap may
bite you as well. How big are your keys?
Pat...
- Original Message -
From: mos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 10, 2004 10:48 AM
Subject: Re: MYSQL is getting slow
At 09:49 AM
Hi,
any one give me an idea how to rebuild indexes in InnDB database. database
users are complaining that response time is slow. right now what I am doing
is dropping indexes on table and recreating them. After that Database is
working fine for some days and again it is giving problem. dropping
Hi,
I need to increase the innodeb_log_file_size parameter,
but when I set it higher, mysql donĀ“t starts and give the
follow erro:
041210 13:27:40 mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 100663296 bytes
InnoDB: than specified in the .cnf
Hi,
First shutdown the mysql cleanly.
#mysqladmin shutdown
then drop log files in data directory.
restart mysql. it will create new log files.
Thanks
Anil
NOC
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 11:08 PM
To: [EMAIL
ALTER TABLE tablename TYPE = InnoDB;
Will rebuild the indexes all at the same time.
-Original Message-
From: Anil Doppalapudi [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 9:06 AM
To: [EMAIL PROTECTED]
Subject: How to rebuild indexes in InnoDB
Hi,
any one give me an idea
Hello,
I have a MySQL database hosted with my ISP. They
provide direction as well as thru SSH tunneling. I can
very well connect to it diredctly from any app but I
prefer to use SSH tunneling.
So I use Putty to create the SSH tunneler and then
connecting to the local port.
Now the problem, is
Anil,
First shutdown the mysql cleanly.
#mysqladmin shutdown
then drop log files in data directory.
restart mysql. it will create new log files.
Do you know if is there a risk of loosing any data?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives:
if mysql shutdowns cleanly. then there is no chance of loosing data. for
safe side take compleate database backup.
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 11:39 PM
To: Anil Doppalapudi; [EMAIL PROTECTED]
Subject: Re: Increasing the
- Original Message -
From: Karam Chand [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 10, 2004 1:08 PM
Subject: Lost connection during query when using SSH tunneling
Hello,
I have a MySQL database hosted with my ISP. They
provide direction as well as thru SSH
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 12:08 PM
To: [EMAIL PROTECTED]
Subject: Lost connection during query when using SSH tunneling
So I use Putty to create the SSH tunneler and then connecting
to the local port.
Now
I am not sure of Putty as I am using plink.exe that is
the SSH tunneler for tunnel.
The thing is that I call up plink.exe from my app to
create an ssh tunnel and then set the correct values
for mysql_real_connect() in my app.
What I am doing is that I am bundling plink.exe with
my app and then
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 2:17 PM
To: Adams, Pat 006; [EMAIL PROTECTED]
Subject: RE: Lost connection during query when using SSH tunneling
I am not sure of Putty as I am using plink.exe that is the
SSH tunneler
I made a copy of my entire Mysql 3.23 data directory and moved it on to
a box with a fresh install of MySQL 4. While the NT service starts up
fine (I'm using 4.0.22-nt-max), I can't login. I know that there are
supposed to be mods made to the mysql database tables, but I thought
there was at
I'm obviously missing something. I can use mysqlcc to change data in a
row of a table and save it. But, if I try to insert a row, add data and
save it, it never gets saved. What am I overlooking?
--
/\ ASCII RIBBON Robin Lynn Frank
\ / CAMPAIGN Director of Operations
X AGAINST
Hi all ,
I have a relatively simple query that is taking longer than I think it
should. Can anyone possibly give me some idea why this might be or any
potential bottleneck areas I might want to check out?
thanks!
Here is some information.
The query below takes around 8 seconds, and
What errors are being displayed when you attempt to log in? Is anything
being written to the error log itself?
A. Clausen wrote:
I made a copy of my entire Mysql 3.23 data directory and moved it on
to a box with a fresh install of MySQL 4. While the NT service starts
up fine (I'm using
Have you tried optimizing or run an analyze table command on this table?
Aaron wrote:
Hi all ,
I have a relatively simple query that is taking longer than I think it
should. Can anyone possibly give me some idea why this might be or any
potential bottleneck areas I might want to check out?
What are some typical queires for a given schema?
I have no idee thats the whole problem, its a propretaire product.
Nothing is proprietary when it comes to mysql, you can turn on the slow
query log which is the first thing, do you have it turned on? What is the
slow query set to? Are any
In the last episode (Dec 10), Aaron said:
The query below takes around 8 seconds, and returns 3253 rows.
Query:SELECT ID FROM Offers_To_Buy FORCE INDEX(scdd) WHERE subcatID = 72;
3253 rows in set (8.00 sec)
Explain says:
Bad word-wrapping fixed:
mysql EXPLAIN SELECT ID FROM
MySQL CC seems to be discontinued. Nowadays I prefer
SQLyog (http://www.webyog.com)
Karam
--- Robin Lynn Frank [EMAIL PROTECTED]
wrote:
I'm obviously missing something. I can use mysqlcc
to change data in a
row of a table and save it. But, if I try to insert
a row, add data and
save it,
We have always found using anything other than alphanumeric characters and
maybe an occasional underscore for clarity is a bad idea. It will always
come back to bite you at some point. Try not using spaces or punctuation in
table or column names and your life will be easier. White space and
At 09:49 AM 12/9/2004, Patrick Marquetecken wrote:
Hi,
I have 3 snort sensors logging to a central mySQL database after two weeks
the size of the database is about 3.3GB and the machine is getting slow,
as i'm not used to be working with mySQL is my question how far can i go
before the machine
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 startup option, but that apparently only
The only gotcha I'm aware of is that you must set the *nix server to use
case-insensitive table names, since on windows the SQL table references
didnt need to match case. I'll leave you to you own devices to find that
documentation (I just dont have it handy, sorry)
select 8 from testtable ||
Hello,
I had the same issue myself, i read the manual and there says that you have to
stop mysql, then change the parameter in my.cnf, then i moved to another
directory the log file just to be cautious, and then restarted mysql.
Everything went right.
Best regards
Alejandro
-Mensaje
Anil and Oropeza,
if mysql shutdowns cleanly. then there is no chance of loosing data. for
safe side take compleate database backup.
Ok, thank you very much for your help.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
[EMAIL PROTECTED] wrote:
CONTEXT USE Example:
Do *you* really understand what this feature is supposed to do? Can you
explain it to us in (low-level) detail?
No, MySQL doesn't have a feature like this.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Aaron,
Three things.
1. Do a show create table Offers_To_Buy
2. And why in the world would you have force index(scdd) when your where
clause is on subcatID? If you can explain what you are trying to do, I'm
sure many people can help you get exactly what you are looking for.
3. Why so many
33 matches
Mail list logo