Hi Everybody,
I need small help from you. In my Linux box i have limitation of Size in
partition. I have only 5 GB space for /var. MySQL is installed in this
partition only. I want to give another path like /home, where i have 120GB
of space. Somebody told me that we need to change the data path
Hi All,
As per the below query, can we have simultaneous
connection with two DBS and refer both the DBs in the same query? Like
CREATE TABLE DB2.tblname LIKE DB1.tblname.
Regards,
Ravi K
-Original Message-
From: Dominik Klein [mailto:[EMAIL PROTECTED]
Sent: Friday, August
Given the three tables (Type, Value, and Links), here is another (crazy
looking) way to structure the query for the Person table.
SELECT P.*
FROM Person P
WHERE
(
EXISTS
(
SELECT null
FROM StringLinks L
JOIN StringValue SV ON L.ID = SV.ID AND SV.refTypeID = 1
Hey all, got a simple question:
Is there a quick way to convert all the data in my database to a specific
character set? I want to convert all the text to UTF-8.
-Charlie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
I would encourage people to use date filters on their searches, as
that could help by eliminating rows prior to the fulltext search.
For backup and recovery of a database this size, with MyISAM tables, I
recommend the included 'mysqlhotcopy' script. Also a mastery of the
mysqldump command will h
Dear list,
I'm programming a PHP-driven Search Engine for a newspaper.
Full-text Search with MyISAM Tables, MySQL 4.1.11, PHP 4.3.0
1GB of Text encoded by UTF-8
An average of 1Mbyte Data is inserted to database every day
A common SQL-Query:
SELECT COUNT(*) FROM news_archive
WHERE
MATCH(news_tit
On 8/12/06, Miles Teg wrote:
Sun also has some awesome CoolThreads offerings (SPARC architecture), but I
haven't had a chance to benchmark one yet. With 32 concurrent threads on a
single 8 core 4 way threaded cpu, I'd like to see how MySQL's performance is
on those systems. Does anyone have an
Dan,
Dan,
Right now I am using load data to load into my database.
I am inserting 10,000 - 20,000 rows (X3) every 10 minutes.
One table currently has 17866472 rows
Just using the date command from bash, the rough estimates for the
inserts via "load data..." are :
2006-08-18 15:39:23 : begin
George, for raw speed into a MyISAM table, I think you'll find it hard
to beat LOAD DATA INFILE, especially if you disable keys before and
re-enable afterwards (which is not unlike what your friend proposes -
creating the index in a more efficient fashion). I'd be interested to
hear how you get o
No takers?
-Original Message-
From: Robert DiFalco
Sent: Thursday, August 17, 2006 3:03 PM
To: Robert DiFalco; mysql@lists.mysql.com
Subject: RE: More query help for user-defined values
One simple solution is to denormalize a little and take the refTypeID
column out of StringValue and
his exact email:
"As you know, when you are doing mass inserts of millions of
rows of data it can take hours. Well, these guys said that if you sort
the rows of data 1st by the information that will be inserted in to the
database primary key before you do the inserts then the total insert
George, I've not heard of that technique - "sorting so that mysql
doesn't have to jump around as much".
What I am aware of, and what can make a difference, is disabling
indexes prior to starting the load. Your load goes quite a bit
faster, in general, but then there is some time at the spent upd
Hello All,
An ex-coworker of my recently sent over a link to a mysql article about
speeding up mass imports.
unfortunately I deleted the email before I had time to actually digest
it and now I am wondering if it could help with my imports.
The article suggested sorting the data ahead of time to p
HI all ,
i have a huge Undertaking here at our office, ("intranet / MySQL /
php / asp") and i've gotten alot of the Frontend written and 60% of the
backend, i,m realy needing A Individual or Individuals to
Aid me in Alot of the Table Querys and Procedures, i am going to open a
forum on our
Brian, you can also set a default storage engine in your mysql config
file (my.cnf) to ensure future tables get created with the desired
storage engine (unless otherwise specified in your create statement).
From http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
If you omit the ENGINE
I use EMS MySQL Manager. You can buy it here:
http://www.sqlmanager.net/en/products/mysql/manager/buy
No, I am not affiliated with them, but I use the product everyday and I
love it.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Pooly wrote:
Hi,
MysqlCC not being in
most of my Storage enines is MyISAM i wanna change them all to|InnoDB
how do i do this >?
ALTER TABLE tblname ENGINE="innodb";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
most of my Storage enines is MyISAM i wanna change them all to|InnoDB
how do i do this >?thanks
|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey everybody,
i´m becoming desperate about the following problem.
We´ve an online-community / network.
There´s a network table ( sql create below ), in which we store the
relationships between the member.
I need a SQL-statement or a PHP-Function to calculate the 2nd, 3rd and
4th degrees betwee
Hi,
Yes it can be done.
Hi,
Create table can be done across the database but please let me know what
version are us using (MYSQL).
mysql> create table test.tww like broadbandnew.cds ;
Query OK, 0 rows affected (0.06 sec)
Thanks & Regards
Dilipkumar
- Original Message -
From: <[EM
Hi,
Create table can be done across the database but please let me know what
version are us using (MYSQL).
mysql> create table test.tww like broadbandnew.cds ;
Query OK, 0 rows affected (0.06 sec)
Thanks & Regards
Dilipkumar
- Original Message -
From: "Dominik Klein" <[EMAIL PROTEC
Hi,
Guys! Stange!!!
I am replying to my own post just to tell you that after posting the
previously message, I restarted my system and ran my VB6 program. To
my surprise, MySQL__IS__ executing the same stored procedure,
that it was previously complaining about, again and not complaining
Hi,
MysqlCC not being in developement anymore and not working properly
with a server 5.0, we are trying to use MySQL Query browser, but there
are few things which are less than efficient compared to mysqlCC.
- you can't execute several queries ! The query tab executes them one
by one, and if you
Hi,
I posted the following code in one or two of my earlier posts and
_then_ it WAS working! I know there is no GROUP BY clause but IT WAS
WORKING somehow - the procedure ran fine and inserted quite a good few
records. However, NOW, after I have dropped and re-created the
database/tables/all th
In the destination database the table doesn't exist. Please let me know,
if there is any way to do it.
CREATE TABLE DB2.tblname LIKE DB1.tblname;
INSERT INTO DB2.tblname SELECT * FROM DB1.tblname;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
25 matches
Mail list logo
