The following page has some nice interesting stuff, assuming you have a
reasonable configuration in place (innodb_buffer_pool, etc[1])
http://download.oracle.com/docs/cd/E17952_01/refman-5.5-en/optimizing-innodb-bulk-data-loading.html
[1] http://gpshumano.blogs.dri.pt/2009/09/28/importing-wikim
Dear MySQL users,
MySQL Installer 5.5.14.1 RC4 has been released. This is the final,
final release
candidate before GA so your feedback is greatly appreciated.
MySQL Installer is the all-in-one installation solution for all your MySQL
software needs. It comes with the latest MySQL Server and
Quoting supr_star :
Is there any way to speed up this process? by disabling indexes or
something? I can't afford to be down for 3 more days...
First stop, the mysql documentation:
http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html
--
MySQL General Mailing List
For list archives
I recently recovered a very large corrupt database with your help. Now I'm
having a problem during the next step, importing all the data back into a clean
system. I have a 24GB dump file, the ibdata1 file was about 100GB when the
disk filled and everything got wrecked. I have a server with a
On Aug 3, 2011 9:24 AM, "David Lerer" wrote:
>
> I rarely use aliases (unless rarely required in self-join queries).
> When I have that option, I create unique columns by prefixing every
> table (and its objects) with a number.
> Something like:
> Create table T1234_Employee
> (C1234_Employee_id
I rarely use aliases (unless rarely required in self-join queries).
When I have that option, I create unique columns by prefixing every
table (and its objects) with a number.
Something like:
Create table T1234_Employee
(C1234_Employee_id number(5),
C1234_employee_status char(1)...)
Index X12
> 2011/08/02 12:11 +0530, Adarsh Sharma
>
> select p.* from table A p, B q where p.id=q.id
>
> or
>
> select p.* from table B q , A p where q.id=p.id
>
> Why do people constantly change table names for queries, although, as here,
> it gain them nothing? It often makes for less
> Any mysql instance can replicate from any other as long as binary logging
> is enabled on the designated master.
> Two instances can replicate from one another yes, but precautions must be
> taken especially in the case of active-active configuration.
Works perfectly indeed, to name the precauti
Any mysql instance can replicate from any other as long as binary logging is
enabled on the designated master.
Two instances can replicate from one another yes, but precautions must be
taken especially in the case of active-active configuration.
Cheers,
Claudio
On Aug 3, 2011 7:19 AM, "Jon Siebert"
