Hi,
I have experienced similar problems to the one you have; the problem you have
is that the time gap between the failure and now is so big that you cannot
resume replication, because of the big data portion you have to replicate.
When this happens to me, increasing the value of the variable y
Hi,
My experience shows me that RAM and disk is fundamental for any
database, especially MySQL. As much IO load, much more disk preading you
have to take with.
Personally, i have 2 databases with 11 millions Inserts / day (2GB /
day), so my advise is that you spend as much money as you can in SAN
17:34
CC: mysql@lists.mysql.com
Asunto: RE: Performance problem
On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda
<[EMAIL PROTECTED]> wrote:
> > im new on the performance tuning of this database (MySQL 5.0.45,
> > rpm-based installation), and i have one performance probl
I`ve resolved my problems without hardware manipulation.
Thanks to all.
-Mensaje original-
De: Francisco Rodrigo Cortinas Maseda
Enviado el: miércoles 16 de abril de 2008 18:57
Para: mysql@lists.mysql.com
Asunto: RV: Performance problem
Hi all,
im new on the performance tuning of
Hi all,
im new on the performance tuning of this database (MySQL 5.0.45, rpm-based
installation), and i have one performance problem on our new installation:
- The radius servers (that are written on perl) we have are writing the auth
and acct log to one mysql database. The conn we have is a
Hi there
I checked your post at
http://lists.mysql.com/mysql/166873
I'm with some troubles with Multiple Query and error
2013 (lost connection).
Can u gimme some help??
10ks
Franz
-
Francisco Bischoff
ICQ#: 1891104
Current ICQ status:
+ More ways to co
Received: (qmail 22439 invoked by uid 48); 13 May 2005 13:54:38 -
> Date: 13 May 2005 13:54:38 -
> Message-ID: <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Unsubscribe request
> From: <[EMAIL PROTECTED]>
>
> This message was generated because of
that pretty much explains why it's been happening ;) Thanks :)
On Thu, 17 Mar 2005 22:34:08 +0100, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Francisco,
>
> > Maybe it's my setup... but:
> >
> > whenever I try to login to use the mySQL query browser, it
07f9000". The
memory could not be "read".
Running Win2k pro w/ 512mb of ram.
--
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
Hello all,
I am getting quite desperate on this, since I've been trying to recover
my diary of a whole year of travelling which was stored in a MyISAM
table for a couples of weeks now! The MySQL server was running in a XP
machine and suddenly the hard disk crashed starting my particular
nig
Egor Egorov wrote:
Francisco Ivan Anton Prieto <[EMAIL PROTECTED]> wrote:
I am crazy with a problem.
I would like to know the best method to SELECT affected rows after an
UPDATE.
If you set column values to the new (different from current value), you can just use the same WHERE
I am crazy with a problem.
I would like to know the best method to SELECT affected rows after an
UPDATE.
Thanks to all by your help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
subset of a particular table).
One does not require views to restrict access to columns, as MySQL Server
has a sophisticated privilege system. See section 5.4 The MySQL Access
Privilege System (http://www.mysql.com/doc/en/Privilege_system.html).
Maybe this could help you
Francisco
-Original
ave to add the IP address as an allowed host though, but I thought that
the mySQL server could resolve the IP to the host name? Thanx!
-Original Message-
From: O'K Web Design [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 8:06 AM
To: Francisco Castellon
Subject: Re: ERROR 2003
Hello list:
Just finished installing mySQL on a Linux Debian system and I have a
question about how the 2 root users that are set up by default. When I
look at my user table there is a root user allowed to log in from
"localhost" and also another root user but this one is only allowed to
log in f
Hello list:
Just finished installing mySQL on a Linux Debian system and I have a
question about how the 2 root users that are set up by default. When I
look at my user table there is a root user allowed to log in from
"localhost" and also another root user but this one is only allowed to
log in f
a bug from mysql or mandrake9 by trying it on
other systems...
I guess it's a mysql bug as nss_ldap is very standard and used worldwide.
Thank you
--
Francisco A. Lozano
Factory Web - I+D
Tlf: 902 365 055
http://www.factoryw.com
Error 152. Windows no encontrado. ¿(A)leg
Hi,
You can check that if the server is running by
executing this:
Show variables like "datadir%"
from mysql.
Bye,
--- Robert Citek <[EMAIL PROTECTED]> wrote:
>
> At 05:35 AM 12/10/2002 -0800, tmb wrote:
> >1 - On a Linux/Apache box,
> >when you create a MySQL db with tables, etc,
> >Where do
Hello,
I have several mysql 3.23 daemons running in a Windows
XP Professional computer. To achieve this, I have run
the following commands:
mysqld-opt --basedir=C:\mysql
--datadir="C:\mydb\data1"
--port=3020
--standalone
--default-table-type=MyISAM
--tmpdir="C:\mydb\temp1"
mysqld-opt --based
Change your query for:
select red,green,blue from colorchanger INNER JOIN
jobattributekit ON colorcode = value where
attributekit = "Color" and jobnumber =
"28200124RB4-001" and scenario="JN75K";
Also remember that MySQL does not allow sub-queries.
--- Amit Lonkar <[EMAIL PROTECTED]> wrote:
>
Hi,
If you are generating the id yourself a good strategy
is to use UUID that are "guaranteed" to be
"universally" unique. If you are developing
for the Microsoft platform, there is an API functions
that returns you a UUID and this number is guaranteed
to be unique.
If you are working in Java, y
here is an interesting article comparing Ms-SQL,
Oracle, DB2 and MySQL in:
http://www.pcmag.com/article2/0,4149,7279,00.asp
Sincerely,
Francisco
--- Mary Stickney <[EMAIL PROTECTED]> wrote:
>
> I have been doing speed tests the same query
> ran on MYSQL took 45
> minutes
>
Hi,
I am beging using MySQL for quite a while and it is a
very good choice if you don't really need stored
procedures. MySQL provides a pretty good
implementation of a subset of MySQL-92, performance is
great, it is cross-platform, provides transactions,
and its price... well is free.
Hope it he
Interesting a spooky.
Try to use different cursor types. As you know, ADO,
or better said, OLE DB behaves (or misbehaves)
depending on the cursor. Have you tried a FORWARD and
READ ONLY cursor.
Good Luck
--- "Menard, Inc. Information Systems"
<[EMAIL PROTECTED]> wrote:
> Evening
>
> I think I'm
Hi Florian,
If you want to connect remotely to the server, you
have to grant permission to that user. Try this:
GRANT ALL PRIVILEGES ON *.* TO 'theuser'@'%'
IDENTIFIED BY 'thepassword';
With this command you are telling MySQL to accept
calls from any computer if the user name is 'theuser'
and t
Hi,
It depends how you want to treat those images. One of
the advantages of putting the images in separate files
is that you can modified them directly.
If the images are small, I think that a blob field is
a good idea but if the images are big, can make the
database grow to much.
Hope it helps
Hi,
Could you put more detail in the description of the
problem?
Bye.
--- Florian Litot <[EMAIL PROTECTED]>
wrote:
> Hi,
> i use mysql v4.0 i have got a problem with the
> connection to database i can
> connect if i have localhost but if i want to connect
> to database i can't.
> There is a li
mysqlsource sms.sql
Bye and Good Luck!
--- Scott Pippin <[EMAIL PROTECTED]> wrote:
> I need to run a file called sms.sql from the command
> line. Is this
> possible and what is the syntax?
> Thanks in advance.
>
>
-
> Before po
Hi,
Search if somebody has the OLEDB driver for MySQL, and
then you will be able to do it.
Bye and Good Luck!
--- "Darrell A. Sullivan, II"
<[EMAIL PROTECTED]> wrote:
> Can anyone tell me if it is possible to connect to a
> MySQL server running on
> Linux from a Windows Visual Basic application
Hi,
I recomend you to use the pre-compiles binary
distribution. You won't have to build it and it worked
for me.
This is the link for the Intel platform:
http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-3.23.51-pc-linux-gnu-i686.tar.gz
Bye and Good Luck.
--- Saravana
Hi,
I wanted to summarize my problem again so if somebody
had the same issue can help me.
O.S. IBM AIX 4.3.3
MySQL Binary Distribution: 3.23.46
When I run ./scripts/mysql_install_db, I got this
error:
exec(): 0509-036 Cannot load program ./bin/mysqld
because of the following errors:
0509-150
Hi,
Change the alias to date_format(date,'%D %M %Y') AS
mydate, so you are sure that you sort by the date
field not my the formatted date. Be aware that if you
sort my the formatted string, MySql is going to treat
it as a string and therefore sort it as a string.
"11th July 2002" < "2st July 20
Hi,
Are you sure that is trying to access the internet. It
may be trying to open the port, remember that MySQL
needs 3306 (by default) to communicate with the
server.
I think if you just open that port, everything will be
ok.
Bye and Good Luck.
--- "Matthew K. Gold" <[EMAIL PROTECTED]> wrote:
>
Hi,
Use LEFT JOIN instead of =. In a 1:m relationship,
only records that match in both tables are selected.
With L.J., the master is always selected even if the
record is not present in the child.
Master
Id
1
2
3
4
5
Children
FK_id Value
1 V1
1 V2
2 V3
Select id, value from Master,
Hello Nitesh,
You can find that and more at...
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Good Luck,
--- Nitesh Divecha <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I need help with tables. I have created my table
> with some attributes in
> it.
>
> I need to modify my table attributes, ca
ween types "struct hostent*" and "int" is
not allowed.
make: 1254-004 The error code from the last command is
1.
I am using GNU Make 3.79.1
Thanks in advance.
Francisco,
Thursday, July 25, 2002, 2:46:39 AM, you wrote:
FR> When I try to execute scripts/mysql_install_db, I
get
FR&
Hi,
When I try to execute scripts/mysql_install_db, I get
some errors about some libraries missing:
exec(): 0509-036 Cannot load program
./bin/my_print_defaults because of the following
errors:
0509-150 Dependent module libz.a(shr.o) could not be
loaded.
0509-022 Cannot load module libz.a(shr.
Hi,
Mailing list: http://lists.mysql.com/
Joining three tables could be something like this.
Select * from t1 INNER JOIN t2 ON t1.id = t2.id INNER
JOIN t3 ON t2.id = t3.id
I highly recomend you to read some basic SQL books
before you carry on with your project. Trial and error
is not always th
Hi,
If you mean how to connect to a MySQL server from a
remote machine in a local network, you only need to
include the computer (or ip address) of the server in
the HOSTNAME. You also have to make sure that the user
in the connection string, has permission to access the
database, you should go t
Hi,
Use LEFT JOIN instead =
Bye and Good Luck!
--- Mark Colvin <[EMAIL PROTECTED]> wrote:
> I want to select from three tables where there may
> or may not be a record in
> the third table. Table 1 and 2 have a one to one
> relationship and table 1
> and 2 both have a one to many relationship w
ny) 1 services the three
service type.
Let me know if this is not what you wanted.
Bye and Good Luck.
> So how do we handle these situations
>
> -Arul
> - Original Message -
> From: "Francisco Reinaldo" <[EMAIL PROTECTED]>
> To: "Arul" <[E
>From MySQL manual:
http://www.mysql.com/doc/M/o/Moving.html
http://www.mysql.com/doc/U/p/Upgrading-to-arch.html
I have tried and it works in HP-Solaris and LINUX, but
I tend to agree with Cal, my recomendation is to use
an alternative procedure such as dumping and
importing.
Bye and Good Luc
Hi,
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2 or serviceid = 3
group by companyid
having count(*) = 3
Bye and Good Luck.
--- Arul <[EMAIL PROTECTED]> wrote:
> Hi All
>
> The Table design goes like this
>
> Company Table
>
> companyid
Hi,
This is not related with your issue but if you want to
do serious development, don't use Windows 98 in any of
its versions. It is going to give a lot of problems.
Bye and Good Luck.
--- Matthew Scarrow <[EMAIL PROTECTED]> wrote:
> I've built a whole program with vb6 and mysql
> database back
Hi,
Since subqueries are not allowed in MySQL, this is
what I would do:
Create a temporary table with the id's containing
multiple dates.
Inner join your table with the temporary table.
Even if MySQL allowed subqueries, this is what will
probably happen behind the scene.
Bye and Good Luck!
---
Hi,
Sorry but MySQL does not support subqueries yet.
Bye and Good Luck!
--- Narcis GRATIANU <[EMAIL PROTECTED]>
wrote:
>
>
> When I try this:
>
> SELECT article, dealer, price
> FROM shop s1
> WHERE price=(SELECT MAX(s2.price)
> FROM shop s2
> WHERE s1.article
Dough! They started behaving like big corporations
already; certification, consulting, etc, etc.
:-)
--- "Defryn, Guy" <[EMAIL PROTECTED]> wrote:
>
>
>
> I was wondering if anybody heard about a possible
> release of books that help you prepare for the Mysql
> certification?
>
> Cheers
>
>
-
No1.
Sounds like a permission problem. Make sure that you
have that domain in the list of computer allowed to
connect to MySQL. Refer to MySQL manual to get more
information about this.
No2.
PC based application won't run on Linux unless you run
them under an PC-emulator which I don't even know i
Hi,
These tools are not open source:
http://www.thekompany.com/products/dataarchitect/
You can download the evaluation. It supports MySQL
directly:
http://www.datanamic.com/download/download_dezign.html
If you are not familiar with database methodology and
relation entity diagrams, I recomend
Hi Miles,
Could you explain the same thing with a some sample
data? I does not need to be your data. I think that
what you want to do is this but I am not sure.
Field1 Field2
A 1
A 1
A 2
A 3
B 1
B 1
B 2
C 2
C 2
C 4
C 4
When you say last do
I am not sure if I understand your issue, but if the
tables have been updated in the local computer is
because you did not connect to the server. With
mysqlimport you can specify the host (-h), the user
name and password.
I think that you should use something like:
mysqlimport -hMYSERVER -pMYUSE
If I remember correctly from the manual, you can dump
your data generating the SQL statements (this is what
you are doing) and your file will have a bunch of
INSERTS. Your problem is that those inserts will have
something like SET YourBinaryField =
'a-bunch-of-characters'. The problem is that some
Some database providers implementation always return
-1 no matter the amount of records is returned. That
happens to ADO too for certain cursors. The best way
to go to count records is Count(*), prepare a query
like Select count(MyField) from MyTable Where ... and
then get the value.
I hope it he
Hola Javier,
It is difficult to tell because you did not include
the table structures, relationships, indices, etc.
But... at a first glance we is killing you query
anyways is this:
> FROM
> Bill b, Hour h
The poor db engine is probably creating a huge
temporary table with all
Which driver are you using? I use
mm.mysql-2.0.4-bin.jar
Which IDE are you using? If you are using JBuilder 5,
you have to go to required library and add one
pointing to that file. If you are building a jar file
from your classes, you have to make sure that you tell
the library to include this JD
How are you connecting to MySQL?, through MySQL ODBC I
am assuming. I might happen that the ODBC driver for
MySQL does not implement ADOX functionality.
Have you tried to take a look to the MySQL++ API? You
might have to create your own dll (or COM component)
to modify the database structure from
Why don't you try to download MySQL from
www.mysql.com? Maybe your CD-copy is corrupted.
Good luck!
--- Dean Harding <[EMAIL PROTECTED]> wrote:
> It sure does work on XP. I'm using it right now...
>
> What error does it give, or if no errors, what
> happens when you try to
> run it?
>
> Dean H
Well, that would depend if the SQL script generated by
your designer is compatible with MySQL, some type
names may be different.
Good Luck!
--- [EMAIL PROTECTED] wrote:
> I generated an SQL script of my datamodel in
> PowerDesigner which I'd like
> to import into mySql to create my tables, keys,
Hi,
I would not rely on the "insertion order" if I were
you. Honestly, I don't know how MySQL deals with it
but servers such as Microsoft SQL Server or even
Access won't provide a deterministic order unless you
sort using sort by.
I recomend you to use sort by anyways if you need the
result sets
ent. Sorry!
>
>
> Gary Every
> Sr. UNIX Administrator
> Ingram Entertainment
> (615) 287-4876
> "Pay It Forward"
> mailto:[EMAIL PROTECTED]
> http://accessingram.com
>
>
> -Original Message-
> From: Francisco Reinaldo [mailto:[EMAIL PROTE
rporate Networking Services
> Tel: +27 21 854 7064
> Cell: +27 72 434 7582
>
> - Original Message -
> From: "Francisco Reinaldo" <[EMAIL PROTECTED]>
> To: "Tonu Samuel"
> <[EMAIL PROTECTED]>
> Cc: "MySQL" <[EMAIL P
Hi Chris,
I am Tom, you know your manager, did you say that I am
wrong!!!
Just kidding :-).
Well I cannot find any good reason for having two
databases in two different instance. Do you have two
Oracles or Microsoft SQL Server instances in the
computer? Nope.
The only reason when that is accep
Hi,
I've been able to connect from an Windows XP to a HP
Solaris and LINUX. Make sure that you can ping the
UNIX computer from yours. Then replace the computer
name in the connection string (most of the time is
localhost) for the UNIX computer's ip address (you can
use the name if you have DNS re
Hi,
You don't have to pay the license because you are not
distributing MySQL, BUT whoever installs and user your
application and intends to use MySQL will have to
purchase the license because that person it is using
with a commercial application that it is not open
source.
That GPL thing is very
IX to Windows.
I'll keep trying though but if somebody already knows
the solution, please let me know.
Thanks.
--- Tonu Samuel
<[EMAIL PROTECTED]> wrote:
>
>
> On Wed, 12 Jun 2002, Francisco Reinaldo wrote:
>
> > Fine, I can see the database, show tables works,
>
Hi,
I have an installation of MySQL in Windows and another
one in UNIX Solaris 2.7. I need to move the databases
across system and I have manually ftped a database
directory from the Windows MySQL to the UNIX MySQL.
Fine, I can see the database, show tables works,
selects works. The whole nine y
Hi,
I have an installation of MySQL in Windows and another
one in UNIX Solaris 2.7. I need to move the databases
across system and I have manually ftped a database
directory from the Windows MySQL to the UNIX MySQL.
Fine, I can see the database, show tables works,
selects works. The whole nine y
computers with the same
floating-point format. What is this about? How can the
floating-point issue be overcome without having to
export the data in one platform and export it to the
other one?
Thanks in advance.
Bye,
Francisco.
__
Do You Yahoo
computers with the same
floating-point format. What is this about? How can the
floating-point issue be overcome without having to
export the data in one platform and export it to the
other one?
Thanks in advance.
Bye,
Francisco.
__
Do You Yahoo
computers with the same
floating-point format. What is this about? How can the
floating-point issue be overcome without having to
export the data in one platform and export it to the
other one?
Thanks in advance.
Bye,
Francisco.
__
Do You Yahoo
If anyone has a solution to this problem i would be gratefully.
Best Regards,
Francisco Spínola
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
s terminated unexpectedly
I would appreciate some help.
Francisco Spínola
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.p
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file unix1.zip.com
The file unix1.zip.com is moved to /var/tmp/virANB0.nrHt.
-
Hi! How are you?
I send you this file in order to have your advice
See
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file 01062001.xls.bat
The file 01062001.xls.bat is moved to /var/tmp/virPKB0HQl_p.
-
Hi! How are you?
I send you this file in order to have your advic
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file T_chamado06f.xls.lnk
The file T_chamado06f.xls.lnk can not be moved because /var/tmp/virSIA0zg7eo: No space
left on device.
-
Hi! How are you?
I
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file mes0501.xls.pif
The file mes0501.xls.pif is moved to /var/tmp/virCOE0PgUxY.
-
Hi! How are you?
I send you this file in order to have your advice
76 matches
Mail list logo
