 | | | MySQL General | | Hi
I exported data from a mysql database to a csv file. Null values are exported
as \N. When I import this csv file with the dts service from MSSql then I
receive the following error when a null ...called "Practical Query Analysis " (PQA) is now available here
http //pqa.projects.postgresql.org/
It produces HTML reports on slowest queries most frequent queries
queries by type (selectWhy not set the DB character set to utf8 and probably cover all of them?
CHARACTER SET utf8
Respectfully
Ligaya Turmelle
<grahama@(protected) > wrote in message
news CBB1420B-B992-11D8-90F1-0In the last episode (Jun 08) Lou Olsten said
> In the High Performance MySQL book on page 124 the author suggests
>
> "If you have all your MySQL data on a single disk you can try moving
> "Dan Brown " <danb@(protected) > wrote
> Will the number of databases being handled by MySQL affect it 's speed
> regardless of the actual load being put on MySQL or should I look farther
> into OS issuHi
I 've tryed that after reading this message
But couldn 't get the route correctly established.
I 'm giving some more details in this example
Server (SuSE 8.2) IP 192.168.10.34
Win2Hi
I would appreciate help on the following.
I have installed myODBC 3.51 on my Windows 2000 computer.
I am trying to connect mysql database on a linux server.
I configured the ODBC data sourcHow do you determine the average time per query in MySQL?
Jeff Johnson
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mysql.cVersion 4.0.15 comes after version 4.0.2 (15 > 2) so the version is not a
problem here.
From the manual "As of MySQL 4.0.2 to use LOCK TABLES you must have the
global LOCK TABLES privilege The manual describes wait_timeout thusly
"The number of seconds the server waits for activity on a non-interactive connection before closing it. On thread startup the session wait_timeout value iAre you spitting out an output of the query string to verify that the data
from the form is making it to the query correctly?
GOD BLESS AMERICA!
To God Be The Glory!
--A few days ago Dennis T Cook asked this list if it is OK to abort a
OPTIMIZE that is taking a very long time. I am also wondering this.
Will it cause any damage to the half-optimized table adndRen? Fournier <m5@(protected) > wrote on 06/02/2005 02 53 51 PM
> I 'm having a really hard time selecting rows from a table in one SELECT
> statement. I can do it in two SELECTS but it seem
c s wrote
>Dear friends
>
>I have a question about mysql.
>
>I installed mysql on windows 2000 after I started the mysql I tried to create a database but I was denied I got message Dear friends
I have a question about mysql.
I installed mysql on windows 2000 after I started the mysql I tried to create a database but I was denied I got message
mysql > show databaAndy Eastham put me on the right track for this solution. I just ran the
following and it works so please give him the credit.
I tested with 'van der Plas ' and 'McNeil '
SET @(protected) 'van der PThe proposed solution to sort on a portion of the surname field will work
but it has a drawback. If you sort on the result of a function applied to a
column you prevent the use of any index on Hi
it is not possible to handle all cases proper.
You can just handle all cases you know with the REPLACE-function
so you simply delete the prefixes in the WHERE-clause.
But that only works foHello Andy
I don 't known if this is possible without handle string what I don 't guess
recommended because of performance and legibility of code.
One suggestion will be store in column 'surnaIn a table called 'advisers ' I have a column called 'surname ' which
contains the surnames of a number of people. Using a query like
'select * from advisers order by surname ' lists the people in the
> My requirement was 6 fields and 2nd guy need 12 filed.
You should setup two tables. The first one will track common
data for each user (e.g. name address...) like
create table users (
Working around optimizing some queries I tried to get a better key
improvement.
This is what I get
mysql > explain select ID reply nome email dataora titolo testo status thread from board w
> We 're looking for a client-server instant messaging system (opensource)
> powered by MySQL if possible. Anyone know of one?
> I 've been taking a look at Gaim Sim etc but these all piggyback
Hello Everybody
I am totally new to MySQL. Wanted to know if MySQL supports any options
using which users can specify the row storage order. For instance Let
us consider the Employee table NHi again!
This query is ok
create table TEST (id int saturs char(255) charset utf8 )
alter table TEST add fulltext (saturs)
drop table TEST
create table TEST (id int saturs chaHi All!
Does works fulltext index on utf8 columns on boolean mode
correctly on
MySql 4.1.2 ?
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubOur Opteron server should be arriving today so I can 't provide a whole
lot of insight.
First what version are you using? 4.0.20? The 64-bit or 32-bit version?
Knowing the version might help.
Jeff Smelser wrote
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash SHA1
>
> On Monday 07 June 2004 10 03 pm starofframe wrote
>
> >but
> >delete from table where date_sub(crea_dt interval -----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
jonathan.chiu@(protected) wrote
> AFAIK creation of connection from DB is expensive. This is one of the
> reasons why we need connection pooling.
> > 1. The timeout is set to 5 min because of the number of queries there
> > are a lot of unused http processes that linger with connections and the
> > only way to seeminly keep MySQL connectio |
|
|
