Somewhere about Wed, 09-Mar-2005 at 03:02PM +0100 (give or take), Jigal van
Hemert wrote:
|> From: "Curtis Maurand"
|> > Using ODBC, however, you can link Access tables to MySQL tables and use
|> > Access as the front end to MySQL. It works very nicely.
|>
|> Using ODBC you can access MySQL fro
At 07:19 PM 3/9/2005, you wrote:
Unfortunately this doesn't work well if you want to
tell your users how many pages were found in the
query.
Correct, but the speed difference will more than make up for it. If you
have a busy website, it is very important not to overtax the database
server with fr
Hi
Can you please enter your contact details in my address book. Click on the link
below:
http://www.bebo.com/fr1/10232728a484122677b143804761c521525170d20
After we are connected, in the future, any changes you make in your contact
details will be sent to me.
Thanks for your help.
Kris
On Nov 17, 2004, Matt Babineau & Dan Nelson discussed:
> > Has anyone run into problems with this sql syntax?
> >
> > LIMIT -1
> >
> > I've used this extensively in my code to get back all records rather then
> > specifing a limit. I've done this programmatically with PHP, so all my
> > queries
I'm pleased to annouce the 8th release of Gtk2::Ex::DBI ...
http://entropy.homelinux.org/Gtk2-Ex-DBI/
Gtk2::Ex::DBI is an open-source helper object that makes your Gtk2-Perl
apps data aware. It handles querying, 'painting' records on your
Glade-generated form, passing updates back to the database s
Mysql 4, I have datetime field set of -00-00 00:00:00
Sampling of data I need to insert in is as follow:
12/26/04 13:35
12/25/04 12:41
12/25/04 8:53
How do a massage that to the proper format YYY-MM-DD HH:MM:SS
thanks
--
-
Scott Ha
Unfortunately this doesn't work well if you want to
tell your users how many pages were found in the
query. Sure, you could use SQL_CALC_FOUND_ROWS with
FOUND_ROWS(), but this will defeate the purpose of the
LIMIT clause -- speed -- because MySQL will have to
figure out all the results of the query
If your tables are mostly read-only, you could
pre-generate page numbers on a periodic basis and
select only specific ranges WHERE row_number BETWEEN
page_start AND page_finish.
Or you could just send the top 1000 IDs of the table
to the client, and have the client figure out which
IDs belong to w
I'm sorry, I meant user variables, not session
variables.
--- "Homam S.A." <[EMAIL PROTECTED]> wrote:
> I just spent quite a while hunting out a bug that
> turned out to be a mis-spelled session variable
> defaulting to NULL.
>
> Ultimately what I want is, if I used a session
> veriable without
I just spent quite a while hunting out a bug that
turned out to be a mis-spelled session variable
defaulting to NULL.
Ultimately what I want is, if I used a session
veriable without defining it before hand with a SET,
MySQL would return an error.
Such problem doesn't exist in T-SQL, for example,
Even with only 16 Mo, your query cache is quite efficient (78% of your
queries are fetched directly from the cache).
Try to increaze your query_cache_size until there's no more additional
lowmem_prunes reported.
And executed from time to time FLUSH QUERY CACHE to defragment your
query cache.
Thanks these are fresh results
| query_cache_limit| 1048576 |
| query_cache_min_res_unit | 4096 |
show status like "ques%";
+---+--+
| Variable_name | Value|
+---+--+
| Questions | 14189604 |
+---+--+
sho
In the last episode (Mar 09), Mauricio Pellegrini said:
> Thanks, this the result of show status like "qcache%"
>
> +-+--+
> | Variable_name | Value|
> +-+--+
> | Qcache_free_blocks | 3330 |
> | Qcache_free_mem
Hi,
How many questions for thoses results ?
There's a lot of lowmem_prunes, so I would indeed increase the memory
size to reduce the risk of lowmem_prunes.
What is your query_cache_limit ?
Jocelyn
Mauricio Pellegrini a écrit :
Thanks, this the result of show status like "qcache%"
+
Thanks, this the result of show status like "qcache%"
+-+--+
| Variable_name | Value|
+-+--+
| Qcache_free_blocks | 3330 |
| Qcache_free_memory | 13372320 |
| Qcache_hits | 9149 |
| Qcache_
In the last episode (Mar 09), Mauricio Pellegrini said:
> Hi, I'm trying to tweak the execution time for querys on my mysql
> server which is using InnoDB.
>
> I know that there are a lot of things to check but one of them,
> perhaps not the most important, is the query_cache_size.
>
> I have a d
Depends on the result sets you want to cache. Check the other variables in the
manual, you can analyze if all the query cache is utilized at a point in time.
In general 16M is low when you have 4GB, you can safely increase it.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PRO
Hi, I'm trying to tweak the execution time for querys on my mysql
server which is using InnoDB.
I know that there are a lot of things to check but one of them, perhaps
not the most important, is the query_cache_size.
I have a dual Xeon cpu with 4gb of ram and this is a Linux dedicated
server whic
Osvaldo Sommer wrote:
This is the code:
Public Sub Graba_Recibido(texto As String)
277On Error GoTo Manejo_Error
278Dim db As Database
279Dim rec As DAO.Recordset
281texto = Mid(texto, 2, 2) & Mid(texto, 7, Len(texto) - 7)
282texto = Mid(texto, 1, Len(texto) - 1)
284Set db =
Well, we allready use ip numbers instead of host names in the grant
tables, but after setting the skip-name-resolve startup option
machines with Windows ( any flavor) are still slow when internet
connection goes down.
Still, I cant tell if the startup parameter (skip-name-resolve) has been
accepte
Carlos,
Apart from using the proper indexes, you should only retrieve the
number of rows that are going to be displayed on the page at one time. If
you are displaying 10 rows on the page, why retrieve 1000 rows? The user
would have to page through it 100x and you have to ask yourself, is
That's incredibly slow. I pull 1000 records through PHP in 1 second
on a P4 2.4 Ghz. Are you pulling the entire recordset and then
limiting it in your app code? Or are you using a limit clause in the
DB?
Also, Peter's point about indexing might help. Without specific SQL
examples, it's difficu
Run an explain on the query and post it here. Make sure all the join columns
are appropriately indexed. Also, notice the large difference in rows examined
vs sent (My guess is this is due to the left joins.) Left joins are horribly
overused and I know you said that you cannot change the query bu
Does the app display all 1000 rows at once? Does your app require all
fields? Only retrieve what you need for the page. If the app displays all
1000 rows, it may remain slow depending on how you get them (order, group,
function) and indexing.. Also, the link and disk may matter depending on
the si
There is likely an rpm package for the php mysql module. Install that, or
compile php with mysql support.
P
--Original Message--
From: Kamal Ahmed
To: mysql
Cc: Kamal Ahmed
Sent: Mar 9, 2005 3:58 PM
Subject: PHP/MyphpAdmin/MySql
Dear MySql List experts,
I have the following installed on
Hi all:
I programming a GUI which retrieve big tables oftenly.
So, I retrieve chunks of 1000 rows and paginate then
to browse the entire table. It works fine, but it's rather
slow.
I would like to know if I could set some option thru
mysql_option() to optimize the client side (mysql-client-3.
Dear MySql List experts,
I have the following installed on redhat 9:
[EMAIL PROTECTED] html]#php -v
PHP 4.3.10 (cgi) (built: Mar 8 2005 17:52:13)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
-
[EMAIL PROTECTED] html]# rpm
At 12:40 -0800 3/9/05, Homam S.A. wrote:
Thanks Tom, Daniel, and Philippe for you replies.
Yes, I got the statement working exactly as I wrote
it. I was confused about this documentation:
http://dev.mysql.com/doc/mysql/en/case-statement.html
which states that you need to specify "END CASE"
instead
Thanks Tom, Daniel, and Philippe for you replies.
Yes, I got the statement working exactly as I wrote
it. I was confused about this documentation:
http://dev.mysql.com/doc/mysql/en/case-statement.html
which states that you need to specify "END CASE"
instead of just "END". So I used the same synt
Speaking of the --read-only option, I don't suppose there's
any way to run --read-only but allow CREATE TEMPORARY TABLE,
is there? We run several reports against a slave server
which require temporary tables for speed, and have had a
problem with the occasional accidental write to the slave.
The sl
Atle Veka wrote:
Even if you replicate the 'mysql' DB, GRANT/REVOKE statements are not
replicated, nor are FLUSH statements. So if you are adding new access
privileges on the master they will not be active on the slave until you
issue FLUSH PRIVILEGES (one the slave).
What version are you talking a
Even if you replicate the 'mysql' DB, GRANT/REVOKE statements are not
replicated, nor are FLUSH statements. So if you are adding new access
privileges on the master they will not be active on the slave until you
issue FLUSH PRIVILEGES (one the slave).
Hope this helps. :)
Atle
-
Flying Crocodile
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill Dodson wrote:
> First off, sorry if this is going to the wrong list.
>
> I installed the new Connector J (mysql-connector-java-3.1.7-bin.jar).
> Now some of my code does not work. It seems that when I do a
> ResultSet.getObject() on a Date fie
Hmm, We'll we just won't give them access to the replicated database to
begin with... It's used internally, and the few people in the company that
do need to write to the database are all skilled administrators /
programmers who know what to do :) Dont think we'll be having those
problem.
I'
First off, sorry if this is going to the wrong list.
I installed the new Connector J (mysql-connector-java-3.1.7-bin.jar).
Now some of my code does not work. It seems that when I do a
ResultSet.getObject() on a Date field with the value -00-00 (the
default value) I get an SQLException. Whi
Hi
I have a big problem with my mysq server. ater installing it in a new
machine it works extremally slowly.
My mysql server serves a quite big web site with numerous queries.
Unfortunately, I can't alter the queries.
And one more thing. Everything run much better on a previous machine.
What I ha
Mauricio Pellegrini wrote:
Is there a way to check whether this option is active or not, while the
server is running?
Not sure why it doesn't show up in "SHOW VARIABLES", but one way
to check would be to see whether the hosts in the "Host" column
of "SHOW PROCESSLIST" are shown as IP addresses or
Two more notes, assuming this is a MyISAM table. If this
table sees concurrent inserts (many mixed INSERTs and
SELECTs), you'll definitely want to run an OPTIMIZE TABLE
after your purge. Large numbers of deletes or updates to
variable-length fields will result in free blocks in the
data file, and t
Gleb Paharenko wrote:
Hello.
Execute FLUSH PRIVILEGES after granting.
See:
http://dev.mysql.com/doc/mysql/en/flush.html
http://dev.mysql.com/doc/mysql/en/privilege-changes.html
Yes, please read this one. FLUSH PRIVILEGES is NOT needed after GRANT,
REVOKE, or SET PASSWORD. You only need to FL
Is there a way to check whether this option is active or not, while the
server is running?
Thanks
Mauricio
On Tue, 2005-03-08 at 06:39, Gleb Paharenko wrote:
> Hello.
>
> > Is the option well set and in the right place ?
>
> Yes. If your mysqld reads this file (use --defaults-file command lin
I found the article very interesting. It seems they couldn't trash
3ware cards enough.
We swear by 3ware cards -- other than the PCIX riser card issue, we
haven't a single problem with them. Our production database server is
running off of a RAID1 for the OS and a RAID10 for the data and every
tim
At 9:08 -0500 3/9/05, Jason L. McAffee wrote:
The MySQL manual states that as of MySQL 5.0.2 "If the
column cannot take NOT NULL as the value, MySQL defines the column with
no explicit DEFAULT clause." How are the default values then backed-up?
I did not see any statements defining the
I would probably not replica the mysql database in your case.
We run a similar setup. One problem we have is people connecting to
the wrong database server and applying updates (for example, they
think they are in the master, but it's really the slave and they
perform an update or an insert). As y
From: "Terry Spencer"
> An index exists on all three columns referred to, in addition to a
> combination of del and signoff.
>
> The indexes are listed as possible keys, but none used by the query; key =
> null. Can anyone suggest why? How can I optimise this?
How many records are there in the tab
RE: Import Access Data...
> I'll try and import using ODBC. Is there any good web sites
> about ODBC and its operations that I can learn about it?
>
> Scott
If you haven't found this by now:
http://forums.mysql.com/list.php?65 - MySQL forum for Access conversion.
Many people use ODBC to migra
Lo all,
Just wondering... Would the below be considered a "safe" way to do
replication...
MasterBD: One Database (most Critical)
SlaveDB: Replicating all databases from MasterBD as well as hosting allot of
other 3rd party, or customer DBs.
Basically, the MasterBD holds a single critical databa
>Description:
Mysqld got signal 11.
HardWare: HP Proliant DL380G4 (5G RAM + 2 * Xeon 3.4GHz)
SoftWare: SunOS noc-db.simtel.ru 5.9 Generic_117172-17 i86pc i386 i86pc
In error log:
=Start Log==>
mysqld got signal 11;
This could be because you hit a bug. It is also
This is the code:
Public Sub Graba_Recibido(texto As String)
277On Error GoTo Manejo_Error
278Dim db As Database
279Dim rec As DAO.Recordset
281texto = Mid(texto, 2, 2) & Mid(texto, 7, Len(texto) - 7)
282texto = Mid(texto, 1, Len(texto) - 1)
284Set db = CurrentDb
285
On Wednesday, March 09, 2005 07:49, Philippe Poelvoorde wrote:
> Daniel Kasak wrote:
>> Homam S.A. wrote:
>>
>>> In the documentation, it doesn't mention which version
>>> of MySQL supports the CASE statement, but it refers to
>>> stored procedures, so is it only supported for 5.x?
>>>
>>> I ca
The MySQL manual states that as of MySQL 5.0.2 "If the
column cannot take NOT NULL as the value, MySQL defines the column with
no explicit DEFAULT clause." How are the default values then backed-up?
I did not see any statements defining the default values. Will I have
to re-create the
After building, I ran "make test". The func_group test failed.
Here is the output:
func_group [ fail ]
Errors are (from
/mnt/raid/download/computer/software/mysql/mysql-5.0.2-alpha/mysql-test/var/log/mysqltest-time)
:
/mnt/raid/download/computer/software/mysql/mysql-5.0.2-alp
From: "Curtis Maurand"
> Using ODBC, however, you can link Access tables to MySQL tables and use
> Access as the front end to MySQL. It works very nicely.
Using ODBC you can access MySQL from OpenOffice.org (which has an
Access-like frontend built in), using ODBC and MS Jet engine (standard with
Daniel Kasak wrote:
Homam S.A. wrote:
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example of a CASE statement work in
MySQL.
For example, I can execute the follo
Are you running server or client?
Up until this week I've always run MySQL on OS X client, since there
really isn't much of a difference between OS X client and server as far
as MySQL is concerned. I just ran into the problem where I locked
myself out, but I couldn't start MySQL from the command
Using ODBC, however, you can link Access tables to MySQL tables and use
Access as the front end to MySQL. It works very nicely.
Curtis
Martijn Tonies said:
>> > > Alternatively you could use OpenOffice.org
> (http://www.openoffice.org/)
>> > > which has built in MySQL support.
>> >
>> > Alterna
Im trying to speed up a query.
select
project_id
from
timesheet ts
where
ts.del is null
and signoff = 'A'
The output of explain is detailed below.
++-+---+--+-+--+
| id | select_type | table | type | possible_keys | key
Hi,
You have to know why MySql doesn't start.
When you install mysql, the installer creates a directory
"mysql-[version name]" and a symbolic link "mysql" in /usr/local.
There is an error file named "yourservername".err in data directory
that explains why mysql failed.
Type perror errornumber to
Note that with MySQL, unlike some other databases, you don't have to do
this. If you are going to add new records to replace the deleted ones,
MySQL will re-use the space freed by deletions with no special actions on
your part. Of course, if you are not going to replace the deleted records,
the
Hello.
I'm not a developer, I've just looked through the code with vim (gdb
had helped me a lot also).
Kenji HIROHAMA <[EMAIL PROTECTED]> wrote:
> Hi Gleb,
> Thanks for your help.
> (I'm sending again, because first I just sent this only to you to use
> "Reply" of Gmail, not use "Reply
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Billy Pilgrim <[EMAIL PROTECTED]> wrote:
> Hello, I installed MySQL 4.1.10 on Debian Ubuntu based following these
> directions:
> http://dev.mysql.com/doc/mysql/en/installing-binary.html
> I then logged
Hello.
In most encodings english letters remain unchanged, but to be sure
you may execute set NAMES latin1 before quering tables with English
data.
"John Berman" <[EMAIL PROTECTED]> wrote:
> Thanks will do this.
>
> In the same dBase there a lots of tables were the data is in Engl
61 matches
Mail list logo
