I believe it may be because the tables in the Query cache have been
modified causing the cached results to become invalid.
Olivier Kaloudoff wrote:
Hi,
I noticed the following behaviour on mysql 4.1.8
and two servers;
to setup replication, I did the required grant on
the master, and choo
InnoDB files can not be copied from one machine to another like the
MyISAM files. If you did not dump the data or you do not have an
archived backup you will more than likely have to recreate the table
structures.
David Blomstrom wrote:
Yikes...I've been replying to myself! I forgot that
when I
Is the DATE_ADD(time, INTERVAL) an option?
SELECT Now(), DATE_ADD(Now(), interval 60 minute)
schlubediwup wrote:
Hi again mysql-listers
mysql> select version();
++
| version() |
++
| 4.1.9-standard-log |
++
1 row in set (0.00 sec)
Do you know how the file was created/exported from Oracle? Are the files
contents viewable?
Marcos Sanches wrote:
Hello all,
I am a new user, in fact I've never used any software like Mysql,
oracle or sqlserver. But I am very familiar with analysing data, I am a
statistician. I've just received
Does SQLyog log any errors for you? Are your lines terminated by \n or
\r\n? Have you tried performing this import with the LOAD DATA INFILE
command? There you could at least see if warnings or errors were
encountered.
Scott Hamm wrote:
I got my csv delimited using "{" as follows:
87547{2404149
What device driver are you using to access the database? Can you run a sql
trace or maybe turn on the logging on the server side?
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 23, 2005 11:05 AM
To: MySQL list
Subject: MySQL server disconnects when executing
Try show index from t1;
Show index from t2;
-Original Message-
From: Jacek Becla [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 4:00 PM
To: Jay Blanchard
Cc: mysql@lists.mysql.com
Subject: Re: how to check if keys disabled?
Jay
Are you sure? DESCRIBE tells me the table has an ind
Can you see the slave thread on the master when you do a show processlist
from the master?
-Original Message-
From: Keith Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 1:48 PM
To: mysql@lists.mysql.com
Subject: Slave stuck at "registering"
I'm trying to set up replication o
PM
To: mysql@lists.mysql.com
Subject: Re: Slave stuck at "registering"
Victor Pendleton wrote:
> Can you see the slave thread on the master when you do a show processlist
> from the master?
Yes. It shows up with the command as "Sleep", nothing in the
"State"
Do not escape the single ticks.
-Original Message-
From: Jorge Infante Osorio. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 8:32 AM
To: [EMAIL PROTECTED]
Subject: Problem whit DELETE
Hi, I new in this list and I have a problemand I hope that
any of you can resolve or hel
Try the Replace function
replace the `-` character with ``
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:09 AM
To: MYSQL-List (E-mail)
Subject: String Functions
Is there any function to strip non numeric characters from a string?
Such
What programming language are you using? You could write a method to compare
each character and return only those 0-9 as the output and discard the rest.
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:26 AM
To: Victor Pendleton; MYSQL
Do you only have the Microsoft DBF and ldf files?
-Original Message-
From: Mark Graves [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 1:24 PM
To: [EMAIL PROTECTED]
Subject: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
I run a website using MySQL, PHP, and CFMX. S
Try slave start
-Original Message-
From: Andrew Hall [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 2:46 PM
To: [EMAIL PROTECTED]
Subject: replication question
Greetings,
Firstly I have searched the archives and received exactly 0 results
returned for 'START SLAVE 1064' so...
You will need to place the following at the head of your dump file.
SET FOREIGN_KEY_CHECKS=0
-Original Message-
From: sean peters [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 10:28 AM
To: [EMAIL PROTECTED]
Subject: mysqldump table order with foreign keys
Hey all,
I'm tryi
What is the MySQL process running at during this time?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 9:19 AM
To: [EMAIL PROTECTED]
Subject: MySQL runs slow on windows 2003
Hello,
I have upgraded win 2000 to 2003 and since this moment, MySQL 4.0.
What does your Windows Task list --> Processes show when you are running at
a high cpu usage?
Is French your native language?
-Original Message-
From: Rezo [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 11:51 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL runs slow on windows 2003
task list.
At 20:25 19/12/2003, Victor Pendleton wrote:
>What does your Windows Task list --> Processes show when you are running at
>a high cpu usage?
>Is French your native language?
>
>-Original Message-
>From: Rezo [mailto:[EMAIL PROTECTED]
>Sent: Friday, D
How are you shutting down MySQL?
-Original Message-
From: ikm [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 11:14 PM
To: [EMAIL PROTECTED]
Subject: Shutdown error
Every shutdown MySQL I found error as this
shutdown failed; error: 'Access denied for user: '@localhost' (Usin
Do a show variables like '%inno%';
This should tell you if you have innodb enabled or not. If not you will need
to configure your cnf file.
-Original Message-
From: Jeff Mathis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 10:07 AM
To: Sibananda Sahoo; [EMAIL PROTECTED]
Subject
Are you wanting to physically relocate the myd, myi and frm files to a new
location? If so specify datadir in the cnf file or --datadir on the command
line for mysqld.
-Original Message-
From: Chris McKeever [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 10:35 AM
To: [EMAIL PROTE
Have you looked at using the MS DTS and MyODBC to perform your
replication/synchronizing from Microsoft?
-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:31 AM
To: [EMAIL PROTECTED]
Subject: Synchronising SQL Server and MySQL
I need to synchronise a
You can use MS Query and MyODBC to allow your customers to access the MySQL
database.
-Original Message-
From: Bernd Jagla [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 9:12 AM
To: mysql
Subject: Excel(2002) and mysql4
My costomers are using Excel, so I am looking into con
Your grant tables are either corrupted or damaged. Error 145 indicates this.
(B
(B-Original Message-
(BFrom: Pushpinder Singh Garcha [mailto:[EMAIL PROTECTED]
(BSent: Monday, June 23, 2003 9:43 AM
(BTo: Nils Valentin
(BCc: [EMAIL PROTECTED]
(BSubject: Re: mysql ended error
(B
(B
(
[mailto:[EMAIL PROTECTED]
(BSent: Monday, June 23, 2003 9:49 AM
(BTo: Victor Pendleton
(BCc: Nils Valentin; [EMAIL PROTECTED]
(BSubject: Re: mysql ended error
(B
(B
(B
(BThanks Victor,
(B
(B
(BWhat can I do now ?... I do not care about the data because this is just on
(Bthe testing server
Your grant tables in their current state are unusable. You need to either
(Bimport or download a `fresh` copy of the mysql database directory
(B
(B-Original Message-
(BFrom: Pushpinder Singh Garcha [mailto:[EMAIL PROTECTED]
(BSent: Monday, June 23, 2003 9:59 AM
(BTo: Victor Pendleton
Is the mysql server currently running? You can also use either -S or
--socket to specify the socket connection.
-Original Message-
From: Kevin H. Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 8:10 AM
To: [EMAIL PROTECTED]
Subject: mysql.sock doesn't exist
I apologize fo
ng. One odd thing about my setup is that when I
restart the service I get a "Failed" signal for the shutdown phase but
an "OK" for the start phase.
Thanks,
Kevin
Victor Pendleton wrote:
>Is the mysql server currently running? You can also use either -S or
>--socke
Stop the process you currently have or start up the server on a port other
than 3306.
-Original Message-
From: Kevin H. Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 1:46 PM
Cc: [EMAIL PROTECTED]
Subject: Re: mysql.sock doesn't exist
The output of the grep is:
[EMAIL P
The `MUL` indicates that the column have multiple values. When the server
`crashes`, what errors are being reported log file?
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 4:13 PM
To: [EMAIL PROTECTED]
Subject: Strange "Mull" in show fiel
ure what errors are being reported to the server. I'm not sure how
to get those. I am not local to the box.
Is there a way to look at the log files without being at the box?
Karl
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Ka
You could create your own script that runs myisamchk then after completing
starts the MySQL service and place this in the windows startup folder.
-Original Message-
From: Luis Lozano [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 9:32 AM
To: MySQL List
Subject: Include Check and R
You do not have access to either that file or that directory. Try to adjust
permissions then rerun.
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 9:50 AM
To: Mysql List
Subject: RE: CSV Formated output
Ok, I've got FILE priv set on my user n
Depending on your version of windows you may have to type doskey at the
command prompt to turn on the doskey feature.
-Original Message-
From: Ray Thompson [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 7:47 AM
To: Neeraj Vasudeva; [EMAIL PROTECTED]
Subject: RE: doskey feature in my
Schemas and user defined partitions are not utilized in MySQL as they are in
Oracle. If you are attempting to design your architecture according to
schemas you could visualize each database as an user defined schema.
CREATE DATABASE company_00;
-Original Message-
From: Morten Gulbrandsen
What is written to ther error log?
Marc wrote:
I'm using MySQL on Gentoo Linux and today it stopped starting up. It was
working a few days ago, and I haven't played with anything in the system
- no new installs, config changes, etc. It just decided to go on
vacation.
I run mysqld_safe and it quit
If you are on an *nix system you can try
\! echo Hello > test.txt
Rhino wrote:
Sorry, you still haven't got it;-)
I want the echo command to be in the *script*, not to be supplied at the
command line. Is there some way to put a mix of MySQL commands and OS
commands into a script and have both execu
What does the explain plan look like?
John Smith wrote:
Afternoon All,
I have the following table structure:
CREATE TABLE properties (
id int(11) NOT NULL auto_increment,
propid varchar(14) NOT NULL default '0',
townid varchar(255) NOT NULL default '',
countyid mediumint(5) NOT NULL default '0'
If you build the composit indexes as suggested, does your performance
improve?
John Smith wrote:
On Thu, 2004-11-11 at 13:58, Victor Pendleton wrote:
What does the explain plan look like?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE
You can load the file to an intermediate table and then complete your
process using
INSERT INTO targetTable
SELECT col_1, col_5, col_28, col_71
FROM intermediateTABLE
Ferhat BINGOL wrote:
Hi,
I have a 72 fields data txt file and I was inserting all data previously
but now I need only some of them
Is the actual data stored in the database or somewhere in the file
system? If you do not have text or blob columns you may be able to use
heap/memory tables.
[EMAIL PROTECTED] wrote:
Actually no. I have a file that is determined to be requested by mysql (Top
100 site) What I am wanting to do i
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 11:10 AM
To: [EMAIL PROTECTED]
Cc: Eamon Daly; [EMAIL PROTECTED]
Subject: Re: On but off topic Putting a file in Ram
Is the actual data stored in the dat
Are there any MySQL errors being logged? Did you confirm that the ODBC
connection is working?
Sanjeev Sagar wrote:
I have seen mails talking about MydbPAL. I downloaded it and I have
MySQL ODBC data source too but not able to connect to MydbPal at all. I
have tested my odbc data source, it work j
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: RE: how to connect to MyDBPAL from MySQL
YES ODBC work perfect. I am using same data source for MySQL
administrator and Query Browser too.
Anyway, if you are using can you go over the steps for db connection
1. Open dbPAL, Click on Workshop
2
Is the MySQL server running and you can not connect? Or are you not able
to start the MySQL server?
Morris, Andrew wrote:
../var/lib/mysql/mysql.sock.
I've been round the houses with this following the thread but I can't
get past this error despite all the chmod and chown modifications,
insta
Is there an index on the column in the table referenced?
F.Balicchia wrote:
Hello i'd like to converte this DDL for mysql
ALTER TABLE MYTABLE_ROLE
ADD ( FOREIGN KEY (LOGIN)
REFERENCES MYTABLE_USER ) ;
i wrote
ALTER TABLE MYTABLE_ROLE
ADD FOREIGN
Are you data files on a local filesystem? When this issue occurs can you
access any regular files on the drive?
Ajay Kalambur wrote:
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 1
If you plan on connecting only from the localhost host or via an ssh
tunnel you block port 3306 at the firewall or router. What exactly are
you looking to accomplish?
Scott Haneda wrote:
I can do a telnet host.com 3386 and get a answer back from mysql. Is the
only way to turn off remote access
connections will be allowed.
|Scott Haneda wrote:
on 11/30/04 8:53 PM, Victor Pendleton at [EMAIL PROTECTED] wrote:
If you plan on connecting only from the localhost host or via an ssh
tunnel you block port 3306 at the firewall or router. What exactly are
you looking to accomplish?
Well, some
Do you have an index on the client_id in the t_quiz table? Can you post
the ddl for t_quiz?
Ady Wicaksono wrote:
mysql> alter table t_quiz_trivia add foreign key (client_id)
references t_client (client_id) on delete set default;
ERROR 1005: Can't create table './smsserver/#sql-215d_11eff.frm'
(
Have you tried connecting with this user directly from the MySQL monitor?
Hathaway, Scott L wrote:
I have a server that is Windows 2003 server. It is running php from IIS
6. I access the latest 4.0x MySQL and am having some trouble. My
database access is readonly. The user that I connect as has
How did you deduce that the database server is the bottleneck? Are all
your processes running on the same machine?
Andrew Nelson wrote:
Hi,
I have a MySQL 3.23.55 server managing accounts on my exim mail server..
The table type on all tables MyISAM.. I have the MTA performing
various queries
fo
The reason I ask is because eight select statements should not bog down
a production server. On the MySQL side, is anything being written to the
slow query log? On the application side is there any virus scanning or
similar activity being performed? Does iostat show any heavy reading or
writing
When the server begins to slow down, what does top reveal?
Andrew Nelson wrote:
The reason I ask is because eight select statements should not bog
down a production server. On the MySQL side, is anything being
written to the slow query log? On the application side is there any
virus scanning or
A function on the left hand side will nullify the use of an index.
Marc Dumontier wrote:
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07';
On a MYISAM table of 122,000 rows, t
t (0.00 sec)
Jeff Smelser wrote:
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote:
> A function on the left hand side will nullify the use of an index.
Sides dont matter, a function on an index, no matter what side, will
kill an
index.
Jeff
--
MySQL General Mailing List
For list arch
When the database is in a `hung` state, is the file system where the
MYI, MYD and frm files accessible?
Paul Smith wrote:
%% Gleb Paharenko <[EMAIL PROTECTED]> writes:
gp> Very often similar symptoms causes various lock problems. Do you
gp> use InnoDB? Try log_slow_queries to find hung queries.
What state are the queries in while they are hung? What command or SQL
are they executing?
Paul Smith wrote:
%% Victor Pendleton <[EMAIL PROTECTED]> writes:
vp> When the database is in a `hung` state, is the file system where
vp> the MYI, MYD and frm files accessible?
Definitely.
Understandable. The state, command and info values from `show
processlist` could shed some light on what is occurring.
Paul Smith wrote:
%% Victor Pendleton <[EMAIL PROTECTED]> writes:
vp> What state are the queries in while they are hung? What command or
vp> SQL are th
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 4.0.22-
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?
thanks
What does the show processlist look like?
Have you ran top/vmstat/iostat when the `hanging` occurs?
Hjalmar Gislason wrote:
Hi there,
I've been having some trouble with an application that I'm running
(www.spurl.net).
I have a database that consists of about 20 tables. The largest tables are a
litt
Did you install MySQL on the other box? It sounds like you took a
snapshot of the data but have not installed the executables yet.
James Sherwood wrote:
I am trying to transfer a database from one linux box to another, both using
redhat.
On one I performed a mysqldump and it worked fine.
On the o
Have you verified that the MySQL server is currently running? Was this
installed as service to automatically start up?
Leandro Melo wrote:
Hi, i built an application which uses MySQL 4.0.17
using Windows XP Professional.
Tomorrow, i need to present the application to my
client, so i preparing my
What do you get when you do a `which mysql` from the command line?
James Sherwood wrote:
Yes, there are other databases on that mysql installation.
The only thing is, I recently upgraded it to the latest release of mysql.
James
- Original Message -
From: "Victor Pendleton&quo
Did you install MySQL as a service and have you started the service?
Sheni R. Meledath wrote:
Hello:
I am trying to install mysql on my laptop which is running Windows XP
professional. But after installation when trying to connect to the MySQL
server I am getting the following error message:
Erro
Are you using a streaming connection?
-Original Message-
From: Leonardo Francalanci
To: Mysql
Sent: 6/22/04 7:43 AM
Subject: connectorJ & huge table problem
I have a large table (64,000,000 rows).
Everything was fine when the table was 16,000,000 rows,
now connectorJ crashes:
java.sql.S
A non-streaming connection will place the resultset in memory. With large
tables you can run out of memory and the application will stop. A streaming
resultset does not place the entire dataset in memory and therefore you can
retrieve `large` data sets. In order versions of connectorJ the default w
load data infile '' into table helpdeskgrouptotal;
-Original Message-
From: Chris Stevenson
To: [EMAIL PROTECTED]
Sent: 6/22/04 9:58 AM
Subject: Newby to loading
I'm trying to load ACD call data into a table for the first time. I've
saved my data file as a text file on my root directory
Is the MySQL server running? What OS are you using?
-Original Message-
From: Angela Howley
To: [EMAIL PROTECTED]
Sent: 6/24/04 7:13 AM
Subject: connection error
Hi,
I have spent the last two days trying to configure PHP 4.3.7 & MySQL
4.0.20 - none of which is successful.
The error I ha
The location depends on the name of the file
my.cnf will go in C:\
and my.ini will go in C:\winnt or C:\windows
-Original Message-
From: James E Hicks III
To: Dirk Bremer (NISC); [EMAIL PROTECTED]
Sent: 6/24/04 10:57 AM
Subject: Re: Server Down/General Server Questions
On Thursday 24 Jun
Have you ran an explain plan on the query to identify the execution path?
-Original Message-
From: Aasef Iqbal
To: [EMAIL PROTECTED]
Sent: 6/28/04 6:15 AM
Subject: slow query when searching database of over 2 million records
Hi,
I am working on a web project project where one of my pages
Can you post the code or sql that you are attempting to execute that is
throwing tis error?
-Original Message-
From: Oliver Chua
To: [EMAIL PROTECTED]
Sent: 6/28/04 5:08 AM
Subject: SQLException when retrieving resultset containing mediumint
(4.1.2b-alpha-win db and java-3.1.2-alpha driver
I do not believe this is currently an option in the `load data infile`
syntax. One option would be to read the file programmatically and issue the
commits after `x` number of inserts.
-Original Message-
From: Michael Lee
To: [EMAIL PROTECTED]
Sent: 6/28/04 1:21 AM
Subject: INNODB transacti
Do a show variables from the MySQL monitor.
show variables;
-Original Message-
From: Scott Fletcher
To: [EMAIL PROTECTED]
Sent: 6/28/04 10:27 AM
Subject: MySQL Storage Engines and Table Types.
Hi!
How do I know which of the storage engine am I using or running, or
whatever that
What does the error log say?
-Original Message-
From: Chip Bell
To: [EMAIL PROTECTED]
Sent: 6/29/04 9:03 AM
Subject: authentication error
Hello, I run a toaster email server which is having trouble
authenticating at times. Both methods of authentication, imap AND web
for some reason ju
inform me whether my conculsion is right
or wrong.
Thanks & Regards,
Michael
Victor Pendleton <[EMAIL PROTECTED]> wrote:
I do not believe this is currently an option in the `load data infile`
syntax. One option would be to read the file programmatically and issue
the
commits after `x` num
Show warnings is not available until 4.1.x
...
The empty field will be imported as that. Empty and not a null value.
...
Have you tried importing the data yet to see how the date fields look in
MySQL?
-Original Message-
From: Robert L Cochran
To: [EMAIL PROTECTED]
Sent: 6/28/04 9:20 PM
Sub
Can you view or log the errors that imap and the web authentication are
getting? Try issuing a flush-hosts to see if the max_connect_errors was
reached.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 11:47 AM
Subject: RE: authentication error
>From the mysql monitor it is `FLUSH HOSTS;` . Does the email server not log
failed connection attempts?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 11:55 AM
Subject: RE: authentication error
Ok, I tried to run "flush-hosts" fr
What is the connection like between the two servers? Once you are logged in
can you do a show processlist and see if anything is bottelnecking the
database?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 12:05 PM
Subject: RE: authentication error
Do you have an `execessive` numer of processes running? Do you have any
processes that have been running for an `abnormal` length of time?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 12:12 PM
Subject: RE: authentication error
It's all o
look at that one. You just need to identify what is acceptable and normal
behaviour and correct where possible.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 12:43 PM
Subject: RE: authentication error
Ok, we might be on to something. Right now
You should just become familiar with your data and the queries that are sent
to the database. You could turn on the slow query log and after a few days
or hours or whatever see what queries are logged.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29
ENGINE syntax is availiable in 4.1.x and later versions.
-Original Message-
From: Bing Du
To: [EMAIL PROTECTED]
Sent: 6/29/04 2:30 PM
Subject: Re: Didn't find any fields in table, why?
Yes, both user and group ownership of the mydb directory and all its sub
directories/files are mysql.
I
max_memory is roughly equivalent to ==> key_buffer_size + (read_buffer_size
+ sort_buffer_size) * max_connections
-Original Message-
From: João Paulo Vasconcellos
To: Mysql-general Mailing List
Sent: 6/29/04 1:09 PM
Subject: Server tuning
Hello everybody,
I am setting up a server to d
Are you migrating from 5.0.x to 3.23.x? Do you have any innodb or dbd
tables?
-Original Message-
From: Bing Du
To: '[EMAIL PROTECTED] '
Sent: 6/29/04 3:59 PM
Subject: RE: Didn't find any fields in table, why?
Yup, that's it. I just checked out the mysql online documents.
mysqldump
shoul
There is a section in the MySQL manual titled `Programs Known to Work with
MyODBC' and section called `Access`.
http://dev.mysql.com/doc/mysql/en/MyODBC_clients.html
Look at this section and let us know if you are still having issues.
-Original Message-
From: Daniel Eliav Sharvit
To: [EMA
I have not tried 5.0.x to 3.23.x but give this a try:
Flush the tables with read lock or flush the tables and shutdown the
database
tar.gz the files
Move the files to the the new server
Untar/unzip the files
Start up both databases
-Original Message-
From: Bing Du
To: ''[EMAIL PROTECTED]
do a show grants for root@'localhost' and look at it privileges. If your
root account has been altered you can started the database with the skip
grant table option, log, fix the grant tables, and flush privileges.
-Original Message-
From: Scott Haneda
To: MySql
Sent: 6/30/04 4:30 AM
Subj
While the Visual Basic application is querying the database can you log into
the MySQL via the mysql monitor and do a show processlist to see if the
query is executing? If not I would suggest you view the mysql error log or
set up Visual basic to throw and error when it is getting disconnected.
-
27;hostname.err' file did not show any errors. Is there another file i
should be looking at?
The error handler in in VB could not handle the error.
Is there some ODBC setting I need to optimize?
Any help will be appreciated.
Thanks
Greg
>From: Victor Pendleton <[EMAIL PROTECT
Have you checked the slow query log and the error log?
-Original Message-
From: Mohammad shojatalab
To: [EMAIL PROTECTED]
Sent: 6/30/04 11:58 AM
Subject: Minitoring mysqld process activities
Hi all,
I'm running a small database as backend of a relatively quiet website,
This is the versi
If the table type is MyISAM, have you tried full text indexing?
-Original Message-
From: Schalk
To: [EMAIL PROTECTED]
Sent: 6/30/04 2:31 PM
Subject: RE: Query on large text field
Hey there everyone
I have tried a couple of things but would like to know what suggestions
people on the l
ALTER TABLE table_name ADD FULLTEXT INDEX index_name (col);
-Original Message-
From: Schalk
To: [EMAIL PROTECTED]
Sent: 6/30/04 3:28 PM
Subject: FULLTEXT
I am using the following command on MySQL 4.0.18
ALTER TABLE tablename MODIFY columnname FULLTEXT;
I keep getting an error rega
I would check to see if your server is swapping at this point.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:27 PM
Subject: RE: authentication error
Hi Victor,
I have stumbled on to something. The server is bouncing back and forth
b/t fast
Do you have a high number of temp tables being created or high i/o?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:44 PM
Subject: RE: authentication error
No sir...
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED
Are you using delayed insert statements?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:50 PM
Subject: RE: authentication error
After looking through, "show variables;" the only one I found with a
value of "100" is the &
What does the network setup look like? What type of data is being replicated
varchar, text, blob? Is the network connection being dropped or are there
any errors being logged anywhere?
-Original Message-
From: MaFai
To: [EMAIL PROTECTED]
Sent: 6/30/04 10:34 PM
Subject: Replication Perfor
Do the math and see what your memory usage is with 100 simultaneous
connections. If I recal you said you had three gigs of ram.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 7/1/04 5:27 AM
Subject: RE: authentication error
Nope, nothing out of the
1 - 100 of 462 matches
Mail list logo
