21
21
#ifndef DRIZZLED_SESSION_H
22
22
#define DRIZZLED_SESSION_H
24
/* Classes in mysql */
24
26
#include "drizzled/plugin.h"
25
#include "drizzled/sql_locale.h"
27
#include <drizzled/sql_locale.h>
26
28
#include "drizzled/resource_context.h"
27
#include "drizzled/cursor.h"
28
#include "drizzled/current_session.h"
29
#include "drizzled/sql_error.h"
30
#include "drizzled/file_exchange.h"
31
#include "drizzled/select_result_interceptor.h"
32
#include "drizzled/statistics_variables.h"
33
#include "drizzled/xid.h"
29
#include <drizzled/cursor.h>
30
#include <drizzled/current_session.h>
31
#include <drizzled/sql_error.h>
32
#include <drizzled/file_exchange.h>
33
#include <drizzled/select_result_interceptor.h>
34
#include <drizzled/statistics_variables.h>
35
#include <drizzled/xid.h>
34
36
#include "drizzled/query_id.h"
35
37
#include "drizzled/named_savepoint.h"
36
38
#include "drizzled/transaction_context.h"
37
39
#include "drizzled/util/storable.h"
38
41
#include "drizzled/my_hash.h"
39
#include "drizzled/pthread_globals.h"
42
#include <sys/resource.h>
50
#include "drizzled/identifier.h"
51
#include "drizzled/open_tables_state.h"
52
#include "drizzled/internal_error_handler.h"
53
#include "drizzled/diagnostics_area.h"
54
#include "drizzled/plugin/authorization.h"
49
#include "drizzled/internal/getrusage.h"
51
#include <drizzled/security_context.h>
52
#include <drizzled/open_tables_state.h>
54
#include <drizzled/internal_error_handler.h>
55
#include <drizzled/diagnostics_area.h>
57
#include <drizzled/plugin/authorization.h>
56
59
#include <boost/unordered_map.hpp>
58
#include <boost/thread/thread.hpp>
59
60
#include <boost/thread/mutex.hpp>
60
61
#include <boost/thread/shared_mutex.hpp>
61
62
#include <boost/thread/condition_variable.hpp>
62
#include <boost/make_shared.hpp>
65
64
#define MIN_HANDSHAKE_SIZE 6
405
396
/** query associated with this statement */
406
typedef boost::shared_ptr<const std::string> QueryString;
408
boost::shared_ptr<std::string> query;
410
// Never allow for a modification of this outside of the class. c_str()
411
// requires under some setup non const, you must copy the QueryString in
414
QueryString getQueryString() const
419
void resetQueryString()
426
We need to copy the lock on the string in order to make sure we have a stable string.
427
Once this is done we can use it to build a const char* which can be handed off for
428
a method to use (Innodb is currently the only engine using this).
430
const char *getQueryStringCopy(size_t &length)
432
QueryString tmp_string(getQueryString());
441
length= tmp_string->length();
442
char *to_return= strmake(tmp_string->c_str(), tmp_string->length());
447
std::vector <char> _query;
450
typedef boost::shared_ptr<State> const_shared_ptr;
452
State(const char *in_packet, size_t in_packet_length)
454
if (in_packet_length)
456
size_t minimum= std::min(in_packet_length, static_cast<size_t>(PROCESS_LIST_WIDTH));
457
_query.resize(minimum + 1);
458
memcpy(&_query[0], in_packet, minimum);
466
const char *query() const
474
const char *query(size_t &size) const
478
size= _query.size() -1;
486
friend class Session;
487
typedef boost::shared_ptr<State> shared_ptr;
490
State::shared_ptr _state;
493
State::const_shared_ptr state()
499
400
Name of the current (default) database.
532
422
memory::Root warn_root; /**< Allocation area for warnings and errors */
533
423
plugin::Client *client; /**< Pointer to client object */
535
void setClient(plugin::Client *client_arg);
537
plugin::Client *getClient()
542
424
plugin::Scheduler *scheduler; /**< Pointer to scheduler object */
543
425
void *scheduler_arg; /**< Pointer to the optional scheduler argument */
545
427
typedef boost::unordered_map< std::string, user_var_entry *, util::insensitive_hash, util::insensitive_equal_to> UserVars;
547
428
typedef std::pair< UserVars::iterator, UserVars::iterator > UserVarsRange;
548
429
UserVars user_vars; /**< Hash of user variables defined during the session's lifetime */
552
const UserVars &getUserVariables() const
557
drizzle_system_variables variables; /**< Mutable local variables local to the session */
432
struct system_variables variables; /**< Mutable local variables local to the session */
558
433
struct system_status_var status_var; /**< Session-local status counters */
559
434
THR_LOCK_INFO lock_info; /**< Locking information for this session */
560
435
THR_LOCK_OWNER main_lock_id; /**< To use for conventional queries */
561
436
THR_LOCK_OWNER *lock_id; /**< If not main_lock_id, points to the lock_id of a cursor. */
438
boost::mutex LOCK_delete; /**< Locked before session is deleted */
446
void unlockForDelete()
448
LOCK_delete.unlock();
452
* A peek into the query string for the session. This is a best effort
453
* delivery, there is no guarantee whether the content is meaningful.
455
char process_list_info[PROCESS_LIST_WIDTH+1];
564
458
* A pointer to the stack frame of the scheduler thread
684
564
ResourceContext *getResourceContext(const plugin::MonitoredInTransaction *monitored,
685
565
size_t index= 0);
688
* Structure used to manage "statement transactions" and
689
* "normal transactions". In autocommit mode, the normal transaction is
690
* equivalent to the statement transaction.
692
* Storage engines will be registered here when they participate in
693
* a transaction. No engine is registered more than once.
695
567
struct st_transactions {
696
568
std::deque<NamedSavepoint> savepoints;
699
* The normal transaction (since BEGIN WORK).
701
* Contains a list of all engines that have participated in any of the
702
* statement transactions started within the context of the normal
705
* @note In autocommit mode, this is empty.
707
TransactionContext all;
710
* The statment transaction.
712
* Contains a list of all engines participating in the given statement.
714
* @note In autocommit mode, this will be used to commit/rollback the
715
* normal transaction.
717
TransactionContext stmt;
569
TransactionContext all; ///< Trans since BEGIN WORK
570
TransactionContext stmt; ///< Trans for current statement
719
571
XID_STATE xid_state;
854
690
uint32_t row_count;
855
691
session_id_t thread_id;
856
692
uint32_t tmp_table;
857
enum global_read_lock_t
860
GOT_GLOBAL_READ_LOCK= 1,
861
MADE_GLOBAL_READ_LOCK_BLOCK_COMMIT= 2
864
global_read_lock_t _global_read_lock;
868
global_read_lock_t isGlobalReadLock() const
870
return _global_read_lock;
873
void setGlobalReadLock(global_read_lock_t arg)
875
_global_read_lock= arg;
878
DrizzleLock *lockTables(Table **tables, uint32_t count, uint32_t flags, bool *need_reopen);
879
bool lockGlobalReadLock();
880
bool lock_table_names(TableList *table_list);
881
bool lock_table_names_exclusively(TableList *table_list);
882
bool makeGlobalReadLockBlockCommit();
883
bool abortLockForThread(Table *table);
884
bool wait_if_global_read_lock(bool abort_on_refresh, bool is_not_commit);
885
int lock_table_name(TableList *table_list);
886
void abortLock(Table *table);
887
void removeLock(Table *table);
888
void unlockReadTables(DrizzleLock *sql_lock);
889
void unlockSomeTables(Table **table, uint32_t count);
890
void unlockTables(DrizzleLock *sql_lock);
891
void startWaitingGlobalReadLock();
892
void unlockGlobalReadLock();
895
int unlock_external(Table **table, uint32_t count);
896
int lock_external(Table **tables, uint32_t count);
897
bool wait_for_locked_table_names(TableList *table_list);
898
DrizzleLock *get_lock_data(Table **table_ptr, uint32_t count,
899
bool should_lock, Table **write_lock_used);
693
uint32_t global_read_lock;
902
694
uint32_t server_status;
903
695
uint32_t open_options;
904
696
uint32_t select_number; /**< number of select (used for EXPLAIN) */
1231
1017
inline time_t query_start() { return start_time; }
1232
1018
inline void set_time()
1234
boost::posix_time::ptime mytime(boost::posix_time::microsec_clock::local_time());
1235
boost::posix_time::ptime epoch(boost::gregorian::date(1970,1,1));
1236
start_utime= utime_after_lock= (mytime-epoch).total_microseconds();
1240
1022
start_time= user_time;
1241
connect_microseconds= start_utime;
1023
connect_microseconds= start_utime= utime_after_lock= my_micro_time();
1244
start_time= (mytime-epoch).total_seconds();
1026
start_utime= utime_after_lock= my_micro_time_and_time(&start_time);
1246
1028
inline void set_current_time() { start_time= time(NULL); }
1247
1029
inline void set_time(time_t t)
1249
1031
start_time= user_time= t;
1250
boost::posix_time::ptime mytime(boost::posix_time::microsec_clock::local_time());
1251
boost::posix_time::ptime epoch(boost::gregorian::date(1970,1,1));
1252
uint64_t t_mark= (mytime-epoch).total_microseconds();
1254
start_utime= utime_after_lock= t_mark;
1256
void set_time_after_lock() {
1257
boost::posix_time::ptime mytime(boost::posix_time::microsec_clock::local_time());
1258
boost::posix_time::ptime epoch(boost::gregorian::date(1970,1,1));
1259
utime_after_lock= (mytime-epoch).total_microseconds();
1032
start_utime= utime_after_lock= my_micro_time();
1034
void set_time_after_lock() { utime_after_lock= my_micro_time(); }
1262
1036
* Returns the current micro-timestamp
1264
1038
inline uint64_t getCurrentTimestamp()
1266
boost::posix_time::ptime mytime(boost::posix_time::microsec_clock::local_time());
1267
boost::posix_time::ptime epoch(boost::gregorian::date(1970,1,1));
1268
uint64_t t_mark= (mytime-epoch).total_microseconds();
1040
return my_micro_time();
1272
1042
inline uint64_t found_rows(void)
1709
1485
Table *openTable(TableList *table_list, bool *refresh, uint32_t flags= 0);
1711
1487
void unlink_open_table(Table *find);
1712
void drop_open_table(Table *table, const TableIdentifier &identifier);
1488
void drop_open_table(Table *table, TableIdentifier &identifier);
1713
1489
void close_cached_table(Table *table);
1715
1491
/* Create a lock in the cache */
1716
table::Placeholder *table_cache_insert_placeholder(const TableIdentifier &identifier);
1717
bool lock_table_name_if_not_cached(const TableIdentifier &identifier, Table **table);
1492
Table *table_cache_insert_placeholder(const char *db_name, const char *table_name);
1493
bool lock_table_name_if_not_cached(TableIdentifier &identifier, Table **table);
1719
1495
typedef boost::unordered_map<std::string, message::Table, util::insensitive_hash, util::insensitive_equal_to> TableMessageCache;
1723
TableMessageCache table_message_cache;
1726
bool storeTableMessage(const TableIdentifier &identifier, message::Table &table_message);
1727
bool removeTableMessage(const TableIdentifier &identifier);
1728
bool getTableMessage(const TableIdentifier &identifier, message::Table &table_message);
1729
bool doesTableMessageExist(const TableIdentifier &identifier);
1730
bool renameTableMessage(const TableIdentifier &from, const TableIdentifier &to);
1496
TableMessageCache table_message_cache;
1498
bool storeTableMessage(const TableIdentifier &identifier, message::Table &table_message);
1499
bool removeTableMessage(const TableIdentifier &identifier);
1500
bool getTableMessage(const TableIdentifier &identifier, message::Table &table_message);
1501
bool doesTableMessageExist(const TableIdentifier &identifier);
1502
bool renameTableMessage(const TableIdentifier &from, const TableIdentifier &to);
1504
/* Work with temporary tables */
1505
Table *find_temporary_table(TableList *table_list);
1506
Table *find_temporary_table(const char *db, const char *table_name);
1507
Table *find_temporary_table(TableIdentifier &identifier);
1509
void doGetTableNames(CachedDirectory &directory,
1510
const SchemaIdentifier &schema_identifier,
1511
std::set<std::string>& set_of_names);
1512
void doGetTableNames(const SchemaIdentifier &schema_identifier,
1513
std::set<std::string>& set_of_names);
1515
void doGetTableIdentifiers(CachedDirectory &directory,
1516
const SchemaIdentifier &schema_identifier,
1517
TableIdentifiers &set_of_identifiers);
1518
void doGetTableIdentifiers(const SchemaIdentifier &schema_identifier,
1519
TableIdentifiers &set_of_identifiers);
1521
int doGetTableDefinition(const drizzled::TableIdentifier &identifier,
1522
message::Table &table_proto);
1523
bool doDoesTableExist(const drizzled::TableIdentifier &identifier);
1525
void close_temporary_tables();
1526
void close_temporary_table(Table *table);
1527
// The method below just handles the de-allocation of the table. In
1528
// a better memory type world, this would not be needed.
1734
TableMessages _table_message_cache;
1530
void nukeTable(Table *table);
1737
TableMessages &getMessageCache()
1739
return _table_message_cache;
1533
void dumpTemporaryTableNames(const char *id);
1534
int drop_temporary_table(TableList *table_list);
1535
bool rm_temporary_table(plugin::StorageEngine *base, TableIdentifier &identifier);
1536
bool rm_temporary_table(TableIdentifier &identifier, bool best_effort= false);
1537
Table *open_temporary_table(TableIdentifier &identifier,
1538
bool link_in_list= true);
1742
1540
/* Reopen operations */
1743
1541
bool reopen_tables(bool get_locks, bool mark_share_as_old);
1542
bool reopen_name_locked_table(TableList* table_list, bool link_in);
1744
1543
bool close_cached_tables(TableList *tables, bool wait_for_refresh, bool wait_for_placeholders);
1746
1545
void wait_for_condition(boost::mutex &mutex, boost::condition_variable_any &cond);
1747
1546
int setup_conds(TableList *leaves, COND **conds);
1748
1547
int lock_tables(TableList *tables, uint32_t count, bool *need_reopen);
1549
Table *create_virtual_tmp_table(List<CreateField> &field_list);
1750
1551
drizzled::util::Storable *getProperty(const std::string &arg)
1752
1553
return life_properties[arg];