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
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
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 problem on our
new
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
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
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 contact
of a request from 217.35.111.1.
--
Tengo que cambiar mi firma
-
Francisco Santiago Capel Torres
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 instantlly
turns off the 5.0.2 alpha mySQL
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 unsubscribe:http://lists.mysql.com/[EMAIL
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
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]
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 clause
(a 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
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
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
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: Can't connect
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)legrarse, (B)ailar, (F)iesta
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 does MySQL
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
Hi,
If you are generating the id yourself a good strategy
is to use UUID that are #34;guaranteed#34; to be
#34;universally#34; 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
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 all
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
There 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
on MS-SQL it took 11 minutes..
yes
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,
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
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
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
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.
---
mysqlsms.sql
Also if you are inside the application
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.
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,
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,
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 2002
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, can any
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
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 some errors about some libraries missing
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
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 with
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
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
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
these situations
-Arul
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Cc: Arul [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 3:27 AM
Subject: Re: help me with this query
Hi,
Select companyid, count
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,
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,
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 =
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!
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
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
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
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
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
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
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
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
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 Harding.
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
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
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'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
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
434 7582
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Tonu Samuel
[EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 12:14 AM
Subject: Re: table is read only when DB copied from
Win to UNIX
Thanks for the tip but I have added
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
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
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,
selects works. The whole nine yards? Nope! I
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
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 list archive
-- 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
-- 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?
-- 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
-- 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
71 matches
Mail list logo