and will need access to the
same data from the MySQL server(s). I am hoping that running MySQL on each
of the web servers will help to reduce the overall load on the servers.
Thank You,
Jason Williard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
ate | Info
|
+--+--+---+---+-+--+---+
--+
| 584 | root | localhost | blogs | Sleep | 915 | | NULL
|
| 595 | root | localhost | blogs | Sleep | 900 | | NULL
|
+--+--+---+---+-+--+---+
--+
---
Thank You
Jason Williard
--
MySQL Gener
/usr/bin/safe_mysqld --user=mysql
[EMAIL PROTECTED] usr]#
---
Any assistance with this would be greatly appreciated.
---
Thank You,
Jason Williard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dge is failing me as I am unsure of how to upgrade the
Client.
The install was done from source, as I have always found this to be the most
stable method of upgrading. Any assistance would be appreciated.
Thank You,
Jason Williard
Systems Administrator
PCSafe Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/usr/local/mysql/bin/mysqld_safe &'.
Does anyone know why I am getting this error message?
----
Thank You,
Jason Williard
PCSafe, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I know that it is possible to do this, though I don't know how.
I have 2 tables containing information about trouble tickets. One of the tables
(table2) contains information about every ticket ever received, including tickets that
were deleted from the system. For this reason, table2 has ~45
Before: 57 seconds
After: <1 second :-D
Thank You,
Jason Williard
Client Services
Spenser wrote:
I wish we had thought to have had him benchmark a query before and after
he added an index. It would be interesting to see the difference in
actual time that an index can make on a table w
Amit,
You are awesome! That fixed it quite nicely. Our system is screaming
now :-)
Thank You VERY MUCH!,
Jason Williard
Client Services
[EMAIL PROTECTED] wrote:
Do this and tell me if it helped
ALTER TABLE `asticketsdata` ADD INDEX ( `ticketidchar` )
Regards,
Amit
-Original Message
icketidno int(11) default NULL,
contents text,
emailbody text,
PRIMARY KEY (ticketdataid),
KEY ticketdata1 (ticketidno)
) TYPE=MyISAM;
Query:
SELECT * FROM asticketsdata WHERE ticketidchar = 'IAZ-16393';
Thank You,
Jason Williard
Client Services
[EMAIL PROTECTED] wrote:
I have ta
I'm sorry to sound like a novice, but could you explain that? Are you
recommending that I set the column I am searching to an Index?
Thank You,
Jason Williard
Client Services
[EMAIL PROTECTED] wrote:
You need Appropriate Indexes on the tables.
-Original Message-
From: Jason Wil
take forever to run. In a specific case, it took 57
seconds to complete the SELECT query.
Any ideas on how to speed this up?
--
Thank You,
Jason Williard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks, Mark, for the syntax. I had actually played around enough to
figure it out already and got it to work the way that I wanted to. I
guess when I asked the question, I wasn't fully aware of what I was
wanting. The LAST_INSERT_ID wasn't a major issue. I ended up using the
following code:
icket. I was hoping that there was a way to update
the LAST_INSERT_ID. Is this possible? If so, what is the query that
should be run?
Thank You,
Jason Williard
Janix
13 matches
Mail list logo
